display_ads (view)
Data source:
simonw/russian-ira-facebook-ads-datasette
1 row
where an ad_target was people_who_match:interests:Donald Trump Jr. or Supporting OurVeterans
This data as JSON, CSV (advanced)
id
|
img
|
targeting
|
impressions
|
clicks
|
url
|
text
|
spend_usd
|
spend_amount
|
spend_currency
|
created
|
ended
|
1934 |
 |
location_living_in:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Young Republicans, people_who_match:interests:Support Our Veterans, people_who_match:interests:Donald Trump for President, people_who_match:interests:Fox News Politics, people_who_match:interests:conservative daily, people_who_match:interests:Donald Trump Jr. or Supporting OurVeterans, people_who_match:interests:Politics: US politics (conservative), people_who_match:interests:US politics (very conservative), people_who_match:interests:Likely to engage with political content (conservative) |
15738 |
150 |
https://www.instagram.com/instotus/ |
Join our AmericaAgainstHillary flashmob! Make a sign with your state - make
Clinton see that we DON'T WANT her! Follow instotus for participation. This is
a community for everyone whose heart is with America. Don't be a stranger,
be a patriot! Follow us! Instagram Of The United Instotus
|
54.164320000000004 |
3385.27 |
RUB |
2016-07-20T06:44:47-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/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