home / russian-ads

display_ads (view)

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

51 rows where search matches "black lives matter"

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
3309 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Corrections Corporation of America, people_who_match:interests:American Correctional Association, people_who_match:interests:The Inmates 0 0 https://www.facebook.com/He||_and_BaCk-1806743482876111/ “This is my lived experience,” Muhammad said. “I’m formerly incarcerated, I spent a lot of my Childhood in different systems and I had no idea about the beast that communities of color are fighting. My mother didn't know about the schooI-to-prison pipeline, she just knew she had a black boy.” Coleman explained how his work with wrongfully-convicted Clients had shaped his view of the US. criminal justice system, which he described as racially lopsided. “It’s not by choice that most of my Clients are African American," Coleman said. "It’s a fact of life and of the prison system. If most of the people going into the system are black men, most of my clients will be too.” The Duke Journal of Gender Law and Policy hosted a symposium Tuesday focusing on efforts to improve criminal justice and the American prison system. Titled “Intersectionality and the Black Lives Matter Movement,” the event featured a panel of speakers, including James Coleman, John S. Bradway professor of the practice of law, and Umar Muhammad, community organizer for the Southern Coalition for Justice, along with Theresa Newman, Clinical professor of law. “I didn’t feel prepared for the world. I didn’t feel rehabilitated. I had no resources,” Muhammad said. ~The Chronicle~ 0.0 0.00 USD 2017-02-13T07:31:36-08:00 2017-02-14T07:31:36-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 688.701ms · Data source: simonw/russian-ira-facebook-ads-datasette