From a 500-row sample across 30 columns.
agency| date | agency | final_incident_type | of_incidents_calculated | call_to_first_pickup | call_to_pd_calltaker_handoff | call_to_agency_dispatch | call_to_agency_arrival | call_to_first_arrival_multi | median_pickup | median_calltaker_handoff | median_dispatch |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-09-21T00:00:00.000 | NYPD | 2. Serious | 2004 | 4.48 | 136.8 | 319.02 | 767.9 | 749.81 | 3 | 103 | 76 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
date | datetime | The week start date of the incident category | 0% | 2023-11-06T00:00:00.0002014-02-24T00:00:00.0002022-11-07T00:00:00.000 |
agency | categorical | The incident agency | 0% | NYPD (Non-CIP)FDNYNYPDof 4 |
final_incident_type | text | The final incident type category | 1% | 3. Medical EmergenciesPossible CrimesDisorderly Person/Group/… |
of_incidents_calculated | integer | Number of Incidents Calculated | 0% |
GET /api/datasets/t7p9-n9dy GET /api/datasets/t7p9-n9dy/quality GET /api/datasets/t7p9-n9dy/related GET /api/columns?dataset=t7p9-n9dy
| 2026-09-21T00:00:00.000 | NYPD (Non-CIP) | Dispute | 4331 | 4.23 | 172.96 | 1198.38 | 4330.89 | 4284.72 | 3 | 142 | 229 |
| 2026-09-21T00:00:00.000 | EMS | 2. Non-Life Threatening Med Emergencies | 9594 | 4.43 | 109.12 | 1135.46 | 2052.24 | 1890.74 | 3 | 95 | 171.5 |
| 2026-09-21T00:00:00.000 | FDNY | 2. Non-Structural Fires | 135 | 4.23 | 27.9 | 94.13 | 372.88 | 371.75 | 3 | 16 | 8 |
| 2026-09-21T00:00:00.000 | NYPD | 1. Critical | 833 | 3.95 | 139 | 275.4 | 569.84 | 547.91 | 3 | 107 | 65 |
| 2026-09-21T00:00:00.000 | NYPD | 3. Non-Critical | 673 | 4.25 | 164.3 | 729.23 | 1980.75 | 1962.62 | 3 | 138 | 136 |
| 2026-09-21T00:00:00.000 | NYPD (Non-CIP) | Hazardous Materials/Suspicious Letters/Packages/Substances/Substances | 102 | 4.79 | 167.39 | 531.17 | 3384.02 | 1642.08 | 3 | 133.5 | 110.5 |
| 2026-09-21T00:00:00.000 | FDNY | 1. Structural Fires | 223 | 4.12 | 31.24 | 97.06 | 299.56 | 299.51 | 3 | 17 | 9 |
| 2026-09-21T00:00:00.000 | NYPD (Non-CIP) | Past Crime | 3354 | 4.64 | 204.78 | 1586.84 | 7509.13 | 7369.62 | 3 | 173 | 293.5 |
| 2026-09-21T00:00:00.000 | NYPD (Non-CIP) | Police Officer/Security Holding Suspect | 89 | 5.51 | 120.55 | 420.07 | 1366.28 | 1366.28 | 3 | 100 | 131 |
Showing 12 of 30 columns. All of them are listed below.
12221call_to_first_pickup | float | Call duration time to First Pickup (in sec) | 0% | 3.63.543.57 |
call_to_pd_calltaker_handoff | float | Call duration time to PD Calltaker Handoff (in sec) | 0% | 160.21166.07175.67 |
call_to_fdny_pickup | float | Call duration time to call to FDNY Pickup (in sec) | 89% | 35.0633.4433.82 |
call_to_fdny_job_creation | float | Call duration time to call to FDNY Job Creation (in sec) | 89% | 89.9588.1587.99 |
call_to_ems_pickup | float | Call duration time to call to EMS Pickup (in sec) | 83% | 83.0286.5683.27 |
call_to_agency_job_creation | float | Call duration time to call to Agency Job Creation (in sec) | 83% | 170.31147.51159.52 |
call_to_agency_dispatch | float | Call duration time to call to Agency Dispatch (in sec) | 0% | 204.98203.2296.49 |
call_to_agency_arrival | float | Call duration time to call to Agency Arrival (in sec) | 0% | 409.64480.5556.8 |
call_to_first_arrival_multi | float | Call duration time to call to First Arrival (Multi-Agency Incidents) (in sec) | 0% | 467.41475.01595 |
median_pickup | categorical | Median pickup time in the middle of an ordered data set containing all pickup times | 0% | 343.5of 19 |
median_calltaker_handoff | integer | Median call to PD calltaker handoff in the middle of an ordered data set containing all call to calltaker handoffs | 0% | 1617139 |
median_fdny_pickup | integer | Median call to FDNY Pickup in the middle of an ordered set of all calls to FDNY pickups | 89% | 5of 1 |
median_fdny_job_creation | float | Median call to FDNY Job Creation in the middle of an ordered data set containing all calls to FDNY job creations | 89% | 474648 |
median_ems_pickup | float | Median call to EMS Pickup in the middle of an ordered data set containing all calls to EMS Pickups | 83% | 51110.5 |
median_ems_job_creation | float | Median call to EMS Job Creation in the middle of a data set containing all calls to Agency Job Creation | 83% | 41.53842 |
median_dispatch | integer | Median call to Agency Dispatch in the middle of an ordered data set containing all calls to agency dispatch | 0% | 786 |
median_travel | integer | Median call to agency arrival in the middle of an ordered data set containing all calls to agency arrival | 0% | 194193192 |
median_cumulative_first | integer | Median call to first arrival in the middle of an ordered data set containing all calls to first arrival | 0% | 383379390 |
average_travel | float | Average Time from when a unit is assigned until the unit arrives on-scene | 0% | 3.323.353.29 |
average_dispatch | float | Average Time from when the job was created until a unit is assigned | 0% | 0.160.150.17 |
average_ems_processing | float | Average Time from when the ARD (in EMS) answered a call until the ARD (in EMS) electronically creates the job | 83% | 0.990.980.96 |
average_ems_pickup | float | Average Time from when the PCT connects to the EMS phone system until the ARD (in EMS) picks up | 83% | 0.090.080.13 |
average_calltaker_processing | float | Average Time from when the PCT answers a call until the PCT connects with the next agency or creates the job | 0% | 2.72.762.75 |
average_pickup | float | Average Time from when the call enters the phone system until the PCT picks up | 0% | 0.060.070.05 |
average_fd_pickup | categorical | Average Time from when the PCT connects to the FD phone system until the ARD (in FD) picks up | 89% | 0.090.080.1of 13 |
average_fd_processing | float | Average Time from when the ARD (in FD) picks up a call until the ARD (in FD) electronically creates the job | 89% | 0.90.880.87 |