home / russian-ads

display_ads (view)

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

9 rows where an ad_target was people_who_match:interests:Donald Trump

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
470 location:united_states:Philadelphia, Pittsburgh Pennsylvania, age:16 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Donald Trump, people_who_match:interests:Manufacturing, people_who_match:interests:Donald Trump for President or conservative daily, people_who_match:interests:Job title: Coal Miner 7282 457 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 113.92960000000001 7120.60 RUB 2016-09-23T02:42:16-07:00 2016-10-01T13:00:00-07: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
1270 location:united_states:New York (+50 mi) New York, excluded_connections:Exclude people who are going to American Flag March in Memory of 9/11, 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:Donald Trump 0 0     0.0 0.00 USD 2016-08-30T02:32:29-07:00  
1868 location:United States, age:13 - 65+, language:English (UK), language:English (US), placements:Instagram Feed, people_who_match:interests:Donald Trump, people_who_match:interests:Multicultural Affinity: African American (US) 21555 67 https://www.instagram.com/blackmattersus/ Hey, everyonel’? You know, a great number of black people support us saying that #HillaryClintonlsNotMyPresident! So this time we would like to make a #flashmob against #HillaryClinton because she is the real enemy of black community and our followers prove it showing their disgrace to her personality and policy. That's why we ask you to do the same and send your photos to us. Why? Because we want to live in a better future and Hillary is not the person who will help us in getting justice and peace by all means! Dear followers, if you agree, just don't be ignorant to your future in America, join our flashmob and take a photo with #HillaryClintonForPrison2016 or #nohillary2016 and tag @blackmattersusl? Looking forward to your photos?? BlackMattersUS AmericanCops 31.258080000000003 1953.63 RUB 2016-04-06T04:26:42-07:00  
1908 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:donaldj trump, people_who_match:interests:Donald Trump for President, people_who_match:interests:Ivanka Trump Fine Jewelry, people_who_match:interests:Donald Trump Jr. 279 1 https://www.instagram.com/tea_party_news/ Do you support Trump? Wanna #MakeAmericaGreatAgain? Wanna see your kid on our account? Take pictures, make videos, send them to us via DM or tag #KIDS4TRUMP and we'll make a patriotic team of young Trump supporters here! I'm sure it'll be great! It would be nice if you tell us why your kid supports Donald Trump and what are his or her thoughts about #Elections2016. Let's have some fun! Don't stay aside! Tea Party News ( @tea Teapartypat 0.02112 1.32 RUB 2016-04-19T08:12:20-07:00  
1909 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:donaldj trump, people_who_match:interests:Donald Trump for President, people_who_match:interests:Ivanka Trump Fine Jewelry, people_who_match:interests:Donald Trump Jr. 165121 78 https://www.instagram.com/tea_party_news/ Do you support Trump? Wanna #MakeAmericaGreatAgain? Wanna see your kid on our account? Take pictures, make videos, send them to us via DM or tag #KIDS4TRUMP and we'll make a patriotic team of young Trump supporters here! I'm sure it'll be great! It would be nice if you tell us why your kid supports Donald Trump and what are his or her thoughts about #Election52016. Let's have some fun! Don't stay aside! Tea Party News ( @tea Teapartypat 159.52928 9970.58 RUB 2016-04-21T00:28:18-07:00  
1910 location:united_states:Alabama, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:South Carolina, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservative News Today, people_who_match:interests:Young Republicans, people_who_match:interests:The Conservative, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America, people_who_match:interests:Donald Trump for President, people_who_match:interests:College Republicans 0 0 https://www.instagram.Com/tea_party_news/ Florida goes Trump! Here are Florida Cities participating: Daytona Beach, Tampa, Fort Myers, Miami, Orlando, Pensacola, Ft Lauderdale, Sarasota, Clearwater, Oxford, West Palm Beach, Coral Springs. For more details write us in comments or via DM. Go Tea Party! Pro- American, Pro—Guns, Pro—Patriotic! Tea Party News Muslimlnst 0.0 0.00 USD 2016-08-16T05:47:11-07:00  
1911 location:united_states:Alabama, location:united_states:Florida, location:united_states:Georgia, location:united_states:Mississippi, location:united_states:South Carolina, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservative News Today, people_who_match:interests:Young Republicans, people_who_match:interests:The Conservative, people_who_match:interests:The Tea Party, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America, people_who_match:interests:Donald Trump for President, people_who_match:interests:College Republicans 9244 85 https://www.instagram.Com/tea_party_news/ Florida goes Trump! Here are Florida Cities participating: Daytona Beach, Tampa, Fort Myers, Miami, Orlando, Pensacola, Ft Lauderdale, Sarasota, Clearwater, Oxford, West Palm Beach, Coral Springs. For more details write us in comments or via DM. Go Tea Party! Pro- American, Pro—Guns, Pro—Patriotic! Tea Party News Teapartypat 50.85056 3178.16 RUB 2016-08-16T05:49:47-07:00  
3178 no image location_living_in:United States, age:18 - 50, placements:News Feed on desktop computers, placements:Right column on desktop computers, people_who_match:interests:Donald Trump, people_who_match:interests:Donald Trump for President, and_must_also_match:interests:Online games, and_must_also_match:interests:Flash Games 1042 32 http://hi||tendo.com/ Check this out! While Americans are deciding who to vote for at the 2016 presidential election, the official Democratic nominee, Hillary Clinton, is having fun. Travel with Hillary as far as you can, picking up emails and money, avoiding FBI agents, journalists and missiles along the way. Hilltendo Hilltendo 21.58464 1349.04 RUB 2016-10-14T05:00:04-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/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
Powered by Datasette · Query took 1331.133ms · Data source: simonw/russian-ira-facebook-ads-datasette