Dataset: Gun Deaths In The US: 2006 - 2020

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

99.08 KB
30896 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

100.67 KB
31224 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

100.86 KB
31593 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

99.78 KB
31347 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

100.87 KB
31672 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

102.32 KB
32351 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

105.23 KB
33563 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

107.16 KB
33636 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

104.8 KB
33599 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

114.81 KB
36252 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

115.24 KB
38658 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

123.9 KB
39773 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

123.51 KB
39740 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

126.12 KB
39707 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

144.03 KB
45222 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
);