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:US.

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
475 location_living_in:united_states:New York (+50 mi) New York, excluded_connections:Exclude people who like Being Patriotic, 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:Young Republicans, people_who_match:interests:2nd Amendment, people_who_match:interests:National Rifle Association, people_who_match:interests:Donald Trump, people_who_match:interests:Republican Party (United States), people_who_match:interests:Gun Owners of America or Donald Trump for President, people_who_match:interests:Employers: NYPD, people_who_match:interests:US., army_reserve_industry:Military (Global) or Veterans (US), army_reserve_industry:Politics: US politics (conservative), army_reserve_industry:US politics (very conservative) 4171 551 https://www.facebook.com/events/365162297165103/ Donald John Trump was elected the 45th president of the United States on Tuesday! Today some massive crowds of libtards marched in NYC against election of Donald Trump. Come to Trump Tower (725 5th Ave) on Saturday to show Mr. Trump there actually ARE people in NY who voted for him! Support Trump in NYC 31.9904 1999.40 RUB 2016-11-10T05:00:07-08:00 2016-11-11T21:00:00-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 1227.635ms · Data source: simonw/russian-ira-facebook-ads-datasette