Name: Police Fatalities From 2000 To 2016
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Police Fatalities From 2000 To 2016

Police fatalities from 2000 to 2016

This dataset aims to provide insight into individuals who were killed during altercations with police. It includes information on their age, race, mental health status, weapons they were armed with, and if they were fleeing.

Content

some of the features are in the original data and the others were added in this updated version.

UID, Unique ID of the murdered, In the original data
Name, The name of the murdered, In the original data
Age, The age of the murdered, In the original data
Stages of Life, The age stage of the murdered, Added in this updated version
Gender, The Gender of the murdered, In the original data
Race, The Race of the murdered, In the original data
Date, The date of death, In the original data
Year, The year in which the death occurred, Added in this updated version
Quarter, The Quarter in which the death occurred, Added in this updated version
Month, The month in which the death occurred, Added in this updated version
Week, The week in which the death occurred, Added in this updated version
Day, The day in which the death occurred, Added in this updated version
City, The City in which the death occurred, In the original data
State, The State in which the death occurred, In the original data
Region, The Region in which the death occurred, Added in this updated version
Manner of death In what way was the victim killed?, In the original data
Armed, Did the victim have a weapon?, In the original data
Mental illness, Was the victim mentally ill?, In the original data
Flee, Did the victim try to escape?, In the original data

Acknowledgements

This dataset comes from https://data.world/awram/us-police-involved-fatalities.

Tables

Policefatalities2

@kaggle.hamdallak_police_fatalities_from_2000_to_2016.policefatalities2

424.05 kB
12,479 rows
19 columns

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
);