home / russian-ads

display_ads (view)

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

18 rows where an ad_target was interests:Donald Trump

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
465 location:united_states:New York (+40 km) New York, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 1752 353 https://www.facebook.com/Being-PatriotiC-1601685693432389/ Clinton said the United States needs to confront the ‘systematic racism’ in its law enforcement efforts. We’re sick of politicians organizing and leading the systematical propaganda against our police. It is unfair and vilely to accuse our heroes of every sin and crime. In fact, the efficiency of our cops resulted in a decrease of the average amount of crimes, especially in large Cities. Law-abiding Citizens should never fear cops, but criminals do. And that’s why Hillary is on the criminals’ side. Join our rally on July, 23th in New York City, it's time to show Clinton that we will never let her become our next President! 8.0 500.00 RUB 2016-07-14T01:34:33-07:00 2016-07-15T01:34:31-07:00
466 location:united_states:New York (+40 km) New York, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 18915 1454 https://www.facebook.com/events/966495900135555/ Our country was drawing a blank for the last eight years. We need a strong leader who will March for Trump 264.54256 16533.91 RUB 2016-06-02T03:50:04-07:00 2016-06-22T03:50:01-07:00
476 location:united_states:New York (+40 km) New York, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 3001 204 https://www.facebook.com/Being-PatriotiC-1601685693432389/ We insist over and over again: Black Lives Matter is a radical hate group and its violent actions must be stopped. And we're glad to know that our police officials are on our side on that issue. 8.0 500.00 RUB 2016-07-14T01:35:03-07:00 2016-07-15T01:35:01-07:00
477 location:united_states:New York (+40 km) New York, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 15255 1312 https://www.facebook.com/events/1139813819411853/ Hillary Clinton is the co-author of Obama’s anti-police and anti-Constitutional propaganda Down With Hillary! 235.29088000000002 14705.68 RUB 2016-07-12T02:52:38-07:00 2016-07-23T02:52:36-07:00
479 location:United States, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 11505 560 https://www.facebook.com/Being-PatriotiC-1601685693432389/ Clinton was the most ardent initiator of Arabic Spring, multiple Civil wars in the Middle East and overthrowing regimes of both Gaddafi and Hussein. Neither of the Middle East countries affected by Obama and Hillary's foreign policy are prospering today. The whole region is ruined by war now, and the terrorism turned into the whole Islamic State due to Hillary's absolute incompetence in foreign policy. We can't let a person like that become our next President. #NeverHiIIary #HillaryForPrison #Hillary4Prison #HillaryForPrison2016 #Trump2016 #Trump #Trump4President 24.0 1500.00 RUB 2016-06-30T06:33:46-07:00 2016-07-01T06:33:44-07:00
525 location:united_states:Florida, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 59025 8382 https://www.facebook.com/events/620928338080560/ We announce a patriotic flash mob in Florida on August, 20! We either win Florida or lose Florida Goes Trump! 438.44752000000005 27402.97 RUB 2016-08-04T04:34:15-07:00 2016-08-20T04:34:13-07:00
526 location:united_states:New York (+40 km) New York, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices 1301 120 https://www.facebook.com/events/966495900135555/ Our country was drawing a blank for the last eight years. We need a strong leader who will March for Trump 21.85584 1365.99 RUB 2016-06-01T06:31:00-07:00 2016-06-03T06:30:57-07:00
1254 location_living_in:United States, interests:Immigration to the United States, interests:Conservatism, interests:Deportation, interests:Stop Illegal Immigration, interests:Julian Assange, interests:Laura Ingraham, interests:Ron Paul, interests:National identity, interests:Welfare state, interests:United States Department of Homeland Security, interests:Donald Trump, interests:Bill O'Reilly (political commentator), interests:Illegal immigration, interests:WikiLeaks, interests:Law enforcement, interests:Republican Party (United States), interests:Patriotism, interests:Old Glory, interests:United States Constitution, interests:Immigration law, interests:Conservatism in the United States, interests:Foreign policy, interests:Christopher Hitchens, interests:United States Bill of Rights, interests:Sean Hannity, interests:Michael Savage, interests:Mike Huckabee, interests:Racism in the United States, interests:Politics and social issues, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 184 16 https://www.facebook.com/Secured.Borders/ Secured borders are a national priority. America is at risk and we need to protect our... 3.26704 204.19 RUB 2017-07-16T15:51:18-07:00 2017-07-19T15:51:23-07:00
1255 location_living_in:United States, interests:Immigration to the United States, interests:Conservatism, interests:Deportation, interests:Stop Illegal Immigration, interests:Julian Assange, interests:Laura Ingraham, interests:Ron Paul, interests:National identity, interests:Welfare state, interests:United States Department of Homeland Security, interests:Donald Trump, interests:Bill O'Reilly (political commentator), interests:Illegal immigration, interests:WikiLeaks, interests:Law enforcement, interests:Republican Party (United States), interests:Patriotism, interests:Old Glory, interests:United States Constitution, interests:Immigration law, interests:Conservatism in the United States, interests:Foreign policy, interests:Christopher Hitchens, interests:United States Bill of Rights, interests:Sean Hannity, interests:Michael Savage, interests:Mike Huckabee, interests:Racism in the United States, interests:Politics and social issues, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 0 0 https://www.facebook.com/Secured.Borders/ Secured borders are a national priority. We need to protect America now more than ever. 0.0 0.00 USD 2017-07-16T23:37:07-07:00 2017-07-19T15:51:23-07:00
1256 location_living_in:United States, interests:Immigration to the United States, interests:Conservatism, interests:Deportation, interests:Stop Illegal Immigration, interests:Julian Assange, interests:Laura Ingraham, interests:Ron Paul, interests:National identity, interests:Welfare state, interests:United States Department of Homeland Security, interests:Donald Trump, interests:Bill O'Reilly (political commentator), interests:Illegal immigration, interests:WikiLeaks, interests:Law enforcement, interests:Republican Party (United States), interests:Patriotism, interests:Old Glory, interests:United States Constitution, interests:Immigration law, interests:Conservatism in the United States, interests:Foreign policy, interests:Christopher Hitchens, interests:United States Bill of Rights, interests:Sean Hannity, interests:Michael Savage, interests:Mike Huckabee, interests:Racism in the United States, interests:Politics and social issues, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 1706 194 https://www.facebook.com/Secured.Borders/ Secured borders should be a top priority. We need to protect America now more than ever. 26.01264 1625.79 RUB 2017-07-16T23:38:24-07:00 2017-07-19T15:51:23-07:00
1260 location_living_in:United States, interests:Immigration to the United States, interests:Conservatism, interests:Deportation, interests:Stop Illegal Immigration, interests:Julian Assange, interests:Laura Ingraham, interests:Ron Paul, interests:National identity, interests:Welfare state, interests:United States Department of Homeland Security, interests:Donald Trump, interests:Bill O'Reilly (political commentator), interests:Illegal immigration, interests:WikiLeaks, interests:Law enforcement, interests:Republican Party (United States), interests:Patriotism, interests:Old Glory, interests:United States Constitution, interests:Immigration law, interests:Conservatism in the United States, interests:Foreign policy, interests:Christopher Hitchens, interests:United States Bill of Rights, interests:Sean Hannity, interests:Michael Savage, interests:Mike Huckabee, interests:Racism in the United States, interests:Politics and social issues, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 1072 90 https://www.facebook.com/Secured.Borders/ Secured borders should be a top priority. We need to protect America now more than ever. 14.381440000000001 898.84 RUB 2017-05-28T23:26:02-07:00 2017-05-31T23:26:07-07:00
1269 location_living_in:united_states:New York (+37 mi) New York, interests:Donald Trump, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4592 276 Join For all of America. Never forget. Never forgive. 74.0 74.00 USD 2016-08-31T05:44:32-07:00 2016-09-10T23:00:54-07:00
1785 location_living_in:United States, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 34943 6276 https://petitions.whitehouse.gov/petition/disavow-support-CIinton-political- We call for disqualification and removal of Hillary Clinton from the presidential ballot as dynastic succession of the Clinton family in American politics breaches the core democratic principles laid out by our Founding Fathers. Sign the petition! We call for disqualification and removal of Hillary Clinton from the presidential ballot as dynastic succession of the Clinton family in American politics breaches the core democratic principles laid out by our Founding Fathers. We demand members of one family legislatively banned from holding the s... Disavow support for the Clinton political dynasty. Disqualify and remove Hillary Clinton from 2016 Presidential Ballot | We the People: Your Voice in Our Government Donald Trump America 233.70432000000002 14606.52 RUB 2016-08-02T09:29:28-07:00 2016-08-05T07:29:25-07:00
1955 location_living_in:United States, interests:Conservatism, interests:Confederate States of America, interests:Donald Trump, interests:Republican Party (United States), interests:Dixie, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 15370 2158 https://www.facebook.com/Secured-Borders-757183957716200/ We should not only strengthen our geographical boundaries but also our cultural. Like us! 163.036 10189.75 RUB 2016-06-07T00:14:39-07:00  
1956 location_living_in:United States, interests:Conservatism, interests:Confederate States of America, interests:Donald Trump, interests:Republican Party (United States), interests:Dixie, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 29644 3590 https://www.facebook.com/Secured-Borders-757183957716200/ We should not only strengthen our geographical boundaries but also our cultural. Like us! 303.584 18974.00 RUB 2016-06-22T04:04:00-07:00  
1957 location_living_in:united_states:Idaho, interests:Conservatism, interests:Confederate States of America, interests:Donald Trump, interests:Republican Party (United States), interests:Conservatism in the United States, interests:Dixie, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 103 25 https://www.facebook.com/events/1171162859608506/ Due to the town of Twin falls, Idaho, becoming a center of refugee resettlement, which led Citizens before refugees 54.87488 3429.68 RUB 2016-08-11T06:08:59-07:00 2016-08-22T06:08:57-07:00
3503 location_living_in:United States, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4650 681 https://petitions.whitehouse.gov/petition/disavow-support-CIinton-political- Thousands of Americans have already signed a petition to ban Clinton dynasty from owning the White House. Thousands of people demand to disavow support for Hillary Clinton and to disqualify her from participating in 2016 presidential race. Dynastic succession of the Clinton family in American politics breaches the core democratic principles laid out by our Founding Fathers. Corrupt corporations and Clinton foundation have already helped Hillary evade imprisonment for her wrongdoings. A president from the same self—perpetuating dynasty will further rupture the American political system, turning American democracy into a monarchy. Join us. Sign and share the petition using #SayNoToPoIiticalDynasties. America needs YOUR help We call for disqualification and removal of Hillary Clinton from the presidential ballot as dynastic succession of the Clinton family in American politics breaches the core democratic principles laid out by our Founding Fathers. We demand members of one family legislatively banned from holding the s... Disavow support for the Clinton political dynasty. Disqualify and remove Hillary Clinton from 2016 Presidential Ballot | We the People: Your Voice in Our Government Make America Great Again Donald J Trump for President 29.48288 1842.68 RUB 2016-08-05T02:38:49-07:00 2016-08-06T02:38:47-07:00
3504 location_living_in:United States, interests:Donald Trump, interests:Donald Trump for President, interests:Donald Trump Jr., age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1011 169 https://www.facebook.com/wethepeoplepetitions/posts/501304456731720   8.8128 550.80 RUB 2016-08-05T01:24:42-07:00 2016-08-06T01:24:41-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 1368.991ms · Data source: simonw/russian-ira-facebook-ads-datasette