police-deaths/clean_data

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

22,800 rows

View and edit SQL

Suggested facets: canine, date (date)

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "police-deaths/clean_data" (
"person" TEXT,
  "dept" TEXT,
  "eow" TEXT,
  "cause" TEXT,
  "cause_short" TEXT,
  "date" TEXT,
  "year" INTEGER,
  "canine" INTEGER,
  "dept_name" TEXT,
  "state" TEXT
);
Powered by Datasette · Query took 1092.449ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub