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