home / russian-ads

display_ads (view)

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

3 rows where an ad_target was people_who_match:interests:Military

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
35 location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Politics 0 0 https://www.instagram.Com/veterahs_us/ There are some people who will always support you! And unfortunately, the VA is not on the list. There are numerous examples of disgusting treatment of our Veterans by the VA employees. And there is little Chance the situation will Change in the near future. The failure of the Defense Department and VA to create a joint electronic health record, despite spending $1 billion for development is just another example of it. Click Learn More! Veterans USA ( @veterans GovSpending 0.0 0.00 USD 2016-01-14T06:25:20-08:00  
36 location:United States, age:13 — 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Politics 143644 496 https://www.instagram.com/veterans_usl He's lucky to return home to reunite with his family for the holidays. But he's just one of a few servicemen to do this. For many of our brave troops stationed abroad and far from their loved ones. Our brave servicemen and servicewomen will continue to make sacrifices for our great country while the VA employees will be having their dinner and laughing at the VA backlog. Click to Learn More! Veterans USA ( @veterans GovSpending 133.42592000000002 8339.12 RUB 2016-01-14T07:18:30-08:00  
3392 location: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:Military, people_who_match:interests:Veterans, people_who_match:interests:Family 147 5 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! Veterans Come First 2.36 2.36 USD 2017-03-10T01:29:58-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 1423.972ms · Data source: simonw/russian-ira-facebook-ads-datasette