home / russian-ads

display_ads (view)

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

24 rows where an ad_target was interests:Black nationalism

This data as JSON, CSV (advanced)

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
1062 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black is beautiful, interests:Black Consciousness Movement, interests:Martin Luther King ”I, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Blacktivist-128371547505950/ Anyways, nobody is listening to us. 0.0 0.00 USD 2016-10-18T06:42:06-07:00 2016-10-13T03:59:39-07:00
1063 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Martin Luther King ”I, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Blacktivist-128371547505950/ Anyways, nobody is listening to us. 0.0 0.00 USD 2016-10-18T06:42:43-07:00 2016-10-13T03:59:39-07:00
1065 location:United States, interests:Black nationalism, interests:Pan-Africahism, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black is beautiful, interests:Black Consciousness Movement, interests:Martin Luther King ”I, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Blacktivist-128371547505950/ Don‘t Choose the side of the oppressor! There is enough room for you in the fight for black equality and justice. A fight for Civil Rights isn‘t over 0.0 0.00 USD 2016-10-18T06:42:05-07:00 2016-10-15T03:20:13-07:00
1066 location:United States, interests:Black nationalism, interests:Pan-Africahism, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Martin Luther King ”I, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Blacktivist-128371547505950/ Don‘t Choose the side of the oppressor! There is enough room for you in the fight for black equality and justice. A fight for Civil Rights isn‘t over 0.0 0.00 USD 2016-10-18T06:42:45-07:00 2016-10-15T03:20:13-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
1071 location:United States, interests:Black nationalism, interests:Pan-Africanism, 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:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIacktivist-128371547505950/ Dear cop, please stop using our children for publicity stunts. 0.0 0.00 USD 2016-10-20T07:48:37-07:00 2016-10-21T07:48:36-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
1087 location:United States, interests:Black nationalism, interests:Pan—Africanism, interests:African—American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Martin Luther King I”, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 12055 1781 https://www.facebook.com/Blacktivist-128371547505950/ Positive young black men serving this country will not be on any news outlet. That‘s why we decided to post it here. 6.4 400.00 RUB 2016-10-18T06:57:44-07:00 2016-10-19T06:57:43-07:00
1093 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black is beautiful, interests:Black Consciousness Movement, interests:Martin Luther King ”I, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Blacktivist-128371547505950/ This young woman who resembles an iconic activist, Angela Davis brought back good memories. 0.0 0.00 USD 2016-10-18T06:42:06-07:00 2016-10-17T03:17:22-07:00
1094 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Martin Luther King ”I, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Blacktivist-128371547505950/ This young woman who resembles an iconic activist, Angela Davis brought back good memories. 0.0 0.00 USD 2016-10-18T06:42:44-07:00 2016-10-17T03:17:22-07:00
1095 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 17618 2094 https://www.facebook.com/Blacktivist-128371547505950/ Never back down, my friends. Black America is so tired of explaining and debating. 6.4 400.00 RUB 2016-11-01T06:24:00-07:00 2016-11-02T06:23:59-07: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
1136 location:United States, interests:Black nationalism, interests:Pan—Africanism, interests:African—American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Martin Luther King I”, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 9746 1415 https://www.facebook.com/Blacktivist-128371547505950/ Share this and make it go viral. Media won‘t share this because positive Black male images it‘s not okay to display in America. 6.4 400.00 RUB 2016-10-18T06:58:45-07:00 2016-10-19T06:58:44-07:00
1140 location:United States, interests:Black nationalism, interests:Pan—Africanism, interests:African—American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Martin Luther King I”, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 11817 2744 https://www.facebook.com/BIacktivist-128371547505950/ A black man employed by Comcast being given a ticket for doing his job. This man was working on a house when a bystander reported him to the cops. When police showed up, they drew the gun and told the man to put his hands up because he was accused of walking around the property, looking through windows and searching for a way to steal from home. Despite the fact that the man wore a red Comcast shirt and was standing next to his white Comcast truck searching for some wiring to do his job, the police gave him a ticket for literally doing hisjob. Welcome to the United States of Racism. 6.4 400.00 RUB 2016-10-18T06:44:30-07:00 2016-10-19T06:44:29-07:00
1165 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black is beautiful, interests:Black Consciousness Movement, interests:Martin Luther King ”I, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIacktivist-128371547505950/ Their mom decided to start her Children‘s first day of school at the National Museum of African American History and Culture. What a great day of homeschool. 0.0 0.00 USD 2016-10-18T06:42:07-07:00 2016-10-15T03:19:28-07:00
1166 location:United States, interests:Black nationalism, interests:Pan-Africanism, interests:African-American culture, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black Consciousness Movement, interests:Martin Luther King I”, interests:Black (Color), age:16 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BIacktivist-128371547505950/ Their mom decided to start her Children‘s first day of school at the National Museum of African American History and Culture. What a great day of homeschool. 0.0 0.00 USD 2016-10-18T06:42:43-07:00 2016-10-15T03:19:28-07:00
1176 location:United States, interests:Black nationalism, interests:Pan-Africanism, 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:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 17968 2305 https://www.facebook.com/BIacktivist-128371547505950/ Share this image, because it will never make it to the mainstream media. 6.4 400.00 RUB 2016-10-18T06:43:38-07:00 2016-10-19T06:43:37-07: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/umd-mith/irads/master/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 1538.476ms · Data source: simonw/russian-ira-facebook-ads-datasette