Doc: NYPD Crime Stats - wimlds/smart_cities GitHub Wiki
NYPD has released statistics about city-wide crime starting from 2000. The data are publicly released and documented here: "For statistical presentation purposes the numerous law categories and subsections are summarized by law class, Felony, Misdemeanor and Violation. These legal categories are then subdivided into broad crime and offense categories, e.g. Felonious Assault, Grand Larceny, Misdemeanor Criminal Mischief, etc." The data is released in individual excel files for the categories: Seven Major Felonies, Non-Seven Major Felony Crimes, Misdemeanors and Violations.
We aggregated the Felony and Misdemeanor data tables and organized them in a csv file, collected at the precinct. There are over 70 precincts in NYC determining the geographical areas patrolled by different NYPD forces. You can find a file containing the geographical information for the NYC precincts on our github repository in zipped "shapefile" format for use with Geopandas, Carto, ARCGIS, QGIS and other geographical visualization and analysis tools.
Table path:
`smart_cities_data.NYPD_crime_stats_2000_2015`
| Column Name | Explanation |
|---|---|
| PCT | String, Precinct Number |
| crime_category | String, one of the three main legal categories Felonious Assault, Grand Larceny, Misdemeanor Criminal Mischief |
| CRIME | String, specific crime category (e.g. murder) |
| _2000 | Float, the number of crimes in that category in the precinty during year 2000 |
| _2001 | Float |
| _2002 | Float |
| _2003 | Float |
| _2004 | Float |
| _2005 | Float |
| _2006 | Float |
| _2007 | Float |
| _2008 | Float |
| _2009 | Float |
| _2010 | Float |
| _2011 | Float |
| _2012 | Float |
| _2013 | Float |
| _2014 | Float |
| _2015 | Float |