From a 500-row sample across 18 columns.
nypd_pct_cdadd_tsgeo_cd_x+15latitudelongitudeMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| cad_evnt_id | create_date | incident_date | incident_time | nypd_pct_cd | boro_nm | patrl_boro_nm | geo_cd_x | geo_cd_y | radio_code | typ_desc | cip_jobs |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 108642792 | 2025-01-01T00:00:00.000 | 2024-12-31T00:00:00.000 | 23:22:32 | 116 | QUEENS | PATROL BORO QUEENS SOUTH | 1056625 | 180527 | 53S | VEHICLE ACCIDENT: SPECIAL CONDITION | Non CIP |
| 108643213 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
cad_evnt_id | text | Unique identifier generated by the the ICAD 911 system | 0% | 115309391108685554110923105 |
create_date | datetime | Date of call | 0% | 2025-05-24T00:00:00.0002025-06-01T00:00:00.0002025-06-21T00:00:00.000 |
incident_date | datetime | Date of incident | 0% | 2025-05-24T00:00:00.0002025-06-01T00:00:00.0002025-06-21T00:00:00.000 |
incident_time | text | Time of incident | 0% | 19:08:11 |
GET /api/datasets/n2zq-pubd GET /api/datasets/n2zq-pubd/quality GET /api/datasets/n2zq-pubd/related GET /api/columns?dataset=n2zq-pubd
incident_datelatitudelongitude| 2025-01-01T00:00:00.000 |
| 2024-12-31T00:00:00.000 |
| 23:58:23 |
| 52 |
| BRONX |
| PATROL BORO BRONX |
| 1013953 |
| 255677 |
| 54I2 |
| AMBULANCE CASE: INJURY/OUTSIDE |
| Non CIP |
| 108643225 | 2025-01-01T00:00:00.000 | 2025-01-01T00:00:00.000 | 00:00:08 | 84 | BROOKLYN | PATROL BORO BKLYN NORTH | 987351 | 193828 | 75S | STATION INSPECTION BY TRANSIT BUREAU PERSONNEL | Non CIP |
| 108643226 | 2025-01-01T00:00:00.000 | 2025-01-01T00:00:00.000 | 00:00:43 | 70 | BROOKLYN | PATROL BORO BKLYN SOUTH | 993152 | 168419 | 50G2 | DISORDERLY: GROUP/OUTSIDE | Non CIP |
| 108643227 | 2025-01-01T00:00:00.000 | 2025-01-01T00:00:00.000 | 00:00:49 | 13 | MANHATTAN | PATROL BORO MAN SOUTH | 987653 | 210944 | 10H1 | INVESTIGATE/POSSIBLE CRIME: CALLS FOR HELP/INSIDE | Non CIP |
| 108643230 | 2025-01-01T00:00:00.000 | 2025-01-01T00:00:00.000 | 00:01:43 | 84 | BROOKLYN | PATROL BORO BKLYN NORTH | 987649 | 191484 | 75O | TRAIN ORDER MAINTENANCE SWEEP (TOMS) | Non CIP |
| 108643231 | 2025-01-01T00:00:00.000 | 2025-01-01T00:00:00.000 | 00:01:50 | 10 | MANHATTAN | PATROL BORO MAN SOUTH | 983130 | 212860 | 54U2 | AMBULANCE CASE: UNCONSCIOUS/OUTSIDE | Non CIP |
| 108643233 | 2025-01-01T00:00:00.000 | 2025-01-01T00:00:00.000 | 00:02:53 | 68 | BROOKLYN | PATROL BORO BKLYN SOUTH | 975657 | 163824 | 75S | STATION INSPECTION BY TRANSIT BUREAU PERSONNEL | Non CIP |
| 108643234 | 2025-01-01T00:00:00.000 | 2025-01-01T00:00:00.000 | 00:02:58 | 42 | BRONX | PATROL BORO BRONX | 1010390 | 241131 | 52D1 | DISPUTE: INSIDE | Non CIP |
| 108643235 | 2025-01-01T00:00:00.000 | 2025-01-01T00:00:00.000 | 00:03:06 | 115 | QUEENS | PATROL BORO QUEENS NORTH | 1014322 | 211463 | 75O | TRAIN ORDER MAINTENANCE SWEEP (TOMS) | Non CIP |
Showing 12 of 18 columns. All of them are listed below.
19:05:0819:14:51nypd_pct_cd | integer | NYPD precinct call is in | 0% | 401475 |
boro_nm | categorical | Borough call is in | 0% | BROOKLYNMANHATTANBRONXof 6 |
patrl_boro_nm | categorical | NYPD patrol Borough call is in | 0% | PATROL BORO BRONXPATROL BORO BKLYN NORTHPATROL BORO BKLYN SOUTHof 9 |
geo_cd_x | text | The X-Coordinate of the midblock of the street segment where the violation was issued | 0% | 987472989420987649 |
geo_cd_y | text | The Y-Coordinate of the midblock of the street segment where the violation was issued | 0% | 214939149230191484 |
radio_code | text | NYPD code used to inform NYPD member of service the nature of the call | 0% | 75D75S42 |
typ_desc | text | Description based on RADIO_CODE | 0% | VISIBILITY PATROL: DIREC…STATION INSPECTION BY TR…QUALITY OF LIFE COMPLAIN… |
cip_jobs | categorical | Flag indicating if the call relates to a Crime In Progress (CIP) | 0% | Non CIPNon CriticalSeriousof 4 |
add_ts | datetime | Timestamp of when the call was added to the system | 0% | 2025-04-02T17:52:04.0002026-03-21T20:38:04.0002025-10-15T22:34:14.000 |
disp_ts | datetime | Timestamp of when the call was dispatched to a responding unit | 0% | 2025-11-10T08:46:00.0002025-03-13T22:24:18.0002025-11-05T15:47:56.000 |
arrivd_ts | datetime | Timestamp of when the responding unit arrived on the scene | 23% | 2025-02-24T14:26:24.0002026-03-27T16:12:21.0002025-05-23T19:07:33.000 |
closng_ts | datetime | Timestamp of when the call was marked closed | 0% | 2025-11-05T15:33:48.0002025-01-31T16:21:13.0002025-01-27T23:55:04.000 |
latitude | float | The Latitude of the midblock of the street segment where the violation was issued | 0% | 40.75664204200006740.57628456500003740.692263680000053 |
longitude | float | The Longitude of the midblock of the street segment where the violation was issued | 0% | -73.988371576999953-73.981390612999974-73.987744534999933 |