FBI Crime Stats 2011 Q1 & Q2

Status
Not open for further replies.
Joined
Mar 22, 2009
Messages
3,401
Location
Illinois
This is the 2nd year where I have denormalized the FBI Crime Stats. The spreadsheet covers the 1st half of 2011 (data available as of this post) and is a compilation of the 5 FBI tables for crime by State. Truly interesting numbers. Instead of percentages, I translated the incidents into PER 10,000 - somewhat more digestible as compared to a murder rate of 0.80% of the population. I've also added a ranking column where the filters when sorted highest to lowest will give you a city's ranking for that type of crime.

Please let me know if I had screwed anything up and I will fix it. I kind of did this on the fly because of some of the nonsense spewed from certain individuals about crime and blah blah blah - it's not as bad as you think...blah blah blah... Well, got news for all y'all - in some areas it worst than you think...
 

Attachments

  • Denormalized Q1-Q2 2011 FBI Crime Stats.zip
    145.8 KB · Views: 102
Last edited:
At least if you did mess something up, it wasn't deliberate...

http://www.jsonline.com/watchdog/wa...ukee-police-department-v44ce4p-152862135.html
JOURNAL SENTINEL WATCHDOG REPORT
Hundreds of assault cases misreported by Milwaukee Police Department
City's violent crime rate lowered based on faulty data
===============

http://www.milwaukeemag.com/article/5242012-MissingData
Missing Data
MPD may be dragging its feet on crime stats, but a blockbuster Journal Sentinel story misses some information, too. BY ERIK GUNN 5/24/2012
 
hmm, interesting figures...and an interesting article... who wouldve thought that someone would fudge numbers to look better? (/sarc)

also, thanks for doing the spreadsheet!
 
Statistics are only as reliable as their sources, and only as useful as their interpretation... or misinterpretation as the case may be. One of my favorite book titles while I was still working was Lies, Damn Lies and Statistics...

The main point to all my rambling on this thread is, 'crime statistics' have limited utility (more so in some places than others) in predicting how safe a given area actually is. Most university campuses, for example, drastically under-report crime numbers where their students are victims simply because the crimes often happen on the fringes of campus and not actually on campus.

Be alert everywhere...
=================

http://nation.foxnews.com/chicago/2...ors-war-zone-federal-data-shows#ixzz1wZERGGvQ
May 31, 2012
Chicago's Murder Rate Mirrors War Zone, Federal Data Shows
With NATO summit over, city’s crime back on front-burner
By NOLAN PETERSON
Medill News Service

If Chicago were a war zone, it would be a deadlier one for Americans than Afghanistan.

In fact, according to the Department of Defense and FBI data, the number of Chicagoans murdered is two and a half times U.S. soldiers killed in Afghanistan since 2001.

With NATO in the rear-view mirror, area law enforcement officials and politicians will turn their attention away from unruly protestors back to the city's rising murder rate - up 54 percent from last year, according to police data.

Last week, Mayor Rahm Emanuel announced a new strategy to combat gang activity in crime hot spots to halt the killing. The strategy, called a "wraparound plan," focuses on improving neighborhood services after police descend on an area to target and remove gangs.

"Once we make arrests, and we eliminate a narcotics organization, we are committed to holding onto that turf, to that territory, to squeeze out the drug market and the violence," said Chicago Police Supt. Garry McCarthy last week.

Homicides in Chicago have spiked this year, though overall crime is down. Chicago has had 169 murders in 2012, compared to 110 at the same date last year. Overall, the city's crime rate is down 11 percent from last year.

According to FBI and Department of Defense data, 5,056 people have been murdered in Chicago since 2001, compared with 1,976 total U.S. deaths in Afghanistan since 2001. Chicago's murder rate even outpaces total NATO coalition fatalities in Afghanistan since 2001 by a difference of more than 2,500 killed.
///snip
 
Hats off to a good and interesting chart.
No surprise to me that Houston is way ahead of every other city in Texas in major crimes.
Hear about each and every single day.
It is not decreasing here at all.
 
Holy Cow!

I didn't realize Memphis, TN had gotten so bad...I grew up there, so I knew there were some bad areas, but it is ROUGH there now..
 
I feel fortunate to live where I do. Crime isn't as common in Oregon as it is in many places, and our gun laws are great.

If anything, it could be said that the biggest danger here is the sense that "it won't happen to me". The low crime rate here becomes a sort of blanket that covers the eyes of many residents.


I am fascinated by the incredibly common belief that crime only happens in certain areas. We all know that crime happens more frequently in some areas, but it seems like people translate "low crime rate" into "crime free".


Just for fun, Google the crime rates of suburbs in your areas. It can be eye-opening.
 
Status
Not open for further replies.
Back
Top