About this Dataset

NYPD Complaint Data Historic

This dataset includes all valid felony, misdemeanor, and violation crimes reported to the New York City Police Department (NYPD) from 2006 to the end of last year (2019). For additional details, please see the attached data dictionary in the ‘About’ section.
Organization: City of New York
Last updated: 2020-11-10T17:04:45.727101
Tags: crime, incident, nycopendata, nypd

Tables

Table 1

@usgov.city_of_new_york_nypd_complaint_data_historic.table_1

289.77 MB
9,491,946 rows
35 columns

CREATE TABLE table_1 (
  "cmplnt_num" VARCHAR,
  "cmplnt_fr_dt" VARCHAR,
  "cmplnt_fr_tm" VARCHAR,
  "cmplnt_to_dt" VARCHAR,
  "cmplnt_to_tm" VARCHAR,
  "addr_pct_cd" DOUBLE,
  "rpt_dt" TIMESTAMP,
  "ky_cd" BIGINT,
  "ofns_desc" VARCHAR,
  "pd_cd" DOUBLE,
  "pd_desc" VARCHAR,
  "crm_atpt_cptd_cd" VARCHAR,
  "law_cat_cd" VARCHAR,
  "boro_nm" VARCHAR,
  "loc_of_occur_desc" VARCHAR,
  "prem_typ_desc" VARCHAR,
  "juris_desc" VARCHAR,
  "jurisdiction_code" BIGINT,
  "parks_nm" VARCHAR,
  "hadevelopt" VARCHAR,
  "housing_psa" VARCHAR,
  "x_coord_cd" DOUBLE,
  "y_coord_cd" DOUBLE,
  "susp_age_group" VARCHAR,
  "susp_race" VARCHAR,
  "susp_sex" VARCHAR,
  "transit_district" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "lat_lon" VARCHAR,
  "patrol_boro" VARCHAR,
  "station_name" VARCHAR,
  "vic_age_group" VARCHAR,
  "vic_race" VARCHAR,
  "vic_sex" VARCHAR
);