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
2006	1	Suicide	M	81	White	100	Home	HS/GED
2006	1	Homicide	M	55	White	100	Other unspecified	Less than HS
2006	1	Homicide	M	19	Black	100	Home	Less than HS
2006	1	Homicide	M	33	Black	100	Other unspecified	Less than HS
2006	1	Homicide	M	23	Black	100	Home	Less than HS
2006	1	Suicide	M	88	White	100	Home	Less than HS
2006	1	Suicide	M	23	White	100	Home	HS/GED
2006	1	Homicide	M	23	Hispanic	211	Home	HS/GED
2006	1	Homicide	M	43	Black	100	Home	Less than HS
2006	1	Homicide	M	23	Black	100	Home	HS/GED


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