About this Dataset

911 End-to-End Data

All incident segments for each of the first responding agencies (PD, FD and EMS) that contribute to the end-to-end response times. This data set provides call volumes broken down by incident type for each Week Start time period as well as the timestamps and average response times (in seconds) for each segment of the call. For the Incident Type Definitions please refer to this link.
Organization: City of New York
Last updated: 2020-11-10T17:05:19.675790
Tags: 911

Tables

Table 1

@usgov.city_of_new_york_911_end_to_end_data.table_1

600.11 kB
10,964 rows
30 columns

CREATE TABLE table_1 (
  "week_start_date" TIMESTAMP,
  "agency" VARCHAR,
  "final_incident_type" VARCHAR,
  "n__of_incidents_calculated" BIGINT  -- # Of Incidents Calculated,
  "call_to_first_pickup" DOUBLE,
  "call_to_pd_calltaker_handoff" DOUBLE,
  "call_to_fdny_pickup" DOUBLE,
  "call_to_fdny_job_creation" DOUBLE,
  "call_to_ems_pickup" DOUBLE,
  "call_to_agency_job_creation" DOUBLE,
  "call_to_agency_dispatch" DOUBLE,
  "call_to_agency_arrival" DOUBLE,
  "call_to_first_arrival_multi_agency_incidents" DOUBLE  -- Call To First Arrival (Multi-Agency Incidents),
  "median_pickup" DOUBLE,
  "median_calltaker_handoff" DOUBLE,
  "median_fdny_pickup" DOUBLE,
  "median_fdny_job_creation" DOUBLE,
  "median_ems_pickup" DOUBLE,
  "median_ems_job_creation" DOUBLE,
  "median_dispatch" DOUBLE,
  "median_travel" DOUBLE,
  "median_cumulative_first_arrival_multi_agency_incidents" DOUBLE  -- Median Cumulative First Arrival (Multi-Agency Incidents),
  "average_travel" DOUBLE,
  "average_dispatch" DOUBLE,
  "average_ems_processing" DOUBLE,
  "average_ems_pickup" DOUBLE,
  "average_calltaker_processing" DOUBLE,
  "average_pickup" DOUBLE,
  "average_fd_pickup" DOUBLE,
  "average_fd_processing" DOUBLE
);