Mass Shootings In United States (2018-2022)

List of Mass shootings in US

@kaggle.hemil26_mass_shootings_in_united_states_20182022

Table List

5 tables(170.44 KB)

Shootings 2021

@kaggle.hemil26_mass_shootings_in_united_states_20182022.shootings_2021

43.02 KB
694 rows
6 columns

date Date	state State	dead Dead	injured Injured	total Total	description Description
Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Maryland		4	4	An adult and three juveniles were wounded in an evening shooting.
Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	California		6	6	Six shoppers were wounded at a grocery supermarket by two shooters.
Fri Dec 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mississippi	4	3	7	During an outdoor New Year's Eve party, a physical fight started escalated to a shooting, with multiple people firing guns.
Thu Dec 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Pennsylvania		6	6	Six shooters opened fire on a busy street with six wounded.
Thu Dec 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Missouri	2	2	4	An adult and infant were killed and two adults wounded in an afternoon shooting.
Mon Dec 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Alabama	1	3	4	A man was killed and three others wounded at a local gas station.
Mon Dec 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Colorado	6	2	8	A gunman went on a shooting spree across multiple locations in the Denver metropolitan area before dying in a shootout with police.
Mon Dec 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Ohio	1	3	4	A man was killed and three others were wounded at a local apartment complex.
Sun Dec 26 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	New York		4	4	Four adults were wounded inside a pop-up store.
Sun Dec 26 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Virginia	1	4	5	Four people were wounded at a rest stop, and the shooter fled before police arrived. The shooter was later found dead.


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