display_ads (view)
Data source:
simonw/russian-ira-facebook-ads-datasette
3 rows
where an ad_target was people_who_match:Friends of connections: Friends of people who are connected to Black Matters and an ad_target was location_living_in:united_states:Cleveland (+50 mi) Ohio
This data as JSON, CSV (advanced)
|
id
|
img
|
targeting
|
impressions
|
clicks
|
url
|
text
|
spend_usd
|
spend_amount
|
spend_currency
|
created
|
ended
|
| 312 |
no image |
location_living_in:united_states:Cleveland (+50 mi) Ohio, 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 |
6592 |
212 |
https://www.facebook.com/blackmattersus/ |
—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
|
27.445919999999997 |
1715.37 |
RUB |
2016-02-08T07:06:35-08:00 |
2016-02-09T07:06:34-08:00 |
| 313 |
no image |
location_living_in:united_states:Cleveland (+50 mi) Ohio, 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 |
0 |
0 |
https://www.facebook.com/events/1486230091674577/ |
November 23, 2015 Is the One year anniversary Death of 12 year old Tamir
Rice; killed by two Cleveland Police Officers Timothy Loehmann and Frank
Garmback. You are welcome! Join the meeting. A Year Without Justice for
Tamir Rice
|
0.0 |
0.00 |
USD |
2015-11-19T23:51:19-08:00 |
2015-11-22T23:51:18-08:00 |
| 315 |
no image |
location_living_in:united_states:Cleveland (+50 mi) Ohio, 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 |
0 |
0 |
|
|
0.0 |
0.00 |
USD |
2015-11-19T23:21:05-08:00 |
2015-11-22T23:21:03-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