home / russian-ads

display_ads (view)

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

1 row where an ad_target was location_living_in:united_states:Gainesville (+25 mi) Florida

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
2964 no image location_living_in:united_states:Gainesville (+25 mi) Florida, age:18 — 65+, gender:Male, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Protect the Second Amendment, people_who_match:interests:Gun Owners of America, people_who_match:interests:Concealed carry, people_who_match:interests:Concealed carry in the United States, people_who_match:interests:National Association for Gun Rights, people_who_match:interests:Guns & Ammo, people_who_match:interests:Students for Concealed Carry 1149 55 https://www.facebook.com/Defend-the-2nd-692068924291672/ FREE shooting practice for our subscribers! (Hurry, only 8 packages left!) Dear subscribers, we offer you to gather together and visit shooting range in Gainesville, FL. Oh we are making an event for our subscribers. Join the event and share it with your friends. First 8 people who will message us will get a FREE 9mm Shooting Package (includes the day pass, a rental handgun, 100 rounds 9mm, 1 target, eye/ear protection if neededi. If iou want to get it, just message us Shooting practice at 16.0 1000.00 RUB 2017-02-17T07:48:04-08:00 2017-02-20T07:48:04-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 1444.165ms · Data source: simonw/russian-ira-facebook-ads-datasette