home / russian-ads

display_ads (view)

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

3 rows where an ad_target was location:united_states:Tennessee

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
32 location:united_states:Alabama, location:united_states:Arkansas, location:united_states:Florida, location:united_states:Georgia, location:united_states:Louisiana, location:united_states:Mississippi, location:united_states:North Carolina, location:united_states:South Carolina, location:united_states:Tennessee, location:united_states:Texas, location:united_states:Virginia, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Confederate Flag, people_who_match:interests:Flags of the Confederate States of America, people_who_match:interests:confederate states america, people_who_match:interests:United Daughters of the Confederacy, people_who_match:interests:Confederate States of America, people_who_match:interests:Sons of Confederate Veterans, people_who_match:interests:Confederate States Army, people_who_match:interests:Robert E. Lee, people_who_match:interests:Southern United States, people_who_match:interests:Redneck Social Club 12727 375 https://www.instagram.com/south_united/ Heritage not hate y'all! Our flag has nothing to do with racism! The Federal Government shouldn’t be able to dictate what we can and cannot do. Go follow Confederate page #1 on Instagram south united if you are proud of our southern heritage. God bless Dixie! Confederate page #1 on Instagram! No racism, no hate! The south will rise again! https://twitter.com/March_for_Trump South United GovSpehding 49.700480000000006 3106.28 RUB 2016-08-18T08:31:16-07:00  
1329 location:united_states:Tennessee, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Stop A.|., people_who_match:Friends of connections: Friends of people who are connected to Stop A.|. 682 192 https://www.facebook.com/Stop-AI-896610653786585/ I cannot understand why democrats encourage breaking the law. They harbor illegal aliens who are breaking our immigration and labor laws. They praise rioters and vandals... What's wrong with them? 8.0 500.00 RUB 2016-07-14T02:32:13-07:00 2016-07-15T02:32:12-07:00
1330 no image location:united_states:Tennessee, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3395 194 https://www.facebook.com/Stop-AI-896610653786585/ America is deceased. Islamic terror has penetrated our homeland and now spreads at a three Remember Victims Of Islamic Terror 58.96928 3685.58 RUB 2016-07-07T04:41:41-07:00 2016-07-16T13:00:00-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)
                "no image"
            end as img,
                    "label", targets.name,
                    "href", "/russian-ads/display_ads?_target="
                        || urllib_quote_plus(targets.id)
            ) as targeting,
            ads.impressions, ads.clicks, ads.url, ads.text,
                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 1570.406ms · Data source: simonw/russian-ira-facebook-ads-datasette