List of every arrest in NYC going back to 2006 through the end of the year 2020
Dataset Description
Context
Inspired by the Onyx Data - Data DNA Dataset Challenge - October 2021 - NYPD Arrest Data (Year to Date), I decided to go deeper and see how the insights compare.
Content
This data was acquired from NYC open data, it lists every arrest in NYC going back to 2006 through the end of the previous calendar year (2020).
Acknowledgements
This data is manually extracted every quarter and reviewed by the Office of Management Analysis and Planning before being posted on the NYPD website.
Inspiration
This data can be used by the public to explore the nature of police enforcement activity. See below a description of the columns:
| Column Name | Column Description |
|---|---|
| ARREST_KEY | Randomly generated persistent ID for each arrest |
| ARREST_DATE | Exact date of arrest for the reported event |
| PD_CD | Three digit internal classification code (more granular than Key Code) |
| PD_DESC | Description of internal classification corresponding with PD code (more granular than Offense Description) |
| KY_CD | Three digit internal classification code (more general category than PD code) |
| OFNS_DESC | Description of internal classification corresponding with KY code (more general category than PD description) |
| LAW_CODE | Law code charges corresponding to the NYS Penal Law, VTL and other various local laws |
| LAW_CAT_CD | Level of offense: felony, misdemeanor, violation |
| ARREST_BORO | Borough of arrest. B(Bronx), S(Staten Island), K(Brooklyn), M(Manhattan), Q(Queens) |
| ARREST_PRECINCT | Precinct where the arrest occurred |
| JURISDICTION_CODE | Jurisdiction responsible for arrest. Jurisdiction codes 0(Patrol), 1(Transit) and 2(Housing) represent NYPD whilst codes 3 and more represent non NYPD jurisdictions |
| AGE_GROUP | Perpetrator’s age within a category |
| PERP_SEX | Perpetrator’s sex description |
| PERP_RACE | Perpetrator’s race description |
| X_COORD_CD | Midblock X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) |
| Y_COORD_CD | Midblock Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) |
| Latitude | Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) |
| Longitude | Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) |
Related Datasets
-
NYPD Arrests Data (Historic)
@usgov
-
NYPD Complaint Data Historic
@usgov