home / fivethirtyeight / police-deaths/clean_data

Menu
  • GraphQL API

police-deaths/clean_data: 9

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
9 Deputy Sheriff Ebenezer Parker Cumberland County Sheriff's Office, ME EOW: Monday, January 18, 1808 Cause of Death: Assault Assault 1808-01-18 1808 0 Cumberland County Sheriff's Office ME
Powered by Datasette · Queries took 1384.374ms · Data source: https://github.com/fivethirtyeight/data/blob/master/police-deaths/clean_data.csv