This dataset includes all valid felony, misdemeanor, and violation crimes reported to the New York City Police Department (NYPD) for all complete quarters so far this year (2019). For additional details, please see the attached data dictionary in the ‘About’ section.
This dataset has the following 36 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| CMPLNT_NUM | cmplnt_num | text | Randomly generated persistent ID for each complaint | 279749442 279749443 279749444 279749445 279759078 view top 100 |
| ADDR_PCT_CD | addr_pct_cd | number | The precinct in which the incident occurred | 75 14 40 44 43 view top 100 |
| BORO_NM | boro_nm | text | The name of the borough in which the incident occurred | BROOKLYN MANHATTAN QUEENS BRONX STATEN ISLAND 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) | 2024-02-02T00:00:00.000 2024-03-14T00:00:00.000 2024-03-01T00:00:00.000 2024-01-26T00:00:00.000 2024-03-15T00: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 17:00:00 18:00:00 16: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 | 2024-03-14T00:00:00.000 2024-03-15T00:00:00.000 2024-01-26T00:00:00.000 2024-02-02T00:00:00.000 2024-03-01T00: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 16:00:00 08:00:00 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 view top 100 |
| HADEVELOPT | hadevelopt | text | Name of NYCHA housing development of occurrence, if applicable | (null) INGERSOLL NOSTRAND WALD MARBLE HILL view top 100 |
| HOUSING_PSA | housing_psa | number | Development Level Code | 887 1251 415 670 489 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 17 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 MTA POLICE DEPT view top 100 |
| KY_CD | ky_cd | number | Three digit offense classification code | 341 578 344 109 348 view top 100 |
| LAW_CAT_CD | law_cat_cd | text | Level of offense: felony, misdemeanor, violation | MISDEMEANOR FELONY VIOLATION 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 |
| OFNS_DESC | ofns_desc | text | Description of offense corresponding with key code | PETIT LARCENY HARRASSMENT 2 ASSAULT 3 & RELATED OFFENSES GRAND LARCENY CRIMINAL MISCHIEF & RELATED OF 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 WASHINGTON SQUARE PARK FLUSHING MEADOWS CORONA PARK SARA D. ROOSEVELT PARK 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 QUEENS NORTH view top 100 |
| PD_CD | pd_cd | number | Three digit internal classification code (more granular than Key Code) | 638 333 101 109 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 LARCENY,PETIT FROM STORE-SHOPL ASSAULT 3 ASSAULT 2,1,UNCLASSIFIED HARASSMENT,SUBD 1,CIVILIAN 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 (null) view top 100 |
| RPT_DT | rpt_dt | calendar_date | Date event was reported to police | 2024-03-14T00:00:00.000 2024-01-11T00:00:00.000 2024-03-13T00:00:00.000 2024-03-15T00:00:00.000 2024-02-01T00:00:00.000 view top 100 |
| STATION_NAME | station_name | text | Transit station name | (null) 42 ST.-PORT AUTHORITY BUS TERM 161 ST.-YANKEE STADIUM 59 ST.-COLUMBUS CIRCLE 125 STREET view top 100 |
| SUSP_AGE_GROUP | susp_age_group | text | Suspect’s Age Group | UNKNOWN 25-44 (null) 45-64 18-24 view top 100 |
| SUSP_RACE | susp_race | text | Suspect’s Race Description | BLACK UNKNOWN WHITE HISPANIC (null) WHITE view top 100 |
| SUSP_SEX | susp_sex | text | Suspect’s Sex Description | M U F (null) view top 100 |
| TRANSIT_DISTRICT | transit_district | number | Transit district in which the offense occurred. | 33 20 4 11 12 view top 100 |
| VIC_AGE_GROUP | vic_age_group | text | Victim’s Age Group | 25-44 UNKNOWN 45-64 18-24 65+ view top 100 |
| VIC_RACE | vic_race | text | Victim’s Race Description | UNKNOWN BLACK WHITE HISPANIC WHITE ASIAN / PACIFIC ISLANDER view top 100 |
| VIC_SEX | vic_sex | text | Victim’s Sex Description | F M D E L 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 1046315 1019946 1018896 1030206 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 187088 206619 215367 207065 view top 100 |
| Latitude | latitude | number | Midblock Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 40.750423 40.6799807384666 40.733729 40.734955 40.757691 view top 100 |
| Longitude | longitude | number | Midblock Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | -73.98928 -73.7762339071953 -73.871197 -73.874983 -73.834115 view top 100 |
| Lat_Lon | lat_lon | location | view top 100 | |
| New Georeferenced Column | geocoded_column | point | {"coordinates":[-73.98928,40.750423],"type":"Point"} {"coordinates":[-73.7762339071953,40.6799807384666],"type":"Point"} {"coordinates":[-73.871197,40.733729],"type":"Point"} {"coordinates":[-73.874983,40.734955],"type":"Point"} {"coordinates":[-73.834115,40.757691],"type":"Point"} view top 100 |