Police Fatalities From 2000 To 2016

Updated and modified dataset

@kaggle.hamdallak_police_fatalities_from_2000_to_2016

Table List

1 table(414.11 KB)

Policefatalities2

@kaggle.hamdallak_police_fatalities_from_2000_to_2016.policefatalities2

414.11 KB
12479 rows
19 columns

uid UID	name Name	age Age	stages_of_life Stages Of Life	gender Gender	race Race	date Date	year Year	quarter Quarter	month Month	week Week	day Day	city City	state State	region Region	manner_of_death Manner Of Death	armed Armed	mental_illness Mental Illness
133	Karen O. Chin	44	Middle Age Adult	Female	Asian	Thu May 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2000	2	5	18	4	Alameda	California	west	Shot	UnKnown
169	Chyraphone Komvongsa	26	Adult	Male	Asian	Fri Jun 02 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2000	2	6	22	2	Fresno	California	west	Shot	UnKnown
257	Ming Chinh Ly	36	Adult	Male	Asian	Sun Aug 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	2000	3	8	32	13	Rosemead	California	west	Shot	Gun
483	Kinh Quoc Dao	29	Adult	Male	Asian	Fri Feb 09 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	2001	1	2	6	9	Valley Glen	California	west	Shot	Gun
655	Vanpaseuth Phaisouphanh	25	Adult	Male	Asian	Sun Jun 10 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	2001	2	6	23	10	Riverside	California	west	Shot	Knife
668	Bernardo Ancheta Caberto	55	Middle Age Adult	Male	Asian	Sat Jun 23 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	2001	2	6	25	23	Henderson	Nevada	west	Shot	Knife
677	Cuong Tran	33	Adult	Male	Asian	Sat Jun 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	2001	2	6	26	30	Syracuse	New York	northeast	Shot	UnKnown	true
678	Sengsadaphet Phongsavanh	29	Adult	Male	Asian	Sun Jul 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	2001	3	7	26	1	Beaverton	Oregon	west	Shot	Knife	true
686	Nam Quoc Nguyen	21	Adult	Male	Asian	Fri Jul 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	2001	3	7	27	6	Garden Grove	California	west	Shot	Gun
736	Rosa Hammer	27	Adult	Female	Asian	Thu Aug 09 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	2001	3	8	32	9	Gorst	Washington	west	Shot	Gun


CREATE TABLE policefatalities2 (
  "uid" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "stages_of_life" VARCHAR,
  "gender" VARCHAR,
  "race" VARCHAR,
  "date" TIMESTAMP,
  "year" BIGINT,
  "quarter" BIGINT,
  "month" BIGINT,
  "week" BIGINT,
  "day" BIGINT,
  "city" VARCHAR,
  "state" VARCHAR,
  "region" VARCHAR,
  "manner_of_death" VARCHAR,
  "armed" VARCHAR,
  "mental_illness" BOOLEAN,
  "flee" BOOLEAN
);