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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 942 | |
location:United States, interests:Pan-Afrioanism, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-American history, interests:Black (Color), age:16 - 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/Blacktivist-128371547505950/ | VIDEO: TEXAS SCHOOL TEACHER FIRED AFTER MANHANDLING LITTLE BLACK BOY The shocking video shows a Central Texas Child trying to get up from a bean bag Chair in his Classroom, while a Snook Independent School District employee, Troy Vahn pushing him repeatedly into it and mocking him again and again. After the concerned parent posted a disturbing video showing teacher manhandling a small Child on Facebook, the video went viral and it was shared thousands of times. In the video footage, Vahn also tells the boy: “Tell me no. When | tell you to do something, you do it, boy.” After the Burleson County Sheriff‘s Office launched an investigation, a “behavior specialist” who acted in an inappropriate manner with a young student was fired. The school district should provide a safe and secure environment for the students. And the school should not condone or tolerate the employees who abuse any Child. The teachers who use excessive force against any Child should be removed immediately from the Classroom and placed on administrative leave. Otherwise, this will continue to happen. | 0.0 | 0.00 | USD | 2016-10-20T07:56:03-07:00 | 2016-10-21T07:56:02-07:00 |
| 1051 | |
location:United States, interests:Pan-Afrioanism, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 36295 | 6656 | https://www.facebook.com/Blacktivist-128371547505950/ | CHARLESTON COP WHO FATALLY SHOT BLACK MAN ASKS JUDGE TO DROP CHARGES, CITING DOUBLE RISK North Charleston police officer Michael Slager, who shot and killed 50-year- old Scott after an April 2015 traffic stop, and his attorneys urged the court to drop murder Charge due to the double jeopardy that Slager faced before the shooting. According to ex-cop‘s attorneys, their defendant acted in self- defense despite the fact that Scott was unarmed and Slager fired eight times, hitting Scott five times from behind. Slager‘s defense attorney‘s: “The doubIe-teaming of Slager is a chilling example of how far politically motivated politicians and prosecutors will go to seek headlines and feather their own nests at the expense of a public servant who had to make a split- second life or death decision that will be seoond-guessed by comfortable armchair quarterbacks. This is unconscionable.” The shooting occurred in April 2015 when Slager stopped Scott for a broken brake light on the Mercedes-Benz he was driving. According to Slager‘s dashcam, ex-cop asked Scott to show his driving license and questioned him about documents for the car. When Slager returned to his car, Walter Scott jumped out of the car and ran away giving Slager chase. According to a bystander‘s video, Scott ran away from the officer when Slager opened fire. We‘ve seen what happened in different parts of America: unarmed dead black bodies lying across the streets at the hands of police officers and none of them found guilty. That‘s why today it‘s important to send a message to other police officers that if they do this, it‘s harsh penalty to pay. | 8.0 | 500.00 | RUB | 2016-11-03T08:11:51-07:00 | 2016-11-10T07:11:51-08:00 |
| 1100 | |
location:United States, interests:Pan-Afrioanism, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 34914 | 3640 | https://www.facebook.com/Blacktivist-128371547505950/ | COPS SHOT AND KILLED CALIFORNIA BLACK WOMAN WHO STRUGGLED WITH BIPOLAR DISORDER Michelle Lee Shirley was fatally shot by Torrance police officer as she approached a group of police officers in her car. Police arrived at the scene after a series of 911 calls in which they were warned of a reckless driver and her erratic behavior. When cop saw Shirley, who was off her bipolar medication, they boxed her in with their patrol cars. When she started approaching them, law enforcement officers opened fire at her. The incident resulted in a fatal shooting. After the shooting, Shirley was taken to County Harbor—UCLA Medical Center and was pronounced dead. Michelle Shirley, 39, who received a diagnosis of a mental disorder tried to balance motherhood and law school. In a video titled, “It‘s Up to Us,” she was asking people to take seriously a mental disorder and seek help because ignoring it can take away years of people‘s lives. Did you know that people with mental illness are 16 times more likely to be killed during a police encounter than mental healthy? Did you know that half of people shot by cops are mentally ill? Police officers are not equipped with firearms to deal with mental illness in the field. But they are equipped to protect us from criminals. | 8.0 | 500.00 | RUB | 2016-11-03T08:13:05-07:00 | 2016-11-10T07:13:05-08:00 |
| 1104 | |
location:United States, interests:Pan-Afrioanism, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 11217 | 1991 | https://www.facebook.com/Blacktivist-128371547505950/ | Don‘t be scared to rock your natural hair. Life is short and you only live once on this earth. | 6.4 | 400.00 | RUB | 2016-10-18T06:43:09-07:00 | 2016-10-19T06:43:07-07:00 |
| 1145 | |
location:United States, interests:Pan-Afrioanism, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Black (Color), age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 8475 | 1441 | https://www.facebook.com/Blacktivist-128371547505950/ | Colin Kaepernick is no Rosa Parks, who was a victim of segregation. But Colin Kaepernick is an articulate young man, who refused to show pride in a flag for a country that continues to gun down innocent black men. | 9.6 | 600.00 | RUB | 2016-10-20T07:56:56-07:00 | 2016-10-21T07:56:54-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