About this Dataset

EMS - Quarterly Call To Door Intervals

This table contains data describing ATCEMS performance in delivering patients with time-sensitive conditions (aka “Alert Patients”) to receiving facilities in a timely manner. The call-to-door interval begins when the first 911 call for an incident is answered in the Communications Center, and ends when the patient is recorded in CAD as arriving at a receiving facility.
Organization: City of Austin
Last updated: 2020-11-12T13:26:12.712486
Tags: 911, alert, ambulance, atcems, austin, call-to-door, clinical-data, clinical-measures, clinical-performance, emergency-medical-services, ems, patient-care, stemi, stroke, trauma, travis-county

Tables

Table 1

@usgov.city_of_austin_ems_quarterly_call_to_door_intervals.table_1

14.56 kB
46 rows
13 columns

CREATE TABLE table_1 (
  "fiscal_quarter_key" BIGINT,
  "fiscal_quarter" VARCHAR,
  "fiscal_quarter_start_date" VARCHAR,
  "fiscal_quarter_end_date" VARCHAR,
  "count_all_alerts" BIGINT  -- Count - All Alerts,
  "average_call_to_door_interval_overall" DOUBLE  -- Average Call-to-Door Interval – Overall,
  "average_call_to_door_interval_target" BIGINT  -- Average Call-to-Door Interval – Target,
  "count_stemi_alerts" BIGINT  -- Count – STEMI Alerts,
  "average_call_to_door_interval_stemi_alerts" DOUBLE  -- Average Call-to-Door Interval – STEMI Alerts,
  "count_stroke_alerts" BIGINT  -- Count – Stroke Alerts,
  "average_call_to_door_interval_stroke_alerts" DOUBLE  -- Average Call-to-Door Interval – Stroke Alerts,
  "count_trauma_alerts" BIGINT  -- Count – Trauma Alerts,
  "average_call_to_door_interval_trauma_alerts" DOUBLE  -- Average Call-to-Door Interval – Trauma Alerts
);