home / russian-ads

display_ads (view)

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

3,498 rows sorted by spend_usd descending

This data as JSON, CSV (advanced)

id img targeting impressions clicks url text spend_usd ▲ spend_amount spend_currency created ended
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  
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  
745 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 175705 18083 https://www.facebook.com/timetosecede/ Best state in US! Should I say more? 1894.93632 118433.52 RUB 2015-09-22T07:42:46-07:00  
2751 location_living_in:United States, age:20 - 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:State police, people_who_match:interests:Law enforcement in the United States, people_who_match:interests:Police, people_who_match:interests:Sheriffs in the United States, people_who_match:interests:Law enforcement, people_who_match:interests:Police officer, and_must_also_match:interests:Support Law Enforcement, and_must_also_match:interests:The Thin Blue Line, and_must_also_match:interests:Officer Down Memorial Page, and_must_also_match:interests:Police Wives Unite, and_must_also_match:interests:National Police Wives Association, and_must_also_match:interests:Heroes Behind The Badge 1334544 73063 https://www.facebook.com/Copsareheroes/ Community of people who support our brave Police Officers. Back The Badge 1769.40272 110587.67 RUB 2016-10-19T04:54:17-07: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  
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  
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  
2885 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:jesus love u, people_who_match:interests:I Am a Child of God, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:| Have Decided to Follow Jesus, and_must_also_match:interests:Jesus 368065 28137 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Together we are a shining beacon of faithfulness! Join us and light your way to Jesus! Army Of Jesus 1425.29776 89081.11 RUB 2017-02-20T05:37:42-08: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  
2779 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:30 - 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:industry:Veterans (US), people_who_match:industry:Politics: Likely to engage with political content (conservative), and_must_also_match:interests:Iraq War Veterans, and_must_also_match:interests:Veterans of Foreign Wars, and_must_also_match:interests:Support Our Veterans, and_must_also_match:interests:Veterans benefits support, and_must_also_match:interests:Disabled American Veterans, and_must_also_match:interests:Veterans Advantage, and_must_also_match:interests:Dysfunctional Veterans 112737 15163 https://www.facebook.comNeterans-Come-First-1757336424535312/ They fought for our freedom, now its our time to fight for their rights! 1163.76224 72735.14 RUB 2017-04-06T05:56:18-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  
2647 location_living_in:United States, excluded_connections:Exclude people who like Brown Power, age:16 - 65+, language:Spanish, language:English (UK), language:English (US), language:Spanish (Spain), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Mexico, people_who_match:interests:Latin hip hop, people_who_match:interests:Chicano Movement, people_who_match:interests:Hispanidad, people_who_match:interests:Lowrider, people_who_match:interests:Chicano rap, and_must_also_match:interests:La Raza 968768 56405 https://www.facebook.com/brownunitedfront/ Brown Power is a platform designed to educate, entertain and connect Chicanos in the US. 953.1425600000001 59571.41 RUB 2016-12-09T00:51:10-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  
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  
3145 location_living_in: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:African-American Civil Rights Movement (1954—68), people_who_match:interests:African-American history, people_who_match:interests:Malcolm X 752179 33444 https://www.facebook.com/Woke-B|acks-294234600956431/ Staying Woke,bui|ding-up our communities,up|ifting our people. Join us! Woke Blacks 931.09744 58193.59 RUB 2016-12-01T07:46:44-08:00  
1150 location:united_states:Atlanta (+25 mi) Georgia, location:united_states:New Orleans (+50 mi) Louisiana, location:united_states:Baltimore (+50 mi), Oakland (+50 mi) Maryland, location:united_states:Ferguson (+50 mi), St. Louis (+50 mi) Missouri, location:united_states:Milwaukee (+25 mi) Wisconsin, interests:Humanitarianism, interests:Human rights, interests:Humanitarian aid, 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 76981 4482 https://www.facebook.com/blacktivists/ Black Lives Matters! Say it loud. I'm black and I'm proud! 897.2424000000001 56077.65 RUB 2015-10-13T02:03:35-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  
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  
54 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:Ferguson (+20 km), St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 201428 12127 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 854.7991999999999 53424.95 RUB 2015-07-13T07:20:58-07:00  
1326 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 91603 18259 https://www.facebook.com/StopAlllnvaders This page is dedicated to protection against illegal immigrants! Like to join! 832.3352 52020.95 RUB 2016-05-05T03:27:06-07:00  
1666 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 59, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Zaid Shakir, people_who_match:interests:Muslims for America, people_who_match:interests:Abu Eesa Niamatullah 73077 3063 https://www.facebook.com/MuslimAmerica/ USA Muslims united 977')? 9777') 77777779 7977??? 819.0888000000001 51193.05 RUB 2015-12-18T03:55:37-08: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  
2965 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, 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:Right to keep and bear arms, people_who_match:interests:The Second Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:Second Amendment Sisters, people_who_match:interests:Gun Owners of America, 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:Gun Rights, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo or Gun Rights Across America, people_who_match:interests:Employers: Gun Owners of America, and_must_also_match:interests:2nd Amendment 301608 24955 https://www.facebook.com/Defend-the-2nd-692068924291672/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 772.8888000000001 48305.55 RUB 2016-10-21T07:51:03-07:00  
718 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 68285 8733 https://www.facebook.com/timetosecede/ Texas - homeland of guns, BBQ and ur heart! 767.93664 47996.04 RUB 2015-09-22T07:44:09-07:00  
590 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 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices 67221 6566 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 751.9161600000001 46994.76 RUB 2015-11-05T23:11:58-08: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  
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  
2196 location_living_in:United States, interests:Martin Luther King, interests:African-American Civil Rights Movement (1954—68), interests:African-American history, interests:Malcolm X, excluded_connections:Exclude people who like BM, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 223343 18796 https://www.facebook.com/blackmattersus.mvmnt/ Our mission is to tell the bold truth about racism. Join us! Black Lives Matter! 636.39648 39774.78 RUB 2016-08-30T01:04:27-07:00  
780 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu-Jamal, people_who_match:interests:The Raw Story or motherjones, people_who_match:interests:Behaviors: African American (US) 82725 2592 https://www.facebook.com/WilliamsandKalvin/ Black Discrimination Awareness! Like to join! 624.87088 39054.43 RUB 2016-01-14T06:53:15-08:00  
1147 location:united_states:Atlanta (+25 mi) Georgia, location:united_states:New Orleans (+50 mi) Louisiana, location:united_states:Baltimore (+50 mi), Oakland (+50 mi) Maryland, location:united_states:Ferguson (+50 mi), St. Louis (+50 mi) Missouri, location:united_states:Milwaukee (+25 mi) Wisconsin, interests:Humanitarianism, interests:Human rights, interests:Humanitarian aid, excluded_connections:Exclude people who like Blacktivist, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 44278 3804 https://www.facebook.com/blacktivists/ Black Lives Matters! Say it loud. I'm black and I'm proud! 612.80352 38300.22 RUB 2015-09-09T04:00:29-07:00  
731 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 61357 4612 https://www.facebook.com/timetosecede/ Heart of Texas! Time to secede! 593.2712 37079.45 RUB 2015-09-22T07:44:43-07:00  
2430 location_living_in:United States, excluded_connections:Exclude people who like Born Liberal, 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:Bernie Sanders, people_who_match:interests:Social democracy, people_who_match:interests:Liberalism, people_who_match:interests:Democratic Party (United States) 49920 4799 https://www.facebook.com/bornliberall New ideas, old values. Like us! 586.0768 36629.80 RUB 2016-07-14T00:58:10-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  
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  
2967 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, 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, and_must_also_match:interests:Right to keep and bear arms, and_must_also_match:interests:The Second Amendment, and_must_also_match:interests:National Rifle Association, and_must_also_match:interests:SeIf-defense, and_must_also_match:interests:Second Amendment Sisters, and_must_also_match:interests:Gun Owners of America, and_must_also_match:interests:Second Amendment to the United States Constitution, and_must_also_match:interests:Concealed carry in the United States, and_must_also_match:interests:Gun Rights, and_must_also_match:interests:National Association for Gun Rights, and_must_also_match:interests:Guns & Ammo or Gun Rights Across America, and_must_also_match:interests:, employers:Gun Owners of America 268604 21197 https://www.facebook.com/savetheZa/ Protect the 2nd. Without it, you won't have any others! Join! Defend The 2nd 569.51328 35594.58 RUB 2016-12-16T05:35:14-08: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  
2888 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Amenity, people_who_match:interests:Jesus Daily, and_must_also_match:interests:Jesus 277317 20426 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Let's stand united to defend our faith as an army of Jesus! 562.056 35128.50 RUB 2016-10-17T02:17:19-07:00  
2891 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:jesus love u, people_who_match:interests:| Have Decided to Follow Jesus, and_must_also_match:interests:Jesus 163358 15590 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Let's stand united to defend our faith as an army of Jesus! Army Of Jesus 556.68128 34792.58 RUB 2017-01-10T02:20:56-08: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  
1459 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 desktop computers, placements:News Feed on mobile devices 32064 3977 https://www.facebook.com/BIackJourneyZJustice/ We are not against police, we against police brutality! 509.17503999999997 31823.44 RUB 2015-09-23T04:49:10-07:00  
111 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:Ferguson (+20 km), St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 113435 7173 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 507.86384000000004 31741.49 RUB 2015-07-13T07:20:58-07: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  
739 location:united_states:Texas, interests:Independence, interests:Patriotism, excluded_connections:Exclude people who like Heart of Texas, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 36702 3868 https://www.facebook.com/timetosecede/ Best state in US! Should I say more? 497.66464 31104.04 RUB 2015-09-22T07:42:53-07: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: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  
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  
525 location:united_states:Florida, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 59025 8382 https://www.facebook.com/events/620928338080560/ We announce a patriotic flash mob in Florida on August, 20! We either win Florida or lose Florida Goes Trump! 438.44752000000005 27402.97 RUB 2016-08-04T04:34:15-07:00 2016-08-20T04:34:13-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  
2996 location:United States, excluded_connections:Exclude people who like Stand for Freedom, age:24 - 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:Republican Party (United States) or Gun Owners of America, people_who_match:interests:Politics: US politics (conservative), people_who_match:interests:Likely to engage with political content (conservative), and_must_also_match:interests:Donald Trump for President 87235 8249 https://www.facebook.com/Stand-for-Freedom-1133397646698140/ Stand up for Freedom. Stand up for America! 423.81152000000003 26488.22 RUB 2016-10-14T07:29:09-07: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  
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  

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/umd-mith/irads/master/site/" || image, "width", 200)
            else
                "no image"
            end as img,
            json_group_array(
                json_object(
                    "label", targets.name,
                    "href", "/russian-ads/display_ads?_target="
                        || urllib_quote_plus(targets.id)
                )
            ) as targeting,
            ads.impressions, ads.clicks, ads.url, ads.text,
            cast(case
                when ads.spend_currency == "RUB" then ads.spend_amount * 0.016
                else ads.spend_amount
            end as float) as spend_usd,
            ads.spend_amount, ads.spend_currency,
            ads.created, ads.ended
        from ads
            join ad_targets on ads.id = ad_targets.ad_id
            join targets on ad_targets.target_id = targets.id
        group by ads.id
        order by ads.id
Powered by Datasette · Query took 1351.5ms · Data source: simonw/russian-ira-facebook-ads-datasette