home / russian-ads

display_ads (view)

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

25 rows where an ad_target was people_who_match:Friends of connections: Friends of people who are connected to Black Matters and an ad_target was location_living_in:United States

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
210 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 20386 2363 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Bill Clinton angrily tells Black Lives Matter protesters that they "are defending the people who kill the lives you say matter." Finally, the Clintons are showing their true colors. On Thursday former President Bill Clinton gave Black Lives Matter protesters another reason to be cautious of Hillary. On the campaign trail for Hillary in Phil Bill Clinton Confronts Black Lives Matter Protesters | Black Matters Black Matters 16.0 1000.00 RUB 2016-04-08T08:21:47-07:00 2016-04-10T08:21:46-07:00
213 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 55630 6706 https://b|aokmattersus.com/6411-texas-po|ice-officer-found-not-guiIty-for- Daniel Willis, a former deputy police officer in Texas has been Cleared of murder Charges in the fatal shooting of a 47-year-old black mom. The unarmed black woman, Yvette Smith, was shot to death on February 16, 2014 at her front door by Officer Daniel Willis who was supposed to calm a dispute betw Texas Police Officer Found Not Guilty For Killing A Black Woman | Black Matters Black Matters 56.0 3500.00 RUB 2016-04-11T01:37:15-07:00 2016-04-14T01:37:00-07:00
214 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 6143 1030 https://www.facebook.com/BlaCk-Matters-1579673598947501/ A Texas district police officer, Joshua Kehm, has been fired for brutalizing a sixth grader Janissa Valdez at Rhodes Middle School. According to reports, two preteens were arguing outside the school campus on Tuesday March 29 and Officer Kehm was called to calm the situation. When the Office Police Officer Fired For Body-Slamming 12-Year-Old Girl | Black Matters Black Matters 8.0 500.00 RUB 2016-04-14T01:22:25-07:00 2016-04-16T01:22:24-07:00
215 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 7772 1145 https://www.facebook.com/BlaCk-Matters-1579673598947501/ A 16-year-old African-Amerioan Pierre Loury was fatally shot by a Chicago patrol officer on Monday April 11. It was around 7:40 pm. and Officers were on their patrol routine hunting down black men for crimes. They saw Pierre Loury in a vehicle matching a description 0 Police Officer Fatally Shoots Black Teenager And Lies About His Death | Black Matters Black Matters 8.0 500.00 RUB 2016-04-14T01:22:07-07:00 2016-04-16T01:22:06-07:00
216 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 13936 2116 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Ah unarmed black man who was shot by two officers in Florida in 2013 has been compensated by the state, through the effort of the Black Lives Matter. Fusion reported that the now-paralyzed Dontrell Stephens, the unarmed black man who was shot in Florida during traffic stop in September 2013, by Sgt. Adams Lin Black Man Shot By Police Receives $23M Settlement Because of BLM | Black Matters Black Matters 16.0 1000.00 RUB 2016-04-14T01:21:30-07:00 2016-04-16T01:21:29-07:00
217 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 13808 2097 https://www.facebook.com/BlaCk-Matters-1579673598947501/ A report recently revealed that the jail in which Sandra Bland had been kept was seriously suffering from consistent violations of inmates’ rights. In July last year, Sandra Bland a 28-year-old black woman was pulled over by a cop for traffic violation; officer brutally arrested her and brought to the jail. Serious Problems Discovered At County Where Sandra Bland Died | Black Matters Black Matters 16.0 1000.00 RUB 2016-04-14T01:21:05-07:00 2016-04-16T01:21:04-07:00
218 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 37267 3856 https://b|ackmattersus.com/6948-officers-vio|entIy-beat-and-arrest-teen-just- The Baton Rouge Advocate reported that some Louisiana officers are under investigation for beating a 16-year-old boy after a video of the beating got to the dep Officers Violently Beat And Arrest Teen Just For Asking Question | Black Matters Black Matters 59.333760000000005 3708.36 RUB 2016-04-21T02:03:04-07:00 2016-04-24T22:20:00-07:00
219 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 13 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Ruffins is filing Charges against NYPD cops who responded to a call by security, Claiming Ruffins kicked a door at New year’s in 2014. The disabled Ruffin was s Blind Black Veteran Humiliatingly Ruffed By Cops Files Charges | Black Matters Black Matters 0.07536 4.71 RUB 2016-04-21T02:02:45-07:00 2016-04-23T02:02:45-07:00
220 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 46437 5607 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Bernie Sanders has proven himself to be the best candidate in every way. He is fair and strong and he is the only one fighting for the black community. For more than 40 years he is advocating against any injustice and stays true to his moral values. Vote for Bernie! 44.58176 2786.36 RUB 2016-04-21T02:02:13-07:00 2016-04-24T22:02:00-07:00
221 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 14 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The Atlanta police department reported that the driver, Ryan Lisabeth, was on top speed to Joseph E. Boone Boulevard on Friday when he lost control on his steer Atlanta Driver On Drugs Injures 2 Black Children, Killing 1 in Accident | Black Matters Black Matters 0.14048 8.78 RUB 2016-04-21T00:22:59-07:00 2016-04-23T00:22:58-07:00
222 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 32 4 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Hunter Park, pleaded guilty to making terrorist threats against Black students at the University of Missouri. A white male form Missouri has pleaded guilty to making online threats toward black students at the University of Missouri after university's president ste Missouri Man Pleads Guilty To Threatening Blacks At University | Black Matters Black Matters 0.10640000000000001 6.65 RUB 2016-04-21T02:01:32-07:00 2016-04-22T02:01:31-07:00
223 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 17376 2083 https://b|ackmattersus.com/6980-baltimore-cop-drag-bIaCk-teeh-from-home- A white cop slammed Tionne Jones, 18, to the ground and dragged him from his home after he rightfully requested a warrant. A white police officer in Baltimore was caught on video violently dragging a Black teen out of his home. The incident occurred on Saturday, April 16, when 18-ye Baltimore Cop Drag Black Teen From Home Without Warrant | Black Matters Black Matters 29.412 1838.25 RUB 2016-04-21T00:22:05-07:00 2016-04-24T22:22:00-07:00
224 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 20280 2034 https://b|aokmattersus.com/6984-man-set-free-after-10-years-in-prison- Chicago police testified there was no surveillance camera in the alley where they arrested Jermaine Walker — but there was. A Chicago man, who spent 10 years in jail on drug Charges, has been set free after an investigation proved that police officers and a state’s attorney investiga Man Set Free After 10 Years In Prison Because Police Lied In Court | Black Matters Black Matters 28.872 1804.50 RUB 2016-04-21T00:21:47-07:00 2016-04-24T22:21:00-07:00
225 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 58 9 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The Daily Beast reported that a black veteran, Elliot Williams, 37, encountered a painful death in jail cell without help from jail officials as they watched hi Oklahoma Cops Left Black Army Veteran To Die In Jail Cell | Black Matters Black Matters 0.12016 7.51 RUB 2016-04-21T00:21:22-07:00 2016-04-23T00:21:21-07:00
226 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 139 20 https://www.facebook.com/BlaCk-Matters-1579673598947501/ African-American protest groups gathered on Wednesday, April 20, outside Mayor Rahm Emanuel’s City Hall demanding that Officer Dante Servin be fired. It’s been over four years since an off-duty Chicago police officer, Dante Servin, fatally shot a 22-year-old black woman in Douglas Park. According to sources, Protesters Demand Firing Of Officer, Who Killed Rekia Boyd | Black Matters Black Matters 0.44464 27.79 RUB 2016-04-22T03:15:27-07:00 2016-04-24T03:15:51-07:00
227 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 29056 3293 https://www.facebook.com/BlaCk-Matters-1579673598947501/ A “quiet and nice” 16-year-old girl “who kept to herself” is dead after an assault at Delaware high school. A teen girl died after she was assaulted at her Delaware high school, authorities said. The 10th grader, who has been identified as Amy Inita Joyner—Francis, wa TRAGIC: Teen Girl Beaten To Death In High School Bathroom | Black Matters Black Matters 52.94096 3308.81 RUB 2016-04-25T05:37:03-07:00 2016-04-27T18:37:00-07:00
228 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 458 56 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Jaden Malone’s mom has removed him from the NC. Charter school over his suspension for pushing bully off him. A furious Charlotte, NC, mother has pulled her son out from the Invest Collegiate Charter School over his suspension for defending himself against a bully, WJ 12-Year—Old Boy Suspended From School For Standing Up To Bully | Black Matters Black Matters 0.72368 45.23 RUB 2016-04-25T05:25:40-07:00 2016-04-27T05:25:40-07:00
229 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 11249 1590 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Prince Rogers Nelson’s contributions to help |ow-income black Children will be forever remembered. The 57-year-old music legend commonly known as Prince, who died on Thursday April 21, is remembered in Silicon Valley as an innovator and a passionate advocate Music Icon Prince Remembered As Advocate For Black Youth | Black Matters Black Matters 28.51728 1782.33 RUB 2016-04-26T00:10:23-07:00 2016-04-27T00:10:23-07:00
230 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 19309 2252 https://b|ackmattersus.com/7167-bIm-members-arrested-for-counter-protest- Nine Black Lives Matter protesters were arrested after a counter-protest at a “pro-white” rally, organized by members of Ku Klux Klan in Georgia. A white- power rally was held over the weekend by members of KKK, Aryan Nation sects and other white supremacist groups to celebrate the Confederate Memorial Day BLM Members Arrested For Counter-Protest Against “White- Power” Rally In Georgia | Black Matters Black Matters 40.78112 2548.82 RUB 2016-04-25T05:25:19-07:00 2016-04-27T05:25:19-07:00
231 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 7122 769 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Several anti-raoist organizations, including Black Matters, stood up against white supremacists, who staged the rally at Stone Mountain Park on April, 23. Hundreds of neo-nazis and klansmen attended an “openly White Power” rally at Stone Mountain on Saturday. According to SPLC, the racist rally was organized by Jo White Pride Rally Was Interrupted by Anti-racist Groups | Black Matters Black Matters 18.55216 1159.51 RUB 2016-04-26T00:25:13-07:00 2016-04-27T00:25:13-07:00
232 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 8239 998 https://www.facebook.com/BlaCk-Matters-1579673598947501/ "We need our community's help; we aren't interested in rumors or gossip; we're looking to find the truth," said Ken Mascara, St. Lucie County Sheriff. St. Lucie County police officers are investigating the fatal shooting of a 21 -year- old black motorist, Demarcus Semer, committed by two officers whose names are 12 Witnesses Of Police Shooting Demarcus Semer Refuse To Talk | Black Matters Black Matters 18.40176 1150.11 RUB 2016-04-26T00:24:45-07:00 2016-04-27T00:24:44-07:00
233 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 20905 2427 https://www.facebook.com/BlaCk-Matters-1579673598947501/ A 23-year-old black mom, Jeannette Maclin, was unjustly jailed over a month ago after her two young boys set their apartment on fire. According to reports, Maclin left her two boys aged five and two at home alone that day in desperation to make ends meet. She works endlessly on a Iow-paid job Struggling Single Mother Jailed Over Accidental Fire Gets Support | Black Matters Black Matters 51.17088 3198.18 RUB 2016-04-25T05:30:29-07:00 2016-04-27T18:30:00-07:00
282 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 21301 1814 https://b|ackmattersus.com/10718-take-part-in-bIaCk-pride-survey/ We are conducting this survey because your opinion is important to us! Black Voices must be heard! Black opinion matters! Online survey powered by Typeform Thank you for your time! We highly appreciate your efforts and your opinion. Please, SHARE this article with your friends to m Take Part in Black Pride Survey | Black Matters Black Matters 24.0 1500.00 RUB 2016-07-07T08:05:38-07:00 2016-07-08T08:05:35-07:00
283 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 0 0     0.0 0.00 USD 2016-07-14T02:05:21-07:00 2016-07-15T02:05:19-07:00
284 no image location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ When a Black man is shot dead, the world will know about every little secret he had. It is obvious that every time a Black man is killed, all his secretes and mistakes will be all over the internet. The media goes in search of all his criminal r 2 Blacks, Sterling and Castile, Are Now Subject To Intense Scrutiny | Black Matters Black Matters 0.0 0.00 USD 2016-07-17T11:01:34-07:00 2016-07-15T02:05:19-07:00

Advanced export

JSON shape: default, array

CSV options:

CREATE VIEW display_ads AS 
        select ads.id,
            case when image is not null then
                json_object("img_src", "https://raw.githubusercontent.com/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 1357.426ms · Data source: simonw/russian-ira-facebook-ads-datasette