home / russian-ads

display_ads (view)

Data source: simonw/russian-ira-facebook-ads-datasette

3 rows where an ad_target was people_who_match:interests:Gay pride

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
575 location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Gay pride, people_who_match:interests:LGBT culture, people_who_match:interests:LGBT community, people_who_match:interests:LGBT social movements 65649 11131 https://www.facebook.com/LGBT-United-839497472793277/ HELP RODNEY SUMTER RECOVER Rodney Sumter Jr., 27 miraculously survived Pulse nightclub Orlando shooting, being shot three times. But he’s still in a lot of pain. Rodney is still recovering at Orlando Regional Medical Center. Lenita Sumter, his mother, said he is in intense pain and that it has been difficult for him to get comfortable and is needing sedation and heavy pain medications. Rodney was shot in the arms and back. He had surgery Monday to repair his arms, but shrapnel was left in his back. He had another surgery Wednesday night, family said. Doctors said Rodney is running a fever and suspect he may have an infection. Please help Rodney Sumter to recover! https://www.gofundme.com/294czwct Don't forget to send forward your payment invoice???? 64.5856 4036.60 RUB 2016-06-17T11:07:24-07:00  
591 location:United States, friends_of_connections:Friends of people who are connected to LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Gay pride, people_who_match:interests:LGBT community, people_who_match:interests:Homosexuality, people_who_match:interests:LGBT culture, people_who_match:interests:Same-sex marriage 93925 5441 https://www.facebook.com/Igbtun/ We speak for all fellow members of LGBT community across the nation. 507.40992 31713.12 RUB 2016-03-23T05:36:11-07:00  
592 location:United States, friends_of_connections:Friends of people who are connected to LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Gay pride, people_who_match:interests:Homosexuality, people_who_match:interests:LGBT culture, people_who_match:interests:LGBT community, people_who_match:interests:Same-sex marriage 190076 7289 https://www.facebook.com/Igbtun/ We speak for all fellow members of LGBT community across the nation. 576.0 36000.00 RUB 2016-08-04T04:20:05-07:00  

Advanced export

JSON shape: default, array

CSV options:

CREATE VIEW display_ads AS 
        select ads.id,
            case when image is not null then
                json_object("img_src", "https://raw.githubusercontent.com/edsu/irads/03fb4b/site/" || image, "width", 200)
            else
                "no image"
            end as img,
            json_group_array(
                json_object(
                    "label", targets.name,
                    "href", "/russian-ads/display_ads?_target="
                        || urllib_quote_plus(targets.id)
                )
            ) as targeting,
            ads.impressions, ads.clicks, ads.url, ads.text,
            cast(case
                when ads.spend_currency == "RUB" then ads.spend_amount * 0.016
                else ads.spend_amount
            end as float) as spend_usd,
            ads.spend_amount, ads.spend_currency,
            ads.created, ads.ended
        from ads
            join ad_targets on ads.id = ad_targets.ad_id
            join targets on ad_targets.target_id = targets.id
        group by ads.id
        order by ads.id
Powered by Datasette · Query took 1262.074ms · Data source: simonw/russian-ira-facebook-ads-datasette