home / russian-ads

display_ads (view)

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

1,353 rows where an ad_target was location:United States sorted by impressions descending

id img targeting impressions ▲ clicks url text spend_usd spend_amount spend_currency created ended
1141 location:United States, interests:Human rights, interests:Malcolm X, behaviors:African American (US), excluded_connections:Exclude people who like Blacktivist, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 530762 31413 https://www.facebook.com/blacktivists/ Say it loud: I'm black and I'm proud! 1935.21056 120950.66 RUB 2015-12-10T01:35:01-08:00  
450 location:United States, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Being Patriotic, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 529205 72043 https://www.facebook.com/patriototus/ United We Stand! Welcome every patriot we can reach. Flag and news! 5306.812 331675.75 RUB 2015-06-23T00:41:02-07:00  
2774 location:United States, excluded_connections:Exclude people who like South United, 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:Confederate Flag, people_who_match:interests:Confederate States Army, people_who_match:interests:American Civil War, people_who_match:interests:Southern Pride 511224 40134 https://www.facebook.com/South-United-1777037362551238/ Heritage, not hate. The South will rise again! South United 1253.71728 78357.33 RUB 2016-10-14T05:54:10-07:00  
1033 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 I”, people_who_match:interests:Stop Police Brutality, people_who_match:interests:Black (Color) 501552 49197 https://www.facebook.com/Blacktivist-128371547505950/ This video may bring tears to your eyes. Make it go viral. We need this unity in our communities. 24.0 1500.00 RUB 2017-02-14T06:35:27-08:00 2017-02-17T06:35:27-08:00
955 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) 489186 26179 https://www.facebook.com/blacktivists/ This hairdresser from Atlanta is amazing. She can install Iocs at supersonic speeds. This hairdresser from Atlanta is amazing. She can install Iocs... 8.368 523.00 RUB 2017-04-03T08:21:28-07:00 2017-04-05T08:21:28-07:00
1941 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Police, people_who_match:interests:Police officer, people_who_match:interests:Safety 418904 9211 https://www.facebook.com/Libelibe—1484239251885741/ Join Us! Support The Police! 425.57584 26598.49 RUB 2016-04-13T09:15:28-07:00  
807 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 371295 16442 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 889.7540799999999 55609.63 RUB 2016-04-13T04:43:03-07:00  
59 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 359345 24838 https://www.facebook.com/blackmattersus/ Black Matters. Black community. 934.5356800000001 58408.48 RUB 2015-11-05T23:17:06-08:00  
2815 location:United States, excluded_connections:Exclude people who like Woke Blacks, 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:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Malcolm X 307235 17214 https://www.facebook.com/Woke-B|acks-294234600956431/ Staying Woke,bui|ding-up our Black communities,up|ifting Black people. Join us! 372.20944000000003 23263.09 RUB 2016-10-18T04:53:49-07:00  
2770 location:United States, excluded_connections:Exclude people who like South United, 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:Flags of the Confederate States of America, people_who_match:interests:Hart of Dixie, people_who_match:interests:Mud & Trucks, people_who_match:interests:Dixie, people_who_match:interests:Redneck Nation, and_must_also_match:interests:Confederate States of America 300815 16587 https://www.facebook.com/South-United-1777037362551238/ Join us if you know it's just a car, NOT A SYMBOL OF HATE South United 1051.29312 65705.82 RUB 2017-03-09T06:14:52-08:00  
1040 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) 295361 23054 https://www.facebook.com/Blacktivist-128371547505950/ When ballet dancers can mix modern dance and ballet. When ballet dancers can mix modern dance and ballet. 4.8 300.00 RUB 2017-02-09T23:34:38-08:00 2017-02-10T23:34:38-08:00
1067 location:United States, interests:Human rights, interests:Malcolm X, behaviors:African American (US), excluded_connections:Exclude people who like Blacktivist, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 289781 13310 https://www.facebook.com/blacktivists/ African American Civil Rights Movement! 646.57712 40411.07 RUB 2015-12-10T01:34:22-08: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
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  
1462 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:14 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 226262 9657 https://www.facebook.com/BIackJourney2Justice/ We are not against police, we against police brutality! 875.67152 54729.47 RUB 2016-05-05T02:12:02-07:00  
1028 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 191238 11360 https://www.facebook.com/Blacktivist-128371547505950/ Watch this heart-piercing story about a racial bias that might cause law enforcement officers to shoot innocent and unarmed black people. 8.0 500.00 RUB 2016-11-03T08:12:06-07:00 2016-11-10T07:12:06-08:00
592 location:United States, friends_of_connections:Friends of people who are connected to LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Gay pride, people_who_match:interests:Homosexuality, people_who_match:interests:LGBT culture, people_who_match:interests:LGBT community, people_who_match:interests:Same-sex marriage 190076 7289 https://www.facebook.com/Igbtun/ We speak for all fellow members of LGBT community across the nation. 576.0 36000.00 RUB 2016-08-04T04:20:05-07:00  
804 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Black (Color), people_who_match:interests:Racism in the United States 185599 10575 https://www.facebook.com/WilliamsandKalvin We are proud to be black and stand for our community! Join to end the racism in the US. 774.0616 48378.85 RUB 2016-04-13T04:42:55-07:00  
588 location:United States, interests:Gay pride, interests:LGBT community, interests:Homosexuality, interests:LGBT culture, interests:Same-sex marriage, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 175460 21449 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 1500.0700800000002 93754.38 RUB 2015-07-14T00:01:38-07:00  
2763 location:United States, excluded_connections:Exclude people who like South United, 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:Flags of the Confederate States of America, people_who_match:interests:Hart of Dixie, people_who_match:interests:Dixie, and_must_also_match:interests:Confederate States of America 171320 10000 https://www.facebook.com/South-United-1777037362551238/ Heritage, not hate. The South will rise again! 487.4328 30464.55 RUB 2017-02-02T07:06:38-08:00  
1909 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:donaldj trump, people_who_match:interests:Donald Trump for President, people_who_match:interests:Ivanka Trump Fine Jewelry, people_who_match:interests:Donald Trump Jr. 165121 78 https://www.instagram.com/tea_party_news/ Do you support Trump? Wanna #MakeAmericaGreatAgain? Wanna see your kid on our account? Take pictures, make videos, send them to us via DM or tag #KIDS4TRUMP and we'll make a patriotic team of young Trump supporters here! I'm sure it'll be great! It would be nice if you tell us why your kid supports Donald Trump and what are his or her thoughts about #Election52016. Let's have some fun! Don't stay aside! Tea Party News ( @tea Teapartypat 159.52928 9970.58 RUB 2016-04-21T00:28:18-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
1043 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) 160565 16132 https://www.facebook.com/Blacktivist-128371547505950/ A 21-year-old senior at the university, Aja Sims, influenced floor routine by putting Hip-Hop in gymnastics and was praised as #BlackGirlsMagic. However, several non-black fans took offense to the proclamation. A 21-year- old senior at the university, Aja Sims, influenced f... 9.6 600.00 RUB 2017-02-03T05:39:22-08:00 2017-02-04T05:39:22-08:00
1086 location:United States, interests:Pan-Africanism, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 152716 19558 https://www.facebook.com/Blacktivist-128371547505950/ Look at these gorgeous queens in all shades. 8.0 500.00 RUB 2016-11-03T08:11:21-07:00 2016-11-10T07:11:21-08:00
974 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) 144987 21695 https://www.facebook.com/blacktivists/ Black Americans are dealing with psychopaths when it comes to police. This guy is far from Civilized. 9.6 600.00 RUB 2017-04-19T07:11:11-07:00 2017-04-20T07:11:11-07:00
36 location:United States, age:13 — 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Politics 143644 496 https://www.instagram.com/veterans_usl He's lucky to return home to reunite with his family for the holidays. But he's just one of a few servicemen to do this. For many of our brave troops stationed abroad and far from their loved ones. Our brave servicemen and servicewomen will continue to make sacrifices for our great country while the VA employees will be having their dinner and laughing at the VA backlog. Click to Learn More! Veterans USA ( @veterans GovSpending 133.42592000000002 8339.12 RUB 2016-01-14T07:18:30-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
73 location:United States, friends_of_connections:Friends of people who are connected to Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:behaviors:African American (US), and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 141500 6282 https://b|ackmattersus.oom/ Black Community! We finally made a website! News about black racial and social issues. This happened yesterday, Feb. 2, at a dry Cleaning shop in a black neighborhood, when this black guy went for his Clothes he had already sent for laundry. “What do you mean by you people?” The black guy asked. There was a murmur from inside the shop; the dry Cleaner answered “those who are arguing m... Black Matters The Police should protect not Brutalize Ideally Black Women... S. F. Police Vow To Eradicate Racism Plans to fight racism in the ranks. Black History Month The event grew out of “Negro History Week,” the brainchild Black Matters 386.6528 24165.80 RUB 2016-02-04T23:54:33-08:00  
981 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) 130992 15124 https://www.facebook.com/blacktivists/ How would we feel if another country bombed us for the poisoned water in Flint and for police brutality? 14.4 900.00 RUB 2017-05-19T07:08:27-07:00 2017-05-29T08:00:00-07: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
3088 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, 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:African-American Civil Rights Movement (1954—68), people_who_match:interests:Racism in the United States, interest_expansion:On 127188 3309 https://www.facebook.com/Williamsathalvin/ Newsblog about social injustice in the US. Join us and stay informed! Williams&Ka|vin 418.49136 26155.71 RUB 2016-12-12T06:40:45-08:00  
1426 location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices, people_who_match:interests:Cop Block 125179 2305 http://donotshoot.us/ Click Watch More to join us! Let's fight against police brutality together! donotshoot.us Donotshoot.us Don't Shoot 329.25600000000003 20578.50 RUB 2016-06-07T01:44:20-07:00  
1461 location:United States, excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Cop Block 120496 4684 https://www.facebook.com/BIackJourney2Justice/ We are not against police, we against police brutality! 684.88768 42805.48 RUB 2016-02-12T05:52:58-08:00  
1689 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:BuzzFeed, people_who_match:interests:Humour 119733 1256 https://www.instagram.Com/nuts.news/ 5-year-old David Southwick of Cortlandville had an argument with his wife in the parking lot and got into his car trying to run over the woman. He was so pissed off that he intentionally hit 14 vehicles and drove into the porch of a nearby house. Join us to read more funny news! Nuts News ( @nuts.news) Funnylnst 112.57600000000001 7036.00 RUB 2015-12-17T06:43:41-08:00  
2835 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: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:Malcolm X, and_must_also_match:interests:Black nationalism, and_must_also_match:interests:Pan-Africanism, and_must_also_match:interests:Black Power, and_must_also_match:interests:Black history, and_must_also_match:interests:Kemetism, and_must_also_match:interests:Afrocentrism 118865 4373 https://www.facebook.com/PanAfrootsmove/ Unapologetically melaneted Kings and Queens are powerful together. Join us! Pan-Afican Roots MOVE 327.59184000000005 20474.49 RUB 2017-03-22T04:27:16-07:00 2017-04-26T06:00:00-07:00
938 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) 116540 15153 https://www.facebook.com/blacktivists/ repost_ repost _ 9.6 600.00 RUB 2017-05-21T07:27:26-07:00 2017-05-22T07:27:26-07:00
61 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 115604 10292 https://www.facebook.com/blackmattersus/ Fast-growing black community. Latest news and everyday updates! 552.01728 34501.08 RUB 2015-11-05T23:17:06-08:00  
1687 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Humour 113296 778 https://www.instagram.Com/Cop_block_us/ Fed up with police violence? Wanna stop police brutality? Join us! Cop Block Us ( @COp Block AmericanCops 112.29056 7018.16 RUB 2015-12-17T05:21:36-08:00  
1917 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Conservative Republicans of Texas, people_who_match:interests:Donald Trump for President 108433 857 https://www.facebook.com/Teapartypat—1649468318669272/ This is the way our Children have to be raised. It's not the promotion of violence. It's the promotion of confidence and the ability to defend yourself. Follow us if this video makes you proud! 276.9112 17306.95 RUB 2016-04-22T10:43:02-07:00  
85 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 105431 10547 https://www.facebook.com/blackmattersus/ Black Matters. Black community. 563.8454399999999 35240.34 RUB 2015-11-05T23:17:06-08:00  
1460 location:United States, interests:Cop Block, excluded_connections:Exclude people who like Don't Shoot, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 103614 10629 https://www.facebook.com/BIackJourneyZJustice/ We are not against police, we against police brutality! 1689.36976 105585.61 RUB 2015-11-06T02:41:18-08:00  
1655 location:United States, excluded_connections:Exclude people who like United Muslims of America, 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:Muslims Are Not Terrorists, people_who_match:interests:Zaid Shakir, people_who_match:interests:ProductiveMuslim, people_who_match:interests:Abu Eesa Niamatullah 103079 4491 https://www.facebook.com/MuslimAmerica/ A page to unit all Muslim people living in the USA! 951.26016 59453.76 RUB 2015-12-18T03:52:42-08:00  
1474 no image location:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Don't Shoot, people_who_match:Friends of connections: Friends of people who are connected to Don't Shoot 102914 9192 https://www.facebook.com/Dont-Shoot-1157233400960126/ NO CRIME SHOULD BE HIDDEN! Visit our website http://DoNotShoot.Us for exclusive updates and breaking news! 80.0 5000.00 RUB 2016-04-22T07:48:47-07:00 2016-04-24T07:48:47-07:00
451 location:United States, excluded_connections:Exclude people who like Being Patriotic, 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:Independence, people_who_match:interests:Patriotism 99946 11684 https://www.facebook.com/patriototus/ United We Stand! Welcome every patriot we can reach. Flag and news! 578.5600000000001 36160.00 RUB 2016-09-15T02:50:06-07:00  
1188 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) 98328 13873 https://www.facebook.com/Blacktivist-128371547505950/ Educate your Children on black culture and appropriation. #Blackisonfleek 4.8 300.00 RUB 2017-02-03T03:39:00-08:00 2017-02-06T03:39:00-08:00
689 location:United States, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 97529 15254 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 1483.38192 92711.37 RUB 2016-02-09T03:34:26-08:00  
1852 location:United States, excluded_connections:Exclude people who like Memopolis, age:13 - 4O, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Entertainment, people_who_match:interests:Humour 97300 2778 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 212.61616 13288.51 RUB 2016-04-11T23:58:16-07:00  
39 location:United States, age:13 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 95140 300 https://www.instagram.com/black_america_today/ Join us to learn more! Why aren't white hoods and white supremacist propaganda illegal here in America? Why are Germans ashamed of their bigotry, while America is proud of it? Black America ( @black Blacklivessss 146.57407999999998 9160.88 RUB 2016-01-14T06:07:11-08:00  
591 location:United States, friends_of_connections:Friends of people who are connected to LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Gay pride, people_who_match:interests:LGBT community, people_who_match:interests:Homosexuality, people_who_match:interests:LGBT culture, people_who_match:interests:Same-sex marriage 93925 5441 https://www.facebook.com/Igbtun/ We speak for all fellow members of LGBT community across the nation. 507.40992 31713.12 RUB 2016-03-23T05:36:11-07:00  
1011 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) 93044 5582 https://www.facebook.com/blacktivists/ Watch this baby drama. This child‘s great escape is hilarious. Watch this baby drama. This child‘s great escape is hilarious. 2.77504 173.44 RUB 2017-04-14T07:58:44-07:00 2017-04-15T08: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 1556.633ms · Data source: simonw/russian-ira-facebook-ads-datasette