police-deaths/all_data

22,800 rows

View and edit SQL

Link rowid person dept eow cause
101 Deputy Sheriff James Holden Smith County Sheriff's Office, TX EOW: Saturday, September 27, 1851 Cause of Death: Gunfire
102 Night Policeman William Baker Philadelphia Police Department, PA EOW: Friday, December 26, 1851 Cause of Death: Fire
103 Captain Chin Chi Kee United States Department of the Interior - Bureau of Indian Affairs - Division of Law Enforcement, US EOW: Saturday, January 10, 1852 Cause of Death: Gunfire
104 Sheriff James Preston Fulkerson Calhoun County Sheriff's Office, TX EOW: Sunday, April 4, 1852 Cause of Death: Gunfire
105 Deputy Sheriff Moses Formwalt DeKalb County Sheriff's Office, GA EOW: Saturday, May 1, 1852 Cause of Death: Stabbed
106 Watchman William T. Pullan Providence City Watch, RI EOW: Tuesday, May 18, 1852 Cause of Death: Assault
107 Constable Gideon Manchester Fall River Police Department, MA EOW: Friday, July 16, 1852 Cause of Death: Gunfire
108 Watchman Joseph Stoddard Cincinnati Police Department, OH EOW: Friday, September 10, 1852 Cause of Death: Stabbed
109 Deputy Sheriff Wesley F. Cherry King County Sheriff's Office, WA EOW: Sunday, March 6, 1853 Cause of Death: Gunfire
110 Night Watchman Samuel H. Ferguson Pittsburgh Night Watch, PA EOW: Thursday, April 21, 1853 Cause of Death: Stabbed
111 Deputy Sheriff Rodney Badger Salt Lake County Sheriff's Office, UT EOW: Friday, April 29, 1853 Cause of Death: Drowned
112 Shadow George Trenchard New York Municipal Police Force, NY EOW: Thursday, June 2, 1853 Cause of Death: Fire
113 Watchman John Osborne Cleveland Police Department, OH EOW: Thursday, December 1, 1853 Cause of Death: Stabbed
114 Constable James Quinn Chicago Police Department, IL EOW: Monday, December 5, 1853 Cause of Death: Assault
115 Constable Jack Wheelan Los Angeles County Constable's Office, CA EOW: Wednesday, December 7, 1853 Cause of Death: Stabbed
116 Police Officer George R. Turner Stockton Police Department, CA EOW: Friday, April 14, 1854 Cause of Death: Gunfire
117 Officer Cyrus Beebe Columbus Division of Police, OH EOW: Thursday, April 27, 1854 Cause of Death: Gunfire
118 Deputy U.S. Marshal James Batchelder United States Department of Justice - United States Marshals Service, US EOW: Friday, May 26, 1854 Cause of Death: Gunfire
119 Constable William H. Hardmount Monterey County Constable's Office, CA EOW: Saturday, September 2, 1854 Cause of Death: Gunfire
120 Patrolman Casper Lauer Chicago Police Department, IL EOW: Monday, September 18, 1854 Cause of Death: Stabbed
121 Patrolman James Cahill New York Municipal Police Force, NY EOW: Friday, September 29, 1854 Cause of Death: Gunfire
122 Police Officer Maxwell Badgley Newark Police Department, NJ EOW: Monday, October 23, 1854 Cause of Death: Stabbed
123 Patrolman David Gourley New York Municipal Police Force, NY EOW: Sunday, November 5, 1854 Cause of Death: Stabbed
124 Deputy Sheriff William Harrison Reams Laurel County Sheriff's Department, KY EOW: Friday, November 24, 1854 Cause of Death: Stabbed
125 Policeman John Sheldon Sonora Police Department, CA EOW: Sunday, April 29, 1855 Cause of Death: Stabbed
126 Sheriff William A. Phoenix Amador County Sheriff's Department, CA EOW: Sunday, August 12, 1855 Cause of Death: Gunfire
127 Indian Agent Andrew J. Bolon United States Department of the Interior - Bureau of Indian Affairs - Division of Law Enforcement, US EOW: Tuesday, September 25, 1855 Cause of Death: Stabbed
128 Private William H. Clopton Texas Rangers, TX EOW: Wednesday, October 3, 1855 Cause of Death: Gunfire
129 Private Willis E. Jones Texas Rangers, TX EOW: Wednesday, October 3, 1855 Cause of Death: Gunfire
130 Private H. K. Holland Texas Rangers, TX EOW: Wednesday, October 3, 1855 Cause of Death: Gunfire
131 Private Augustus Smith Texas Rangers, TX EOW: Wednesday, October 3, 1855 Cause of Death: Gunfire
132 Deputy Sheriff Charles Layton Monterey County Sheriff's Department, CA EOW: Saturday, November 10, 1855 Cause of Death: Gunfire
133 Deputy Sheriff Joaquin De La Torre Monterey County Sheriff's Department, CA EOW: Saturday, November 10, 1855 Cause of Death: Gunfire
134 Deputy Sheriff Jim Beckwith Monterey County Sheriff's Department, CA EOW: Saturday, November 10, 1855 Cause of Death: Gunfire
135 Marshal William H. Richardson United States Department of Justice - United States Marshals Service, US EOW: Saturday, November 17, 1855 Cause of Death: Gunfire
136 Night Watchman Thomas Cummins New Haven Police Department, CT EOW: Saturday, November 24, 1855 Cause of Death: Assault
137 Marshal Eli R. Doyle United States Department of Justice - United States Marshals Service, US EOW: Thursday, December 27, 1855 Cause of Death: Fall
138 Police Officer Alexander Algeo New Orleans Police Department, LA EOW: Wednesday, March 26, 1856 Cause of Death: Gunfire
139 Lieutenant Levi Parker Cincinnati Police Department, OH EOW: Sunday, May 4, 1856 Cause of Death: Gunfire
140 Watchman Neil Mooney Philadelphia Police Department, PA EOW: Sunday, May 25, 1856 Cause of Death: Gunfire
141 City Marshal David Johnson Nevada City Police Department, CA EOW: Monday, November 3, 1856 Cause of Death: Gunfire
142 Sheriff W. W. Wright Nevada County Sheriff's Office, CA EOW: Monday, November 3, 1856 Cause of Death: Gunfire
143 Sheriff John F. Taylor Winnebago County Sheriff's Office, IL EOW: Tuesday, November 11, 1856 Cause of Death: Gunfire
144 Night Watchman John Omayer Baltimore City Police Department, MD EOW: Thursday, November 13, 1856 Cause of Death: Gunfire (Accidental)
145 Police Officer William I. Van Arsdale New Brunswick Police Department, NJ EOW: Sunday, December 7, 1856 Cause of Death: Drowned
146 Deputy Warden Galen Carter Walker Massachusetts Department of Correction, MA EOW: Monday, December 15, 1856 Cause of Death: Stabbed
147 Warden Solon Tenney Massachusetts Department of Correction, MA EOW: Monday, December 29, 1856 Cause of Death: Stabbed
148 Sheriff James R. Barton Los Angeles County Sheriff's Department, CA EOW: Friday, January 23, 1857 Cause of Death: Gunfire
149 Constable Charles K. Baker Los Angeles County Sheriff's Department, CA EOW: Friday, January 23, 1857 Cause of Death: Gunfire
150 Deputy Charles T. Daly Los Angeles County Sheriff's Department, CA EOW: Friday, January 23, 1857 Cause of Death: Gunfire
151 Constable William H. Little Los Angeles County Sheriff's Department, CA EOW: Friday, January 23, 1857 Cause of Death: Gunfire
152 Sheriff James M. Land Estill County Sheriff's Department, KY EOW: Sunday, March 22, 1857 Cause of Death: Gunfire
153 Deputy Sheriff Jessie Arvin Estill County Sheriff's Department, KY EOW: Sunday, March 22, 1857 Cause of Death: Gunfire
154 Patrolman Stephen P. Hardenbrook New York Municipal Police Force, NY EOW: Wednesday, April 15, 1857 Cause of Death: Stabbed
155 Deputized Civilian William B.M. Barbee Burleson County Constable's Office - Precinct 3, TX EOW: Sunday, May 24, 1857 Cause of Death: Gunfire
156 Assistant City Marshal Frederick W. Fieldstrup San Antonio Police Department, TX EOW: Friday, May 29, 1857 Cause of Death: Gunfire
157 Special Patrolman Thomas Sparks New York Metropolitan Police Force, NY EOW: Thursday, July 9, 1857 Cause of Death: Assault
158 Patrolman Eugene Anderson New York Metropolitan Police Force, NY EOW: Monday, July 20, 1857 Cause of Death: Gunfire
159 Sergeant William Jourdan Baltimore City Police Department, MD EOW: Wednesday, October 14, 1857 Cause of Death: Gunfire
160 Patrolman Ezekiel Wentworth Hodsdon Boston Police Department, MA EOW: Sunday, October 18, 1857 Cause of Death: Gunfire
161 Patrolman Horatio Sanger New York Metropolitan Police Force, NY EOW: Sunday, November 22, 1857 Cause of Death: Assault
162 Sheriff William C. Getman Los Angeles County Sheriff's Department, CA EOW: Thursday, January 7, 1858 Cause of Death: Gunfire
163 Sheriff Samuel Lee Lockhart Llano County Sheriff's Office, TX EOW: Saturday, January 9, 1858 Cause of Death: Stabbed
164 Special Police Officer George C. Chapman Sacramento Police Department, CA EOW: Tuesday, April 27, 1858 Cause of Death: Gunfire
165 Private William Earbee Texas Rangers, TX EOW: Wednesday, May 5, 1858 Cause of Death: Gunfire (Accidental)
166 Private Robert Nickles Texas Rangers, TX EOW: Wednesday, May 12, 1858 Cause of Death: Stabbed
167 Private Waco Indian Texas Rangers, TX EOW: Wednesday, May 12, 1858 Cause of Death: Gunfire
168 City Marshal Joseph Beard Lexington Police Department, KY EOW: Saturday, July 10, 1858 Cause of Death: Stabbed
169 Deputy Sheriff Travis Gibson Campbell County Sheriff's Office, TN EOW: Tuesday, August 3, 1858 Cause of Death: Stabbed
170 Sheriff Sampson D. Queener Campbell County Sheriff's Office, TN EOW: Tuesday, August 3, 1858 Cause of Death: Stabbed
171 Patrolman George Coulter Louisville Police Department, KY EOW: Tuesday, August 17, 1858 Cause of Death: Gunfire
172 Police Officer Benjamin Benton Baltimore City Police Department, MD EOW: Wednesday, September 22, 1858 Cause of Death: Gunfire
173 Police Officer William Cooke Salt Lake City Police Department, UT EOW: Monday, October 18, 1858 Cause of Death: Gunfire
174 Police Officer Robert M. Rigdon Baltimore City Police Department, MD EOW: Monday, November 8, 1858 Cause of Death: Gunfire
175 Policeman Joel N. McDonald Columbia Police Department, CA EOW: Friday, November 26, 1858 Cause of Death: Gunfire
176 Constable John Leary Columbia Police Department, CA EOW: Monday, November 29, 1858 Cause of Death: Gunfire
177 Constable David Welch Henderson County Sheriff's Office, IL EOW: Tuesday, January 11, 1859 Cause of Death: Gunfire
178 Deputy Sheriff George W. Martin Placer County Sheriff's Department, CA EOW: Monday, July 11, 1859 Cause of Death: Gunfire
179 Jailer Robert L. Johnson Cameron County Sheriff's Office, TX EOW: Wednesday, September 28, 1859 Cause of Death: Gunfire
180 Constable George Morris Cameron County Constable's Office - Precinct 2, TX EOW: Wednesday, September 28, 1859 Cause of Death: Gunfire
181 Private John Fox Texas Rangers, TX EOW: Wednesday, November 16, 1859 Cause of Death: Gunfire
182 Private Thomas Grier Texas Rangers, TX EOW: Wednesday, November 16, 1859 Cause of Death: Gunfire
183 Private William McKay Texas Rangers, TX EOW: Wednesday, November 16, 1859 Cause of Death: Gunfire
184 Private Nicholas R. Milett Texas Rangers, TX EOW: Wednesday, November 16, 1859 Cause of Death: Gunfire
185 Private David Herman Texas Rangers, TX EOW: Wednesday, December 14, 1859 Cause of Death: Gunfire
186 Patrolman John Steward New York Metropolitan Police Force, NY EOW: Tuesday, December 20, 1859 Cause of Death: Structure collapse
187 Private Fountain B. Woodruff Texas Rangers, TX EOW: Saturday, February 4, 1860 Cause of Death: Gunfire
188 Sheriff Thomas S. Milligan Mason County Sheriff's Department, TX EOW: Sunday, February 19, 1860 Cause of Death: Assault
189 Officer C. Edward Foley Houston Police Department, TX EOW: Saturday, March 10, 1860 Cause of Death: Gunfire
190 Deputy U.S. Marshal Leonard Armes United States Department of Justice - United States Marshals Service, US EOW: Friday, April 20, 1860 Cause of Death: Gunfire
191 Patrolman W. Stith Tucker Memphis Police Department, TN EOW: Saturday, May 5, 1860 Cause of Death: Stabbed
192 Police Officer Levi Washington Davis Springville Police Department, UT EOW: Monday, May 7, 1860 Cause of Death: Gunfire
193 Patrol Officer William Loughrey Cambridge Police Department, MA EOW: Tuesday, June 26, 1860 Cause of Death: Stabbed
194 Deputy Sheriff Thomas Shain Collin County Sheriff's Office, TX EOW: Monday, July 2, 1860 Cause of Death: Gunfire
195 Constable Miles Huntsman Amador County Constable's Office, CA EOW: Thursday, July 26, 1860 Cause of Death: Gunfire
196 Deputy Thomas Nolan Nueces County Sheriff's Office, TX EOW: Wednesday, August 15, 1860 Cause of Death: Gunfire
197 Officer Claborne Long Cincinnati Police Department, OH EOW: Wednesday, January 9, 1861 Cause of Death: Stabbed
198 Officer Daniel Hallam Cincinnati Police Department, OH EOW: Thursday, January 10, 1861 Cause of Death: Stabbed
199 Sheriff Jesse Sut Harris Brown County Sheriff's Department, TX EOW: Thursday, June 6, 1861 Cause of Death: Gunfire
200 Officer Patrick Nuttle Cincinnati Police Department, OH EOW: Tuesday, June 11, 1861 Cause of Death: Stabbed

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
);
Powered by Datasette · Query took 11.917ms