home / russian-ads

display_ads (view)

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

1 row where an ad_target was interests:Patient Protection and Affordable Care Act

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
29 location:United States, interests:Patient Protection and Affordable Care Act, interests:Supporting Our Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed 3527 33 https://instagram.Com/veterans_us/ What do you know about PTSD? Do you know that US Military deaths since 1999 count 6,904, while veterans suicides since 1999 account for 128,480? We'are losing 18 times more warriors in Civilian life than on the battlefields! Learn more! Follow us! Veterans USA ( @veterans GovSpending 24.09936 1506.21 RUB 2015-11-12T04:38:35-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 1355.181ms · Data source: simonw/russian-ira-facebook-ads-datasette