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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 588 | |
location:United States, interests:Gay pride, interests:LGBT community, interests:Homosexuality, interests:LGBT culture, interests:Same-sex marriage, excluded_connections:Exclude people who like LGBT United, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 175460 | 21449 | https://www.facebook.com/lgbtun/ | We speak for all fellow members of LGBT community across the nation. | 1500.0700800000002 | 93754.38 | RUB | 2015-07-14T00:01:38-07:00 | |
| 589 | |
location:United States, interests:Gay pride, interests:LGBT community, interests:Homosexuality, interests:LGBT culture, interests:Same-sex marriage, excluded_connections:Exclude people who like LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 0 | 0 | https://www.facebook.com/lgbtun/ | We speak for all fellow members of LGBT community across the nation. | 0.0 | 0.00 | USD | 2015-11-05T23:11:52-08:00 | |
| 590 | |
location:United States, interests:Gay pride, interests:LGBT community, interests:Homosexuality, interests:LGBT culture, interests:Same-sex marriage, excluded_connections:Exclude people who like LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices | 67221 | 6566 | https://www.facebook.com/lgbtun/ | We speak for all fellow members of LGBT community across the nation. | 751.9161600000001 | 46994.76 | RUB | 2015-11-05T23:11:58-08:00 | |
| 594 | |
location:united_states:Glendale (+10 mi) Arizona, interests:Bisexuality, interests:Lesbian community, interests:LGBT culture, interests:LGBT community, interests:Transgenderism, interests:Human Sexuality, age:13 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 4189 | 679 | https://www.facebook.oom/lgbtun/ | ls here anyone from Glendale, Arizona? WE NEED YOU! HELP US to protect the memory of the victims of hate! Last week on Friday, May Kieu and Dorothy Dutiel, both 15-year-old sophomores at Independence High School in Glendale, each died of a single gunshot wound about 8 am. just outside the school’s cafeteria. The girls were a couple. Police are calling it a murder-suicide. This heart-breaking incident is all over the news and the comments are disgusting! Homophobes use the incident as a proof that love is a sin! This is just ignorance! Two Children died and people are grieving! How would you feel if strangers came to your neighborhood or your school to push their agenda? These people are just aggravating the situation and traumatizing other KIDS! If you live in Glendale, Arizona, please, come and support us today: 6602 N 75th Ave,Glendale, AZ 85303. LET'S STAND UP AGAINST BIGOTRY! If you are not from Glendale, please, SHARE this post! Let people know we support them! P.S. please, send us photos from the event. | 13.70064 | 856.29 | RUB | 2016-02-18T06:40:45-08:00 | 2016-02-19T06:40:45-08:00 |
| 631 | |
location:united_states:Glendale (+10 mi) Arizona, interests:Bisexuality, interests:Lesbian community, interests:LGBT culture, interests:LGBT community, interests:Transgenderism, interests:Human Sexuality, age:13 - 50, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 0 | 0 | https://www.facebook.oom/lgbtun/ | ls here anyone from Glendale, Arizona? WE NEED YOU! HELP US to protect the memory of the victims of hate! Last week on Friday, May Kieu and Dorothy Dutiel, both 15-year-old sophomores at Independence High School in Glendale, each died of a single gunshot wound about 8 am. just outside the school’s cafeteria. The girls were a couple. Police are calling it a murder-suicide. This heart-breaking incident is all over the news and the comments are disgusting! Homophobes use the incident as a proof that homo love is a sin! This is just ignorance! Two Children died and people are grieving! How would you feel if strangers came to your neighborhood or your school to push their agenda? These assholes are just aggravating the situation and traumatizing other KIDS! If you live in Glendale, Arizona, please, come and support us today: 6602 N 75th Ave,Glendale, AZ 85303. LET'S STAND UP AGAINST BIGOTRY! If you are not from Glendale, please, SHARE this post! Let people know we support them! P.S. please, send us photos from the event. | 0.0 | 0.00 | USD | 2018-02-18T05:41:28-08:00 | 2016-02-18T12:41:00-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