home / russian-ads

display_ads (view)

Data source: simonw/russian-ira-facebook-ads-datasette

10 rows where an ad_target was location_living_in:united_states:New York (+50 mi) New York

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

Advanced export

JSON shape: default, array

CSV options:

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
Powered by Datasette · Query took 1296.002ms · Data source: simonw/russian-ira-facebook-ads-datasette