home / fivethirtyeight / police-deaths/clean_data

Menu
  • GraphQL API

police-deaths/clean_data: 67

This directory contains the data and code behind the story The Dallas Shooting Was Among The Deadliest For Police In U.S. History. The primary source of data is the Officer Down Memorial Page (ODMP), started in 1996 by a college student who is now a police officer and who continues to maintain the database.

File descriptions:

File Description
scrape.R Scrapes data on the death of every officer tracked on ODMP
all_data.csv Output of scrape.R
clean.R Takes the data in all_data.csv, cleans it and formats the dates correctly, and tags every entry as human or canine.
clean_data.csv Output of clean.R
plot.R Summarizes police deaths by category and generates a plot similar to the one below

Data source: https://github.com/fivethirtyeight/data/blob/master/police-deaths/clean_data.csv

This data as json, copyable

rowid person dept eow cause cause_short date year canine dept_name state
67 Prison Guard William Bullard Missouri Department of Corrections, MO EOW: Monday, June 14, 1841 Cause of Death: Assault Assault 1841-06-14 1841 0 Missouri Department of Corrections MO
Powered by Datasette · Queries took 873.577ms · Data source: https://github.com/fivethirtyeight/data/blob/master/police-deaths/clean_data.csv