home / russian-ads

display_ads (view)

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

6 rows where an ad_target was people_who_match:interests:Confederate Flag

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  
1876 location_living_in:United States, age:13 - 35, language:English (US), placements:lnstagram Feed, people_who_match:interests:Confederate Flag, people_who_match:interests:Republicans 12500 29 https://www.instagram.com/south_united/ Hey what's up buds! Let's continue to preserve our history from substitution. It is well-known how libtards are eager to blame our forefathers for being racist. Yet they always forget to underpin their empty words with facts. Not like all these SJWs, let's refer to racial discrimination in the army of Union. A black soldier was paid $10 a month with a $3 clothing fee taken out, while a white soldier was paid $13 a month but was not forced to pay a clothing allowance. Almost a twofold difference! How tolerant tho! And what was going on in the "racist" Confederate States Army? Every soldier was paid $11/month until 1864 regardless of his skin color. Click to Learn More! #southunited South United ( @south Yoyoyoyoyo 32.14304 2008.94 RUB 2016-01-15T01:14:22-08:00  
2774 location:United States, excluded_connections:Exclude people who like South United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Confederate Flag, people_who_match:interests:Confederate States Army, people_who_match:interests:American Civil War, people_who_match:interests:Southern Pride 511224 40134 https://www.facebook.com/South-United-1777037362551238/ Heritage, not hate. The South will rise again! South United 1253.71728 78357.33 RUB 2016-10-14T05:54:10-07:00  
2775 location:United States, excluded_connections:Exclude people who like South United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Confederate Flag, people_who_match:interests:Confederate States Army, people_who_match:interests:Southern Pride 41280 2927 https://www.facebook.com/South-United-1777037362551238/ Heritage, not hate. The South will rise again! South United 149.93008 9370.63 RUB 2017-01-16T03:06:47-08:00  
2776 location:United States, excluded_connections:Exclude people who like South United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Confederate Flag, people_who_match:interests:Confederate States Army, people_who_match:interests:Southern Pride 8484 330 https://www.facebook.com/South-United-1777037362551238/ Keep it flying high and proud! The South will rise again! 18.75216 1172.01 RUB 2017-02-13T04:32:19-08:00  
2777 location:United States, excluded_connections:Exclude people who like South United, age:18 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Confederate Flag, people_who_match:interests:Confederate States Army, people_who_match:interests:Southern Pride, people_who_match:interests:My Big Redneck Family, people_who_match:interests:Redneck Nation 1 0 https://www.facebook.com/South-United-1777037362551238/ God Bless Dixie! The South will rise again! 0.0 0.00 USD 2017-02-20T06:48:46-08: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 1237.257ms · Data source: simonw/russian-ira-facebook-ads-datasette