Police misconduct settlements

This repo contains the data behind the story Police Misconduct Costs Cities Millions Every Year, But That's Where The Accountability Ends.

Words of caution

As we describe in an accompanying article, this data has major issues. It constitutes our best guess at the amount of money that was paid out as settlements for police misconduct from 2010-19 (or for the range otherwise provided), but different cities have different ways of collecting, storing and categorizing such settlements. As a result, this data should not be compared across cities. We have no way of knowing (or checking) whether the kinds of misconduct this covers are comparable across cities. (For example, city officials in Boston likely interpreted our request more narrowly than those in New York City.) Descriptions of the types of misconduct are included where provided, but are also not comparable across cities. For this reason, while we are making all the data we obtained available, we are not providing it in an easy-to-use, collated data set. This is because we don’t want you to use it this way!

Moreover, while records within the same city might be more comparable across time, this is also not encouraged. Data storage may have changed in this time period, as have the humans who entered the information into it, and much of the information entered is subject to human categorization based on judgement calls that cannot be assumed to have stayed constant over time. And even if the data collection had stayed the same for the entire period, other factors (such as whether cities are likely to settle in response to police misconduct and if so, for how much) may have changed such that the settlements themselves are a poor measure of police misconduct. For these reasons, we advise extreme caution when comparing this data across time and within a city.

Folder structure

Each city folder contains:

• an R script that cleans the data
• an original/ folder that contains original data as provided by the city.
• an intermediate/ folder - if we did any manual data cleaning. This folder contains data after the manual data cleaning step (e.g. an xlsx sheet into which data from a pdf was copied).
• a final/ folder that contains data output of the cleaning script, with columns described by the data dictionary below.

Data dictionary

FOIA text

This is the text of the FOIA request we sent to each city:

Dear Records Officer,

Pursuant to all laws and traditions governing the release of public records in your jurisdiction, I am requesting records related to any and all civil lawsuits brought forth against the [CITY] Police Department or [CITY] PD law enforcement officials that resulted in a monetary legal settlement between the period of January 1, 2010 and December 31, 2019.

Specifically, I am requesting any and all records concerning each legal settlement, including:

• Name(s) of plaintiff(s)
• Name(s) of officer(s) involved
• Name of court and docket number
• Date of incident at issue
• Location of incident at issue
• Date lawsuit filed
• Date lawsuit resolved
• Type of misconduct
• Summary of allegations
• Settlement amount
• Name of plaintiff’s attorney (or pro se status if plaintiff represented him/herself)

Please provide the records in an electronic spreadsheet. In addition, I request you send along any data dictionaries that accompany these records.

Please waive any applicable fees. I am a representative of the news media through FiveThirtyEight and The Marshall Project. Release of this information is in the public interest because it will help the public understand how taxpayer dollars are used to compensate victims of police misconduct.

If my request is denied in whole or part, I ask that you justify all deletions and denials by reference to specific exemptions of the laws and traditions in your state. I also request that you release all segregable portions of the otherwise exempt material. I reserve the right to appeal your decision to withhold any information or to deny any waiver of fees.

As I am making this request as a journalist and this information is of timely value, I would appreciate your communication through telephone or email if you have any questions regarding this request. I can be reached by email at [email] and by phone at [phone].

Thank you for your assistance.

List of cities FOIA'd and what happened with each