home / russian-ads

display_ads (view)

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

17 rows where an ad_target was people_who_match:interests:Donald Trump for President

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
468 location:united_states:Pennsylvania, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Donald Trump for President, people_who_match:interests:Job title: Coal Miner 0 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.0 0.00 USD 2016-09-22T05:09:05-07:00 2016-10-01T13:00:00-07:00
469 location:united_states:Allentown, Erie, Harrisburg, Philadelphia, Pittsburgh, Scranton Pennsylvania, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Donald Trump for President, people_who_match:interests:Job title: Coal Miner 1225 77 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 14.023040000000002 876.44 RUB 2016-09-22T05:13:54-07:00 2016-10-01T13:00:00-07:00
686 location:united_states:Alabama, location:united_states:Georgia, location:united_states:New Mexico, people_who_match:interests:Same-sex marriage, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Right to keep and bear arms, people_who_match:interests:The Second Amendment, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump for President 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Secured borders - only salvation of US land! 0.0 0.00 USD 2016-10-11T09:11:47-07:00  
691 location:united_states:Alabama, location:united_states:Georgia, location:united_states:New Mexico, people_who_match:interests:Same-sex marriage, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Right to keep and bear arms, people_who_match:interests:The Second Amendment, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump for President 2502 258 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 48.40832 3025.52 RUB 2016-10-11T09:11:47-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  
1912 location_living_in:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Donald Trump for President 0 0 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 Teapartypat 0.0 0.00 USD 2016-04-19T08:08:19-07:00  
1913 location_living_in:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Tea Party movement, people_who_match:interests:The Tea Party, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Americans for Prosperity, people_who_match:interests:donaldj trump, people_who_match:interests:Donald Trump for President, people_who_match:interests:Donald Trump Jr. 0 0 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 Teapartypat 0.0 0.00 USD 2016-04-19T08:05:39-07:00  
1914 location_living_in:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Donald Trump for President 0 0 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 Teapartypat 0.0 0.00 USD 2016-04-19T08:07:22-07:00  
1917 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:The Tea Party, people_who_match:interests:Conservative Republicans of Texas, people_who_match:interests:Donald Trump for President 108433 857 https://www.facebook.com/Teapartypat—1649468318669272/ This is the way our Children have to be raised. It's not the promotion of violence. It's the promotion of confidence and the ability to defend yourself. Follow us if this video makes you proud! 276.9112 17306.95 RUB 2016-04-22T10:43:02-07:00  
1934 location_living_in:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Young Republicans, people_who_match:interests:Support Our Veterans, people_who_match:interests:Donald Trump for President, people_who_match:interests:Fox News Politics, people_who_match:interests:conservative daily, people_who_match:interests:Donald Trump Jr. or Supporting OurVeterans, people_who_match:interests:Politics: US politics (conservative), people_who_match:interests:US politics (very conservative), people_who_match:interests:Likely to engage with political content (conservative) 15738 150 https://www.instagram.com/instotus/ Join our AmericaAgainstHillary flashmob! Make a sign with your state - make Clinton see that we DON'T WANT her! Follow instotus for participation. This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! Instagram Of The United Instotus 54.164320000000004 3385.27 RUB 2016-07-20T06:44:47-07:00  
2740 location:United States, excluded_connections:Exclude people who like Angry Eagle, age:18 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Donald Trump for President, and_must_also_match:interests:breitbart, and_must_also_match:interests:conservative daily 39819 3160 https://www.facebook.com/Angry-EagIe-1936291449958430/ The community of people who share True American values. Make the US Eagle fly high again! 240.0 15000.00 RUB 2016-10-14T07:10:10-07:00  
3175 location:United States, excluded_connections:Exclude people who like Clinton FRAUDation, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Donald Trump for President 3730 553 https://www.facebook.com/Clinton-FRAUDation-885699971532130/ Everything you wanted to know about Clinton's dark side. Clinton FRAUDation 57.77536 3610.96 RUB 2016-10-25T04:56:25-07:00  
3177 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 for President, and_must_also_match:interests:Flash Games 0 0 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 0.0 0.00 USD 2016-10-14T04:58:21-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 1347.701ms · Data source: simonw/russian-ira-facebook-ads-datasette