Police Deaths: all_data.csv

Table actions

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 license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

22,800 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ person dept eow cause
1 1 Constable Darius Quimby Albany County Constable's Office, NY EOW: Monday, January 3, 1791 Cause of Death: Gunfire
2 2 Sheriff Cornelius Hogeboom Columbia County Sheriff's Office, NY EOW: Saturday, October 22, 1791 Cause of Death: Gunfire
3 3 Deputy Sheriff Isaac Smith Westchester County Sheriff's Department, NY EOW: Thursday, May 17, 1792 Cause of Death: Gunfire
4 4 Marshal Robert Forsyth United States Department of Justice - United States Marshals Service, US EOW: Saturday, January 11, 1794 Cause of Death: Gunfire
5 5 Sheriff Robert Maxwell Greenville County Sheriff's Office, SC EOW: Sunday, November 12, 1797 Cause of Death: Gunfire
6 6 High Sheriff John Caldwell Cook Mecklenburg County Sheriff's Office, NC EOW: Tuesday, October 16, 1804 Cause of Death: Gunfire
7 7 Watchman Christian Luswanger New York City Watch, NY EOW: Thursday, December 25, 1806 Cause of Death: Stabbed
8 8 Deputy Sheriff John A. Gooch Livingston County Sheriff's Department, KY EOW: Saturday, March 7, 1807 Cause of Death: Gunfire
9 9 Deputy Sheriff Ebenezer Parker Cumberland County Sheriff's Office, ME EOW: Monday, January 18, 1808 Cause of Death: Assault
10 10 Night Watchman George Workner Baltimore City Police Department, MD EOW: Tuesday, March 15, 1808 Cause of Death: Stabbed
11 11 Boatman Asa Marsh United States Department of the Treasury - Customs Service, US EOW: Wednesday, August 3, 1808 Cause of Death: Gunfire
12 12 Boatman Ellis Drake United States Department of the Treasury - Customs Service, US EOW: Wednesday, August 3, 1808 Cause of Death: Gunfire
13 13 Custom House Officer Daniel Miller United States Department of the Treasury - Customs Service, US EOW: Monday, January 1, 1810 Cause of Death: Gunfire
14 14 Deputy Sheriff John Tileston Downes Hancock County Sheriff's Department, ME EOW: Monday, January 28, 1811 Cause of Death: Gunfire
15 15 Customs Inspector John Stout United States Department of the Treasury - Customs Service, US EOW: Friday, January 21, 1814 Cause of Death: Gunfire
16 16 Sheriff John Coor Pender Wayne County Sheriff's Office, NC EOW: Monday, January 1, 1816 Cause of Death: Gunfire
17 17 Sheriff Caleb Hewitt Davidson County Sheriff's Office, TN EOW: Monday, September 9, 1816 Cause of Death: Assault
18 18 Deputy Sheriff William Huddleston Schoharie County Sheriff's Department, NY EOW: Friday, October 9, 1818 Cause of Death: Assault
19 19 Constable Jacob Dearduff, Sr. Jamestown Police Department, OH EOW: Saturday, February 22, 1823 Cause of Death: Stabbed
20 20 Constable Elijah Chenault Alexandria Police Department, VA EOW: Monday, August 4, 1823 Cause of Death: Assault
21 21 Constable Robert Murphy Franklin County Sheriff's Department, IN EOW: Thursday, November 11, 1824 Cause of Death: Stabbed
22 22 Constable William Davidson Pennsylvania State Constable - Venango County, PA EOW: Thursday, April 14, 1825 Cause of Death: Gunfire
23 23 Watch Officer Jonathan Houghton Boston Watch, MA EOW: Monday, December 19, 1825 Cause of Death: Assault
24 24 Watchman Gerrard Arnold Alexandria Police Department, VA EOW: Sunday, September 9, 1827 Cause of Death: Assault
25 25 Watchman Steven Heimer Philadelphia Police Department, PA EOW: Tuesday, January 8, 1828 Cause of Death: Gunfire
26 26 Sheriff Thomas Griffin Thornton Caroline County Sheriff's Office, VA EOW: Saturday, June 12, 1830 Cause of Death: Gunfire
27 27 Town Sergeant John Smith Foster Police Department, RI EOW: Thursday, June 21, 1832 Cause of Death: Assault
28 28 Guard Ezra Hoskins Connecticut Department of Correction, CT EOW: Wednesday, May 1, 1833 Cause of Death: Assault
29 29 Sheriff William Gresham Harrison County Sheriff's Department, IN EOW: Thursday, January 23, 1834 Cause of Death: Stabbed
30 30 Constable Moore C. Wisdom Purdy Constable's Office, TN EOW: Saturday, August 30, 1834 Cause of Death: Stabbed
31 31 Watchman Lewis L. Leuba New York City Watch, NY EOW: Wednesday, April 13, 1836 Cause of Death: Stabbed
32 32 Constable William Mull St. Louis Metropolitan Police Department, MO EOW: Thursday, April 28, 1836 Cause of Death: Stabbed
33 33 Deputy Sheriff George Hammond St. Louis Metropolitan Police Department, MO EOW: Thursday, April 28, 1836 Cause of Death: Stabbed
34 34 Watchman Kim Hudson New York City Watch, NY EOW: Sunday, August 28, 1836 Cause of Death: Stabbed
35 35 Private David Clark Texas Rangers, TX EOW: Saturday, January 7, 1837 Cause of Death: Gunfire
36 36 Second Lieutenant Alfred H. Miles Texas Rangers, TX EOW: Friday, November 10, 1837 Cause of Death: Assault
37 37 Private Jesse Blair Texas Rangers, TX EOW: Friday, November 10, 1837 Cause of Death: Assault
38 38 Private Alexander Bostwick Texas Rangers, TX EOW: Friday, November 10, 1837 Cause of Death: Gunfire
39 39 Private James Christian Texas Rangers, TX EOW: Friday, November 10, 1837 Cause of Death: Assault
40 40 Private Joseph Cooper Texas Rangers, TX EOW: Friday, November 10, 1837 Cause of Death: Gunfire
41 41 Private James Joslen Texas Rangers, TX EOW: Friday, November 10, 1837 Cause of Death: Assault
42 42 Private Westley Nicholson Texas Rangers, TX EOW: Friday, November 10, 1837 Cause of Death: Assault
43 43 Private William Nicholson Texas Rangers, TX EOW: Friday, November 10, 1837 Cause of Death: Gunfire
44 44 Private William Sanders Texas Rangers, TX EOW: Friday, November 10, 1837 Cause of Death: Gunfire
45 45 Private Lewis F. Scheuster Texas Rangers, TX EOW: Friday, November 10, 1837 Cause of Death: Assault
46 46 Deputy Sheriff Nester Young Ashtabula County Sheriff's Department, OH EOW: Monday, January 15, 1838 Cause of Death: Gunfire
47 47 Private Julius Bullock Texas Rangers, TX EOW: Friday, October 12, 1838 Cause of Death: Assault
48 48 Private John W. Carpenter Texas Rangers, TX EOW: Friday, October 12, 1838 Cause of Death: Assault
49 49 Private Thomas M. Scott Texas Rangers, TX EOW: Friday, October 12, 1838 Cause of Death: Assault
50 50 Private John Wilson Texas Rangers, TX EOW: Friday, October 12, 1838 Cause of Death: Assault
51 51 Private James Hall Texas Rangers, TX EOW: Monday, December 17, 1838 Cause of Death: Assault
52 52 Deputy U.S. Marshal John Gatewood United States Department of Justice - United States Marshals Service, US EOW: Saturday, February 2, 1839 Cause of Death: Gunfire
53 53 Captain Jacob Shipman Burleson Texas Rangers, TX EOW: Monday, February 25, 1839 Cause of Death: Gunfire
54 54 Private Edward Blakey Texas Rangers, TX EOW: Monday, February 25, 1839 Cause of Death: Gunfire
55 55 Private John B. Walters Texas Rangers, TX EOW: Monday, February 25, 1839 Cause of Death: Gunfire
56 56 Private James Gilleland Texas Rangers, TX EOW: Thursday, March 7, 1839 Cause of Death: Gunfire
57 57 Captain John Bird Texas Rangers, TX EOW: Sunday, May 26, 1839 Cause of Death: Assault
58 58 First Sergeant William H. Weaver Texas Rangers, TX EOW: Sunday, May 26, 1839 Cause of Death: Gunfire
59 59 Private Jesse E. Nash Texas Rangers, TX EOW: Sunday, May 26, 1839 Cause of Death: Assault
60 60 Private Thomas Gay Texas Rangers, TX EOW: Sunday, May 26, 1839 Cause of Death: Gunfire
61 61 Private H. M. C. Hall Texas Rangers, TX EOW: Monday, May 27, 1839 Cause of Death: Gunfire
62 62 Watchman James P. Van Duzen New York City Watch, NY EOW: Tuesday, June 25, 1839 Cause of Death: Fall
63 63 Sheriff Joseph L. Hood Bexar County Sheriff's Office, TX EOW: Thursday, March 19, 1840 Cause of Death: Stabbed
64 64 Town Marshal John Yeomans Jacksonville Police Department, FL EOW: Sunday, May 24, 1840 Cause of Death: Gunfire
65 65 Sheriff John B. Campbell Harrison County Sheriff's Office, TX EOW: Saturday, January 23, 1841 Cause of Death: Gunfire
66 66 Guard Cyrus Sells Ohio Department of Rehabilitation and Correction, OH EOW: Wednesday, June 9, 1841 Cause of Death: Assault
67 67 Prison Guard William Bullard Missouri Department of Corrections, MO EOW: Monday, June 14, 1841 Cause of Death: Assault
68 68 Private Abram Trigg Smith Texas Rangers, TX EOW: Thursday, August 5, 1841 Cause of Death: Gunfire
69 69 Sheriff Thomas Wooldridge Dubois County Sheriff's Department, IN EOW: Thursday, May 19, 1842 Cause of Death: Gunfire
70 70 Warden Charles Lincoln, Jr. Massachusetts Department of Correction, MA EOW: Sunday, June 18, 1843 Cause of Death: Stabbed
71 71 Sheriff Samuel B. Wingo Shannon County Sheriff's Department, MO EOW: Thursday, August 31, 1843 Cause of Death: Gunfire
72 72 Sheriff George Lee Phillips Ashe County Sheriff's Office, NC EOW: Saturday, September 23, 1843 Cause of Death: Drowned
73 73 Sheriff Robert D. Lester Crawford County Sheriff's Department, WI EOW: Thursday, March 21, 1844 Cause of Death: Gunfire
74 74 Sheriff Lewis Williams Jackson County Sheriff's Department, FL EOW: Friday, April 26, 1844 Cause of Death: Gunfire
75 75 Private Peter Fohr Texas Rangers, TX EOW: Saturday, June 8, 1844 Cause of Death: Assault
76 76 Keeper James Gastin Pennsylvania Department of Corrections, PA EOW: Thursday, October 31, 1844 Cause of Death: Assault
77 77 Undersheriff Osman N. Steele Delaware County Sheriff's Office, NY EOW: Thursday, August 7, 1845 Cause of Death: Gunfire
78 78 Constable John Holton Augusta Police Department, KY EOW: Monday, November 24, 1845 Cause of Death: Stabbed
79 79 Sheriff Lansford Stallings Cherokee County Sheriff's Office, AL EOW: Thursday, December 4, 1845 Cause of Death: Gunfire
80 80 Lieutenant John M. Brown Cherokee Nation Marshal Service, TR EOW: Sunday, December 28, 1845 Cause of Death: Stabbed
81 81 Sheriff Samuel Grimmett Montgomery County Sheriff's Office, TX EOW: Sunday, April 11, 1847 Cause of Death: Gunfire
82 82 Deputy Sheriff William Armstrong Hampshire County Sheriff's Office, VA EOW: Friday, June 25, 1847 Cause of Death: Gunfire
83 83 Sheriff Enoch B. Morelock Sullivan County Sheriff's Office, MO EOW: Sunday, December 19, 1847 Cause of Death: Gunfire
84 84 Watchman David Estes Boston Watch, MA EOW: Thursday, April 27, 1848 Cause of Death: Gunfire
85 85 Watchman John Brasher Cincinnati Police Department, OH EOW: Sunday, May 6, 1849 Cause of Death: Gunfire
86 86 Watchman Peter Davison Cincinnati Police Department, OH EOW: Monday, June 25, 1849 Cause of Death: Stabbed
87 87 Patrolman Thomas Lynch New York Municipal Police Force, NY EOW: Thursday, September 27, 1849 Cause of Death: Assault
88 88 Patrolman William Helms New York Municipal Police Force, NY EOW: Tuesday, October 16, 1849 Cause of Death: Structure collapse
89 89 Major Charles Grandison Bryant Texas Rangers, TX EOW: Saturday, January 12, 1850 Cause of Death: Assault
90 90 Police Officer Ephraim Hibler St. Louis Metropolitan Police Department, MO EOW: Sunday, May 26, 1850 Cause of Death: Gunfire
91 91 Private William Gillespie Texas Rangers, TX EOW: Wednesday, May 29, 1850 Cause of Death: Assault
92 92 Sheriff Joseph McKinney Sacramento County Sheriff's Department, CA EOW: Thursday, August 15, 1850 Cause of Death: Gunfire
93 93 Private John Lemon Wilbarger Texas Rangers, TX EOW: Tuesday, August 20, 1850 Cause of Death: Gunfire
94 94 Private Daniel C. "Doc" Sullivan Texas Rangers, TX EOW: Tuesday, August 20, 1850 Cause of Death: Gunfire
95 95 Private Samuel Baker Barton Texas Rangers, TX EOW: Monday, January 27, 1851 Cause of Death: Assault
96 96 Private William Lackey Texas Rangers, TX EOW: Monday, February 3, 1851 Cause of Death: Assault
97 97 Patrolman George T. Gillespie New York Municipal Police Force, NY EOW: Thursday, July 10, 1851 Cause of Death: Assault
98 98 Sergeant Michael Foster New York Municipal Police Force, NY EOW: Monday, August 4, 1851 Cause of Death: Stabbed
99 99 Posseman Edward Gorsuch United States Department of Justice - United States Marshals Service, US EOW: Thursday, September 11, 1851 Cause of Death: Gunfire
100 100 Deputy Sheriff David Neil Smith County Sheriff's Office, TX EOW: Saturday, September 27, 1851 Cause of Death: Gunfire

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "police-deaths/all_data" (
"person" TEXT,
  "dept" TEXT,
  "eow" TEXT,
  "cause" TEXT
);