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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 565 | |
location:united_states:Kansas, age:14 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:Lesbian community, people_who_match:interests:LGBT community, people_who_match:interests:Hillary Clinton, people_who_match:interests:Same—sex marriage | 4798 | 240 | https://www.facebook.com/events/533144703560571/ | Westboro baptist church is planning to stand against tolerance in education system near LG God H85 Bigots Rally | 50.186879999999995 | 3136.68 | RUB | 2016-05-12T08:05:06-07:00 | 2016-05-22T07:19:00-07:00 |
| 566 | |
location:united_states:Kansas, age:14 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Rainbow flag (LGBT movement), people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:Gay Rights, people_who_match:interests:Lesbian community, people_who_match:interests:LGBT community, people_who_match:interests:LGBT Equality, people_who_match:interests:Same-sex marriage in the United States, people_who_match:interests:Same-sex marriage, people_who_match:interests:LGBT social movements | 7159 | 318 | https://www.facebook.com/events/533144703560571/ | Westboro baptist church is planning to stand against tolerance in education system near LG Westboro Baptist Church counter protest | 53.1184 | 3319.90 | RUB | 2016-05-16T07:50:43-07:00 | 2016-05-22T07:19:00-07:00 |
| 567 | |
location:united_states:Kansas, age:14 — 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:LGBT community | 9372 | 373 | https://www.facebook.com/events/533144703560571/ | Westboro baptist church is planning to stand against tolerance in education system near LG Westboro Baptist Church counter protest | 81.11536 | 5069.71 | RUB | 2016-05-18T00:13:06-07:00 | 2016-05-22T07:19:00-07:00 |
| 575 | |
location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Gay pride, people_who_match:interests:LGBT culture, people_who_match:interests:LGBT community, people_who_match:interests:LGBT social movements | 65649 | 11131 | https://www.facebook.com/LGBT-United-839497472793277/ | HELP RODNEY SUMTER RECOVER Rodney Sumter Jr., 27 miraculously survived Pulse nightclub Orlando shooting, being shot three times. But he’s still in a lot of pain. Rodney is still recovering at Orlando Regional Medical Center. Lenita Sumter, his mother, said he is in intense pain and that it has been difficult for him to get comfortable and is needing sedation and heavy pain medications. Rodney was shot in the arms and back. He had surgery Monday to repair his arms, but shrapnel was left in his back. He had another surgery Wednesday night, family said. Doctors said Rodney is running a fever and suspect he may have an infection. Please help Rodney Sumter to recover! https://www.gofundme.com/294czwct Don't forget to send forward your payment invoice???? | 64.5856 | 4036.60 | RUB | 2016-06-17T11:07:24-07:00 | |
| 591 | |
location:United States, friends_of_connections:Friends of people who are connected to LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Gay pride, people_who_match:interests:LGBT community, people_who_match:interests:Homosexuality, people_who_match:interests:LGBT culture, people_who_match:interests:Same-sex marriage | 93925 | 5441 | https://www.facebook.com/Igbtun/ | We speak for all fellow members of LGBT community across the nation. | 507.40992 | 31713.12 | RUB | 2016-03-23T05:36:11-07:00 | |
| 592 | |
location:United States, friends_of_connections:Friends of people who are connected to LGBT United, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Gay pride, people_who_match:interests:Homosexuality, people_who_match:interests:LGBT culture, people_who_match:interests:LGBT community, people_who_match:interests:Same-sex marriage | 190076 | 7289 | https://www.facebook.com/Igbtun/ | We speak for all fellow members of LGBT community across the nation. | 576.0 | 36000.00 | RUB | 2016-08-04T04:20:05-07:00 | |
| 618 | |
location:united_states:Kansas, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:LGBT community, people_who_match:interests:Hillary Clinton, people_who_match:interests:Same-sex marriage | 0 | 0 | https://www.facebook.com/LGBT-United-839497472793277/ | Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those idiots. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! | 0.0 | 0.00 | USD | 2016-05-12T08:05:04-07:00 | 2016-05-12T08:27:26-07:00 |
| 619 | |
location:united_states:Kansas, age:14 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Rainbow flag (LGBT movement), people_who_match:interests:LGBT rights by country or territory, people_who_match:interests:LGBT community, people_who_match:interests:Same-sex marriage in the United States, people_who_match:interests:Same-sex marriage, people_who_match:interests:LGBT social movements | 0 | 0 | https://www.facebook.com/LGBT-United-839497472793277/ | Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those idiots. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! | 0.0 | 0.00 | USD | 2016-05-16T07:50:40-07:00 | 2016-05-12T08:27:26-07:00 |
| 620 | |
location:united_states:Kansas, age:14 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:LGBT community | 0 | 0 | https://www.facebook.com/LGBT-United-839497472793277/ | Well, as you know, schools are places of learning and also miniature societies. The school Climate has a direct impact on both how well students learn and how well they interact with other people. More and more teachers today understand the importance of socialization and try to make their Classes more friendly where each student feels involved. But despite these efforts, students who are LGBT continue to face a harsh reality.... May 24,25 Westboro baptist Church is planning to stand against tolerance in education system near LGBT-friendly Lawrence High School. They want to "remind this nation that the parents, students, teachers and staff of the high schools celebrate disobedience to God's law." They are just inciting hate riots and violence! Their right to protest infringes on others rights! Personally I have had enough of those idiots. Someone should picket them (in return)!! Any volunteers willing to help me drown out their voices of hatred? Please, DM us for more information and we can stop their nonsense - to put them on the right way! | 0.0 | 0.00 | USD | 2016-05-18T00:12:58-07:00 | 2016-05-12T08:27:26-07:00 |
| 629 | |
location:United States, age:13 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:LGBT history, people_who_match:interests:LGBT culture, people_who_match:interests:LGBT community, people_who_match:interests:LGBT social movements | 870 | 64 | https://www.facebook.com/LGBT—United—839497472793277/ | HUMAN RIGHTS PHOTO CHALLENGE Despite our race, religion, gender, age, education, sexual orientation and beliefs, we are all HUMANS. In the midst of the presidential race, all what politicians dream about is money. They keep giving empty promises in order to win votes. And this is our friendly reminder for the candidates: we are the ones who elect them. We don’t deserve having problems with employment, marriage, Child birth etc... We all deserve the right to be accepted. Go for it! Clicking the “like” button is not enough. If you want to attract the candidates' attention to the fight for human rights, do the following: 1) Take a picture with Campaign (HUMAN RIGHTS) logo (state required) 2) Post it in comments within a week 3) Share with your friends For the first place $50; second place $30; third place $20 | 2.7054400000000003 | 169.09 | RUB | 2016-03-22T07:17:38-07:00 | |
| 632 | |
location:united_states:Glendale (+10 mi) Arizona, age:13 - 50, language:English (UK), language:English (US), placements:News Feed on mobile devices, people_who_match:interests:Bisexuality, people_who_match:interests:Lesbian community, people_who_match:interests:LGBT culture, people_who_match:interests:LGBT community, people_who_match:interests:Transgenderism, people_who_match:interests:Human Sexuality | 0 | 0 | https://www.facebook.com/Igbtun/ | 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—suioide. 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,GIendaIe, 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 | 2016-02-18T05:42:24-08:00 | 2016-02-18T12:41:00-08:00 |
| 2427 | |
location_living_in:United States, excluded_connections:Exclude people who like Born Liberal, age:45 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Social democracy, people_who_match:interests:Liberal Democrats, people_who_match:interests:Liberalism, people_who_match:interests:LGBT community, people_who_match:interests:Anti-racism, people_who_match:interests:Anti-discrimination, and_must_also_match:politics:Likely to engage with political content (liberal) | 3412 | 289 | https://www.facebook.com/Born-LiberaI-522628564598423/ | New ideas, old values. Join! | 67.39568 | 4212.23 | RUB | 2017-02-22T07:30:32-08:00 | |
| 2431 | |
location_living_in:United States, excluded_connections:Exclude people who like Born Liberal, age:45 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:Social democracy, people_who_match:interests:Liberal Democrats, people_who_match:interests:Liberalism, people_who_match:interests:LGBT community, people_who_match:interests:Anti-racism, people_who_match:interests:Anti-discrimination | 33349 | 2710 | https://www.facebook.com/bornliberall | New ideas, old values. Like us! | 143.9464 | 8996.65 | RUB | 2016-10-11T07:11:08-07:00 | |
| 2432 | |
location_living_in:United States, excluded_connections:Exclude people who like Born Liberal, age:45 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Bernie Sanders, people_who_match:interests:Social democracy, people_who_match:interests:Liberal Democrats, people_who_match:interests:Liberalism, people_who_match:interests:LGBT community, people_who_match:interests:Anti-racism, people_who_match:interests:Anti-discrimination | 0 | 0 | https://www.facebook.com/Born-LiberaI-522628564598423/ | New ideas, old values. Join! | 0.0 | 0.00 | USD | 2017-02-22T05:40:21-08:00 | |
| 2433 | |
location_living_in:United States, excluded_connections:Exclude people who like Born Liberal, age:45 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Social democracy, people_who_match:interests:Liberal Democrats, people_who_match:interests:Liberalism, people_who_match:interests:LGBT community, people_who_match:interests:Anti-racism, people_who_match:interests:Anti-discrimination | 2440 | 206 | https://www.facebook.com/Born-LiberaI-522628564598423/ | New ideas, old values. Join! | 44.60432 | 2787.77 | RUB | 2017-02-22T05:41:42-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