home / russian-ads

display_ads (view)

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

5 rows where an ad_target was age:16 - 40

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1039 location:united_states:Baltimore (+25 mi) Maryland, excluded_connections:Exclude people who are going to Freddie Gray Anniversary March, age:16 - 40, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:behaviors:African American (US) 40227 1606 https://www.facebook.com/events/248456415499895/ Come and march with us on 16 April. Stand with Baltimore. Let‘s make Change! Freddie Gray Anniversary March 111.18848 6949.28 RUB 2016-04-08T08:14:06-07:00  
1872 location:united_states:Latitude 41.88 Longitude -87.71 Chicago (+16 km), Chicago Heights (+40 km), Latitude 42.01 Longitude -87.91 Des Plaines (+16 km), Latitude 41.69 Longitude -88.19 Naperville (+16 km), Latitude 41.88 Longitude -88.11 Wheaton (+16 km) Illinois, location:united_states:Ferguson (+40 km) Missouri, interests:Cop Block, age:16 - 40, language:English (US), placements:Instagram Feed 1753 7 https://www.instagram.Com/Cop_block_us/ Fed up with police violence? Wanna stop police brutality? Join us! Click learn more! Cop Block Us ( @COp Block AmericanCops 12.30352 768.97 RUB 2015-12-01T04:01:12-08:00  
1878 location:United States, interests:Cop Block, behaviors:African American (US), age:16 - 40, language:English (US), placements:Instagram Feed 1632 13 https://www.instagram.Com/black_pride_us/ You know, every great accomplishment began with a small thought somewhere. May you move towards your dreams today. We hope you are doing good and also you are ready for a new week! We are proud of our black community and appreciate every follower! Stay with us because black lives do matter! Join us! Black Pride Yoyoyoyoyoy 9.37856 586.16 RUB 2015-11-17T06:58:43-08:00  
1900 location:United States, age:16 - 40, language:English (UK), language:English (US), placements:Instagram Feed, people_who_match:interests:Islam in the United States, people_who_match:interests:Allah Akbr 9741 53 https://www.instagram.Com/muslim_voice/ Click to Learn More! Everybody knows that Islam is against terrorism but not everyone believes this fact! Islam does not support terrorism under any Circumstances. Terrorism goes against every principle in Islam. In fact if a Muslim engages in terrorism, he is not following Islam and so he is not a Muslim! America, stop insulting peaceful Citizens, stop taking all of us as criminals, we don't deserve such attitude! #muslimvoice #muslim @muslim Voice - Muslimlnst 57.39792 3587.37 RUB 2016-01-15T01:59:05-08:00  
2409 location_living_in:United States, age:16 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:African American, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Police brutality in the United States, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 3810 291 https://www.facebook.com/blackmattersus.mvmnt/ Police have already killed 10 African Americans in November! Please, like and share! Click if you agree that police brutality against Blacks must stop: http://bit.|y/2gOJtQa 4.8 300.00 RUB 2016-11-28T07:26:17-08:00 2016-11-29T07:26:17-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 1302.008ms · Data source: simonw/russian-ira-facebook-ads-datasette