home / russian-ads

display_ads (view)

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

1 row where an ad_target was people_who_match:interests:Afro—American religion

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
31 location:United States, age:13 - 35, language:English (UK), language:English (US), placements:Instagram Feed, people_who_match:interests:Afro—American religion, people_who_match:interests:Malcolm X 23670 235 https://www.instagram.com/black_america_today/ Quiz from EBONY magazine April 1952. Which is Negro? Which is White? Passing for white is a direct consequence of how race works in America. Because of the One Drop Rule if you look at all part black African you are seen as “black” by “whites” and suffer all the racism that goes with that. Click "Learn More" Black America ( @black Blacklivessss 64.64272 4040.17 RUB 2016-03-11T04:54:05-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 1612.731ms · Data source: simonw/russian-ira-facebook-ads-datasette