home / russian-ads

display_ads (view)

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

4 rows where an ad_target was people_who_match:interests:Corrections Corporation of America

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
3307 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Prison—industrial complex, people_who_match:interests:Corrections Corporation of America, people_who_match:interests:American Correctional Association, people_who_match:interests:Incarceration in the United States, people_who_match:interests:Prisoner, people_who_match:interests:The Inmates, people_who_match:interests:Children Of Inmates, people_who_match:interests:Prison V\fives, people_who_match:interests:School-to-prison pipeline 0 0 https://www.facebook.com/He||_and_BaCk—1806743482876111/ Repost from Photo by Isadora Kosofsky @isadorakosofsky, part of an ongoing series documenting bonding visits between children and their incarcerated parents at eight men’s and women’s prisons in Florida. 0.0 0.00 USD 2017-02-13T07:32:39-08:00 2017-02-14T07:32:39-08:00
3308 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Prison—industrial complex, people_who_match:interests:Corrections Corporation of America, people_who_match:interests:American Correctional Association, people_who_match:interests:Incarceration in the United States, people_who_match:interests:Prisoner, people_who_match:interests:The Inmates, people_who_match:interests:Children Of Inmates, people_who_match:interests:Prison V\fives, people_who_match:interests:School-to-prison pipeline 0 0 https://www.facebook.com/He||_and_Back—1806743482876111/ According to the Correctional Association of New York’s most recent statistics, “as of June 2006, 203,100 women were in state or federal prisons or local jails, just under 10% of the total US. prison and jail population”—more than two million. In New York alone, as of January 2008, “2,821 women were incarcerated in New York’s prisons—about 4.5% of the state’s total prison population of 62,577.” “More than 65 percent of women in state prisons and 55 percent of men in state prisons report being parents of children under 18.” -“About 64 percent of mothers in state prisons lived with their children before prison, compared to 44 percent of men.” -“About 40 percent of women in state prisons were employed fulltime prior to their arrest, compared with 60 percent of men.” -“Nearly 30 percent were receiving public assistance before arrest, compared to 8 percent of men. About 37 percent had incomes of less than $600 per month prior to arrest, compared to 28 percent of men.” ~Rea| Truth~ 0.0 0.00 USD 2017-02-13T07:32:20-08:00 2017-02-14T07:32:20-08:00
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
3310 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Prison—industrial complex, people_who_match:interests:Corrections Corporation of America, people_who_match:interests:American Correctional Association, people_who_match:interests:Incarceration in the United States, people_who_match:interests:Prisoner, people_who_match:interests:The Inmates, people_who_match:interests:Children Of Inmates, people_who_match:interests:Prison V\fives, people_who_match:interests:School-to—prison pipeline 0 0 https://www.facebook.com/Hell_and_Back-1806743482876111/ Repost from — Naomi Campbell...25 years later. Seeing any difference? Naomi Campbell...25ans plus tard, voyez—vous une difference? 0.0 0.00 USD 2017-02-13T07:29:44-08:00 2017-02-14T07:29:44-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 1312.071ms · Data source: simonw/russian-ira-facebook-ads-datasette