Dataset: US Mass Shooting 1966 - 2019

About this Dataset

US Mass Shooting 1966 - 2019

One can easily find postings, articles, etc… in social network about mass shooting, gun violence, it's frequency, impacts, severity, and so on. However, one might be curious in its details of what the root causes are? where are common incident areas? Are those shooters mostly have mental health problem or some kind of severe psycho as everyone has mentioned about? What are those shooters features? How are their behaviors, age range, race, etc? or is there any correlational relationships between those features that helps us understand more about them and their motives?
By having more insight of US Mass shooting cases, its common root cause, features of shooter and other related aspects, it might help every single individual to recognize sign of a mass shooter or can even have solutions on education, mental balance support, and obligation for preventing such tragedy to contribute to a better healthier society. For my world fellow friends, hope you all have a quality data source for your references, analysis and learning.

Content

This data covers raw data of mass shooting cases in US from 1966-2019. In fact it does not cover all cases but it gives analyst/ viewer a general viewpoint of gun violence situation in US. For my analysis on this data please find in links below:
• US Mass Shooting 1: Overview Analysis and Root Cause 1966-2019
• US Mass Shooting 1: Shooter’s Analysis 1966-2019

Data structure shown in sheet "Data Structure". Data includes:
• Fields: 24
• Rows: 339 (339 cases)
• Data coverage: partial (not included all mass shooting cases but typical ones) data from 1966-2019
• Cleaned: Yes
• Data cleaning procedure: click here
• Original data source: (1) https://www.kaggle.com/zusmani/us-mass-shootings-last-50-years?select=Mass+Shootings+Dataset.csv , (2) https://www.motherjones.com/politics/2012/12/mass-shootings-mother-jones-full-data/
• Original data problems: Missing data, duplicate data, null data, partial or incomplete data (incomplete location name, missing latitude, longtitude, etc.), incorrect information (number of victims, etc.).

Acknowledgements

Thanks Zeeshan-ul-hassan Usmani and motherjones.com team for your contribution and wish everyone all the best.

Tables

Data Structure

@kaggle.myho63_us_mass_shooting_1966_2019.data_structure

6.2 KB
24 rows
6 columns


CREATE TABLE data_structure (
  "data_structure" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" DOUBLE,
  "meaning" VARCHAR
);

Us Mass Shooting 1966–2019 Cleaned

@kaggle.myho63_us_mass_shooting_1966_2019.us_mass_shooting_1966_2019_cleaned

101.15 KB
339 rows
24 columns


CREATE TABLE us_mass_shooting_1966_2019_cleaned (
  "s" BIGINT,
  "title" VARCHAR,
  "location" VARCHAR,
  "date" TIMESTAMP,
  "area" VARCHAR,
  "incident_area" VARCHAR,
  "open_close_location" VARCHAR,
  "target" VARCHAR,
  "cause" VARCHAR,
  "summary" VARCHAR,
  "shooter_status" VARCHAR,
  "no_of_shooter_suspect" VARCHAR,
  "fatalities" BIGINT,
  "injured" BIGINT,
  "total_victims" BIGINT,
  "policeman_killed" BIGINT,
  "age" VARCHAR,
  "employeed_y_n" BIGINT,
  "employed_at" VARCHAR,
  "mental_health_issues" VARCHAR,
  "race" VARCHAR,
  "gender" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);