The avatar for @themarshallproject
The Marshall Project
Published
data/Releases
Edited
Feb 26, 2021
1 star
data/Releases
The Annual Survey of Public Employment & Payroll Aggregated by State and Government Sector, 2003-2023Prison Mortality Rate Estimates By State and By Age, 2014-2020Books Banned In State Prisons (2022)How Bratenahl, Ohio, Disproportionately Targets Black DriversHow do we know mass shootings are increasing?Participation in the FBI national crime data collectionCriminal cases in the Cuyahoga County Court of Common Pleas in Ohio, 2016-2021Life Without Parole in LousianaAdults in Correctional Facilities, From Decennial Census (2000 to 2020)Foster care benefits policies by stateU.S. Customs and Border Protection child detentions, 2017 to 2020
Police misconduct settlements
How much money does MTC owe Mississippi for vacant guard jobs?FBI Crime Clearances and Clearance Rate, 1970 to 2020The Marshall Project 2024 Political Survey, State Summaries of Selected QuestionsThe Marshall Project 2024 Political Survey, Summaries of Selected Questions by Jail
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
convertCSV = d => ({
...d,
calendar_year: parseInt(d.calendar_year),
filed_year: parseInt(d.filed_year),
incident_year: parseInt(d.incident_year),
amount_awarded: parseFloat(d.amount_awarded),
other_expenses: parseFloat(d.other_expenses),
total_incurred: parseFloat(d.total_incurred)
})
Insert cell
Insert cell
// Used this to help make the cells above, left for reference
// html`${directories.map(d => {
// const parts = d.split("_");
// const city = parts
// .slice(0, parts.length - 1)
// .map(c => journalize.capfirst(c))
// .join("");
// const citySlug = parts.slice(0, parts.length - 1).join("_");
// const state = parts[parts.length - 1].toUpperCase();
// return html`<p><code>Settlements${city}${state} = d3.csv("https://raw.githubusercontent.com/fivethirtyeight/police-settlements/main/${d}/final/${citySlug}_edited.csv")</code></p>`;
// })}`
Insert cell
Insert cell
journalize = require("journalize")
Insert cell
d3 = require("d3")
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more