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
2007	1	Suicide	M	35	White	100	Other unspecified	HS/GED
2007	1	Suicide	M	51	White	100	Other unspecified	Less than HS
2007	1	Homicide	M	34	Black	100	Other specified	HS/GED
2007	1	Suicide	M	43	White	100	Other unspecified	HS/GED
2007	1	Homicide	F	20	Black	100	Home	HS/GED
2007	1	Homicide	F	35	White	100	Home	HS/GED
2007	1	Suicide	M	68	White	100	Home	HS/GED
2007	1	Suicide	M	62	White	100	Sports	BA+
2007	1	Suicide	M	97	White	100	Other unspecified	Less than HS
2007	1	Suicide	M	41	White	100	Home	Some college


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