home / russian-ads

display_ads (view)

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

7 rows where an ad_target was people_who_match:interests:Support our troops

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  
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  
1937 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Support our troops, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Proud to be an American, people_who_match:interests:ForAmerica, people_who_match:interests:United States Armed Forces, people_who_match:interests:Veterans, people_who_match:interests:Patriotism, people_who_match:interests:The Veterans Site 22635 41 https://www.instagram.com/instotus/ This is a community for everyone whose heart is with America. Don't be a stranger - Follow @instotus Instagram Of The United Instotus 46.559839999999994 2909.99 RUB 2016-02-25T01:06:31-08:00 2016-03-24T05:00: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 1860.055ms · Data source: simonw/russian-ira-facebook-ads-datasette