home / russian-ads

display_ads (view)

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

72 rows where an ad_target was interests:HuffPost Black Voices

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
278 no image 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 8069 396 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The instruction on how to start a revolution from the creator of Occupy Wall Street Micah White. Micah White is an extraordinary person. The only American creator of the Occupy Wall Street movement, the former editor of Adbusters magazine, the author of the Protest Guru Micah White: Time To Start Revolution | Black Matters Black Matters 18.89872 1181.17 RUB 2016-06-17T01:23:56-07:00 2016-06-20T01:23:55-07:00
279 no image 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 6540 701 https://blackmattersus.com/9599-orlando-blaCk-victims-need-support/ Black victims of Orlando massacre need our help as some of them struggling to raise money for medical treatment. #gofundme We all know about the horrible tragedy happened early Sunday, June 12, in Orlando gay nightclub called Pulse. The whole country mourns and prays for the innocen Orlando: Black Victims Need Support | Black Matters Black Matters 20.8 1300.00 RUB 2016-06-17T01:23:01-07:00 2016-06-18T01:23:00-07:00
280 no image 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 7803 735 https://www.facebook.com/BlaCk-Matters-1579673598947501/ "I wish I could have saved more, to be honest," said a brave ex-marine who had saved 70 people during Orlando nightclub shooting. Many witnesses of Orlando shooting said that they mistook the gunfire for the part of the show. Luckily, Imran Yousuf, a 24-year-old Hindu who left the Marine C War Veteran Of Color Saves Dozens During Orlando Shooting. Media Remains Silent. | Black Matters Black Matters 16.0 1000.00 RUB 2016-06-17T01:20:58-07:00 2016-06-18T01:20:56-07:00
281 no image 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 4293 602 https://www.facebook.com/BlaCk-Matters-1579673598947501/ They could have shot him in the arm or leg, somewhere where he could drop and still be alive. NYPD officers in Bronx were responding to an alert from shot spotter when they found Rashaun Lloyd around the same area the alert was coming from. They Claim th NYPD Shoot Mentally Ill Black Man 31 Times | Black Matters Black Matters 5.5912 349.45 RUB 2016-06-22T03:41:13-07:00 2016-06-25T03:41:12-07:00
285 no image 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 4909 608 https://www.facebook.com/BlaCk-Matters-1579673598947501/ White Privilege is everywhere even in auto Insurance. A new report published by 4AutolnsuranceQuote.com shows that Black Americans pay hundreds of dollars more for car insurance than whites. According to the resear Study: Black Car Owners Pay More For Auto Insurance Than Whites | Black Matters Black Matters 8.0 500.00 RUB 2016-07-22T02:41:17-07:00 2016-07-23T02:41:15-07:00
286 no image 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:News Feed on mobile devices 6747 694 https://www.facebook.com/BlaCk-Matters-1579673598947501/ New video released shows police officer assaulting Black female teacher during a routine traffic stop in Austin. Black schoolteacher, Breaion King, 26 was stopped by the white police officer Bryan Richter on June 15, 2015, for driving 50 mph in a 35 mph zone. However, the Video: Officer Hurls Black Woman During Traffic Stop | Black Matters Black Matters 8.0 500.00 RUB 2016-07-22T02:40:08-07:00 2016-07-23T02:40:07-07:00
287 no image 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 4077 466 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Stereotype: Being black while shopping in a grocery store. A grocery Clerk Abhishek Dubey has been arrested for holding 11-year-old Black boy Dylan under gunpoint in store. Dubey racially profiled the young boy suspecti Atlanta Man Arrested For Locking Black Boy In Grocery Store | Black Matters Black Matters 8.0 500.00 RUB 2016-07-22T02:39:42-07:00 2016-07-23T02:39:41-07:00
288 no image 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 3203 345 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Individual protesters in Oakland refused to attend police barbecue until their message is heard. Black Lives Matter, Wichita, Kan Activists, earlier this week, engaged in a protest that ended in a reunion cookout with the police. The Wichita Police Chief Go Oakland Protesters Response To Police BBQ Invitation | Black Matters Black Matters 8.0 500.00 RUB 2016-07-22T02:39:14-07:00 2016-07-23T02:39:12-07:00
289 no image 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 4975 618 https://www.facebook.com/BlaCk-Matters-1579673598947501/ “The City of Somerville stands against all violence and all injustice, which is why a Black Lives Matter banner hangs at City Hall”. Mayor Joseph Curtatone of Somerville, Massachusetts, boldly said he won’t remove Black Lives Matter banner from the City Hall after the local police union asked Massachusetts Mayor Refuses To Remove BLM Banner From City Hall | Black Matters Black Matters 7.5537600000000005 472.11 RUB 2016-07-25T07:19:27-07:00 2016-07-26T07:19:25-07:00
290 no image 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 6768 1098 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Now after eight police officers were killed in Dallas and Baton Rouge, Louisiana, the Ku Klux Klan targets Black activist groups. The racist and violent KKK group was distributing fliers in Georgia County, calling on residents to join them and terrorize Black people in response to the BLM, KKK Recruits Supremacists After Recent Killings Of Police Officers | Black Matters Black Matters 7.1496 446.85 RUB 2016-07-25T07:19:08-07:00 2016-07-26T07:19:06-07:00
302 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 0 0 https://www.facebook.com/events/1730167210590258/ Stand up, South Carolina! Let’s stop the propaganda of hate and white supremacy! Not My Heritage 0.0 0.00 USD 2016-07-21T01:07:46-07:00 2016-07-23T10:00:00-07:00
303 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 1239 58 https://www.facebook.com/events/1730167210590258/ White supremacists are planning to raise the racist flag again! The state officials ordere Not My Heritage 13.16384 822.74 RUB 2016-06-29T06:11:58-07:00 2016-07-24T06:11:56-07:00
306 no image 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 690 66 https://b|ackmattersus.com/7868-officer-puts-his-gun-he-used-in-killing-black- George Zimmerman hopes to fetch at least $5,000 for the gun he used to fatally shot unarmed teen Trayvon Martin in 2012. We can’t make up our minds on how one can arrogantly display the executing of a human being as an act of pride. It’s disheartening to see when a bloody murder Officer Puts His Gun He Used In Killing Black Teen On Auction | Black Matters Black Matters 3.2 200.00 RUB 2016-05-13T06:41:26-07:00 2016-05-14T06:41:25-07:00
308 no image 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 5 0 https://b|ackmattersus.com/7474-blaCk-fami|ies-embark-on-homeschooling- A study by the National Home Education Research Institute shows that approximately 220,000 black students are currently homeschooling in the US. Increasing number of Black families now prefer to teach their Children at home rather than to send them to public schools. The simple cause for this is racism. Black Families Embark On Homeschooling Because Of Racial Bias And Safety Concerns | Black Matters Black Matters 0.01648 1.03 RUB 2016-04-30T08:52:12-07:00 2016-05-02T08:52:11-07:00
788 location:United States, interests:BIackNews.com, interests:HuffPost Politics, interests:HuffPost Black Voices, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.youtube.com/watch?v=Gij0RgShO| Where is the justice? Our brothers and sisters are being cruelly killed by the so—called police every day and ourjudicial system is absolutely blind. We are all Americans, but why does our corrupt Government differ black and white people? We want the same attitude! I don‘t want to be scared of living in my country! They will never shut me up! https://www.youtube.com/watch?v=Gij0RgShO| Where is the justice? Our brothers and sisters are being cruelly killed by the so—called police every day and ourjudicial system is absolutely blind. We are... Police is not above the law! Wi||iams&Ka|vin 0.0 0.00 USD 2016-01-05T02:03:02-08:00 2016-01-07T02:03:00-08:00
799 location:United States, interests:Martin Luther King, interests:Jr., interests:Melanin, interests:African-Amerioan Civil Rights Movement (1954—68), interests:African-Amerioan history, interests:Malcolm X, interests:Black (Color), interests:HuffPost Black Voices, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 13263 1100 https://www.facebook.com/WilIiamsKalvin-788980617892144/ I pity anyone who has to deal with neighbors in an apartment building. Especially when you have to deal with the complaining and passive- aggressive types. Oh, and let’s not forget gentrifiers. Or, as I like to call them, “white migrators.” Apparently, instead of knocking on a neighbor’s door, people take the easy and passive-aggressive way out and just leave notes instead. But one man wasn’t having it. Link: https://scontent-arn2-1 .xx.fbcdn.net/v/t1 .0-9/14572967_1772905896322 988_913778538274424647_n.jpg?oh=9a4945f2582b54297fe1f8f786f297be& oe=5862D508 Subscribe to our Channel: https://www.youtube.com/ChahnellUCszPCwUDPvDCR6VRaOCDtg Follow my Facebook: https://www.facebook.com/WilliamsandKalvin Follow me on Instagram: https://www.instagram.Com/williams.and.kalvin Follow me on Twitter: https://twitter.com/Williams8kalvih 19.2 1200.00 RUB 2016-10-14T02:45:50-07:00 2016-10-15T02:45:48-07:00
823 location:United States, interests:HuffPost Black Voices, age:18 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Hypocrisy of our society has gone way too far... Celebrating human rights day, when black society is being oppressed by authorities and racist radicals every day is a spit in our faces! Why do black people are always guilty in everything in this country? Aren‘t african americans humans? 80... this day creates more questions than give answers... Thanks everybody for watching! 0.0 0.00 USD 2015-12-18T03:20:05-08:00 2015-12-21T03:20:04-08:00
847 location:United States, interests:BIackNews.com, interests:HuffPost Politics, interests:HuffPost Black Voices, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/WilIiamsKalvin-788980617892144/ Why don‘t american cops realize that being black is not a crime? African american kids are being shot only for playing with toy guns... How is it possible? Where is the justice? Our Government is blind, they simply don‘t want to pay attention to this legalized homicide of own people... This is crazy! We must speak about it! 0.0 0.00 USD 2016-01-05T02:03:13-08:00 2016-01-08T02:03:12-08:00
859 location:United States, interests:BIackNews.com, interests:HuffPost Politics, interests:HuffPost Black Voices, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2574 50 https://www.facebook.com/WilliamsandKalvin/   13.6 850.00 RUB 2016-02-02T06:18:30-08:00 2016-02-06T04:00:45-08:00
905 location:United States, interests:BIackNews.com, interests:HuffPost Politics, interests:HuffPost Black Voices, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 7452 554 https://www.facebook.com/Williamsathalvin/ There're a lot of racial discrimination going on in America these days. Can you imagine that a group of armed men took over a federal property and have vowed to kill if they are forced to leave there unless the government Change the law in their favor. Nonsense! The ongoing Oregon standoff has taught us is that it’s never been more apparent that the US. government values white lives above all others. The most stark example is comparing the kid-gloves treatment the white gunmen in Oregon are getting with the 1985 bombing of the MOVE house in Philadelphia. #GunmeninOregon #TheMove #1985Bombing 16.0 1000.00 RUB 2016-01-21T03:53:21-08:00 2016-01-23T03:53:21-08:00
1238 no image location:united_states:New York, interests:Black Tea Patriots, interests:Black Knowledge, interests:BlaCkNews.com, interests:BEING BLACK!!!, interests:HuffPost Black Voices, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blacktivists/ BE A BLACKTIVIST —JOIN THE We all know that black communities and Natives have always been plagued by an array of issues that we have to deal on a daily basis. Watching America’s reaction to racism is very telling. Last year, police brutality and racism have made it t the forefront. Hundreds of unarmed black men and women died at the hands of police officers. We are tired to feel neglected and ignored. We all have had enough. And now we need to come together, be honest and get the government‘s attention. You are all invited to em We do not expect you to solve generations of inequality and oppression overnight. We do, however, expect you to come and to address the issues and put forward a plan to make change. —#StopNativeGenocide #BIaokLivesMatter 0.0 0.00 USD 2016-02-18T05:30:07-08:00 2016-02-19T05:30:06-08:00
1443 location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Don't Shoot, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 384 15 https://www.facebook.com/BIackJourneyZJustice/ We are not against the police, We are against police brutality! 10.87936 679.96 RUB 2015-12-10T02:14:26-08: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/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 1007.184ms · Data source: simonw/russian-ira-facebook-ads-datasette