Dataset: NYPD Arrests Data Historic 2006 - 2020

About this Dataset

NYPD Arrests Data Historic 2006 - 2020

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)

Tables

Nypd Arrests Data Historic

@kaggle.okettaeneye_nypd_arrests_data_historic_2006_2020.nypd_arrests_data_historic

215.44 MB
5153369 rows
19 columns


CREATE TABLE nypd_arrests_data_historic (
  "arrest_key" BIGINT,
  "arrest_date" TIMESTAMP,
  "pd_cd" DOUBLE,
  "pd_desc" VARCHAR,
  "ky_cd" DOUBLE,
  "ofns_desc" VARCHAR,
  "law_code" VARCHAR,
  "law_cat_cd" VARCHAR,
  "arrest_boro" VARCHAR,
  "arrest_precinct" BIGINT,
  "jurisdiction_code" DOUBLE,
  "age_group" VARCHAR,
  "perp_sex" VARCHAR,
  "perp_race" VARCHAR,
  "x_coord_cd" DOUBLE,
  "y_coord_cd" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "lon_lat" VARCHAR
);