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 2022

@kaggle.hemil26_mass_shootings_in_united_states_20182022.shootings_2022

26.67 KB
284 rows
6 columns

date Date	state State	dead Dead	injured Injured	total Total	description Description
Sun Jun 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	South Carolina		4	4	Four people were injured in a drive-by shooting shortly before midnight.
Sun Jun 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Michigan	3	2	5	Three people were killed and two others wounded in a shooting during the early morning.
Sun Jun 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Arizona	2	2	4	Two people were killed and two others injured in a shooting outside a nightclub.
Sun Jun 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tennessee	2	12	14	2022 Chattanooga shooting: Fourteen were shot, two of them fatally, at a nightclub during the early morning. A third person was killed by a vehicle attempting to flee.
Sun Jun 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Michigan	1	3	4	One person was killed and three others injured in an early morning shooting at the Festival of the Arts.
Sat Jun 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	South Carolina	1	7	8	Eight people, including six children, were shot during a graduation party after occupants in two cars opened fire at the partygoers in the yard of the house it was being held at. An adult woman was killed.
Sat Jun 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Pennsylvania	3	11	14	2022 Philadelphia shooting: Fourteen people were shot, three of them fatally, by multiple shooters on South Street. One of the shooters may have been shot by a responding police officer.
Sat Jun 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	New York	1	3	4	A teenager was fatally shot, and three others were wounded.
Sat Jun 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Nevada		4	4	A couple was arrested after the boyfriend shot three people during an argument. The boyfriend was also shot.
Sat Jun 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Georgia	1	3	4	Four people were shot, one fatally, at an abandoned home.


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