Prosecutorial Analytics
Click card to view examples.
I designed visualizations and dashboards for 55 prosecutor indicators and system level metrics. Built and deployed 25 public dashboards, numerous policy briefs, and 14 racial disparity analyses in 42 offices in 12 states including California, Colorado, Florida, Illinois, Maryland, New York, Oregon, and Wisconsin. Selected examples of my work are featured below.
Deployed internal and external dashboards in Colorado. The first statewide data initiative in the United States. Conducted 8 reports on racial and ethnic disparities.
An analysis on racial disparity and disproportionality in the Ninth Circuit Solicitor’s Office in Charleston County, South Carolina.
Designed and deployed a public dashboard in Santa Clara, County.
An interactive visual essay on the Queens DA's Office retail theft program.
A statewide analysis of Marijuana Possession Convictions in Wisconsin.
Click arrows or drag right to view more examples
Pretrial Justice Reform
Click card to view examples.
Led high level analytics, casual inference, and data management in an ongoing four-year evaluation of the implementation and impact of the Pretrial Fairness Act which most notably ends the use of cash bail. The evaluation produced over 22 reports, policy briefs, and data tools to date. The 1-year review and related research of the law’s implementation was widely covered and cited in publications like The Nation, Center for America Progress, and WBEZ Chicago. Selected examples of my work are featured below.
The First Year of the Pretrial Fairness Act. Beginning September 18, 2023, the Pretrial Fairness Act fundamentally altered pretrial practices in Illinois. A report on the workings and effects of the new law at the one-year point.
Tracking the Cook County Jail and Community Corrections Population. A small, automated script and visualization build using python, datawrapper, and github actions.
Will Eliminating Monetary Bail Deprive Crime Victims of Compensation? We found that only 4% of the money disbursed from monetary bail payments went toward restitution.
Cash Bail Detains People Charged with Serious Offenses—But for How Long?. A report finding large proportion of serious felonies are released after 7 days under cash bail.
Dollars and Sense in Cook County. I conducted a causal analysis on crime rates in Cook County and found there was no change in the amount of crime in Chicago in the year after GO18.8A Cook County.
Click arrows or drag right to view more examples
Data Engineering
No links to external examples.
Built privacy forward, CJIS compliant pipelines in Azure Government and Amazon Web Services using Dagster and Airflow. These end-to-end pipelines support statewide work in Colorado, Wisconsin, and Cook County. And automate complex justice system measures.
Built and maintain an internal system-wide dashboard for the entire Cook County justice system. The depth and breadth of justice system data metrics is extensive and spans agencies across the system. It includes metrics on incidents, arrests, cases filed in court, pretrial release decisions, disposition, time to disposition, sentence, case flow, average daily population, daily admissions, total releases, prison, and parole.
Dagster pipeline that downloads and restores Microsoft SQL Databases and calculates complex justice system measures that populate the internal and external metrics for the Colorado Dashboard Project.
Dagster data pipeline (AWS hosted ec2 compute and Postgres RDS) that updates all Wisconsin criminal cases monthly. This statewide database was leveraged for several large Wisconsin research projects around case processing and bail reform.
Click arrows or drag right to view more examples
Eviction and Large Landlords
Click card to view examples.
Built eviction tracking system and property ownership mapping tool to identify Milwaukee’s top evictors. Data from this project was used to make the case for right-to-counsel in Milwaukee, led to a Loeb-award winning investigative story uncovering Milwaukee’s most prolific evictors, and supported the Wisconsin Attorney General’s Office litigation against Wisconsin’s largest landlord.
2021 LISC Rubinger Fellowship – built property ownership mapping tool to identify Milwaukee’s top evictors.
Developed and wrote an interactive scroll visualization for the City of Milwaukee. The report provides an overview of the civic technology infrastructure needed to identify common landlord portfolios and understand a cities’ large evictors.
Provided data analysis for litigation against Wisconsin's largest landlord Berrada. This resulted in a 1.7 million dollar settlement and the expungment of ~3,000 eviction records.
In collaboration with John Johnson, we released a list of top 25 most prolific landlords in Milwaukee for this Loeb winning investigative piece.
I provided analysis on the scale of Anchor Properties (Curtis Hoff) evictions for this, Loeb winning investigative piece.
Click arrows or drag right to view more examples