home / russian-ads

display_ads (view)

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

7 rows where an ad_target was people_who_match:interests:Bernie Sanders

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
565 location:united_states:Kansas, age:14 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:Lesbian community, people_who_match:interests:LGBT community, people_who_match:interests:Hillary Clinton, people_who_match:interests:Same—sex marriage 4798 240 https://www.facebook.com/events/533144703560571/ Westboro baptist church is planning to stand against tolerance in education system near LG God H85 Bigots Rally 50.186879999999995 3136.68 RUB 2016-05-12T08:05:06-07:00 2016-05-22T07:19:00-07:00
618 location:united_states:Kansas, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:LGBT community, people_who_match:interests:Hillary Clinton, people_who_match:interests:Same-sex marriage 0 0 https://www.facebook.com/LGBT-United-839497472793277/ Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those idiots. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! 0.0 0.00 USD 2016-05-12T08:05:04-07:00 2016-05-12T08:27:26-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  
2429 location_living_in:United States, excluded_connections:Exclude people who like Born Liberal, 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:Bernie Sanders, people_who_match:interests:Liberalism 9502 1079 https://www.facebook.com/bornliberall New ideas, old values. Like us! 165.92128 10370.08 RUB 2016-06-07T05:38:34-07:00  
2430 location_living_in:United States, excluded_connections:Exclude people who like Born Liberal, 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:Bernie Sanders, people_who_match:interests:Social democracy, people_who_match:interests:Liberalism, people_who_match:interests:Democratic Party (United States) 49920 4799 https://www.facebook.com/bornliberall New ideas, old values. Like us! 586.0768 36629.80 RUB 2016-07-14T00:58:10-07:00  
2431 location_living_in:United States, excluded_connections:Exclude people who like Born Liberal, age:45 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:Social democracy, people_who_match:interests:Liberal Democrats, people_who_match:interests:Liberalism, people_who_match:interests:LGBT community, people_who_match:interests:Anti-racism, people_who_match:interests:Anti-discrimination 33349 2710 https://www.facebook.com/bornliberall New ideas, old values. Like us! 143.9464 8996.65 RUB 2016-10-11T07:11:08-07:00  
2432 location_living_in:United States, excluded_connections:Exclude people who like Born Liberal, age:45 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:Social democracy, people_who_match:interests:Liberal Democrats, people_who_match:interests:Liberalism, people_who_match:interests:LGBT community, people_who_match:interests:Anti-racism, people_who_match:interests:Anti-discrimination 0 0 https://www.facebook.com/Born-LiberaI-522628564598423/ New ideas, old values. Join! 0.0 0.00 USD 2017-02-22T05:40:21-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 1351.005ms · Data source: simonw/russian-ira-facebook-ads-datasette