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.
This dataset has the following 35 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
CMPLNT_NUM | cmplnt_num | text | Randomly generated persistent ID for each complaint | 10857579 24034437 10539982 10857272 11072795 view top 100 |
CMPLNT_FR_DT | cmplnt_fr_dt | calendar_date | Exact date of occurrence for the reported event (or starting date of occurrence, if CMPLNT_TO_DT exists) | 2010-01-01T00:00:00.000 2016-01-01T00:00:00.000 2014-01-01T00:00:00.000 2011-01-01T00:00:00.000 2008-01-01T00:00:00.000 view top 100 |
CMPLNT_FR_TM | cmplnt_fr_tm | text | Exact time of occurrence for the reported event (or starting time of occurrence, if CMPLNT_TO_TM exists) | 12:00:00 15:00:00 18:00:00 20:00:00 17:00:00 view top 100 |
CMPLNT_TO_DT | cmplnt_to_dt | calendar_date | Ending date of occurrence for the reported event, if exact time of occurrence is unknown | 2022-05-31T00:00:00.000 2023-09-13T00:00:00.000 2023-10-06T00:00:00.000 2023-10-04T00:00:00.000 2023-07-05T00:00:00.000 view top 100 |
CMPLNT_TO_TM | cmplnt_to_tm | text | Ending time of occurrence for the reported event, if exact time of occurrence is unknown | (null) 12:00:00 15:00:00 08:00:00 09:00:00 view top 100 |
ADDR_PCT_CD | addr_pct_cd | number | The precinct in which the incident occurred | 75 43 44 40 14 view top 100 |
RPT_DT | rpt_dt | calendar_date | Date event was reported to police | 2007-05-29T00:00:00.000 2006-11-01T00:00:00.000 2007-10-23T00:00:00.000 2023-09-13T00:00:00.000 2022-05-31T00:00:00.000 view top 100 |
KY_CD | ky_cd | number | Three digit offense classification code | 341 578 344 109 351 view top 100 |
OFNS_DESC | ofns_desc | text | Description of offense corresponding with key code | PETIT LARCENY HARRASSMENT 2 ASSAULT 3 & RELATED OFFENSES CRIMINAL MISCHIEF & RELATED OF GRAND LARCENY view top 100 |
PD_CD | pd_cd | number | Three digit internal classification code (more granular than Key Code) | 638 101 333 639 637 view top 100 |
PD_DESC | pd_desc | text | Description of internal classification corresponding with PD code (more granular than Offense Description) | HARASSMENT,SUBD 3,4,5 ASSAULT 3 LARCENY,PETIT FROM STORE-SHOPL AGGRAVATED HARASSMENT 2 HARASSMENT,SUBD 1,CIVILIAN view top 100 |
CRM_ATPT_CPTD_CD | crm_atpt_cptd_cd | text | Indicator of whether crime was successfully completed or attempted, but failed or was interrupted prematurely | COMPLETED ATTEMPTED (null) view top 100 |
LAW_CAT_CD | law_cat_cd | text | Level of offense: felony, misdemeanor, violation | MISDEMEANOR FELONY VIOLATION view top 100 |
BORO_NM | boro_nm | text | The name of the borough in which the incident occurred | BROOKLYN MANHATTAN BRONX QUEENS STATEN ISLAND view top 100 |
LOC_OF_OCCUR_DESC | loc_of_occur_desc | text | Specific location of occurrence in or around the premises; inside, opposite of, front of, rear of | INSIDE FRONT OF (null) OPPOSITE OF REAR OF view top 100 |
PREM_TYP_DESC | prem_typ_desc | text | Specific description of premises; grocery store, residence, street, etc. | STREET RESIDENCE - APT. HOUSE RESIDENCE-HOUSE RESIDENCE - PUBLIC HOUSING CHAIN STORE view top 100 |
JURIS_DESC | juris_desc | text | Description of the jurisdiction code | N.Y. POLICE DEPT N.Y. HOUSING POLICE N.Y. TRANSIT POLICE PORT AUTHORITY OTHER view top 100 |
JURISDICTION_CODE | jurisdiction_code | number | Jurisdiction responsible for incident. Either internal, like Police(0), Transit(1), and Housing(2); or external(3), like Correction, Port Authority, etc. | 0 2 1 3 97 view top 100 |
PARKS_NM | parks_nm | text | Name of NYC park, playground or greenspace of occurrence, if applicable (state parks are not included) | (null) CENTRAL PARK FLUSHING MEADOWS CORONA PARK WASHINGTON SQUARE PARK CONEY ISLAND BEACH & BOARDWALK view top 100 |
HADEVELOPT | hadevelopt | text | Name of NYCHA housing development of occurrence, if applicable | (null) INGERSOLL WALD WILLIAMSBURG NOSTRAND view top 100 |
HOUSING_PSA | housing_psa | text | Development Level Code | (null) 670 887 845 720 view top 100 |
X_COORD_CD | x_coord_cd | number | X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 987220 1046367 1019946 1017933 1020327 view top 100 |
Y_COORD_CD | y_coord_cd | number | Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 212676 186986 206619 232222 176285 view top 100 |
SUSP_AGE_GROUP | susp_age_group | text | Suspect’s Age Group | (null) 25-44 UNKNOWN 18-24 45-64 view top 100 |
SUSP_RACE | susp_race | text | Suspect’s Race Description | (null) BLACK UNKNOWN WHITE HISPANIC WHITE view top 100 |
SUSP_SEX | susp_sex | text | Suspect’s Sex Description | (null) M U F view top 100 |
TRANSIT_DISTRICT | transit_district | number | Transit district in which the offense occurred. | 4 2 1 3 33 view top 100 |
Latitude | latitude | number | Midblock Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 40.750423 40.67970059 40.733729 40.804008 40.650466 view top 100 |
Longitude | longitude | number | Midblock Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | -73.98928 -73.77604735 -73.871197 -73.878333 -73.869986 view top 100 |
Lat_Lon | lat_lon | location | Geospatial Location Point (latitude and Longitude combined) | view top 100 |
PATROL_BORO | patrol_boro | text | The name of the patrol borough in which the incident occurred | PATROL BORO BRONX PATROL BORO BKLYN SOUTH PATROL BORO BKLYN NORTH PATROL BORO MAN SOUTH PATROL BORO MAN NORTH view top 100 |
STATION_NAME | station_name | text | Transit station name | (null) 125 STREET 14 STREET 42 ST.-PORT AUTHORITY BUS TERM 34 ST.-PENN STATION view top 100 |
VIC_AGE_GROUP | vic_age_group | text | Victim’s Age Group | 25-44 (null) 45-64 UNKNOWN 18-24 view top 100 |
VIC_RACE | vic_race | text | Victim’s Race Description | UNKNOWN BLACK WHITE WHITE HISPANIC ASIAN / PACIFIC ISLANDER view top 100 |
VIC_SEX | vic_sex | text | Victim’s Sex Description | F M E D L view top 100 |