home / russian-ads

display_ads (view)

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

28 rows where an ad_target was people_who_match:interests:African—American history

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
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
1022 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) 48518 4588 https://www.facebook.com/BIacktivist-128371547505950/ In America, most employees are instructed to follow black and Latino customers, because they 'always are the ones that are the thieves.‘ Racial profiling? Yes, it is. 6.4 400.00 RUB 2016-12-04T23:03:21-08:00 2016-12-05T23:03:21-08:00
1026 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) 34796 3525 https://www.facebook.com/BIacktivist-128371547505950/ repost— The powerful statement. 3.2 200.00 RUB 2017-02-14T06:50:57-08:00 2017-02-15T06:50:57-08:00
1180 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) 17158 2527 https://www.facebook.com/BIacktivist-128371547505950/ BO? 5.007680000000001 312.98 RUB 2017-03-14T07:20:18-07:00 2017-03-15T16:00:00-07:00
1933 location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Black nationalism, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Black Power, people_who_match:interests:Black history, people_who_match:interests:Black Panther Party, people_who_match:interests:Afrocentrism, 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:Black is beautiful, people_who_match:interests:Black Consciousness Movement, people_who_match:interests:Malcolm X, people_who_match:interests:New Black Panther Party 2756 79 https://www.instagram.com/black_america_today/ You can achieve anything you want without taking your Clothes off. For more positive black pictures follow BLACK_AMER|CA_TODAY! Today is the day to rise up and act! Proudblacks 8.629280000000001 539.33 RUB 2016-08-04T06:54:34-07:00 2016-09-04T06:47:01-07:00
1988 location_living_in:United States, age:18 - 65+, 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: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:Malcolm X 821 59 https://blackmattersus.com/33616-black-Iives-matter-to—help-incarcerated- Please, don’t stay indifferent as your mother could be one of these women! Before Mother's Day, Black Lives Matter will try and support some female minor offenders. Black Lives Matter To Help Incarcerated Mothers | BIaCkMattersUS.com blackmattersuscom 2.95392 184.62 RUB 2017-05-12T08:00:17-07:00 2017-05-13T08:00:17-07:00
2093 location_living_in:United States, age:18 — 65+, 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: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:Malcolm X 5006 641 https://www.facebook.com/blackmattersus.mvmnt/ Dope! When our people stay woke! I hope these are 16 new black businesses. 3.2 200.00 RUB 2017-04-14T07:08:38-07:00 2017-04-15T10:05:00-07:00
2129 location_living_in:United States, age:18 — 65+, 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: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:Malcolm X 0 0 https://www.facebook.com/blackmattersus.mvmnt/ Absolutely stunning little baby girl with a beautiful smile straight from the heart! Children with special needs matter! 0.0 0.00 USD 2017-04-28T07:05:19-07:00 2017-04-30T20:59:00-07:00
2131 location_living_in:United States, age:18 - 65+, 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: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:Malcolm X 1477 202 https://b|ackmattersus.com/32867-black-Iives-matter-plans—to-baiI-out-moms- Memphis Black Lives Matter chapter plans to collect money to bail out moms for Mother's Day Memphis Black Lives Matter chapter plans to collect money to bail out moms for Mother's Day Black Lives Matter Plans To Bail Out Moms For Mother's Day | BlackMattersUS.com blackmattersus.com 1.64912 103.07 RUB 2017-04-24T08:10:44-07:00 2017-04-25T08:10:44-07:00
2243 location_living_in:United States, age:18 - 65+, 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:African-American culture, people_who_match:interests:African—Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African—American history, people_who_match:interests:Malcolm X 2618 284 https://represent.oom/store/notmypresident Are you ready for anti-Trump meetups? Are you ready to voice your concerns? Click here to get prepaired! #NotMyPresident STOP TRUMP! STOP RACISM! Buying these t—shirts you donate to the events against hate and racism. #NotMyPresident BM 6.4 400.00 RUB 2016-11-18T07:30:08-08:00 2016-11-19T07:30:08-08:00
2244 location_living_in:united_states:Atlanta (+25 mi) Georgia, age:18 - 65+, 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:African-American culture, people_who_match:interests:African—Amerioan Civil Rights Movement (1954—68), people_who_match:interests:African—American history, people_who_match:interests:Malcolm X 0 0 https://represent.oom/store/notmypresident Are you ready for anti-Trump meetups? Are you ready to voice your concerns? Click here to get prepaired! #NotMyPresident STOP TRUMP! STOP RACISM! Buying these t—shirts you donate to the events against hate and racism. #NotMyPresident BM 0.0 0.00 USD 2016-11-22T05:51:29-08:00 2016-11-19T07:30:08-08:00
2828 location:United States, excluded_connections:Exclude people who like Pan—African roots MOVE, age:18 - 65+, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Pan-Africanism, people_who_match:interests:Kemetism, 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:Malcolm X 234401 10018 https://www.facebook.com/PanAfrootsmove/ Unapologetically melaneted Kings and Queens are powerful together. Join us! Pan-Afican Roots MOVE 488.12256 30507.66 RUB 2016-11-11T04:04:53-08:00  
3186 location:United States, excluded_connections:Exclude people who like Black guns matter, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:African—American history, people_who_match:interests:Second Amendment to the United States Constitution, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:Firearm, people_who_match:interests:Malcolm X 396 32 https://www.facebook.com/ProtectBIackGunOwners/ Black American racial experience is real. We support the 2nd ammendment for our safety. 16.81232 1050.77 RUB 2016-11-14T04:10:27-08:00  
3187 location:United States, excluded_connections:Exclude people who like Black guns matter, 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:2nd Amendment, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:African—American history, people_who_match:interests:Malcolm X 0 0 https://www.facebook.com/ProtectBIackGunOwners/ Black American racial experience is real. We support the 2nd ammendment for our safety. 0.0 0.00 USD 2016-11-16T01:08:41-08:00  
3188 location:United States, excluded_connections:Exclude people who like Black guns matter, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:National Rifle Association, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:African—American history, people_who_match:interests:Malcolm X 0 0 https://www.facebook.com/ProtectBIackGunOwners/ Black American racial experience is real. We support the 2nd ammendment for our safety. 0.0 0.00 USD 2016-11-16T01:15:28-08:00  
3189 location:United States, excluded_connections:Exclude people who like Black guns matter, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:National Rifle Association, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:African—American history, people_who_match:interests:Malcolm X 0 0 https://www.facebook.com/ProtectBIackGunOwners/ We are black and we support the 2nd Ammendment! Join us, if seIf-defense if a priority for you. 0.0 0.00 USD 2016-11-16T01:21:46-08:00  
3190 location:United States, excluded_connections:Exclude people who like Black guns matter, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:National Rifle Association, 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:Malcolm X 0 0 https://www.facebook.com/ProtectBIackGunOwners/ We are black and we support the 2nd Ammendment! Join us, if seIf-defense if a priority for you. 0.0 0.00 USD 2016-11-16T01:22:34-08:00  
3191 location:United States, excluded_connections:Exclude people who like Black guns matter, 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:National Rifle Association, 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:Malcolm X 175 15 https://www.facebook.com/ProtectBIackGunOwners/ We are black and we support the 2nd Ammendment! Join us, if seIf-defense is your priority! 8.425120000000001 526.57 RUB 2016-11-16T01:26:33-08:00  
3193 location:United States, age:18 - 65+, 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:2nd Amendment, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:African—American history, people_who_match:interests:Malcolm X, people_who_match:interests:Black (Color), people_who_match:interests:Guns & Ammo 1584 207 https://www.facebook.com/ProtectBIackGunOwners/ 10.5 300 BLK 3.2 200.00 RUB 2016-12-23T00:04:12-08:00 2016-12-24T00:04:12-08:00
3195 location:United States, age:18 - 65+, 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:2nd Amendment, people_who_match:interests:African-American culture, people_who_match:interests:African-American Civil Rights Movement (1954—68), people_who_match:interests:Gun Owners of America, people_who_match:interests:African—American history, people_who_match:interests:Malcolm X, people_who_match:interests:Black (Color), people_who_match:interests:Guns & Ammo 512 68 https://www.facebook.com/ProtectBIackGunOwners/ G360 guns with standard hybrid carry handle from a G36. 3.2 200.00 RUB 2016-12-23T00:03:20-08:00 2016-12-26T00:03:20-08:00
3317 location:united_states:Astoria (+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: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 or Black (Color), people_who_match:interests:Multicultural Affinity: African American (US), 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/694209204073106/ The second seIf-defense class—Joih the event, bring your friends, feel safe with us!!! Self—defense classes with — 0.0 0.00 USD 2017-02-10T04:54:43-08:00 2017-02-11T15:29:15-08:00
3324 location:united_states:Astoria (+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: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 or Black (Color), people_who_match:interests:Multicultural Affinity: African American (US), 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 1533 72 https://www.facebook.com/events/694209204073106/ The second seIf-defense class Join the event, bring your friends, feel safe with us!!! Self—defense classes 23.53696 1471.06 RUB 2017-02-09T06:58:01-08:00 2017-02-11T15:29:15-08:00
3358 location_living_in:united_states:Orlando (+50 mi) Florida, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, 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:Huey P. Newton, people_who_match:interests:Malcolm X, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Right of self-defense 399 26 https://www.facebook.com/events/180754319075270/ The first self—defense Class —Join the event, bring your friends, feel safe with us!!! SeIf-defense classes— 6.10448 381.53 RUB 2017-02-06T07:17:41-08:00 2017-02-11T08:00:00-08:00
3359 location_living_in:united_states:Orlando (+50 mi) Florida, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, 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:Huey P. Newton, people_who_match:interests:Malcolm X, and_must_also_match:interests:Mixed martial arts, and_must_also_match:interests:Martial arts, and_must_also_match:interests:martial arts and self defense, and_must_also_match:interests:The Women's Self Defense Institute, and_must_also_match:interests:PERSONAL & HOME DEFENSE, and_must_also_match:interests:Self—defense, and_must_also_match:interests:SeIf-defense (United States), and_must_also_match:interests:Personal Defense, and_must_also_match:interests:Right of self-defense, and_must_also_match:interests:Personal Defense Network, and_must_also_match:interests:Self Defense Family, and_must_also_match:interests:Safety, and_must_also_match:interests:Active Self Protection, and_must_also_match:interests:The Self Defense Company 1687 54 https://www.facebook.com/events/180754319075270/ The first self—defense Class—Join the event, bring your friends, feel safe with us!!! SeIf-defense classes— 20.62912 1289.32 RUB 2017-02-07T00:05:08-08:00 2017-02-11T08:00:00-08:00
3369 location_living_in:united_states:Astoria (+50 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: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 1274 55 https://www.facebook.com/events/694209204073106/ The second seIf-defense class Join the event, bring your friends, feel safe with us!!! Self—defense classes 23.35584 1459.74 RUB 2017-02-10T04:57:36-08:00 2017-02-11T09:00:00-08:00
3373 location_living_in:united_states:Astoria (+50 mi) New York, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, 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:Malcolm X, 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:SeIf-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 67 3 https://www.facebook.com/events/694209204073106/ The second seIf-defense class Join the event, bring your friends, feel safe with us!!! Self—defense classes 0.8211200000000001 51.32 RUB 2017-02-06T07:15:59-08:00 2017-02-11T15:29:15-08:00
3377 location:united_states:Astoria (+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: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 or Black (Color), people_who_match:interests:Multicultural Affinity: African American (US), 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 16 0 https://www.facebook.com/events/694209204073106/ The second seIf-defense class Join the event brin your friends, feel safe with us!!! Self—defense classes 0.7056 44.10 RUB 2017-02-09T01:01:32-08:00 2017-02-11T15:29:15-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 1572.11ms · Data source: simonw/russian-ira-facebook-ads-datasette