Police Deaths: clean_data.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
5 rows where "date" is on date 1900-09-08
This data as json, copyable, CSV (advanced)
Suggested facets: dept, cause, cause_short, dept_name, state
Link | rowid ▼ | person | dept | eow | cause | cause_short | date | year | canine | dept_name | state |
---|---|---|---|---|---|---|---|---|---|---|---|
1975 | 1975 | Police Officer Adolph Howe | Galveston Police Department, TX | EOW: Saturday, September 8, 1900 | Cause of Death: Weather/Natural disaster | Weather/Natural disaster | 1900-09-08 | 1900 | 0 | Galveston Police Department | TX |
1976 | 1976 | Police Officer Charles Wolfe | Galveston Police Department, TX | EOW: Saturday, September 8, 1900 | Cause of Death: Weather/Natural disaster | Weather/Natural disaster | 1900-09-08 | 1900 | 0 | Galveston Police Department | TX |
1977 | 1977 | Police Officer Frederick L. Richards | Galveston Police Department, TX | EOW: Saturday, September 8, 1900 | Cause of Death: Weather/Natural disaster | Weather/Natural disaster | 1900-09-08 | 1900 | 0 | Galveston Police Department | TX |
1978 | 1978 | Police Officer Samuel Eugene Tovrea | Galveston Police Department, TX | EOW: Saturday, September 8, 1900 | Cause of Death: Weather/Natural disaster | Weather/Natural disaster | 1900-09-08 | 1900 | 0 | Galveston Police Department | TX |
1979 | 1979 | Patrolman T. Perry Gates | LaCrosse Police Department, WI | EOW: Saturday, September 8, 1900 | Cause of Death: Gunfire | Gunfire | 1900-09-08 | 1900 | 0 | LaCrosse Police Department | WI |
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 );