Gun Deaths In The US: 2006 - 2020

year Year	month Month	intent Intent	police Police	sex Sex	age Age	race Race	hispanic Hispanic	place Place	education Education
2009	1	Suicide		M	46	White	100	Home	HS/GED
2009	1	Suicide		M	33	Native American/Native Alaskan	100	Home	HS/GED
2009	2	Homicide	1	F	38	White	100	nan	HS/GED
2009	2	Suicide		F	35	Native American/Native Alaskan	100	Home	Some college
2009	2	Suicide		M	33	White	100	Home	HS/GED
2009	2	Suicide		M	22	Native American/Native Alaskan	100	Other specified	HS/GED
2009	3	Homicide		M	15	Native American/Native Alaskan	100	Home	Less than HS
2009	2	Suicide		M	39	White	100	Home	Some college
2009	2	Suicide		M	50	Asian/Pacific Islander	100	Other specified	nan
2009	2	Homicide		M	19	Native American/Native Alaskan	100	Other unspecified	Less than HS


CREATE TABLE guns_2009 (
  "year" BIGINT,
  "month" BIGINT,
  "intent" VARCHAR,
  "police" BIGINT,
  "sex" VARCHAR,
  "age" DOUBLE,
  "race" VARCHAR,
  "hispanic" BIGINT,
  "place" VARCHAR,
  "education" VARCHAR
);