Andrew Friedman
afriedman412 [at] gmail [dot] com
Data and Writing Experience:
Google/Medill Data-Driven Reporting Project
Data Lead
6.2022 - present
We obtained 30 years of localized crime data from the Baltimore Police department, covering 50 categories. Our goal is to tell the story of the city through the type and location of crime. We are interested in connecting patterns in the data to concurrent events, such as elections, the passing of legislation, or the closing of businesses. Project is ongoing but future plans include integration with outside data sources, statistical modeling and the development of an interactive front-end.
Nobody Defunded The Police
4.15.2022
Analyzed 5 years of municipal budgets from over 400 locations to determine whether the 2020 George Floyd protests led to police being defunded across the country. They did not. Collaboration with Mason Youngblood.
Major Media Outlets Can’t Stop Describing Police Violence As ‘Officer-Involved’ Incidents
1.13.2022
Tracked the rate of use of “officer-involved” and similar exonerative language across 20 years of American reporting on police violence. Collaboration with Brandon Soderberg.
Poorer Cities Spend More of Budget on Police, Even Where Crime Is Lower
6.26.2020
Data analysis of 473 cities nationwide finds that spending on police takes up almost one-third of municipal budgets, independently of local crime rates—with poorer cities spending a higher share. Collaboration with Mason Youngblood.
Structural Racism and Cannabis
12.28.2018
Cross-referenced arrest data with demographics to demonstrate bias in enforcement of cannabis prohibition, and to argue that decriminalization is not sufficient. Collaboration with Brandon Soderberg and Ethan McLeod.