home / fivethirtyeight / police-deaths/clean_data

police-deaths/clean_data: 64

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

rowid person dept eow cause cause_short date year canine dept_name state
64 Town Marshal John Yeomans Jacksonville Police Department, FL EOW: Sunday, May 24, 1840 Cause of Death: Gunfire Gunfire 1840-05-24 1840 0 Jacksonville Police Department FL
Powered by Datasette · Query took 4.111ms · Data source: https://github.com/fivethirtyeight/data/blob/master/police-deaths/clean_data.csv