home / russian-ads

display_ads (view)

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

1 row where an ad_target was interests:United Nations Assistance Mission in Afghanistan

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  

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