home / russian-ads

display_ads (view)

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

2 rows where an ad_target was people_who_match:interests:Patriot Nation

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
762 location_living_in:United States, excluded_connections:Exclude people who like Being Patriotic, age:35 - 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:Fly the American Flag, people_who_match:interests:America the Beautiful, people_who_match:interests:American Patriots, people_who_match:interests:| Love the USA, people_who_match:interests:Proud to be an American, people_who_match:interests:Patriot Nation, people_who_match:interests:Flag of the United States, people_who_match:interests:American Patriot or American patriotism, people_who_match:interests:, employers:Proud to be an American, and_must_also_match:politics:Likely to engage with political content (conservative) 1828 141 https://www.facebook.com/patriototus/ "Patriotism is looking out for yourself by looking out for your country" - Calvin Coolidge. Being Patriotic 16.09856 1006.16 RUB 2017-05-16T01:35:01-07:00  
1936 location:United States, age:13 - 65+, placements:Instagram Feed, people_who_match:interests:Proud to be an American, people_who_match:interests:Patriot Nation, people_who_match:interests:ForAmerica, people_who_match:interests:Patriotism 22567 92 https://www.instagram.oom/instotus/ We are Patriots. We fight for the traditions, for the National Symbols and for the Future. If you don't like the liberal ideas and you are not the one who supports gun control, gay marriage and black lives matter activists. If America is more than just a country for you, we want you to join us! 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 58.899680000000004 3681.23 RUB 2016-05-06T07:29:40-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 1381.195ms · Data source: simonw/russian-ira-facebook-ads-datasette