home / russian-ads

display_ads (view)

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

22 rows where an ad_target was excluded_connections:Exclude people who like Secured Borders

This data as JSON, CSV (advanced)

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
678 location:United States, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:African American (US), exclude:behaviors:Asian American (US) 141 14 https://www.facebook.com/Secured-Borders-757183957716200/ Lies about illegal immigration and refugee crisis REVEALED. 4.18816 261.76 RUB 2016-02-12T01:58:19-08:00  
679 location:United States, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association 0 0 https://www.facebook.com/Secured.Borders/ America is at risk. To protect our country we need to secure the border. 0.0 0.00 USD 2016-10-17T07:07:28-07:00  
680 location:United States, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Stop Illegal Immigration 9264 1237 https://www.facebook.com/Secured.Borders/ America is at risk. To protect our country we need to secure the border. 63.54288 3971.43 RUB 2016-10-17T07:08:58-07:00  
681 location:United States, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:African American (US), exclude:behaviors:Asian American (US) 339 26 https://www.facebook.com/Secured-Borders-757183957716200/ Get a Chance to have your say on Muslim immigration without politically censorship. 6.4656 404.10 RUB 2016-02-12T02:01:03-08:00  
682 location:United States, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:African American (US), exclude:behaviors:Asian American (US) 435 30 https://www.facebook.com/Secured-Borders-757183957716200/ We are the ones to stop illegal immigrants! Your voice counts. 12.16016 760.01 RUB 2016-02-12T01:59:51-08:00  
683 location:United States, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:African American (US), exclude:behaviors:Asian American (US) 369 25 https://www.facebook.com/Secured-Borders-757183957716200/ Facts and news about refugees your government doesn’t want you to know. Subscribe! 7.724640000000001 482.79 RUB 2016-02-12T01:57:45-08:00  
684 location:United States, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 43 2 https://www.facebook.com/Secured-Borders-757183957716200/ Secured borders - only salvation of US land! 1.63632 102.27 RUB 2016-02-09T03:35:11-08:00  
685 location:united_states:New Mexico, location:united_states:Arizona (+25 mi) Texas, excluded_connections:Exclude people who like Secured Borders, age:15 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Secured borders - only salvation of US land! 0.0 0.00 USD 2016-09-20T07:06:40-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  
687 location:United States, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Secured borders - only salvation of US land! 0.0 0.00 USD 2016-10-17T06:28:17-07:00  
688 location:United States, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Stop Illegal Immigration 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Secured borders - only salvation of US land! 0.0 0.00 USD 2016-10-17T07:08:58-07:00  
689 location:United States, excluded_connections:Exclude people who like Secured Borders, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 97529 15254 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 1483.38192 92711.37 RUB 2016-02-09T03:34:26-08:00  
690 location:united_states:New Mexico, location:united_states:Arizona (+25 mi) Texas, excluded_connections:Exclude people who like Secured Borders, age:15 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 11481 873 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 241.42048000000003 15088.78 RUB 2016-09-20T07:06:40-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  
692 location:United States, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:National Rifle Association 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 0.0 0.00 USD 2016-10-17T06:28:17-07:00  
693 location:United States, excluded_connections:Exclude people who like Secured Borders, age:17 - 65+, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Stop Illegal Immigration 0 0 https://www.facebook.com/Secured-Borders-757183957716200/ Every man should stand for our borders! Join! 0.0 0.00 USD 2016-10-17T07:08:58-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
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  

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