From a 500-row sample across 41 columns.
latitudeboro_nmky_cd+41latitudeky_cdy_coord_cd+13latitudeky_cdy_coord_cd+12Mappable — Socrata point column `geocoded_column`.
Open on the map →| cmplnt_num | addr_pct_cd | boro_nm | cmplnt_fr_dt | cmplnt_fr_tm | cmplnt_to_dt | cmplnt_to_tm | crm_atpt_cptd_cd | hadevelopt | jurisdiction_code | juris_desc | ky_cd |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 321141941 | 123 | STATEN ISLAND | 2026-03-02T00:00:00.000 | 00:08:00 | 2026-03-02T00:00:00.000 | 00:20:00 | COMPLETED | (null) | 0 | N.Y. POLICE DEPT | 106 |
| 326554809 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
cmplnt_num | text | Randomly generated persistent ID for each complaint | 0% | 322014606327222910325471496 |
addr_pct_cd | integer | The precinct in which the incident occurred | 0% | 754014 |
boro_nm | categorical | The name of the borough in which the incident occurred | 0% | BROOKLYNMANHATTANBRONXof 6 |
cmplnt_fr_dt | datetime | Exact date of occurrence for the reported event (or starting date of occurrence, if CMPLNT_TO_DT exists) | 0% | 2026-04-15T00:00:00.000 |
GET /api/datasets/5uac-w243 GET /api/datasets/5uac-w243/quality GET /api/datasets/5uac-w243/related GET /api/columns?dataset=5uac-w243
latitudey_coord_cdx_coord_cd+12latitudey_coord_cdx_coord_cd+3latitudey_coord_cdx_coord_cd+12latitudegeocoded_column:@computed_region_efsh_h5xi+6| 123 |
| STATEN ISLAND |
| 2026-06-12T00:00:00.000 |
| 12:50:00 |
| 2026-06-12T00:00:00.000 |
| 13:00:00 |
| COMPLETED |
| (null) |
| 0 |
| N.Y. POLICE DEPT |
| 578 |
| 324298851 | 122 | STATEN ISLAND | 2026-04-30T00:00:00.000 | 05:30:00 | — | (null) | COMPLETED | (null) | 0 | N.Y. POLICE DEPT | 578 |
| 325042430 | 70 | BROOKLYN | 2026-05-13T00:00:00.000 | 20:53:00 | 2026-05-13T00:00:00.000 | 22:00:00 | COMPLETED | (null) | 0 | N.Y. POLICE DEPT | 578 |
| 319580923 | 120 | STATEN ISLAND | 2026-01-28T00:00:00.000 | 19:52:00 | — | (null) | COMPLETED | (null) | 0 | N.Y. POLICE DEPT | 348 |
| 323669524 | 122 | STATEN ISLAND | 2026-04-18T00:00:00.000 | 23:07:00 | 2026-04-18T00:00:00.000 | 23:08:00 | COMPLETED | (null) | 0 | N.Y. POLICE DEPT | 344 |
| 321864377 | 122 | STATEN ISLAND | 2026-03-13T00:00:00.000 | 00:30:00 | 2026-03-14T00:00:00.000 | 22:00:00 | COMPLETED | (null) | 0 | N.Y. POLICE DEPT | 126 |
| 322125496 | 123 | STATEN ISLAND | 2026-02-24T00:00:00.000 | 18:32:00 | 2026-03-17T00:00:00.000 | 16:23:00 | COMPLETED | (null) | 0 | N.Y. POLICE DEPT | 578 |
| 319694096 | 123 | STATEN ISLAND | 2026-01-29T00:00:00.000 | 20:40:00 | 2026-01-29T00:00:00.000 | 20:50:00 | COMPLETED | (null) | 0 | N.Y. POLICE DEPT | 578 |
| 321079250 | 123 | STATEN ISLAND | 2026-02-28T00:00:00.000 | 12:00:00 | 2026-02-28T00:00:00.000 | 12:50:00 | COMPLETED | (null) | 0 | N.Y. POLICE DEPT | 359 |
Showing 12 of 39 columns. All of them are listed below.
2026-04-01T00:00:00.0002026-04-17T00:00:00.000cmplnt_fr_tm | text | Exact time of occurrence for the reported event (or starting time of occurrence, if CMPLNT_TO_TM exists) | 0% | 12:00:0015:00:0018:00:00 |
cmplnt_to_dt | datetime | Ending date of occurrence for the reported event, if exact time of occurrence is unknown | 4% | 2026-04-15T00:00:00.0002026-04-01T00:00:00.0002026-04-17T00:00:00.000 |
cmplnt_to_tm | text | Ending time of occurrence for the reported event, if exact time of occurrence is unknown | 0% | (null)12:00:0015:00:00 |
crm_atpt_cptd_cd | categorical | Indicator of whether crime was successfully completed or attempted, but failed or was interrupted prematurely | 0% | COMPLETEDATTEMPTEDof 2 |
hadevelopt | text | Name of NYCHA housing development of occurrence, if applicable | 0% | (null)INGERSOLLWILLIAMSBURG |
housing_psa | integer | Development Level Code | 93% | 1251670638 |
jurisdiction_code | categorical | Jurisdiction responsible for incident. Either internal, like Police(0), Transit(1), and Housing(2); or external(3), like Correction, Port Authority, etc. | 0% | 021of 19 |
juris_desc | categorical | Description of the jurisdiction code | 0% | N.Y. POLICE DEPTN.Y. HOUSING POLICEN.Y. TRANSIT POLICEof 19 |
ky_cd | integer | Three digit offense classification code | 0% | 341578344 |
law_cat_cd | categorical | Level of offense: felony, misdemeanor, violation | 0% | MISDEMEANORFELONYVIOLATIONof 3 |
loc_of_occur_desc | categorical | Specific location of occurrence in or around the premises; inside, opposite of, front of, rear of | 0% | INSIDEFRONT OF(null)of 6 |
ofns_desc | text | Description of offense corresponding with key code | 0% | PETIT LARCENYHARRASSMENT 2ASSAULT 3 & RELATED OFFE… |
parks_nm | text | Name of NYC park, playground or greenspace of occurrence, if applicable (state parks are not included) | 0% | (null)SARA D. ROOSEVELT PARKFLUSHING MEADOWS CORONA … |
patrol_boro | categorical | The name of the patrol borough in which the incident occurred | 0% | PATROL BORO BKLYN NORTHPATROL BORO BKLYN SOUTHPATROL BORO MAN SOUTHof 10 |
pd_cd | integer | Three digit internal classification code (more granular than Key Code) | 0% | 638101333 |
pd_desc | text | Description of internal classification corresponding with PD code (more granular than Offense Description) | 0% | HARASSMENT,SUBD 3,4,5ASSAULT 3LARCENY,PETIT FROM STORE… |
prem_typ_desc | text | Specific description of premises; grocery store, residence, street, etc. | 0% | STREETRESIDENCE - APT. HOUSERESIDENCE-HOUSE |
rpt_dt | datetime | Date event was reported to police | 0% | 2026-04-15T00:00:00.0002026-04-01T00:00:00.0002026-06-11T00:00:00.000 |
station_name | text | Transit station name | 0% | (null)ATLANTIC AVENUESTILLWELL AVENUE-CONEY I… |
susp_age_group | categorical | Suspect’s Age Group | 0% | UNKNOWN25-4445-64of 19 |
susp_race | categorical | Suspect’s Race Description | 0% | BLACKUNKNOWNWHITE HISPANICof 8 |
susp_sex | categorical | Suspect’s Sex Description | 0% | MUFof 4 |
transit_district | categorical | Transit district in which the offense occurred. | 94% | 333220of 12 |
vic_age_group | categorical | Victim’s Age Group | 0% | UNKNOWN25-4445-64of 19 |
vic_race | categorical | Victim’s Race Description | 0% | UNKNOWNBLACKWHITE HISPANICof 8 |
vic_sex | categorical | Victim’s Sex Description | 0% | FMEof 5 |
x_coord_cd | integer | X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 9905021042801987220 |
y_coord_cd | integer | Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 188496181715212676 |
latitude | float | Midblock Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | 40.6840524940.6652487840.750432 |
longitude | float | Midblock Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | -73.97745785-73.78894843-73.989281 |
lat_lon | coordinate | — | — | — |
geocoded_column | coordinate | — | 0% | {'coordinates': [-73.977…{'coordinates': [-73.788…{'coordinates': [-73.989… |