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 2020

@kaggle.hemil26_mass_shootings_in_united_states_20182022.shootings_2020

46.52 KB
615 rows
6 columns

date Date	state State	dead Dead	injured Injured	total Total	description Description
Thu Dec 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Indiana	1	3	4	A shooting unfolded outside a nightclub on New Year's Eve that killed a man and sent three others to the hospital.
Thu Dec 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Oregon		4	4	Four people were wounded after a shooting at a party. All four are expected to survive.
Sun Dec 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	United States Virgin Islands		4	4	Four men were wounded after a shooting near a restaurant.
Sat Dec 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Massachusetts	1	5	6	Six people were wounded in an evening shooting. One of the victims later died at the hospital.
Sat Dec 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Illinois	3	3	6	Don Carter Lanes shooting: Three people are killed and three others injured in a shooting at a bowling alley. The shooter is believed to have selected his victims at random. A person of interest has been taken into custody by authorities.
Sat Dec 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Florida	2	2	4	Two men were killed and two injured in an early morning targeted shooting in Ybor City.
Sat Dec 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Florida	1	3	4	Three adults and a juvenile were wounded in an afternoon drive-by shooting. One of the wounded later died at the hospital.
Fri Dec 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Florida	1	4	5	Four people were injured and one was killed after a shooting on Christmas Day.
Fri Dec 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Arkansas	5		5	Five females aged between eight and fifty; three were children, were found killed by a family member. Police believe it was domestic related.
Thu Dec 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Florida	1	4	5	After a teenager got into a conflict with another group, four people were injured and one was killed after a shooting at the teenager's home.


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