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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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