Name: Gun Deaths In The US: 2006 - 2020
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

Gun Deaths In The US: 2006 - 2020

Updated dataset for the "Gun Deaths in America" project https://fivethirtyeight.com/features/gun-deaths/, documenting firearm usage fatalities.

The R code for processing the raw data is taken from https://github.com/fivethirtyeight/guns-data

I will be progressively adding the years before 2006, but the data format changed several times, so it is not as fast as I would like :-/ User guide for processing: https://www.cdc.gov/nchs/nvss/mortality_public_use_data.htm

Tables

Guns 2006

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2006

101.46 kB
30,896 rows
10 columns

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

Guns 2007

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2007

103.08 kB
31,224 rows
10 columns

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

Guns 2008

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2008

103.28 kB
31,593 rows
10 columns

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

Guns 2009

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2009

102.18 kB
31,347 rows
10 columns

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

Guns 2010

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2010

103.29 kB
31,672 rows
10 columns

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

Guns 2011

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2011

104.77 kB
32,351 rows
10 columns

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

Guns 2012

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2012

107.75 kB
33,563 rows
10 columns

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

Guns 2013

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2013

109.73 kB
33,636 rows
10 columns

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

Guns 2014

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2014

107.32 kB
33,599 rows
10 columns

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

Guns 2015

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2015

117.57 kB
36,252 rows
10 columns

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

Guns 2016

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2016

118 kB
38,658 rows
10 columns

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

Guns 2017

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2017

126.87 kB
39,773 rows
10 columns

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

Guns 2018

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2018

126.47 kB
39,740 rows
10 columns

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

Guns 2019

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2019

129.15 kB
39,707 rows
10 columns

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

Guns 2020

@kaggle.konradb_gun_deaths_in_the_us_1968_2021.guns_2020

147.48 kB
45,222 rows
10 columns

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