home / russian-ads

display_ads (view)

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

1,426 rows where an ad_target was language:English (UK)

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
31 location:United States, age:13 - 35, language:English (UK), language:English (US), placements:Instagram Feed, people_who_match:interests:Afro—American religion, people_who_match:interests:Malcolm X 23670 235 https://www.instagram.com/black_america_today/ Quiz from EBONY magazine April 1952. Which is Negro? Which is White? Passing for white is a direct consequence of how race works in America. Because of the One Drop Rule if you look at all part black African you are seen as “black” by “whites” and suffer all the racism that goes with that. Click "Learn More" Black America ( @black Blacklivessss 64.64272 4040.17 RUB 2016-03-11T04:54:05-08:00  
49 no image custom_audience:tesy, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 4405 716 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The head of Chicago’s IPRA, Sharon Fairley, has recommended an on-duty officer to be fired for calling President Obama a n****r. According to Chicago Sun-Times, the racist remark was made during a meeting to decide on “who would cover the president’s detail for a Bulls game”. The Independ Chicago Cop To Be Fired For Calling Obama N-Word | Black Matters Black Matters 12.51552 782.22 RUB 2016-06-20T08:22:58-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  
51 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 12653 393 https://b|ackmattersus.com/?utm_source=facebook&utm_medium=Cpc&utm Get breaking news and analysis on the life of African American community in the US. 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 18.69296 1168.31 RUB 2016-07-06T07:18:32-07:00  
52 no image custom_audience:tesy, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 4544 724 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The head of Chicago’s IPRA, Sharon Fairley, has recommended an on-duty officer to be fired for calling President Obama a n****r. According to Chicago Sun-Times, the racist remark was made during a meeting to decide on “who would cover the president’s detail for a Bulls game”. The Independ Chicago Cop To Be Fired For Calling Obama N-Word | Black Matters Black Matters 13.555040000000002 847.19 RUB 2016-06-20T08:03:12-07:00  
53 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states: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 0 0 https://www.facebook.com/blackmattersus/ Join us because we care. Black Matters! 0.0 0.00 USD 2015-07-13T07:13:40-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  
55 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), 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 812 73 https://www.facebook.com/blackmattersus/ Fast-growing black community. Latest news and everyday updates! 3.4312 214.45 RUB 2015-10-06T08:22:34-07:00  
56 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 3251 211 https://www.facebook.com/blackmattersus/ Fast-growing black community. Latest news and everyday updates! 11.70832 731.77 RUB 2015-11-05T23:17:06-08:00  
57 location:united_states:South Carolina, 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 7457 304 https://www.facebook.com/events/1730167210590258/ Stand up, South Carolina! Let’s stop the propaganda of hate and white supremacy! Not My Heritage 74.72 4670.00 RUB 2016-07-21T05:32:28-07:00 2016-07-23T05:32:25-07:00
58 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), 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 16322 2446 https://www.facebook.com/blackmattersus/ Black Matters. Black community. 76.76944 4798.09 RUB 2015-10-06T08:25:00-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  
60 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), 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 967 113 https://www.facebook.com/blackmattersus/ Fast-growing black community. Latest news and everyday updates! 5.08096 317.56 RUB 2015-10-06T08:22:34-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  
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
63 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 0 0 https://b|ackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. 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 0.0 0.00 USD 2016-06-21T07:08:44-07:00  
64 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, 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 500 25 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us. Because we care 5.44544 340.34 RUB 2015-07-10T01:03:31-07:00  
66 location:united_states:Detroit (+70 km) Michigan, interests:HuffPost Black Voices, age:15 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 3 0 https://www.facebook.com/events/1727519624184050/ A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death 0.01312 0.82 RUB 2016-05-06T01:00:41-07:00  
67 location:united_states:Detroit (+70 km) Michigan, age:15 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Detroit, people_who_match:interests:BlackNews.com, people_who_match:interests:HuffPost Black Voices 13066 804 https://www.facebook.com/events/1727519624184050/ A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death 27.437279999999998 1714.83 RUB 2016-05-06T02:21:24-07:00  
68 location:united_states:Detroit (+70 km) Michigan, age:15 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 54836 2546 https://www.facebook.com/events/1727519624184050/ A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death 147.07952 9192.47 RUB 2016-05-10T01:31:35-07:00  
69 location:united_states:Detroit (+70 km) Michigan, age:15 - 54, 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) 8376 314 https://www.facebook.com/events/1727519624184050/ A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death 24.08544 1505.34 RUB 2016-05-16T07:59:50-07:00  
70 location:united_states:Detroit (+70 km) Michigan, age:15 - 54, 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) 10089 442 https://www.facebook.com/events/1727519624184050/ A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death 41.1336 2570.85 RUB 2016-05-17T00:21:13-07:00  
71 location:United States, age:25 - 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:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Behaviors: African American (US) 77530 2317 https://blackmattersus.com/ Breaking news and analysis on the life of African American community in the US! Independent News For Black Amrican community Black Matters Black Matters 107.06592 6691.62 RUB 2016-03-10T06:26:39-08:00  
72 location:United States, interests:BIackNews.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:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 2461 75 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 6.27424 392.14 RUB 2016-02-04T00:28:15-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  
74 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 42072 1805 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 170.8296 10676.85 RUB 2016-04-25T05:36:07-07:00  
75 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 0 0 https://b|ackmattersus.oom/ 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-Amerioan fatally shot by a Detroit police officer 4 Officers, Who Shot Jeremy MoDoIe, 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 Girl Gets Rope Burns During A Camping Trip When Sandy Rougely’s 12-year-old daughter returned from a one day camping trip on April 28, Sandy was shocked to see a horrible rope burn on the front side of the kid’s heck. Black Matters 0.0 0.00 USD 2016-05-23T08:02:51-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  
77 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:multicultural_affinity:African American (US), and_must_also_match:interests:Black Tea Patriots, and_must_also_match:interests:Black Knowledge, and_must_also_match:interests:BIackNews.com, and_must_also_match:interests:HuffPost Black Voices 0 0 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 0.0 0.00 USD 2016-06-16T01:21:05-07:00  
78 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 44405 1739 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 Chicago IPRA Finally Gets Dashcam Video Of Darius Pinex Shooting It took over five years for the IPRA to get the key evidence in the fatal police shooting of a black Chicago man committed in 2011. Orlando Nightclub Massacre And The Race Factor Orlando tragedy shed light on how hate and terrorism can destroy innocent lives within a matter of seconds. Pepper-Sprayed Victim Donates $100K Settlement To Social Justice A Seattle high school history teacher Jesse Hagopian, pepper- sprayed by police, says he’ll donate the $100K settlement to help movement forjustice. NYPD Cop Pulls A Gun On Black Cyclist In Fender-Bender A 21-year-old black cyclist plans to sue a white NYPD police officer for threatening his life by pointing a gun at him during a fender-bender. Black Matters 95.05472 5940.92 RUB 2016-06-16T01:32:37-07:00  
79 location:United States, excluded_connections:Exclude people who like L for life, 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 31 0 https://www.facebook.com/pages/L-for-Iife/994910227187446   0.53744 33.59 RUB 2015-06-09T03:50:21-07:00 2015-06-11T03:48:00-07:00
80 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), 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 10825 1393 https://www.facebook.com/blackmattersus/ Fast-growing black community. Latest news and everyday updates! 53.83344 3364.59 RUB 2015-10-06T08:22:32-07:00  
81 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 7808 738 https://www.facebook.com/blackmattersus/ Fast-growing black community. Latest news and everyday updates! 44.7512 2796.95 RUB 2015-11-05T23:17:06-08:00  
82 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, 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 191 6 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Fast-growing black community. Latest news and everyday updates. 4.116 257.25 RUB 2015-07-10T01:02:58-07:00  
83 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, 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 613 30 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Join us. Because we care 7.488 468.00 RUB 2015-07-10T01:03:32-07:00  
84 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), 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 14050 1838 https://www.facebook.com/blackmattersus/ Black Matters. Black community. 60.166720000000005 3760.42 RUB 2015-10-06T08:24:58-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  
87 location_living_in:united_states:Los Angeles (+50 mi) California, 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:Malcolm X 6368 180 https://www.facebook.com/events/1051176154917933/ 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 113.76176 7110.11 RUB 2016-08-23T04:11:38-07:00 2016-09-03T07:04:49-07:00
88 custom_audience:Lookalike (US, 10%) - tesy, location_living_in:united_states:Los Angeles (+50 mi) California, 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:Malcolm X 5289 236 https://www.facebook.com/events/1051176154917933/ 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 96.05632000000001 6003.52 RUB 2016-08-26T04:19:56-07:00 2016-09-03T07:04:49-07:00
89 custom_audience:Lookalike (US, 10%) - tesy, location_living_in:united_states:Los Angeles (+50 mi) California, 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:Latin, people_who_match:interests:Malcolm X 172 9 https://www.facebook.com/events/1051176154917933/ Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford, Jesse Romero and Donnell Thompson 2.35568 147.23 RUB 2016-08-29T00:27:53-07:00 2016-09-03T07:04:49-07:00
90 location_living_in:united_states:Los Angeles (+50 mi) California, 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:Latin, people_who_match:interests:Malcolm X 3477 103 https://www.facebook.com/events/1051176154917933/ Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford, Jesse Romero and Donnell Thompson 61.588 3849.25 RUB 2016-08-29T05:11:27-07:00 2016-09-03T07:04:49-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  
92 location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, 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 608 27 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Fast-growing black community. Latest news and everyday updates. 7.1248000000000005 445.30 RUB 2015-07-10T01:03:03-07:00  
93 location:united_states:Cleveland (+50 km) Ohio, behaviors:African American (US), age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 17231 922 https://www.facebook.com/events/1486230091674577/ A Year Without Justice for Tamir Rice. Join the meeting! A Year Without Justice for Tamir Rice 63.81888 3988.68 RUB 2015-11-19T23:59:53-08:00  
94 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states: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 0 0 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-07-13T07:17:59-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  
97 location:United States, age:16 - 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:multicultural_affinity:African American (US) 74257 2603 https://blackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters Black Matters This Is What Being “Confident In Ones Blackness” Means To Some White Conservatives Black Matters Life Expectancy For Black Americans Increase Black Matters Police Brutality Videos Change How Black Men Live Black Matters 83.8656 5241.60 RUB 2016-05-10T07:26:47-07:00  
98 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:16 - 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 0 0 https://blackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters Black Matters This Is What Being “Confident In Ones Blackness” Means To Some White Conservatives Black Matters Life Expectancy For Black Americans Increase Black Matters Police Brutality Videos Change How Black Men Live Black Matters 0.0 0.00 USD 2016-06-23T06:07:51-07:00  
99 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:16 - 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 0 0 https://blackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters Black Matters 0.0 0.00 USD 2016-06-23T06:11:47-07:00  
100 location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states: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 0 0 https://www.facebook.com/blackmattersus/ Keeping eye on our brother's cases and much more 0.0 0.00 USD 2015-07-13T07:18: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 1065.555ms · Data source: simonw/russian-ira-facebook-ads-datasette