home / russian-ads

display_ads (view)

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

3 rows where an ad_target was people_who_match:Friends of connections: Friends of people who are connected to Black Matters and an ad_target was location_living_in:united_states:Cleveland (+50 mi) Ohio

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
312 no image location_living_in:united_states:Cleveland (+50 mi) Ohio, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 6592 212 https://www.facebook.com/blackmattersus/ —will attract the UN’s attention to the long term injustice and cruelty against people of color in the United States. The genocide instituted by white supremacists should be stopped. Join our protest that will be held Also, join the event for more info: #CrimesOfGenocide 27.445919999999997 1715.37 RUB 2016-02-08T07:06:35-08:00 2016-02-09T07:06:34-08:00
313 no image location_living_in:united_states:Cleveland (+50 mi) Ohio, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 0 0 https://www.facebook.com/events/1486230091674577/ November 23, 2015 Is the One year anniversary Death of 12 year old Tamir Rice; killed by two Cleveland Police Officers Timothy Loehmann and Frank Garmback. You are welcome! Join the meeting. A Year Without Justice for Tamir Rice 0.0 0.00 USD 2015-11-19T23:51:19-08:00 2015-11-22T23:51:18-08:00
315 no image location_living_in:united_states:Cleveland (+50 mi) Ohio, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:People who like Black Matters, people_who_match:Friends of connections: Friends of people who are connected to Black Matters 0 0     0.0 0.00 USD 2015-11-19T23:21:05-08:00 2015-11-22T23:21:03-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/umd-mith/irads/master/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 1344.805ms · Data source: simonw/russian-ira-facebook-ads-datasette