home / russian-ads

display_ads (view)

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

5 rows where an ad_target was interests:Pan-Afrioanism

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

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 1277.82ms · Data source: simonw/russian-ira-facebook-ads-datasette