New: KC crime data by date

By Greg Reeves
This is an experiment. Every week I get a file from Kansas City police listing reported crimes and dispatched calls for the previous week. There are 800-1,000 incidents a week, on average.
I've processed the data to post here every week in the following formats:

• By date
• By crime
• By area of the city

This file usually arrives on Thursday but is sometimes delayed until Friday or Monday. In the future, I'll post this data a few minutes after I get it. Data this week:

Download kc_crimes_20051106.xls
Download kc_crimes_20051107.xls
Download kc_crimes_20051108.xls
Download kc_crimes_20051109.xls
Download kc_crimes_20051110.xls
Download kc_crimes_20051111.xls
Download kc_crimes_20051112.xls
Download kc_crimes_20051113.xls

Comments

[acmoore]

Thanks, these are interesting to see. Do you know how to interpret the "reportarea" and "po_number" fields? The report area field seems to match up loosely with the radio assignments: 100's in Central patrol, 200's in metro, and so on. That means it may be the radio number that responded, I guess. I can't figure out po number, though. It looks too long to be the officer serial number.

[Crime Scene KC]

Hi ac,
I meant to include a brief explanation. "ponumber" is the reporting officer's badge number. "reportarea" is the patrol beats, corresponding to the departments six patrol divisions. I'll post a translation (100s center, 200s east 300s metro 400s north 500s south 600s shoal creek...I think).
Thanks for the reminder!
Greg Reeves

[brett]

I have created a website where you can map KCMO and Overland Park data. You can find it at:

http://www.rickman.com/brett/crimemap.php

[acmoore]

Here's the document I use to figure out what patrol and division officers are in based on their numbers:
http://www.kcpd.org/masterindex/files/dm/dm0417.pdf
I suspect they're the same numbers.

[brett]

One more thing, here are the totals I found for the dates I mapped:

109 10-23-05
114 10-24-05
117 10-25-05
119 10-26-05
126 10-27-05
117 10-28-05
121 10-29-05
104 10-30-05
927 Total

-Brett

[Judy]

Thank You very much, looking forward to your project to be a on going thing.