Dataset: Mass Shootings In United States (2018-2022)

About this Dataset

Mass Shootings In United States (2018-2022)

Context

1 in 4 mass shooting victims were children and teens. In the years between 2009 and 2020, the horrific scenes of mass shootings have haunted the nation’s collective conscience.US states with weaker gun laws and higher gun ownership rates have higher rates of mass shootings. Mass shooting is defined as any incident in which four or more people are shot and killed, excluding the shooter. The number of mass shootings that plague this country is far too high, and the counts are just a small fraction of the lives left forever changed after the tragedy of a mass shooting. So here is the data for list of mass shootings in United States from 2018 - 2022.

Content

This dataset has five csv files of years 2018 - 2022. Each data contains following attributes

Date : The date on which the mass shooting incident happened
State : The state where the incident took place
Dead : total number of people died in mass shooting
Injured: total number of people who got injured in mass shooting-
Total : total of dead and injured people
Description : description/short report of the incident which may include information like gender/place etc.
Data for 2022 Mass shootings will be updated every 15 days!

Acknowledgements

This data was scraped from https://en.wikipedia.org/wiki/List_of_mass_shootings_in_the_United_States using BeautifulSoup.

Image banner by Wall Street Journal

Inspiration

EDA and Viz.
Which state has highest number of mass shootings
Contextual analysis of the description column
Trend of mass shooting in past years
Number of people killed/injured on an average in a month.

Check out my other works

Tables

Shootings 2018

@kaggle.hemil26_mass_shootings_in_united_states_20182022.shootings_2018

24.55 KB
322 rows
6 columns


CREATE TABLE shootings_2018 (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "dead" BIGINT,
  "injured" BIGINT,
  "total" BIGINT,
  "description" VARCHAR
);

Shootings 2019

@kaggle.hemil26_mass_shootings_in_united_states_20182022.shootings_2019

29.7 KB
441 rows
6 columns


CREATE TABLE shootings_2019 (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "dead" BIGINT,
  "injured" BIGINT,
  "total" BIGINT,
  "description" VARCHAR
);

Shootings 2020

@kaggle.hemil26_mass_shootings_in_united_states_20182022.shootings_2020

46.52 KB
615 rows
6 columns


CREATE TABLE shootings_2020 (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "dead" BIGINT,
  "injured" BIGINT,
  "total" BIGINT,
  "description" VARCHAR
);

Shootings 2021

@kaggle.hemil26_mass_shootings_in_united_states_20182022.shootings_2021

43.02 KB
694 rows
6 columns


CREATE TABLE shootings_2021 (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "dead" BIGINT,
  "injured" BIGINT,
  "total" BIGINT,
  "description" VARCHAR
);

Shootings 2022

@kaggle.hemil26_mass_shootings_in_united_states_20182022.shootings_2022

26.67 KB
284 rows
6 columns


CREATE TABLE shootings_2022 (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "dead" BIGINT,
  "injured" BIGINT,
  "total" BIGINT,
  "description" VARCHAR
);