home / russian-ads

display_ads (view)

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

32 rows where an ad_target was interests:Pan-Africanism

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
1023 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 4172 290 https://represent.com/store/notmypresident Click on the picture if Trump is not your president. #notmypresident https://represent.com/store/notmypresident STOP TRUMP! STOP RACISM! Buying these t-shirts you donate to the events against hate and racism. #NotMyPresident Blacktivist 4.8 300.00 RUB 2016-11-18T08:21:15-08:00 2016-11-19T08:21:15-08:00
1028 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 191238 11360 https://www.facebook.com/Blacktivist-128371547505950/ Watch this heart-piercing story about a racial bias that might cause law enforcement officers to shoot innocent and unarmed black people. 8.0 500.00 RUB 2016-11-03T08:12:06-07:00 2016-11-10T07:12:06-08:00
1034 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 34025 2586 https://represent.com/not-my-president-1 Donald Trump is NOT your president? Click on his face. Stop Trump and his bigoted agenda! Not My President Blacktivist 19.213279999999997 1200.83 RUB 2016-11-11T07:08:33-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
1055 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, 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 forget Huey Newton and Bobby Seale, who founded the Black Panther Party for SeIf-Defense in October 1966. 0.0 0.00 USD 2016-10-18T06:57:05-07:00 2016-10-19T06:57:04-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
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
1084 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 64032 11056 https://www.facebook.com/Blacktivist-128371547505950/ The best costume for Halloween worth posting. Power to the People! 8.0 500.00 RUB 2016-11-03T08:10:07-07:00 2016-11-10T07:10:07-08:00
1086 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 152716 19558 https://www.facebook.com/Blacktivist-128371547505950/ Look at these gorgeous queens in all shades. 8.0 500.00 RUB 2016-11-03T08:11:21-07:00 2016-11-10T07:11:21-08: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
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
1101 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 10831 1804 https://www.facebook.com/Blacktivist-128371547505950/ FOOTBALL COACH SUSPENDED AND THE WHOLE SEASON CANCELED AFTER YOUNG ATHLETES TOOK A KNEE Young people continue to take a knee during a national anthem to protest police brutality and racial injustice in America. However, most of these athletes paid the price for this demonstration. For instance, on September 10, after getting permission from league officials, the staff and the students of the Beaumont Bulls football team took a knee before their game. On the next day, the students and the staff received death threats. Moreover, the executive board decided to suspend Coach RahORah Barber for the rest of the season and canceled the whole football season. So now we know what opposition might face in this country. 9.6 600.00 RUB 2016-10-20T07:54:03-07:00 2016-10-21T07:54:02-07:00
1124 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 31308 3704 https://www.facebook.com/Blacktivist-128371547505950/ In America, racial oppression and racism were never an ancient history. 6.4 400.00 RUB 2016-11-01T06:22:05-07:00 2016-11-02T06:22:04-07:00
1134 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 45404 7885 https://www.facebook.com/Blacktivist-128371547505950/ When a man in blue afraid of a person of color so he has to shoot him,- "blue" lives don‘t exist. 8.0 500.00 RUB 2016-11-03T08:07:40-07:00 2016-11-10T07:07:40-08:00
1153 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 12398 1528 https://www.facebook.com/Blacktivist-128371547505950/ The media did not report this story. But we will. This Nigerian Surgeon in Texas Children‘s Hospital removed a baby from a womb and operated on her tumor returning the baby to her mother‘s uterus. The baby was born healthy. 6.4 400.00 RUB 2016-11-01T06:22:23-07:00 2016-11-02T06:22:22-07:00
1160 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 14372 2011 https://www.facebook.com/Blacktivist-128371547505950/ The truth matters. Stand for what you believe, kneel for what you don‘t. 6.4 400.00 RUB 2016-10-18T06:44:01-07:00 2016-10-19T06:43:59-07:00
1163 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 6780 1287 https://www.facebook.com/Blacktivist-128371547505950/ Share this gorgeous 86-year-old bride. 8.0 500.00 RUB 2016-10-20T07:53:36-07:00 2016-10-21T07:53:35-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
1183 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 18888 1635 https://www.facebook.com/Blacktivist-128371547505950/ Choose peace and vote for Jill Stein. Trust me, it‘s not a wasted vote. 8.0 500.00 RUB 2016-11-03T08:10:21-07:00 2016-11-10T07:10:21-08:00
1192 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 43022 6981 https://www.facebook.com/Blacktivist-128371547505950/ In America, you always feel like there is something wrong with being proud of your ethnicity that is often mistaken as hate. 8.0 500.00 RUB 2016-11-03T08:12:43-07:00 2016-11-10T07:12:43-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 1319.62ms · Data source: simonw/russian-ira-facebook-ads-datasette