About this Dataset

EMS - Quarterly OMD Clinical Performance Indicators

This table contains data related to Clinical Performance Indicators (CPIs) used by the City of Austin/Travis County EMS System Office of the Medical Director (OMD). More information on CPIs can be found at http://www.austintexas.gov/page/performance-improvement.
Organization: City of Austin
Last updated: 2020-11-12T13:20:35.924856
Tags: 911, alert, ambulance, atcems, austin, clinical-data, clinical-measures, clinical-performance, cpi, emergency-medical-services, ems, omd, patient-care, stemi, stroke, trauma, travis-county

Tables

Table 1

@usgov.city_of_austin_ems_quarterly_omd_clinical_performance__0a4a933e.table_1

41.35 kB
46 rows
38 columns

CREATE TABLE table_1 (
  "fiscal_quarter_key" BIGINT,
  "fiscal_quarter" VARCHAR,
  "fiscal_quarter_start_date" VARCHAR,
  "fiscal_quarter_end_date" VARCHAR,
  "count_trauma_alerts" BIGINT  -- Count - Trauma Alerts,
  "count_trauma_alert_scene_interval_compliance" BIGINT  -- Count - Trauma Alert Scene Interval Compliance,
  "percent_trauma_alert_scene_interval_compliance" DOUBLE  -- Percent - Trauma Alert Scene Interval Compliance,
  "trauma_alert_scene_interval_compliance_target" BIGINT,
  "n_90th_percentile_trauma_scene_time" DOUBLE  -- 90th Percentile Trauma Scene Time,
  "n_90th_percentile_trauma_alert_scene_interval_target" BIGINT  -- 90th Percentile Trauma Alert Scene Interval Target,
  "count_stroke_alerts" BIGINT  -- Count - Stroke Alerts,
  "count_stroke_alert_scene_interval_compliance" BIGINT  -- Count - Stroke Alert Scene Interval Compliance,
  "percent_stroke_alert_scene_interval_compliance" DOUBLE  -- Percent - Stroke Alert Scene Interval Compliance,
  "stroke_alert_scene_interval_compliance_target" BIGINT,
  "n_90th_percentile_stroke_alert_scene_interval" DOUBLE  -- 90th Percentile Stroke Alert Scene Interval,
  "n_90th_percentile_stroke_alert_scene_interval_target" BIGINT  -- 90th Percentile Stroke Alert Scene Interval Target,
  "count_stemi_alerts" BIGINT  -- Count - STEMI Alerts,
  "count_stemi_alert_scene_interval_compliance" BIGINT  -- Count - STEMI Alert Scene Interval Compliance,
  "percent_stemi_alert_scene_interval_compliance" DOUBLE  -- Percent - STEMI Alert Scene Interval Compliance,
  "stemi_alert_scene_interval_compliance_target" BIGINT,
  "n_90th_percentile_stemi_alert_scene_interval" DOUBLE  -- 90th Percentile STEMI Alert Scene Interval,
  "n_90th_percentile_stemi_alert_scene_interval_target" BIGINT  -- 90th Percentile STEMI Alert Scene Interval Target,
  "count_acs_patients" BIGINT  -- Count – ACS Patients,
  "count_acs_patient_asa_administration" BIGINT  -- Count – ACS Patient ASA Administration,
  "percent_acs_patient_asa_administration" DOUBLE  -- Percent – ACS Patient ASA Administration,
  "acs_patient_asa_administration_target" BIGINT,
  "count_ams_patients" BIGINT  -- Count - AMS Patients,
  "count_bgl_test_for_ams_patients" BIGINT  -- Count - BGL Test For AMS Patients,
  "percent_bgl_test_for_ams_patients" DOUBLE  -- Percent - BGL Test For AMS Patients,
  "ams_patient_bgl_test_target" BIGINT,
  "count_seizure_patients" BIGINT  -- Count - Seizure Patients,
  "count_bgl_test_for_seizure_patients" BIGINT  -- Count - BGL Test For Seizure Patients,
  "percent_bgl_test_for_seizure_patients" DOUBLE  -- Percent - BGL Test For Seizure Patients,
  "seizure_patient_bgl_test_target" BIGINT,
  "count_stroke_patients" BIGINT  -- Count - Stroke Patients,
  "count_bgl_test_for_stroke_patients" BIGINT  -- Count - BGL Test For Stroke Patients,
  "percent_bgl_test_for_stroke_patients" DOUBLE  -- Percent - BGL Test For Stroke Patients,
  "stroke_patient_bgl_test_target" BIGINT
);