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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 209 | no image | location:united_states:Atlanta Georgia, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters | 18946 | 1276 | https://b|ackmattersus.com/6189-bIaCk-woman-found-dead-in-jaiI-Cel|-after- | Wakiesha Wilson, 36, was found dead on Easter Weekend at the LAPD’s detention center in jail cell. According to ABC? report, the black woman, Wakiesha Wilson, had a disagreement with officers before she was found died. Wilson spoke to her lovely family that v Black Woman Found Dead In Jail Cell After Arguing With Detention Officers | Black Matters Black Matters | 56.0 | 3500.00 | RUB | 2016-04-06T08:48:17-07:00 | 2016-04-10T22:48:00-07:00 |
| 211 | no image | location:united_states:Atlanta Georgia, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters | 2441 | 197 | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | Atlanta Hawks forward Sefolosha files a Civil lawsuit against 5 NYPD officers for breaking his leg. Atlanta Hawks forward Thabo Sefolosha filed a Civil lawsuit against five New York Police Department officers and the City on Wednesday in relation to an inciden NBA Star Sues NYPD Over False Arrest, Excessive Force, And Malicious Prosecution | Black Matters Black Matters | 14.4 | 900.00 | RUB | 2016-04-08T07:30:09-07:00 | 2016-04-09T07:30:08-07:00 |
| 212 | no image | location:united_states:Atlanta Georgia, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters | 1112 | 120 | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | Jay Z and Beyoncé stood with families of police brutality victims, donated bail for Baltimore and Ferguson protesters. The never-ending cases of police brutality and state-sahctioned violence against Black people — the most prominent being the police slaying of Michael Brown, Er Music’s Billion-Dollar Couple Help Raise Awareness Of Race And Police Brutality | Black Matters Black Matters | 4.8 | 300.00 | RUB | 2016-04-07T08:20:46-07:00 | 2016-04-08T08:20:46-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