home / russian-ads

display_ads (view)

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

47 rows where an ad_target was people_who_match:interests:Martin Luther King III and an ad_target was people_who_match:interests:African—American culture

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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
931 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) 10543 1607 https://www.facebook.com/blacktivists/   4.8 300.00 RUB 2017-05-17T04:21:04-07:00 2017-05-18T11: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
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
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
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
948 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) 17771 2466 https://www.facebook.com/BIacktivist-128371547505950/ Let‘s be real. Our hair is always political. 5.3112 331.95 RUB 2016-12-05T23:17:42-08:00 2016-12-06T23:17:42-08:00
954 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) 5129 523 https://www.facebook.com/blacktivists/   4.8 300.00 RUB 2017-05-16T07:09:31-07:00 2017-05-17T09:00:00-07:00
957 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) 28841 1233 https://www.facebook.com/blacktivists/ Practicing the big sister skills. Practicing the big sister skills. 4.8 300.00 RUB 2017-05-16T06:12:45-07:00 2017-05-17T13:55:00-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
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
963 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) 9891 1479 https://www.facebook.com/blacktivists/ repost— 3.5417600000000005 221.36 RUB 2017-05-18T07:10:51-07:00 2017-05-19T13:00:00-07:00
965 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) 50812 9366 https://www.facebook.com/blacktivists/ repost— 4.8 300.00 RUB 2017-05-17T04:09:03-07:00 2017-05-18T09:00:00-07: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
968 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) 19510 3894 https://www.facebook.com/BIacktivist-128371547505950/ repost — 3.2 200.00 RUB 2017-03-23T02:47:38-07:00 2017-03-26T06:00:00-07:00
969 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) 8649 1288 https://www.facebook.com/blacktivists/ repost _ 3.2 200.00 RUB 2017-05-16T06:16:49-07:00 2017-05-17T18:00:00-07:00
978 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) 8389 1209 https://www.facebook.com/blacktivists/ repost _ 3.2 200.00 RUB 2017-04-21T07:39:28-07:00 2017-04-22T13:00:00-07:00
985 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) 11161 1602 https://www.facebook.com/blacktivists/ repeat — 3.2 200.00 RUB 2017-04-21T07:43:13-07:00 2017-04-22T15: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
995 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) 12308 2226 https://www.facebook.com/blacktivists/ reostp— 3.2 200.00 RUB 2017-04-20T01:30:11-07:00 2017-04-21T01:30:11-07:00
997 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) 7434 1200 https://www.facebook.com/blacktivists/ repost — 3.2 200.00 RUB 2017-04-19T07:16:35-07:00 2017-04-20T11: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
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
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
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
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
1014 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) 44393 7206 https://www.facebook.com/blacktivists/ repost _ 6.4 400.00 RUB 2017-04-13T04:44:53-07:00 2017-04-14T04:44:53-07:00
1015 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) 31651 5893 https://www.facebook.com/blacktivists/   4.8 300.00 RUB 2017-04-13T04:44:26-07:00 2017-04-14T04:44:26-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
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
1024 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) 253726 23021 https://www.facebook.com/BIacktivist-128371547505950/ You won‘t stop laughing if you watch this video. #FatherDaughterTalk 7.859680000000001 491.23 RUB 2017-02-22T06:15:48-08:00 2017-02-23T06:15:48-08:00
1027 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) 43618 6730 https://www.facebook.com/BIacktivist-128371547505950/ Black Power Puff Girls. Justice must be served! By any means necessary! 4.8 300.00 RUB 2017-02-07T07:18:42-08:00 2017-02-09T07:18:42-08: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
1053 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) 17905 2328 https://www.facebook.com/BIacktivist-128371547505950/   4.0592 253.70 RUB 2017-03-14T07:01:00-07:00 2017-03-15T12:00:00-07:00
1056 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) 14019 1733 https://www.facebook.com/blacktivists/ “RUNNING INTO DADDY‘S ARMS A LOT EASIER” Meet this little 2-year-old angel -Recently, she received her 1st Runners Blade. We can‘t wait to see what you do next, little one. 4.09072 255.67 RUB 2016-12-09T05:45:39-08:00 2016-12-10T05:45:39-08:00
1073 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) 27357 3208 https://www.facebook.com/blacktivists/ Look at this beautiful four generation photo. Such a blessing. 8.0 500.00 RUB 2016-11-30T07:13:38-08:00 2016-12-01T07:13:38-08:00
1075 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) 34188 4999 https://www.facebook.com/BIacktivist-128371547505950/ repost _ 3.2 200.00 RUB 2017-02-16T03:50:58-08:00 2017-02-17T03:50:58-08:00
1076 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) 81872 5921 https://www.facebook.com/BIacktivist-128371547505950/ Just because dads are the best friends. 8.0 500.00 RUB 2017-02-17T05:42:46-08:00 2017-02-18T05:42:46-08:00
1078 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) 19845 2214 https://www.facebook.com/BIacktivist-128371547505950/ You will never have to tell a real man how to be "the one" 8.0 500.00 RUB 2016-12-05T23:16:08-08:00 2016-12-06T23:16:08-08:00
1088 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) 25038 3275 https://www.facebook.com/BIacktivist-128371547505950/ Repost _ 6.4 400.00 RUB 2016-12-04T23:04:46-08:00 2016-12-06T23:04:46-08:00
1102 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) 15198 2533 https://www.facebook.com/blacktivists/ When your melanin pops severely. 4.31264 269.54 RUB 2016-12-08T23:09:37-08:00 2016-12-09T23:09:37-08:00
1103 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) 20252 2801 https://www.facebook.com/blacktivists/ The blue gang is free to do whatever they want. 9.6 600.00 RUB 2016-11-30T07:13:08-08:00 2016-12-01T07:13:08-08:00
1129 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) 17839 2945 https://www.facebook.com/blacktivists/ Repost _ 5.09488 318.43 RUB 2016-12-09T03:50:28-08:00 2016-12-10T03:50:28-08:00
1131 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) 143558 26964 https://www.facebook.com/BIacktivist-128371547505950/ repost— 3.2 200.00 RUB 2017-02-14T06:45:22-08:00 2017-02-15T06:45:22-08:00
1158 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) 19266 2665 https://www.facebook.com/blacktivists/ Black women are stunning, gorgeous and absolutely beautiful. 6.4 400.00 RUB 2016-12-07T23:05:45-08:00 2016-12-08T23:05:45-08:00
1187 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) 127370 16239 https://www.facebook.com/BIacktivist-128371547505950/ repost— 12.8 800.00 RUB 2017-02-02T03:57:36-08:00 2017-02-04T03:57:36-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 1279.699ms · Data source: simonw/russian-ira-facebook-ads-datasette