home / russian-ads

display_ads (view)

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

191 rows where an ad_target was people_who_match:interests:Pan-Africanism sorted by spend_usd

View and edit SQL

id img targeting impressions clicks url text spend_usd ▼ spend_amount spend_currency created ended
936 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African—American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 0 0 https://www.facebook.com/blacktivists/ Only mom can jump in the conversation and resolve the argument between father and daughter and finally settle on the proper way to count. Only mom can jump in the conversation and resolve the argument... 0.0 0.00 USD 2017-04-13T04:43:00-07:00 2017-04-16T10:00:00-07:00
1048 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 0 0 https://www.facebook.com/blacktivists/ repost — 0.0 0.00 USD 2017-03-14T07:15:45-07:00 2017-03-16T10:00:00-07:00
1077 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 0 0 https://www.facebook.com/Blacktivist-128371547505950/ Goals! Congrats to these two! 0.0 0.00 USD 2017-02-07T07:18:27-08:00 2017-02-09T07:18:27-08:00
1161 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Africanism, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black (Color) 0 0 https://www.facebook.com/Blacktivist-128371547505950/ Back when natural beauty and having a girl was COOL... 0.0 0.00 USD 2017-03-15T05:24:11-07:00 2017-03-16T08:00:00-07:00
1184 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Africanism, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black (Color) 0 0 https://www.facebook.com/Blacktivist-128371547505950/ Back when natural beauty and having a girl was COOL... 0.0 0.00 USD 2017-03-14T07:14:26-07:00 2017-03-16T08:00:00-07:00
1185 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 0 0 https://www.facebook.com/blacktivists/   0.0 0.00 USD 2017-03-15T05:18:46-07:00 2017-03-16T06:00:00-07:00
2846 location:United States, excluded_connections:Exclude people who like Pan-African roots MOVE, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan-Africanism, people_who_match:interests:African- American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:The Move, people_who_match:interests:Malcolm X 0 0 https://www.facebook.com/PanAfrootsmove/ Join us and make Changes for the Black community. It’s time to take actions. 0.0 0.00 USD 2016-10-18T05:50:45-07:00 2017-05-11T06:00:00-07:00
3233 location_living_in:China, excluded_connections:Exclude people who like Nefertiti's Community, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Pan-Africanism, people_who_match:interests:Kemetism, people_who_match:interests:Black Girls Rock! 0 0 https://www.facebook.com/Nefertitis-Community-576081822594619/ If u love to be woke and u wanna improve ur knowledge of self, join our community! We post love everything hotep! Nefertiti's Community 0.0 0.00 USD 2016-12-08T03:58:11-08:00  
3236 location_living_in:United States, excluded_connections:Exclude people who like Nefertiti's Community, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Pan-Africanism, people_who_match:interests:Kemetism, people_who_match:interests:Black Girls Rock! 0 0 https://www.facebook.com/Nefertitis-Community-576081822594619/ We are an online community of woke people. Our goal is to empower you with inspiration! 0.0 0.00 USD 2016-12-09T00:09:50-08:00  
3345 location_living_in:united_states:New York (+25 mi) New York, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan-Africanism, people_who_match:interests:Black Power, people_who_match:interests:Martial arts, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African-American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X, people_who_match:interests:Self Defense Family, people_who_match:interests:Black (Color), people_who_match:interests:The Self Defense Company, and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 0 0 https://www.facebook.com/events/406662303016780/ Join the event, bring your friends, feel safe with us! It's free! Organized on a donation basis. Free SeIf-defense class in NY - 0.0 0.00 USD 2017-03-21T08:22:41-07:00 2017-02-25T06:37:34-08:00
3349 location_living_in:united_states:Long Beach (+25 mi) California, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan-Africanism, people_who_match:interests:Black Power, people_who_match:interests:African American, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:African— American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Black History Month, people_who_match:interests:African-American history, people_who_match:interests:Angela Davis, people_who_match:interests:Malcolm X, people_who_match:interests:Black (Color), and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Self- defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self—defense, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Active Self Protection 0 0 https://www.facebook.com/events/1659819367655435/ Join the event, bring your friends, feel safe with us! Don't miss the opportunity to train outdoors! It's free! Organized on a donation basis. Free SeIf-defense class in Orlando, F'— 0.0 0.00 USD 2017-02-27T07:08:03-08:00 2017-02-25T08:00:00-08:00
3235 location_living_in:United States, excluded_connections:Exclude people who like Nefertiti's Community, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Pan-Africanism, people_who_match:interests:Kemetism, people_who_match:interests:Black Girls Rock! 2 0 https://www.facebook.com/Nefertitis-Community-576081822594619/ If u love to be woke and u wanna improve ur knowledge of self, join our community! We post love everything hotep! Nefertiti's Community 0.01808 1.13 RUB 2016-12-08T23:59:06-08:00  
967 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 492 72 https://www.facebook.com/BIacktivist-128371547505950/   0.23248 14.53 RUB 2017-03-29T07:31:03-07:00 2017-03-30T07:31:03-07:00
950 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 458 84 https://www.facebook.com/blacktivists/ reosp— 0.42192 26.37 RUB 2017-05-11T04:19:41-07:00 2017-05-11T08:15:41-07:00
1031 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 489 74 https://www.facebook.com/blacktivists/ repost — 0.48624 30.39 RUB 2017-03-15T05:23:43-07:00 2017-03-16T06:00:00-07:00
2797 location:United States, excluded_connections:Exclude people who like Nefertiti's Community, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Pan-Africanism, people_who_match:interests:Black history, people_who_match:interests:Black (Color) 7 2 https://www.facebook.com/Nefertitis-Community-576081822594619/ Join us to study your blackness and get the power from your roots. Stay woke and natural! 0.5249600000000001 32.81 RUB 2016-10-18T01:35:53-07:00  
2801 location:United States, excluded_connections:Exclude people who like Nefertiti's Community, age:18 - 60, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Africanism, people_who_match:interests:Black Enterprise, people_who_match:interests:Black (Color) 98 17 https://www.facebook.com/Nefertitis-Community-576081822594619/ Kaepernick declared that both of the major presidential candidates, Donald Trump and Hillary Clinton, were racist and thus not worthy of his support! #woke #king #vote #election #black #power #resistance 0.63248 39.53 RUB 2016-11-15T05:17:16-08:00 2016-11-16T05:17:16-08:00
2805 location:United States, excluded_connections:Exclude people who like Nefertiti's Community, age:18 - 60, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Africanism, people_who_match:interests:Black Enterprise, people_who_match:interests:Black (Color) 125 18 https://www.facebook.com/Nefertitis-Community-576081822594619/ All power to the black community! #black #fist #resistance #blackpanthers #COOI 0.63616 39.76 RUB 2016-11-15T05:19:09-08:00 2016-11-16T05:19:09-08:00
1190 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Africanism, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black (Color) 4371 568 https://www.facebook.com/Blacktivist-128371547505950/ Blacks and Natives do not just share a rich history, but also enormous struggles. Brothers and Sisters! We should stand together against a common oppressor. 1.01552 63.47 RUB 2016-12-03T01:24:45-08:00 2016-12-05T01:24:45-08:00
944 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 9022 1363 https://www.facebook.com/blacktivists/ Black beauty in all shades. 1.08224 67.64 RUB 2017-03-16T05:34:24-07:00 2017-03-17T13:00:00-07:00
984 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Africanism, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black (Color) 3655 628 https://www.facebook.com/blacktivists/ repost @[857553657667666:274:Chakabars] 1.15872 72.42 RUB 2017-04-21T07:41:56-07:00 2017-04-23T11:00:00-07:00
1020 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 10942 1999 https://www.facebook.com/BIacktivist-128371547505950/ repost — 1.36752 85.47 RUB 2017-03-23T02:45:04-07:00 2017-03-25T06:00:00-07:00
1002 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 4416 647 https://www.facebook.com/blacktivists/ reostp — 1.4785599999999999 92.41 RUB 2017-04-14T08:03:40-07:00 2017-04-15T18:00:00-07:00
932 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Africanism, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black (Color) 16654 2166 https://www.facebook.com/blacktivists/ Meet Carlos Morales, the father of quadruplets who raises his Children alone after his wife passed away during Childbirth. You are my hero! 1.5100799999999999 94.38 RUB 2017-03-16T05:33:16-07:00 2017-03-17T08:00:00-07:00
1004 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 3732 539 https://www.facebook.com/blacktivists/ repost _ 1.5649600000000001 97.81 RUB 2017-04-14T08:02:31-07:00 2017-04-15T15:00:00-07:00
1030 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 162331 12303 https://www.facebook.com/Blacktivist-128371547505950/ Make sure you guide your Children and motivate them. 1.6 100.00 RUB 2017-02-21T05:45:54-08:00 2017-02-22T05:45:54-08:00
1003 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 1797 230 https://www.facebook.com/blacktivists/   1.63984 102.49 RUB 2017-04-14T08:03:15-07:00 2017-04-15T17:00:00-07:00
987 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 6482 1250 https://www.facebook.com/blacktivists/   1.6768 104.80 RUB 2017-04-21T07:42:24-07:00 2017-04-24T09:00:00-07:00
934 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 10373 1501 https://www.facebook.com/blacktivists/ Police brutality in America gone crazy. But America is too busy bombing countries in the Middle East. 1.7756800000000001 110.98 RUB 2017-05-23T06:13:38-07:00 2017-05-29T08:00:00-07:00
1007 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 2919 315 https://www.facebook.com/blacktivists/   1.8867200000000002 117.92 RUB 2017-04-14T08:01:00-07:00 2017-04-15T13:00:00-07:00
988 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Africanism, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black (Color) 4372 553 https://www.facebook.com/blacktivists/ Meet Tamya Fultz, 13, the member of the Chess team at Earle STEM elementary school, who just took the bronze in the IESA state Chess tournament in Peoria. 1.9646400000000002 122.79 RUB 2017-04-21T07:41:22-07:00 2017-04-23T06:00:00-07:00
2803 location:United States, excluded_connections:Exclude people who like Nefertiti's Community, age:18 - 60, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Pan-Africanism, people_who_match:interests:Black Enterprise, people_who_match:interests:Black (Color) 64 5 https://www.facebook.com/Nefertitis-Community-576081822594619/ We focus on Pan-African art and design. Welcome, kings and queens! 2.02752 126.72 RUB 2016-10-17T09:05:07-07:00  
958 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 16816 2295 https://www.facebook.com/blacktivists/   2.19264 137.04 RUB 2017-03-16T05:40:05-07:00 2017-03-17T12:00:00-07:00
1005 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 8164 1017 https://www.facebook.com/blacktivists/ repost _ 2.26608 141.63 RUB 2017-04-14T08:01:51-07:00 2017-04-15T15:00:00-07:00
1006 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 3517 337 https://www.facebook.com/blacktivists/ It‘s not flesh and blood. But the heart which makes us fathers and sons. 2.3377600000000003 146.11 RUB 2017-04-14T08:01:22-07:00 2017-04-15T13:55:00-07:00
1009 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Africanism, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black (Color) 3152 310 https://www.facebook.com/blacktivists/ Have a good day, kings, queens, Black Gods and Goddess! 2.38112 148.82 RUB 2017-04-14T08:00:00-07:00 2017-04-15T10:00:00-07:00
1012 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Pan-Africanism, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black (Color) 10922 1310 https://www.facebook.com/blacktivists/ This is Diego. He is crying at the funeral of his teacher Evandro Joéo da Silva, who helped him come out of poverty and violence through music. 2.48544 155.34 RUB 2017-04-14T07:57:59-07:00 2017-04-17T07:57:59-07:00
1010 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African—American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 23950 2515 https://www.facebook.com/blacktivists/ This video is so precious. Father surprises his daughter when he comes to her school after being released from prison. His daughter hasn't seen him for years. This video is so precious. Father surprises his daughter when... 2.61296 163.31 RUB 2017-04-14T07:59:25-07:00 2017-04-15T09:00:00-07:00
982 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 8031 896 https://www.facebook.com/blacktivists/ Recent US-Ied coalition strike in Syria‘s Raqqa province has killed 12 Syrian women. The second coalition strike killed a further 23 Syrian Civilians. The US bombed Syria because of political regime, that American government believes is torturing people. Well, we are so thankful that Syria didn't bomb America for poisoning Children in Flint and gassing natives at Standing Rock. 2.73184 170.74 RUB 2017-05-16T07:05:58-07:00 2017-05-21T08:00:00-07:00
939 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 10493 1868 https://www.facebook.com/blacktivists/   2.77808 173.63 RUB 2017-05-18T07:12:05-07:00 2017-05-19T16:00:00-07:00
1019 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 5115 583 https://www.facebook.com/blacktivists/   2.832 177.00 RUB 2017-04-13T03:41:20-07:00 2017-04-14T03:41:20-07:00
1083 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 41781 6542 https://www.facebook.com/blacktivists/ It's beautiful when you grow together 3.1889600000000002 199.31 RUB 2017-03-14T01:15:46-07:00 2017-03-15T08:00:00-07:00
989 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 7745 1110 https://www.facebook.com/blacktivists/   3.19984 199.99 RUB 2017-04-21T07:40:47-07:00 2017-04-22T18:00:00-07:00
928 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 11287 1567 https://www.facebook.com/blacktivists/ repost — 3.2 200.00 RUB 2017-05-19T07:12:06-07:00 2017-05-20T11:00:00-07:00
930 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 28677 4314 https://www.facebook.com/blacktivists/ repost _ 3.2 200.00 RUB 2017-05-16T06:14:35-07:00 2017-05-17T13:00:00-07:00
937 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 32942 4290 https://www.facebook.com/blacktivists/   3.2 200.00 RUB 2017-05-16T06:17:51-07:00 2017-05-17T06:17:51-07:00
945 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 7193 1066 https://www.facebook.com/blacktivists/ reostp— 3.2 200.00 RUB 2017-05-19T07:11:43-07:00 2017-05-20T09:00:00-07:00
953 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 83692 4369 https://www.facebook.com/blacktivists/ This video may bring tears to your eyes. Make it go viral. We need this unity in our communities. This video may bring tears to your eyes. Make it go viral. We www.facebook.com 3.2 200.00 RUB 2017-03-23T02:47:20-07:00 2017-03-25T13:00:00-07:00
959 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 31093 5101 https://www.facebook.com/blacktivists/ Believe it or not, black doctors exist. 3.2 200.00 RUB 2017-03-23T02:50:09-07:00 2017-03-26T11:00:00-07:00
960 location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black nationalism, people_who_match:interests:Pan-Africanism, people_who_match:interests:Police misconduct, people_who_match:interests:African—American culture, people_who_match:interests:African—American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Martin Luther King III, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 7527 878 https://www.facebook.com/BIacktivist-128371547505950/ repost — 3.2 200.00 RUB 2017-03-23T02:43:42-07:00 2017-03-24T10:00:00-07:00

Next page

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 1390.227ms · Data source: simonw/russian-ira-facebook-ads-datasette