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:united_states:Atlanta Georgia

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
209 no image location:united_states:Atlanta Georgia, 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 18946 1276 https://b|ackmattersus.com/6189-bIaCk-woman-found-dead-in-jaiI-Cel|-after- Wakiesha Wilson, 36, was found dead on Easter Weekend at the LAPD’s detention center in jail cell. According to ABC? report, the black woman, Wakiesha Wilson, had a disagreement with officers before she was found died. Wilson spoke to her lovely family that v Black Woman Found Dead In Jail Cell After Arguing With Detention Officers | Black Matters Black Matters 56.0 3500.00 RUB 2016-04-06T08:48:17-07:00 2016-04-10T22:48:00-07:00
211 no image location:united_states:Atlanta Georgia, 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 2441 197 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Atlanta Hawks forward Sefolosha files a Civil lawsuit against 5 NYPD officers for breaking his leg. Atlanta Hawks forward Thabo Sefolosha filed a Civil lawsuit against five New York Police Department officers and the City on Wednesday in relation to an inciden NBA Star Sues NYPD Over False Arrest, Excessive Force, And Malicious Prosecution | Black Matters Black Matters 14.4 900.00 RUB 2016-04-08T07:30:09-07:00 2016-04-09T07:30:08-07:00
212 no image location:united_states:Atlanta Georgia, 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 1112 120 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Jay Z and Beyoncé stood with families of police brutality victims, donated bail for Baltimore and Ferguson protesters. The never-ending cases of police brutality and state-sahctioned violence against Black people — the most prominent being the police slaying of Michael Brown, Er Music’s Billion-Dollar Couple Help Raise Awareness Of Race And Police Brutality | Black Matters Black Matters 4.8 300.00 RUB 2016-04-07T08:20:46-07:00 2016-04-08T08:20:46-07: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 1338.645ms · Data source: simonw/russian-ira-facebook-ads-datasette