home / russian-ads

display_ads (view)

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

9 rows where an ad_target was people_who_match:interests:Disabled American 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  
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  
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  

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