home / russian-ads

display_ads (view)

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

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

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
34 location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservatism, people_who_match:interests:Veterans Day, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Veterans, people_who_match:interests:Republican Party (United States), people_who_match:interests:Supporting Our Veterans 0 0 https://www.instagram.Com/veterans_us/ A Wounded Warrior and his service dog. Support our Veterans - Follow! Black America ( @black Instalol 0.0 0.00 USD 2016-05-12T02:31:30-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
1273 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 718 11 https://www.facebook.com/Stop-AI-896610653786585/ Like if you are against illegal immigration! News and analysis! 0.9795200000000001 61.22 RUB 2016-01-14T05:01:22-08:00  
1277 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 1599 106 https://www.facebook.com/Stop-AI-896610653786585/ Not all refugees are good. 17.079520000000002 1067.47 RUB 2016-01-14T05:04:49-08:00  
1296 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 2109 34 https://www.facebook.com/Stop-AI-896610653786585/ You are not the only one to despise immigration. Join our community! 0.7152000000000001 44.70 RUB 2016-01-14T05:04:06-08:00  
1307 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 2995 163 https://www.facebook.com/Stop-AI-896610653786585/ News is telling you enough about good refugees. We take on bad ones. 25.479200000000002 1592.45 RUB 2016-01-14T05:05:22-08:00  
1308 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 1610 25 https://www.facebook.com/Stop-AI-896610653786585/ Like if you are against illegal immigration! 4.2623999999999995 266.40 RUB 2016-01-14T05:01:43-08:00  
1315 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 1968 23 https://www.facebook.com/Stop-AI-896610653786585/ Your voice counts! Stop illegal immigration! 1.39392 87.12 RUB 2016-01-14T05:00:25-08:00  
1318 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Syria, people_who_match:interests:Republican Party (United States), people_who_match:interests:Politics 666 6 https://www.facebook.com/Stop-AI-896610653786585/ This page is dedicated to protection against illegal immigrants 0.25792000000000004 16.12 RUB 2016-01-14T04:59:29-08: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  

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