Dataset: 911 End-to-End Data

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

586.04 KB
10964 rows
30 columns


CREATE TABLE table_1 (
  "week_start_date" TIMESTAMP,
  "agency" VARCHAR,
  "final_incident_type" VARCHAR,
  "n__of_incidents_calculated" BIGINT,
  "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,
  "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,
  "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
);