Mass Shooting in USA

#Introduction
After two mass shooting in two consecutive days in USA I wanted to make a quick analysis of mass shooting data. I found a website that collects this data from 1982 till July-2019.

I was interested in number of fatalities, date and race.
The cover image shows the locations of the incidents on the map of USA with disks sizes proportional to the number of fatalities with the latest two shootings highlighted in light blue.

#Fatalities over time
Number of fatalities over time shows an increase in rate and number of fatalities over time specially in the last 10 years.

note that the orange entries represents the latest two shootings!

The Yearly rate of mass shooting is obviously high in recent years

Finding total number of fatalities per year after adding the two recent incidences support the same results.

It also shows that the year 2017 has the highest number of fatalities as a result of mass shootings with total number of fatalities 117.

Also the top 10 years in terms of number of mass shootings are all in the last 10 years except 1999 as shown in the following table:-

4.jpg

In these 10 years the shooters were mostly white in race!

Finally the notebook and data files are included for more analysis.

Mother Jones - Mass Shootings Database, 1982 - 2019.xlsx (72.2 KB)
analysis.nb (650 KB)

5 Likes

Nice post! Have you seen this one by @Marco Thiel and is there data difference?

Hi Kapio

No, but I just did, great article which shows a striking correlation between shop density and locations of shootings. The Mass shooting data in Marco’s is different from the one I used.The later is more detailed and contains only main incidents since 1982 till now. I created this notebook and post in just one hour, mainly to just answer my own questions after reading the sad news while sitting on the beach so it was not meant to be a real data analysis.
This data is very well organized and detailed, hope me or someone else will have some time and give it a deep analysis like Correlation testing, Clustering, modeling …etc.

2 Likes

2015-11-02_10-07-11.png

1 Like

Thanks, it is an honor.