Skip to Content

Analyzing US gun crime statistics using SAP Lumira

     I just made this simple analysis using SAP Lumira to let people know about gun crimes in America. US has the highest gun ownership rate in the world according to the reports there are 89 guns for every 100 Americans, compared to 6 in England and Wales.  In this blog, I tried to analyze the gun crimes in various states of America in the year 2010 with the help of SAP Lumira.

     I got this latest data from FBI Uniform crime reports which provide the interesting picture of the use of firearm crimes across America. The dataset that I took contains the data related to firearms murders, robberies and attacks and I downloaded from the below link.

I hope this analysis will answer the below queries:

1. Which state is leading in total fire arms murders?

2. How many firearm assaults per 100,000 population?

3. What is percentage change when it is compared with previous year?

4. How many firearm murders per 100,000 population?

5. How many firearm robberies per 100,000 population?

SAP Lumira helped me to answer above questions and it will helps to take measures to reduce the gun crimes in US for the coming years.


1. Total firearm murders:


From the above it is clear that California is having the highest total fire arms murders with 1,257 and next to that Texas is in leading with 805 firearm murders. The least number of firearm murders took place in Vermont and North Dakota with 2 and 4 murders respectively.

2.     Total firearm assaults per 100,000 population:


From the below graph it is clear that Tennessee is leading with 137.57 firearm assaults and next South California with 127.8.  Maine and North Dakota having least number of firearm assaults with 4.52 and 4.79 assaults respectively.

3. Percentage change between 2010-2011:


Wyoming and Vermont are having the highest % change with 120% and 100% respectively, which means firearm crimes in these states are increases to more that 100%. Hawaii is having -85 % and Rhode Island is having -65 % changes in firearm crimes.

4.  Firearm murders per 100,000 population:

From the below geographic bubble chart representation District Columbia and Louisiana having the highest number of murders per 100,000 populations with 12.45 and 12.15 respectively. Hawaii and New Hampshire is having the least number of murders per 100,000 populations with 0.07 and 0.53 respectively.


5. Firearm robberies per 100,000 population:


The above Tree map chart describes the firearm robberies per 100,000 populations with District of Columbia and Maryland having the highest number with 242.5 and 79.7 respectively. Illinois is having least with 2.2 firearm robberies per 100,000 populations.


Even though gun crimes has been reduced a lot when compared with last 2 decades still it has to come down when comparing with other countries. I hope this analysis using SAP Lumira will give idea to the governments and local authorities to define policies and strategies to reduce gun trafficking and violence in different states of America.

You must be Logged on to comment or reply to a post.