Our lone Excel whiz cracked open his spreadsheets and did a bunch of filter stuff with $ signs, semi-colons and all that jazz. When he was done, we checked his work. His findings are pretty incredible.
According to City of Chicago data, the city saw reported robberies drop 27% between 2001 and 2012. During the same time, reported robberies increased 54% in Wrigleyville and Boystown, from 136 incidents to 210.
Citywide incidents dropped a bit more than 19% between 2008 and 2012. Wrigleyville and Boystown robberies increased nearly 33% during the same time period, from 158 cases to 210.
Here are our whiz’s not so pretty pictures and, for the detail oriented, his raw data and methodology.
|
We also analyzed robbery reports within the Chicago Police Department official police “beats.” It is equally unflattering.
Raw Data
The raw data used to compile this report is available on our Google Docs page.
Methodology
Historic crime data provided by the City of Chicago for the current 19th police district as well as the former 19th and 23rd police districts were collected. The old 19th and 23rd police districts were combined on March 4, 2012, to form the current 19th district.
We extracted all robberies from the above data.
We filtered the robbery data, reducing it to incidents that occurred in the Wrigleyville and Boystown areas, as defined by the red dotted lines in the map below.
|