home / russian-ads

display_ads (view)

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

24 rows where an ad_target was interests:BIackNews.com

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
65 location:united_states:Los Angeles (+40 km) California, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 41395 1734 https://www.facebook.com/events/1702267153358101/ Two years have passed since August 11, 2014, the date, when 25-year-old Ezell Ford was mur Justice For Ezell Ford And Donnell Thompson 238.108 14881.75 RUB 2016-08-04T07:25:31-07:00 2016-08-20T07:25:28-07:00
72 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:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 2461 75 https://b|ackmattersus.oom/ Black Community! We finally made a website! News about black racial and social issues. This happened yesterday, Feb. 2, at a dry Cleaning shop in a black neighborhood, when this black guy went for his Clothes he had already sent for laundry. “What do you mean by you people?” The black guy asked. There was a murmur from inside the shop; the dry Cleaner answered “those who are arguing m... Black Matters The Police should protect not Brutalize Ideally Black Women... S. F. Police Vow To Eradicate Racism Plans to fight racism in the ranks. Black History Month The event grew out of “Negro History Week,” the brainchild Black Matters 6.27424 392.14 RUB 2016-02-04T00:28:15-08:00  
102 location:united_states:New York (+40 km) New York, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 37821 2775 https://www.facebook.com/events/1085290071563825/ Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner 199.76272 12485.17 RUB 2016-07-06T03:03:43-07:00 2016-07-17T03:03:41-07:00
103 location:united_states:New York (+40 km) New York, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/events/1085290071563825/ Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner 0.0 0.00 USD 2016-07-28T06:40:03-07:00 2016-07-17T03:03:41-07:00
104 location:united_states:Los Angeles (+40 km) California, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/events/1085290071563825/ Almost 2 years have passed since the death of Eric Garner, a father of 6, who was violentl Rally In Memory Of Eric Garner 0.0 0.00 USD 2016-08-04T07:24:02-07:00 2016-07-17T03:03:41-07:00
181 no image location:united_states:New York (+40 km) New York, interests:Black Tea Patriots, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ The—will attract the UN’s attention to the long term injustice and cruelty against people of color in the United States. The genocide instituted by white supremacists should be stopped. Join our protest that will be held Also, join the event for more info: #CrimesOfGenocide 0.0 0.00 USD 2016-02-09T05:37:37-08:00 2016-02-12T06:18:00-08:00
183 no image location:united_states:New York New York, interests:Black Tea Patriots, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1847 144 https://www.facebook.com/blackmattersus/ Join our upcoming event: https://www.facebook.com/events/162707160753103/ Confirmed speakers for the #WeWantFreedom protest include black activist #CrimesOfGenocide 16.0 1000.00 RUB 2016-02-12T00:36:55-08:00 2016-02-14T00:36:55-08:00
186 no image location:united_states:New York New York, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1590 180 https://www.facebook.com/blackmattersus/ “Formation”, undoubtedly focuses on “black identity”, as Beyonce justifies her authority as a proud Black woman and concurrently authenticating her roots and history. Read more: http://b|ackmattersus.com/1670-20-time-grammy-winner—and-proud-queen- diva-be-goes-politicaI-with-her-form ation/ 7.39136 461.96 RUB 2016-02-12T00:36:07-08:00 2016-02-21T00:36:06-08:00
234 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 9 2 https://www.facebook.com/BlaCk-Matters-1579673598947501/ “When the cameras and lights are gone, our babies are dead. So I’m going to ask you here today to wake up,” says late Sandra Bland’s mom. A Congressional Caucus on Black Women and Girls held over the week brought together dozens of public figures, lawmakers and relatives of Sandra Bland, who was k Sandra Bland’s Mom Gives Devastating Speech To Congressional Leaders | Black Matters Black Matters 0.14896 9.31 RUB 2016-04-30T08:54:35-07:00 2016-05-02T08:54:35-07:00
235 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 6349 598 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Beaufort County School District is investigating the case of a white school teacher asking a black student to go back to Africa. According to reports, Nicole Whitmore’s son, who is a freshman in Battery Creek High School, was sitting with about 10 other students when their teacher instruc White Teacher Te||s Black Teen To “Go Back To Africa” | Black Matters Black Matters 8.0 500.00 RUB 2016-04-30T08:53:55-07:00 2016-05-02T08:53:54-07:00
241 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 950 52 https://www.facebook.com/BlaCk-Matters-1579673598947501/ A viral Facebook video shows how an innocent black bystander was attacked by a K—9 dog in a crowd of residents due to an incompetent attitude of a police officer. An innocent bystander, Rafer Allen, a black Virginia man was attacked by a K—9 police dog on Saturday after officers were trying to apprehend a drug dealer susp Cop Attacks Innocent Bystander With K—9 | Black Matters Black Matters 1.6 100.00 RUB 2016-05-06T03:33:49-07:00 2016-05-07T03:33:49-07:00
243 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 614 57 https://b|ackmattersus.com/7660-utah-schooI-defends-white-teachers-use-of— The teacher also had a confederate flag in his Class, but the school district still thinks his intent was not to offend. A Black woman from Utah is outraged that her teenage son sat through a Class in which a teacher used the h-word and defined its meaning and history, Fox 19 repo Utah School Defends White Teacher’s Use of the N-Word In Class | Black Matters Black Matters 1.6 100.00 RUB 2016-05-06T03:32:45-07:00 2016-05-07T03:32:45-07:00
244 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 1118 63 https://www.facebook.com/BlaCk-Matters-1579673598947501/ A Public Defender posed a controversial question to potential Jurors for the trial of a young Black man convicted of murder. The question indicated to an increasing awareness among public defenders that they too may harbor racial and ethnic biases about Blacks. Earlier this year, San Francisco public defender, Mark Jacobs, posed a shocking question to a group ofjurors prior to the trial of a young black man. The quest Racial Incongruities In US. Criminal Justice System | Black Matters Black Matters 1.6 100.00 RUB 2016-05-06T03:32:11-07:00 2016-05-07T03:32:10-07:00
245 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 1323 54 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Smithsonian Rep denies reports that the museum plans to preserve gazebo where Tamir Rice died, but acknowledged they are helping someone else who wants to do it. The Smithsonian Museum has issued a statement that the institute is not looking into preservation of the gazebo where 12-year-old Tamir Rice was gunned down by Smithsonian Museum Is Not Trying To Save Gazebo Where Tamir Rice Was Shot | Black Matters Black Matters 1.6 100.00 RUB 2016-05-06T03:31:27-07:00 2016-05-09T03:31:27-07:00
250 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 2060 147 https://www.facebook.com/BlaCk-Matters-1579673598947501/ The officers choked Maurice Marrow causing him to faint, despite his cries about an imminent seizure. A video taken by a New York City train rider shows cops brutally beating a Black man into seizure and fainting on Friday morning at Halsey St. station in Bushwi Watch How Officers Beat Black Brooklyn Man Into Seizure | Black Matters Black Matters 5.87616 367.26 RUB 2016-05-10T07:00:12-07:00 2016-05-11T07:00:11-07:00
253 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 3563 277 https://www.facebook.com/BlaCk-Matters-1579673598947501/ While in solitary confinement Candie Hailey was physically and sexually abused by prison guards leading to her numerous suicide attempts. Candie Hailey, a Bronx woman, who spent more than two years in solitary confinement at Rikers Island before being acquitted, is preparing a $10 million lawsuit Woman Suing City After Spending More Than 2 Years In Solitary | Black Matters Black Matters 7.0492799999999995 440.58 RUB 2016-05-10T02:24:35-07:00 2016-05-11T02:24:35-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
298 location:united_states:New York (+40 km) New York, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 29689 1969 https://www.facebook.com/events/309180056094025/ August 9, 2016, marks a two—year anniversary of the brutal murder of Michael Brown, an 18- Rally In Memory Of Mike Brown 97.6888 6105.55 RUB 2016-07-28T06:40:40-07:00 2016-08-14T06:40:38-07:00
299 location:united_states:Los Angeles (+40 km) California, interests:BIackNews.com, interests:Black History Month, interests:African-American history, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 14949 1042 https://www.facebook.com/events/309180056094025/ August 9, 2016, marks a two—year anniversary of the brutal murder of Michael Brown, an 18- Rally In Memory Of Mike Brown 120.52992 7533.12 RUB 2016-08-04T07:23:59-07:00 2016-08-14T06:40:38-07:00
310 no image location:united_states:New York New York, interests:BIackNews.com, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/BlaCk-Matters-1579673598947501/ As what happened to India while in police custody remains a major concern, many are wondering why the 27-year-old was denied an appropriate medical evaluation and proper care. The frequent reports of police brutality and extreme use of force, leading to death has regrettably become a daily course. Consequently, protests and demonstrations overflow in every nook and cranny, demanding answers and justice. On February 1, India T. Cummings was under the influence of the synth... #JusticeForlhdia: 27-Year-old Denied Medical Treatment, Dies in Police Custody | Black Matters Black Matters 0.0 0.00 USD 2016-03-04T00:41:08-08:00 2016-03-05T00:41:08-08: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
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

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