Dataset: NYPD Complaint Data Historic

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

276.34 MB
9491946 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
);