home / russian-ads

display_ads (view)

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

6 rows where an ad_target was people_who_match:interests:Support Our Veterans

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1784 location_living_in:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Paralyzed Veterans of America, 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:Vietnam Veterans of America, people_who_match:interests:Vietnam Veterans Against the War, people_who_match:interests:Vietnam Vets, people_who_match:interests:Support Our Veterans, people_who_match:interests:Vietnam Veterans Memorial Fund, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Veterans, united_network_employers:US. Military 509 5 https://www.instagram.com/veterans_us/ Think of all little boys and girls who can lose or have already lost their fathers... God bless our troops! We are forever grateful! Home of the Brave. Support our Veterans! Please, repost it you like and don't forget to tag me! Follow the link. Veterans USA Funnylnst 2.2564800000000003 141.03 RUB 2016-08-12T02:10:06-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  
1934 location_living_in:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Young Republicans, people_who_match:interests:Support Our Veterans, people_who_match:interests:Donald Trump for President, people_who_match:interests:Fox News Politics, people_who_match:interests:conservative daily, people_who_match:interests:Donald Trump Jr. or Supporting OurVeterans, people_who_match:interests:Politics: US politics (conservative), people_who_match:interests:US politics (very conservative), people_who_match:interests:Likely to engage with political content (conservative) 15738 150 https://www.instagram.com/instotus/ Join our AmericaAgainstHillary flashmob! Make a sign with your state - make Clinton see that we DON'T WANT her! Follow instotus for participation. This is a community for everyone whose heart is with America. Don't be a stranger, be a patriot! Follow us! Instagram Of The United Instotus 54.164320000000004 3385.27 RUB 2016-07-20T06:44: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 1525.599ms · Data source: simonw/russian-ira-facebook-ads-datasette