EMS - Patient Contacts By Month
City of Austin
@usgov.city_of_austin_ems_patient_contacts_by_month
City of Austin
@usgov.city_of_austin_ems_patient_contacts_by_month
This table contains data that describes monthly patient contacts. It includes all incidents with a response priority between 1 and 5, inclusive.
Organization: City of Austin
Last updated: 2020-11-12T13:25:23.672333
Tags: 911, ambulance, atcems, austin, emergency-medical-services, ems, patient-care, patient-contacts, patient-transport-rate, patient-transports, patients, travis-county, workload
CREATE TABLE table_1 (
"month_key" BIGINT,
"month_year" VARCHAR,
"total_patient_contacts" BIGINT,
"austin_patient_contacts" BIGINT,
"travis_county_patient_contacts" BIGINT,
"other_area_patient_contacts" BIGINT,
"combined_coa_and_tc_patient_contacts" BIGINT,
"total_patient_transports" BIGINT,
"austin_patient_transports" BIGINT,
"travis_county_patient_transports" BIGINT,
"other_area_patient_transports" BIGINT,
"combined_coa_and_tc_patient_transports" BIGINT,
"overall_patient_transport_rate" DOUBLE,
"austin_patient_transport_rate" DOUBLE,
"travis_county_patient_transport_rate" DOUBLE,
"other_area_patient_transport_rate" DOUBLE,
"combined_coa_and_tc_patient_transport_rate" DOUBLE,
"patient_transport_rate_target" DOUBLE
);Anyone who has the link will be able to view this.