home / russian-ads

display_ads (view)

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

3,498 rows sorted by spend_usd descending

id img targeting impressions clicks url text spend_usd ▲ spend_amount spend_currency created ended
2889 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:Right column on desktop computers, people_who_match:interests:Amenity, people_who_match:interests:Jesus Daily, and_must_also_match:interests:Jesus 131913 5449 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Let's stand united to defend our faith as an army of Jesus! Army Of Jesus 383.1 23943.75 RUB 2016-12-08T00:30:32-08:00  
2315 location_living_in:United States, interests:Martin Luther King, interests:Jr., 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 143008 9807 https://www.facebook.com/blackmattersus.mvmnt/ Our mission is to tell the bold truth about racism. Join us! Black Lives Matter! 373.552 23347.00 RUB 2016-08-30T01:04:32-07:00  
101 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 79112 5155 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 372.77968 23298.73 RUB 2015-07-13T07:20:58-07: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  
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  
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
95 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 69296 4366 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 327.13903999999997 20446.19 RUB 2015-07-13T07:20:58-07:00  
1630 location:United States, excluded_connections:Exclude people who like United Muslims of America, age:18 - 48, language:English (UK), language:Arabic, language:English (US), 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 33027 819 https://www.facebook.com/MuslimAmerica/ i'm a Muslim and i'm proud 7’)? 777') 7777')? 322.90688 20181.68 RUB 2016-02-12T01:19:12-08:00  
2798 location:United States, excluded_connections:Exclude people who like Nefertiti's Community, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Black history, people_who_match:interests:Black (Color), and_must_also_match:interests:Pan-Africanism 91669 7013 https://www.facebook.com/Nefertitis-Community-576081822594619/ Join us to study your blackness and get the power from your roots. Stay woke and natural! Nefertiti's Community 319.34159999999997 19958.85 RUB 2016-10-18T05:58:59-07:00  
2944 custom_audience:Lookalike (US, 1%) - People who like Defend the 2nd, location: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:Gun Owners of America, and_must_also_match:interests:Second Amendment to the United States Constitution 63083 3818 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots. Defend The 2nd 311.23648 19452.28 RUB 2017-03-14T07:34:46-07:00  
1309 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 21001 2280 https://www.facebook.com/Stop-AI-896610653786585/ There is no place for political correctness, join to say what YOU think! 310.636 19414.75 RUB 2016-01-14T05:11:39-08:00  
3107 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: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 188630 9073 https://www.facebook.com/Woke-B|acks-294234600956431/ Staying Woke,bui|ding-up our communities,up|ifting our people. Join us! Woke Blacks 306.56559999999996 19160.35 RUB 2017-03-21T08:28:10-07:00  
1956 location_living_in:United States, interests:Conservatism, interests:Confederate States of America, interests:Donald Trump, interests:Republican Party (United States), interests:Dixie, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 29644 3590 https://www.facebook.com/Secured-Borders-757183957716200/ We should not only strengthen our geographical boundaries but also our cultural. Like us! 303.584 18974.00 RUB 2016-06-22T04:04:00-07:00  
1880 location:United States, interests:Confederate States of America, interests:American History, age:14 - 65+, language:English (US), placements:Instagram Feed 91968 432 https://www.instagram.Com/south_united/ Many of y'all know that the Civil war was not at all about slavery, it was about freedom and independence from the Union. Click Learn More! South United ( @south Yoyoyoyoyo 277.43647999999996 17339.78 RUB 2016-01-06T06:22:09-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  
1639 location:united_states:Washington (+50 mi) District of Columbia, age:18 - 61, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Islam, people_who_match:interests:Islamism, people_who_match:interests:Proud to be A Muslim, people_who_match:interests:Muslim Brotherhood 23858 865 https://www.facebook.com/events/1092180614203742/ The safety, freedom, and dignity of all people must be safeguarded. Terrorism and anti-Mus Safe Space for Muslim Neighborhood 273.2968 17081.05 RUB 2016-08-23T04:43:48-07:00 2016-09-03T03:06:35-07:00
584 location:United States, interests:Motherhood, interests:Philosophy, interests:LGBT community, interests:Indiana, interests:Homosexuality, interests:Love, interests:Society, 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 31618 3206 https://www.facebook.com/lgbtun/ We speak for all fellow members of LGBT community across the nation. 266.08320000000003 16630.20 RUB 2015-06-23T05:06:57-07:00  
2962 custom_audience:Lookalike (US, 1%) - People who like Defend the 2nd, location: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:Gun Owners of America, and_must_also_match:interests:Second Amendment to the United States Constitution 60235 4681 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 265.91728 16619.83 RUB 2017-02-21T03:18:50-08:00  
466 location:united_states:New York (+40 km) New York, 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 18915 1454 https://www.facebook.com/events/966495900135555/ Our country was drawing a blank for the last eight years. We need a strong leader who will March for Trump 264.54256 16533.91 RUB 2016-06-02T03:50:04-07:00 2016-06-22T03:50:01-07:00
1998 location_living_in:United States, interests:Martin Luther King, interests:Jr., 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 80206 6125 https://www.facebook.com/blackmattersus.mvmnt/ Our mission is to tell the bold truth about racism. Join us! Black Lives Matter! 264.172 16510.75 RUB 2016-08-30T01:04:29-07:00  
2000 location_living_in:United States, interests:Martin Luther King, interests:Jr., 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 107295 4669 https://www.facebook.com/blackmattersus.mvmnt/ Our mission is to tell the bold truth about inequality and injustice. Join us! BM 247.65152 15478.22 RUB 2016-12-08T06:34:13-08:00  
690 location:united_states:New Mexico, location:united_states:Arizona (+25 mi) Texas, excluded_connections:Exclude people who like Secured Borders, age:15 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 11481 873 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 241.42048000000003 15088.78 RUB 2016-09-20T07:06:40-07:00  
2740 location:United States, excluded_connections:Exclude people who like Angry Eagle, age:18 - 65+, gender:Male, 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:Donald Trump for President, and_must_also_match:interests:breitbart, and_must_also_match:interests:conservative daily 39819 3160 https://www.facebook.com/Angry-EagIe-1936291449958430/ The community of people who share True American values. Make the US Eagle fly high again! 240.0 15000.00 RUB 2016-10-14T07:10:10-07:00  
2783 location:United States, excluded_connections:Exclude people who like Veterans Come First, 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:Veterans Day, people_who_match:interests:Wounded Warrior Project, people_who_match:interests:Support Our Veterans or Disabled American Veterans, people_who_match:interests:Employers: Veteran, people_who_match:interests:, job_title:Veteran, and_must_also_match:industry:Veterans (US) 41172 4134 https://www.facebook.comNeterans-Come-First-1757336424535312/ The community of brave people who make America Great and Free. 240.0 15000.00 RUB 2016-10-14T06:07:27-07:00  
96 location:united_states:Atlanta (+20 km) Georgia, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 54463 2813 https://www.facebook.com/events/1579032272388106/ Counter-protest against 'White Power' Confederate rally at Stone Mountain Not My Heritage 238.60496 14912.81 RUB 2016-04-06T08:41:45-07:00 2016-04-24T22:41:00-07:00
65 location:united_states:Los Angeles (+40 km) California, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 41395 1734 https://www.facebook.com/events/1702267153358101/ Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford And Donnell Thompson 238.108 14881.75 RUB 2016-08-04T07:25:31-07:00 2016-08-20T07:25:28-07:00
477 location:united_states:New York (+40 km) New York, 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 15255 1312 https://www.facebook.com/events/1139813819411853/ Hillary Clinton is the co-author of Obama’s anti-police and anti-Constitutional propaganda Down With Hillary! 235.29088000000002 14705.68 RUB 2016-07-12T02:52:38-07:00 2016-07-23T02:52:36-07:00
2829 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 69567 2398 https://www.facebook.com/PanAfrootsmove/ Unapologetically melaneted Kings and Queens are powerful together. Join us! Pan-Afican Roots MOVE 235.02895999999998 14689.31 RUB 2017-02-02T07:01:29-08:00  
1785 location_living_in:United States, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 34943 6276 https://petitions.whitehouse.gov/petition/disavow-support-CIinton-political- We call for disqualification and removal of Hillary Clinton from the presidential ballot as dynastic succession of the Clinton family in American politics breaches the core democratic principles laid out by our Founding Fathers. Sign the petition! We call for disqualification and removal of Hillary Clinton from the presidential ballot as dynastic succession of the Clinton family in American politics breaches the core democratic principles laid out by our Founding Fathers. We demand members of one family legislatively banned from holding the s... Disavow support for the Clinton political dynasty. Disqualify and remove Hillary Clinton from 2016 Presidential Ballot | We the People: Your Voice in Our Government Donald Trump America 233.70432000000002 14606.52 RUB 2016-08-02T09:29:28-07:00 2016-08-05T07:29:25-07:00
62 location:united_states:Charleston (+70 km) South Carolina, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 42890 2182 https://www.facebook.com/events/257074994652475/ One year ago nine people were killed by a gunman, including the senior pastor, state senat Remember Victims of Charleston Shooting 230.37904 14398.69 RUB 2016-06-01T06:03:23-07:00 2016-06-19T06:03:19-07:00
76 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: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 89836 3402 https://b|ackmattersus.com/ Black Community! We finally made a website! News about black racial and social issues. Get breaking news and analysis on the life of African American community in the US. Black Matters Hillary Doesn’t Deserve Black Votes Young black voters give up on Mrs. Clinton Outraged Flint Resident: “Lawsuit Must Be Filed Against State!” Flint Water Crisis touched the feelings of all Americans and the whole world. Justice For Aiyana Jones Rally The tragic death of Aiyana Jones, a 7-year-old African-American fatally shot by a Detroit police officer 4 Officers, Who Shot Jeremy McDole, Won’t Face State Charges, Family Protests In Wilmington Friday The tragic alleged murder of Jeremy McDole happened last September after he had been “robbed and shot by an unknown robber,” Black Matters 226.92176 14182.61 RUB 2016-05-24T00:19:06-07:00  
703 location:united_states:Houston (+10 mi) Texas, interests:Texas, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 15891 1355 https://www.facebook.com/events/554359838086349/ It's been 15 years since the 9/11 and it became Clear that extemist terror groups are bein Stop Radical Islam 224.0 14000.00 RUB 2016-08-17T06:10:57-07:00 2016-09-10T03:10:55-07:00
1177 location:united_states:Buffalo (+10 mi) New York, excluded_connections:Exclude people who are going to India Cummings. SayHerName, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:behaviors:African American (US) 70777 2496 https://www.facebook.com/events/607910082706490/ Join event, don't stay indifferent! New Sandra Bland! We need justice. Come and support. India Cummings. SayHerName 224.0 14000.00 RUB 2016-03-24T07:34:32-07:00  
3213 location_living_in:United States, excluded_connections:Exclude people who like Black4Black, 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:Black Economic Empowerment, and_must_also_match:interests:Black Enterprise, interest_expansion:On 53987 2962 https://www.facebook.com/Black4BlaCk-1268698556482143/ Supporting and developing bIk-owned Businesses is the key to raising our community! Black4Black 219.55120000000002 13721.95 RUB 2016-12-11T23:06:46-08:00  
369 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, 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 56408 3296 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us because we care. Black matters. 219.26432 13704.02 RUB 2015-06-10T03:27:28-07:00  
91 location:united_states:Jackson (+17 km) Mississippi, excluded_connections:Exclude people who are going to Not My Heritage Rally, age:18 - 60, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:behaviors:African American (US) 49978 1499 https://www.facebook.com/events/227388350945080/ We don’t want to honor racism, slavery and hatred. This is what Confederate Heritage is. Not My Heritage Rally 218.57728 13661.08 RUB 2016-03-15T08:02:45-07:00  
50 custom_audience:Lookalike (US, 1%) - newtestaudit, 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 92618 6555 https://blackmattersus.com/ Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters 215.33584 13458.49 RUB 2016-06-21T07:09:02-07:00  
2459 location_living_in:United States, excluded_connections:Exclude people who like Black Excellence, 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:Black Girls Rock!, and_must_also_match:interests:My Black is Beautiful, and_must_also_match:interests:Black is beautiful, and_must_also_match:interests:Black Girls Rock! 91531 5957 https://www.facebook.com/iloveblaokexcellence/ Join us, if you proud to be who you are and believe that your roots give you the power! Black Excellence 214.77056 13423.16 RUB 2016-12-27T05:53:41-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  
1638 location:united_states:Washington (+50 mi) District of Columbia, excluded_connections:Exclude people who like United Muslims of America, age:18 - 61, language:English (UK), language:Arabic, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Islamism, people_who_match:interests:Proud to be A Muslim, people_who_match:interests:Muslim Brotherhood 7267 427 https://www.facebook.com/events/1092180614203742/ The safety, freedom, and dignity of all people must be safeguarded. Terrorism and anti-Mus Safe Space for Muslim Neighborhood 206.69488 12918.43 RUB 2016-08-15T07:24:16-07:00 2016-09-03T03:06:35-07:00
364 location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, 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 46447 2740 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 205.73536 12858.46 RUB 2015-06-10T03:29:48-07:00  
2969 location_living_in:United States, excluded_connections:Exclude people who like Defend the 2nd, 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: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, people_who_match:interests:Gun Rights Across America, and_must_also_match:interests:2nd Amendment 43451 3721 https://www.facebook.com/savethe2a/ Protect the 2nd. Without it, you won't have any others! Join! Defend The 2nd 203.64496 12727.81 RUB 2017-01-19T03:05:56-08:00  
2922 location_living_in:United States, interests:The Second Amendment, interests:AR-15, interests:2nd Amendment, interests:Guns & Ammo, politics:US politics (conservative), excluded_connections:Exclude people who like Defend the 2nd, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 39142 1789 https://www.facebook.com/savetheZa/ The community of 2nd Amendment supporters, guns lovers & patriots Defend The 2nd 203.06672 12691.67 RUB 2017-04-07T04:49:50-07:00  
102 location:united_states:New York (+40 km) New York, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 37821 2775 https://www.facebook.com/events/1085290071563825/ Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner 199.76272 12485.17 RUB 2016-07-06T03:03:43-07:00 2016-07-17T03:03:41-07:00
2198 location_living_in:United States, interests:Martin Luther King, interests:Jr., 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 113801 5139 https://www.facebook.com/blackmattersus.mvmnt Our mission is to tell the bold truth about inequality and injustice. Join us! BM 198.4704 12404.40 RUB 2016-12-08T06:34:13-08:00  
1946 no image location_living_in:united_states:New York, age:18 - 43, placements:Instagram Feed, people_who_match:interests:Black Power, people_who_match:interests:Black Panther Party 61971 924 https://www.facebook.com/Proudblacks-954167134618867/ Truth is on the side of the oppressed - Malcolm X 195.34832 12209.27 RUB 2016-06-15T02:35:52-07:00  
2403 location_living_in:united_states:Charlotte (+25 mi) North Carolina, 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:Human rights, 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:Black Panther Party, people_who_match:interests:Black panther, people_who_match:interests:Malcolm X, people_who_match:interests:Black (Color) or Cop Block, people_who_match:interests:Behaviors: African American (US) 24857 1112 https://www.facebook.com/blackmattersus.mvmnt/ October 22 is the National Day of Protest. October 22nd is a day that people around the nation have mobilized every year since 1996 for a National Day of Protest to Stop Police Brutality, Repression and the Criminalization of a Generation. Here in Charlotte, this problem appears especially hard. A number of victims and quantity of cases, where justice wasn't served - horrifies. The most well- known case is shooting of Jonathan Ferrell, an unarmed black man who was shot ten times and killed. Or situation with Daniel Kevin Harris, a deaf man, who just couldn't explain a thing, before he was shot. We need to use our right to protest to demand the authorities and police representatives, to do, the thing they are supposed to do! To protect and serve! Not to kill, damage and cripple! Join us on October 22, in Charlotte, 600 East Trade Street, just between Charlotte City hall and Charlotte-Mecklenburg Police Department. National Day of Protest. Charlotte, NC 186.21904 11638.69 RUB 2016-10-06T06:20:34-07:00 2016-10-22T04:18:29-07:00
1325 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 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:Politics 12834 3051 https://www.facebook.com/StopAlllnvaders This page is dedicated to protection against illegal immigrants! Like to join! 185.62896 11601.81 RUB 2016-04-13T07:46:57-07:00  
2981 location_living_in:United States, excluded_connections:Exclude people who like Watch the Police, 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:Filming Cops, people_who_match:interests:Cop Block 29063 1978 https://www.facebook.com/WatCh-the-Police-1095374457243609/ We united by our shared goal of police accountability! 182.39424 11399.64 RUB 2016-10-21T08:17:45-07:00  
1310 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:25 - 65+, language:English (UK), language:English (US), placements:News Feed on mobile devices 11527 977 https://www.facebook.com/Stop-AI-896610653786585/ There is no place for political correctness, join to say what YOU think! 180.98864 11311.79 RUB 2016-03-10T06:10:18-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/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 694.901ms · Data source: simonw/russian-ira-facebook-ads-datasette