home / russian-ads

display_ads (view)

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

12 rows where an ad_target was interests:Republican Party (United States)

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
15 location:United States, interests:Tax, interests:Republican Party (United States), age:20 - 65+, language:English (US), placements:Instagram Feed 1614 12 https://instagram.Com/gov_spending/ And what would you Choose if u were a president: to create 11200 military- related jobs or to create 26700 jobs in education? Join us! Learn more! The US Gov Spending Stats Instalol 9.54608 596.63 RUB 2015-11-17T07:07:36-08: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
1293 location:United States, interests:Conservatism, interests:The Tea Party, interests:Republican Party (United States), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4990 1403 https://www.facebook.com/Stop-AI-896610653786585/ The law is the law. If I commit a crime, I will get ticketed or arrested. Why do illegal aliens break the law, but our government harbors them? Illegals have more benefits than those who shed their blood for America and our freedom. It makes me sick... 8.0 500.00 RUB 2016-08-10T02:26:20-07:00 2016-08-11T02:26:18-07:00
1298 location:United States, interests:Conservatism, interests:The Tea Party, interests:Republican Party (United States), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3749 91 https://www.facebook.com/EricDraitser1lposts/950925828350122   32.0 2000.00 RUB 2016-07-06T06:56:45-07:00 2016-07-08T06:56:44-07:00
1314 location:United States, interests:Conservatism, interests:The Tea Party, interests:Republican Party (United States), age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Stop-AI-896610653786585/ About $190 billion dollars are spent each year on illegal aliens for welfare & social services by the American taxpayers. Are leftists still sure that illegal immigration improves our economy? 0.0 0.00 USD 2016-07-06T06:56:35-07:00 2016-05-07T03:28:15-07:00
1328 location:United States, interests:Conservatism, interests:The Tea Party, interests:Republican Party (United States), age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 9819 2668 https://www.facebook.com/Stop-AI-896610653786585/ It's wrong if you support Hillary Clinton, who said that problems within the Veterans Affairs Department have “not been as widespread." Hundreds of thousands of veterans may have died awaiting VA care. WE CANNOT TRUST HILLARY TO TAKE CARE OF OUR VETERANS! 16.0 1000.00 RUB 2016-08-10T02:25:38-07:00 2016-08-11T02:25:37-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

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 1430.595ms · Data source: simonw/russian-ira-facebook-ads-datasette