Gun Deaths In The US: 2006 - 2020

year Year	month Month	intent Intent	sex Sex	age Age	race Race	hispanic Hispanic	place Place	education Education
2008	1	Suicide	M	45	White	100	Other specified	Less than HS
2008	1	Suicide	M	35	White	100	Other unspecified	HS/GED
2008	1	Suicide	M	64	White	100	Home	BA+
2008	1	Suicide	M	22	White	100	Other specified	Some college
2008	1	Suicide	F	22	White	100	Home	HS/GED
2008	1	Suicide	F	20	White	100	Home	Some college
2008	1	Suicide	M	42	Native American/Native Alaskan	100	Home	Less than HS
2008	1	Homicide	M	43	White	100	Home	HS/GED
2008	1	Suicide	M	65	White	100	Home	BA+
2008	1	Homicide	M	34	Black	100	Home	HS/GED


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