How bad is gun crime in the US? The latest data from the FBI's uniform crime reports provides a fascinating picture of the use of firearms in crimes across America.
Barack Obama is under pressure to tighten gun laws after following the disclosure by police that the Newtown gunman used a semi-automatic assault rifle equipped with "numerous" high-capacity magazines holding hundreds of bullets to carry out his massacre of young children.
And the murder figures themselves are astounding for Brits used to around 550 murders per year. In 2011 - the latest year for which detailed statistics are available - there were 12,664 murders in the US. Of those, 8,583 were caused by firearms.
The FBI crime statistics are based on reports to FBI bureau and local law enforcement. The figures are not complete - there are no stats for Florida or Alabama on firearm murders. But even so it provides a detailed picture of attacks by state.
In fact, gun crime, like all crime across the US (and the UK, for that matter), is going down - you can see how much in the graph above. And the vast majority invlove firearms.
The figures show that California had the highest number of gun murders last year - 1,790, which is 68% of all murders that year and equivalent to 3.25 per 100,000 people in the state. Big as that figure is, it's still down by 3% on the previous year. Other key findings include:
• While gun crime is down in the vast majority of states, it is up in Indiana, Arkansas, North Carolina, Louisiana and several of the smaller states
• If you look at the firearms murder rate per 100,000 people, District of Columbia comes out top - with 12 firearms murders per 100,000 men, women and children in the state. There were 77 firearms murders in DC in 2010, down 22% on 2009
• DC is followed by Louisiana (10.16) and Mississippi (7.46)
• DC is also top for firearms robberies per 100,000 people - with 242.56
• If you look at aggravated assaults involving a firearm, Tennessee (137.58) and South Carolina (127.88) come above Arkansas (100.56)
The full data is below. What can you do with it?
Data summary
State
|
Total
firearms murders, 2011
|
% change, 2010-11
|
Fire- arms murders as % of all murders
|
Fire- arms murders rate
|
Fire- arms robb- eries rate
|
Fire- arms assaults rate
|
---|---|---|---|---|---|---|
RATES ARE PER 100,000 PEOPLE. SOURCE: FBI UNIFORM CRIME REPORTS NO DATA FOR FLORIDA OR ALABAMA |
||||||
United States | 8,583 | -3 | 68 | 2.75 | 39.25 | 43.77 |
Alaska | 16 | -16 | 55 | 2.24 | 18.19 | 80.47 |
Arizona | 222 | -4 | 65 | 3.53 | 50.24 | 57.36 |
Arkansas | 110 | 18 | 72 | 4.39 | 45.45 | 100.56 |
California | 1,220 | -3 | 68 | 3.25 | 42.97 | 45.39 |
Colorado | 73 | 12 | 50 | 1.51 | 25.74 | 45.72 |
Connecticut | 94 | -3 | 73 | 2.71 | 34.85 | 20.06 |
Delaware | 28 | -26 | 68 | 3.09 | 69.67 | 81.36 |
District of Columbia | 77 | -22 | 71 | 12.46 | 242.56 | 87.7 |
Georgia | 370 | -2 | 71 | 3.93 | 72.48 | 58.64 |
Hawaii | 1 | -86 | 14 | 0.07 | n/a | n/a |
Idaho | 17 | 42 | 53 | 1.14 | 3.41 | 23.43 |
Illinois | 377 | 4 | 83 | 2.93 | 2.26 | 5.26 |
Indiana | 183 | 29 | 64 | 3.29 | 53.14 | 29.91 |
Iowa | 19 | -10 | 43 | 0.71 | 7.31 | 21.95 |
Kansas | 73 | 16 | 66 | 2.78 | 24.86 | 76.87 |
Kentucky | 100 | -14 | 67 | 2.36 | 39.77 | 25.14 |
Louisiana | 402 | 15 | 83 | 10.16 | 63.48 | 99.51 |
Maine | 12 | 9 | 48 | 0.9 | 5.8 | 4.52 |
Maryland | 272 | -7 | 68 | 4.7 | 79.71 | 41.18 |
Massachusetts | 122 | 3 | 67 | 2.02 | 27.84 | 33.19 |
Michigan | 450 | 9 | 73 | 5.06 | 55.95 | 86.41 |
Minnesota | 43 | -19 | 61 | 0.82 | 20.11 | 22.52 |
Mississippi | 138 | 15 | 74 | 7.46 | 60.07 | 51.69 |
Missouri | 276 | -14 | 76 | 4.64 | 52.47 | 88.9 |
Montana | 7 | -42 | 39 | 0.76 | 3.78 | 29.03 |
Nebraska | 42 | 31 | 65 | 2.5 | 25.44 | 33.84 |
Nevada | 75 | -11 | 58 | 3.07 | 69.77 | 53.3 |
New Hampshire | 6 | 20 | 38 | 0.53 | 9.83 | 15.14 |
New Jersey | 269 | 9 | 71 | 3.07 | 49.87 | 26.94 |
New Mexico | 60 | -10 | 50 | 2.98 | 34.96 | 87.26 |
New York | 445 | -14 | 57 | 4.12 | 23.28 | 20.06 |
North Carolina | 335 | 17 | 69 | 3.87 | 48.72 | 67.44 |
North Dakota | 6 | 50 | 50 | 0.93 | 4.79 | 4.79 |
Ohio | 344 | 11 | 70 | 3.54 | 65.45 | 37.97 |
Oklahoma | 131 | 18 | 64 | 3.64 | 42.81 | 58.07 |
Oregon | 40 | 11 | 52 | 1.05 | 14.57 | 17.55 |
Pennsylvania | 470 | 3 | 74 | 3.97 | 54.69 | 39.44 |
Rhode Island | 5 | -69 | 36 | 0.57 | 12.71 | 17.86 |
South Carolina | 223 | 8 | 70 | 5.41 | 52.93 | 127.88 |
South Dakota | 5 | -38 | 33 | 0.68 | 4.91 | 20.6 |
Tennessee | 244 | 11 | 65 | 3.92 | 72.88 | 137.58 |
Texas | 699 | -13 | 64 | 2.91 | 50.21 | 58.28 |
Utah | 26 | 18 | 51 | 0.97 | 10.98 | 21.32 |
Vermont | 4 | 100 | 50 | 0.75 | 4.32 | 12.6 |
Virginia | 208 | -17 | 69 | 2.58 | 35.4 | 21.35 |
Washington | 79 | -15 | 49 | 1.25 | 20.72 | 28.44 |
West Virginia | 43 | 59 | 58 | 2.87 | 16.08 | 52.04 |
Wisconsin | 80 | -18 | 59 | 1.47 | 43.86 | 27.4 |
Wyoming | 11 | 120 | 73 | 2.01 | 3.65 | 20.44 |
Download the data
• DATA: download the full spreadsheet
SOURCE: FBI UNIFORM CRIME REPORTS
More open data
Data journalism and data visualisations from the Guardian
World government data
• Search the world's government data with our gateway
Development and aid data
• Search the world's global development data with our gateway
Can you do something with this data?
• Flickr Please post your visualisations and mash-ups on our Flickr group
• Contact us at data@guardian.co.uk
• Get the A-Z of data
• More at the Datastore directory
• Follow us on Twitter
• Like us on Facebook