home / russian-ads

display_ads (view)

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

5 rows where an ad_target was interests:Veterans

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
14 location:United States, interests:United Nations Assistance Mission in Afghanistan, interests:Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed 1598 10 https://instagram.Com/veterans_us/ This military campaign is very ambiguous given that it has cost nearly 2,500 American lives and hundreds of billions of dollars. The goal was to "disrupt the use of Afghanistan as a terrorist base of operations." Well, the intervention deprived aI-Qaida of a sanctuary. But aI-Qaida — even after its leader Osama bin Laden was killed by US. commandos — has spawned cells elsewhere and inspired other extremists in Syria and Iraq. And now ISIS is rising as the most powerful terrorist organisation in the world. So, the question is whether it's worth to risk the lives of thousands of American soldiers for the mission that hardly can be called successful? It seems that Obama should review his military strategy without delay.Joih us! Veterans USA ( @veterans GovSpending 10.55264 659.54 RUB 2015-11-16T05:17:56-08:00  
25 location:United States, interests:Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed 3970 35 https://instagram.Com/veterans_us/ Homeland of brave. Support our veterans! Join us! Veterans USA GovSpending 22.4288 1401.80 RUB 2015-11-09T05:01:08-08:00  
26 location:united_states:Latitude 38.89 Longitude -77.03 Washington (+16 km) District of Columbia, location:united_states:Gallup (+40 km) New Mexico, interests:Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed 1721 6 https://www.instagram.Com/veterans_us/ Home of the Brave. Support our Veterans! Click Learn More! Veterans USA ( @veterans GovSpending 14.37376 898.36 RUB 2015-12-01T05:51:31-08:00  
2784 location_living_in:United States, interests:Veterans, interests:United States Department of Veterans Affairs, interests:Disabled American Veterans, interests:Supporting Our Veterans, home_composition:Veterans in home, 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 0 0 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! Veterans Come First 0.0 0.00 USD 2017-02-21T01:13:46-08:00  
2791 location_living_in:United States, interests:Veterans, interests:United States Department of Veterans Affairs, interests:Disabled American Veterans, interests:Supporting Our Veterans, home_composition:Veterans in home, 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 15 2 https://www.facebook.comNeterans-Come-First-1757336424535312/ Support our Veterans! 0.80096 50.06 RUB 2017-02-21T01:13:46-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 1624.83ms · Data source: simonw/russian-ira-facebook-ads-datasette