Data source: simonw/russian-ira-facebook-ads-datasette
This data as JSON, CSV (advanced)
| 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 |
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