home / russian-ads

display_ads (view)

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

14 rows where an ad_target was people_who_match:interests:Supporting Our Veterans

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
16 location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Wounded Warrior Project, people_who_match:interests:Support our troops, people_who_match:interests:Veterans, people_who_match:interests:AMVETS, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Chris Kyle, people_who_match:interests:Supporting Our Veterans, and_must_also_match:interests:Paralyzed Veterans of America, and_must_also_match:interests:Veterans Day, and_must_also_match:interests:Wounded Warrior Project, and_must_also_match:interests:Support our troops, and_must_also_match:interests:Veterans, and_must_also_match:interests:AMVETS, and_must_also_match:interests:United States Army Reserve, and_must_also_match:interests:Patriotism, and_must_also_match:interests:Disabled American Veterans, and_must_also_match:interests:The Veterans Site, and_must_also_match:interests:Chris Kyle, and_must_also_match:interests:Supporting Our Veterans 21093 53 https://www.instagram.Com/veterahs_us/ A Wounded Warrior and his service dog. Support our Veterans - Follow! The US Gov Spending Stats Instalol 34.10304 2131.44 RUB 2016-05-12T02:37:39-07:00  
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  
1837 location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Iraq and Afghanistan Veterans of America, people_who_match:interests:Vietnam Veterans of America Foundation, people_who_match:interests:Veterans For America, people_who_match:interests:Support our troops, people_who_match:interests:US Military Veterans, people_who_match:interests:Vietnam Veterans of America, people_who_match:interests:Support Our Veterans, people_who_match:interests:Concerned Veterans for America, people_who_match:interests:Supporting Our Veterans 3600 109 https://www.instagram.Com/veterans_us/ Honoring the high cost paid by so many families to protect our freedom. Buy a T-shirt - help a veteran: Veterans USA Funnylnst 10.82144 676.34 RUB 2016-08-16T05:22:11-07:00  
1838 location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Iraq and Afghanistan Veterans of America, people_who_match:interests:Vietnam Veterans of America Foundation, people_who_match:interests:Veterans For America, people_who_match:interests:Support our troops, people_who_match:interests:US Military Veterans, people_who_match:interests:Vietnam Veterans of America, people_who_match:interests:Support Our Veterans, people_who_match:interests:Concerned Veterans for America, people_who_match:interests:Supporting Our Veterans 0 0 https://www.instagram.Com/veterans_us/ Killary Clinton will never understand what it feels like to lose the person you love for the sake of your country. Buy a T-shirt - help a veteran: Veterans USA Funnylnst 0.0 0.00 USD 2016-08-17T00:12:50-07:00  
1839 location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Iraq and Afghanistan Veterans of America, people_who_match:interests:Vietnam Veterans of America Foundation, people_who_match:interests:Veterans For America, people_who_match:interests:Support our troops, people_who_match:interests:US Military Veterans, people_who_match:interests:Vietnam Veterans of America, people_who_match:interests:Support Our Veterans, people_who_match:interests:Concerned Veterans for America, people_who_match:interests:Supporting Our Veterans 0 0 https://www.instagram.Com/veterahs_us/ Killary Clinton will never understand what it feels like to lose the person you love for the sake of your country. Honoring the high cost paid by so many families to protect our freedom. Buy a T-shirt - help a veteran: Veterans USA Funnylnst 0.0 0.00 USD 2016-08-17T00:13:21-07:00  
1840 location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Iraq and Afghanistan Veterans of America, people_who_match:interests:Vietnam Veterans of America Foundation, people_who_match:interests:Veterans For America, people_who_match:interests:Support our troops, people_who_match:interests:US Military Veterans, people_who_match:interests:Vietnam Veterans of America, people_who_match:interests:Support Our Veterans, people_who_match:interests:Concerned Veterans for America, people_who_match:interests:Supporting Our Veterans 17654 517 https://www.instagram.Com/veterahs_us/ Killary Clinton will never understand what it feels like to lose the person you love for the sake of your country. Honoring the high cost paid by so many families to protect our freedom. Buy a T-shirt - help a veteran: Veterans USA Funnylnst 49.343199999999996 3083.95 RUB 2016-08-17T00:14:05-07:00  
2782 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans, and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 4878 274 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 30.12912 1883.07 RUB 2017-02-22T06:43:39-08:00  
2785 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 39, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.0 0.00 USD 2017-02-21T05:16:27-08:00  
2786 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, 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:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans, and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 3186 296 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 17.279040000000002 1079.94 RUB 2017-02-21T05:17:24-08:00  
2787 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans, and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 5394 317 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 30.38864 1899.29 RUB 2017-02-22T02:24:13-08:00  
2792 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 39, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.0 0.00 USD 2017-02-21T05:16:27-08:00  
2793 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, 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:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans, and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 47 3 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.89776 56.11 RUB 2017-02-21T05:17:24-08:00  
2794 location_living_in:United States, excluded_connections:Exclude people who like Veterans Come First, age:18 - 54, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Veterans, people_who_match:interests:United States Department of Veterans Affairs, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Supporting Our Veterans, and_must_also_match:employers:US. Army Reserve, and_must_also_match:employers:Job title: Veteran, and_must_also_match:employers:, industry:Military (Global), industry:Veterans (US) 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.0 0.00 USD 2017-02-22T02:24:13-08:00  
3255 location_living_in:United States, excluded_connections:Exclude people who like Stop A.|., age:40 - 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:Deportation, people_who_match:interests:Stop Illegal Immigration, people_who_match:interests:Immigration law, people_who_match:interests:Supporting Our Veterans, and_must_also_match:interests:Illegal immigration 2555 216 https://www.facebook.com/StopAlllnvaders/ American Citizens should always come first! Let's fight illegal immigration together! Stop A.|. 15.67888 979.93 RUB 2017-05-16T01:44:24-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 1825.132ms · Data source: simonw/russian-ira-facebook-ads-datasette