home / russian-ads

display_ads (view)

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

10 rows where an ad_target was interests:Black (Color) and an ad_target was interests:African- American culture

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1021 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 38002 5645 https://www.facebook.com/BIacktivist-128371547505950/ repost Back when tv was dope... melanin #blacklove #tv #blacksitcoms #blacktv #blacktelevision 8.0 500.00 RUB 2016-11-18T08:22:22-08:00 2016-11-19T08:22:22-08:00
1041 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 31096 3516 https://www.facebook.com/Blacktivist-128371547505950/ Black intelligence is one of the most highly feared things in this country. 4.8 300.00 RUB 2016-11-03T08:09:10-07:00 2016-11-10T07:09:10-08:00
1045 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African—American Civil Rights Movement (1954—68), interests:African— American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 20322 2847 https://www.facebook.com/BIacktivist-128371547505950/ Absolutely stunning Child. 6.4 400.00 RUB 2016-11-01T06:22:57-07:00 2016-11-02T06:22:56-07:00
1052 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African—American Civil Rights Movement (1954—68), interests:African— American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 10808 2218 https://www.facebook.com/BIacktivist-128371547505950/ How interesting! But you can only get white from black. 9.6 600.00 RUB 2016-10-20T07:54:43-07:00 2016-10-21T07:54:41-07:00
1057 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 16202 1872 https://www.facebook.com/blacktivists/ Growing up dark skinned in America is not an easy task to do. Tell your Children that they represent a rainbow of beautiful shades, that make them special. 6.4 400.00 RUB 2016-11-01T06:23:30-07:00 2016-11-02T06:23:29-07:00
1070 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African—American Civil Rights Movement (1954—68), interests:African— American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 28025 3291 https://www.facebook.com/BIacktivist-128371547505950/ Bless this kid and her parents who keep out Heritage alive. #RosaParks 6.4 400.00 RUB 2016-11-01T06:21:48-07:00 2016-11-02T06:21:47-07:00
1072 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African—American Civil Rights Movement (1954—68), interests:African— American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 12077 2393 https://www.facebook.com/BIacktivist-128371547505950/ Dear cop, please stop using our children for publicity stunts. 8.0 500.00 RUB 2016-10-20T07:51:40-07:00 2016-10-21T07:48:36-07:00
1074 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 68239 9666 https://www.facebook.com/Blacktivist-128371547505950/ It‘s should be an official terminology. 8.0 500.00 RUB 2016-11-03T08:09:45-07:00 2016-11-10T07:09:45-08:00
1098 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 18808 2494 https://www.facebook.com/Blacktivist-128371547505950/ You won‘t see this image Circulating on social media, because it‘s too positive for America. 4.8 300.00 RUB 2016-11-18T08:22:43-08:00 2016-11-19T08:22:43-08:00
1179 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:Police misconduct, interests:African- American culture, interests:African-American Civil Rights Movement (1954—68), interests:African- American history, interests:Black Consciousness Movement, interests:Martin Luther King III, interests:Stop Police Brutality, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 20526 3605 https://www.facebook.com/BIacktivist-128371547505950/   6.4 400.00 RUB 2016-11-18T08:21:54-08:00 2016-11-19T08:21:54-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 1334.735ms · Data source: simonw/russian-ira-facebook-ads-datasette