home / russian-ads

display_ads (view)

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

3 rows where an ad_target was age:13 - 44

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
6 location:United States, age:13 - 44, language:English (US), placements:Instagram Feed, people_who_match:interests:Christ's Commission Fellowship, people_who_match:interests:Jesus, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:Walk with Jesus, people_who_match:interests:The Bible (TV miniseries) 0 0 https://www.facebook.com/Bat-240131319678646/ Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! 0.0 0.00 USD 2016-05-12T04:06:17-07:00  
7 no image location:United States, age:13 - 44, language:English (US), placements:Instagram Feed, people_who_match:interests:Christ's Commission Fellowship, people_who_match:interests:Jesus, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:Walk with Jesus, people_who_match:interests:The Bible (TV miniseries) 23408 54 https://www.facebook.com/Bat-240131319678646/ Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! 45.89696 2868.56 RUB 2016-05-13T01:18:08-07:00  
1744 location:United States, age:13 - 44, language:English (US), placements:Instagram Feed, people_who_match:interests:Bernie Sanders 27379 54 https://www.instagram.Com/blackmattersus/ JOIN our #HiIlaryCIintonForPrison2016 .Take a photo (you may use just a list of paper, or write it on the wall or whatever) and send it DM! Please support us, we really try to make America better! Our followers are going to make their future better and encourage to support #HillaryC|intonForPrison2016 flashmob. BlackMattersUS Blackluive 48.51584 3032.24 RUB 2016-04-19T08:13:55-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 1587.247ms · Data source: simonw/russian-ira-facebook-ads-datasette