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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 467 | |
location_living_in:united_states:New York (+50 mi) New York, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 2 | 0 | https://www.facebook.com/events/312522819127036/ | America has always been hinged on hard-working people. If you remove jobs, you’ll remove our country from the world map. The state of Pennsylvania rose owing to multiple enterprises mining coal, producing steel, and creating the need for otherjobs, groceries, doctors, dentists, insurance, gas, vehicles, mechanics and the list goes on. As far as Mr. Trump pursues the goal of creating more jobs and supports the working Class. He said he would put miners back to work. We could help Mr. Trump win Pennsylvania which is a battleground state. We’d like to organize a rally “Miners for Trump” in Pennsylvania. Have something against coal industries? Please note then that burning coal is not more harmful than lumber. Alternative energy is only possible when subsidized by government for it is not lucrative. You cannot leave tens of thousands of people without a job just because of lobbyists’ interests. The current list of locations is being elaborated. Suggested Cities are Erie, Pittsburg, Scranton, Harrisburg, Allentown, and Philly. Confirmed locations: Marconi Plaza, Philadelphia. Miners for Trump: Unity clay in Pennsylvania | 0.04736 | 2.96 | RUB | 2016-09-22T05:01:05-07:00 | 2016-10-01T13:00:00-07:00 |
| 472 | |
location_living_in:united_states:New York (+50 mi) New York, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 0 | 0 | https://www.facebook.com/events/365162297165103/ | Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC | 0.0 | 0.00 | USD | 2016-11-10T04:41:38-08:00 | 2016-11-11T21:00:00-08:00 |
| 473 | |
location_living_in:united_states:New York (+50 mi) New York, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 0 | 0 | https://www.facebook.com/events/365162297165103/ | Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC | 0.0 | 0.00 | USD | 2016-11-10T04:44:36-08:00 | 2016-11-11T21:00:00-08:00 |
| 474 | |
location_living_in:united_states:New York (+50 mi) New York, connections:People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 1 | 0 | https://www.facebook.com/events/365162297165103/ | Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC | 0.0096 | 0.60 | RUB | 2016-11-10T04:50:28-08:00 | 2016-11-11T21:00:00-08:00 |
| 475 | |
location_living_in:united_states:New York (+50 mi) New York, excluded_connections:Exclude people who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Young Republicans, people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America or Donald Trump for President, people_who_match:interests:Employers: NYPD, people_who_match:interests:US., army_reserve_industry:Military (Global) or Veterans (US), army_reserve_industry:Politics: US politics (conservative), army_reserve_industry:US politics (very conservative) | 4171 | 551 | https://www.facebook.com/events/365162297165103/ | Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC | 31.9904 | 1999.40 | RUB | 2016-11-10T05:00:07-08:00 | 2016-11-11T21:00:00-08:00 |
| 2326 | |
location_living_in:united_states:New York (+50 mi) New York, connections:People who like BM, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 0 | 0 | https://www.facebook.com/events/662307087278604/ | New-York City. Staten Island. October 22. National Day of Protest to stop Police Brutality. The day when everyone must stand up for their rights in the City where "We can't breath" movement was created after Eric Garner's death. Mr. Garner and his family paid a horrible price to make us all realize that we're in danger. Eric will never be forgotten. The crimes of police officers will never be forgotten as well. Police brutality in this country is unacceptable and must be stopped! Join us, show your support and solidarity. On October 22 we will meet at the place where Mr. Garner was killed. 202 Bay Street, Staten Island, New York, 2 pm. National Day of Protest. Staten Island, NY | 0.0 | 0.00 | USD | 2016-09-22T04:23:58-07:00 | |
| 2359 | |
location_living_in:united_states:New York (+50 mi) New York, interests:President of the United States, interests:United States presidential election, interests:Hillary Clinton or United States presidential election, interests:2016, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 9164 | 665 | https://www.facebook.com/events/1831459517122535/ | The Choosing of the President must be left to the popular vote. Trump won the Electoral College but is behind by nearly 840,000 votes nationally! This is just wrong! The Electoral College is an outdated, undemocratic system that does not reflect our modern society, and it needs to be Changed immediately. Every American should be guaranteed that their vote counts. California Sen. Boxer has recently filed a Iong-shot bill to abolish the Electoral College which undoubtedly does NOT represent the true voice of US. New York Against KKK | 60.84032 | 3802.52 | RUB | 2016-11-16T03:28:06-08:00 | 2016-12-03T03:28:06-08:00 |
| 2381 | |
location_living_in:united_states:New York (+50 mi) New York, interests:President of the United States, interests:United States presidential election, interests:Hillary Clinton or United States presidential election, interests:2016, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 842 | 87 | https://represent.com/store/notmypresident | You'll never believe what anti-Trump activists did. Click on Trump's face to Check out. STOP TRUMP! STOP RACISM! #NotMyPresident BM | 3.2 | 200.00 | RUB | 2016-11-22T23:39:02-08:00 | 2016-11-24T23:39:02-08:00 |
| 2450 | |
location_living_in:united_states:New York (+50 mi) New York, connections:People who like United Muslims of America, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices | 6605 | 134 | https://www.facebook.com/events/239129926564203/ | If you also think that there should only be peace, come with us and let's make it happen. Stop war! Stop killing the innocent! Some believed Trump would withdraw the US. from useless and bloody military campaigns. But what we see is only the enhancement of hostility. We don't need wars no more! We want peace! It's time for politicians to take care of the US. residents instead of fating them, as well as other nationals, to death. We're organizing a peaceful gathering to draw public attention to the above- mentioned terrible problem. Our President and Congress must listen to those who granted them power - us, the people. If you also think that there should only be peace, come with us and let's make it happen. Stop war! Stop killing the innocent! Make peace, not war! Make peace, not war! | 46.50464 | 2906.54 | RUB | 2017-05-12T11:32:28-07:00 | 2017-05-22T11:32:28-07:00 |
| 2451 | |
location_living_in:united_states:New York (+50 mi) New York, excluded_connections:Exclude people who like United Muslims of America, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:politics:Likely to engage with political content (liberal) | 6721 | 243 | https://www.facebook.com/events/239129926564203/ | If you also think that there should only be peace, come with us and let's make it happen. Stop war! Stop killing the innocent! Some believed Trump would withdraw the US. from useless and bloody military campaigns. But what we see is only the enhancement of hostility. We don't need wars no more! We want peace! It's time for politicians to take care of the US. residents instead of fating them, as well as other nationals, to death. We're organizing a peaceful gathering to draw public attention to the above- mentioned terrible problem. Our President and Congress must listen to those who granted them power - us, the people. If you also think that there should only be peace, come with us and let's make it happen. Stop war! Stop killing the innocent! Make peace, not war! Make peace, not war! | 73.49536 | 4593.46 | RUB | 2017-05-17T05:49:58-07:00 | 2017-05-22T11:32:28-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