About this Dataset

NYPD Arrest Data (Year To Date)

This is a breakdown of every arrest effected in NYC by the NYPD during the current year. This data is manually extracted every quarter and reviewed by the Office of Management Analysis and Planning. Each record represents an arrest effected in NYC by the NYPD and includes information about the type of crime, the location and time of enforcement. In addition, information related to suspect demographics is also included. This data can be used by the public to explore the nature of police enforcement activity. Please refer to the attached data footnotes for additional information about this dataset.
Organization: City of New York
Last updated: 2020-11-10T17:05:37.001960
Tags: arrest, crime, law-enforcement, nypd, public-safety

Tables

Table 1

@usgov.city_of_new_york_nypd_arrest_data_year_to_date.table_1

2.47 MB
71242 rows
19 columns


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