EMS - Transport Count By Destination
City of Austin
@usgov.city_of_austin_ems_transport_count_by_destination
City of Austin
@usgov.city_of_austin_ems_transport_count_by_destination
This table shows the count of patients transported to each system-approved receiving facility by month. The current facilities included in the list are:
• Cedar Park Regional Medical Center
• Dell Children's Medical Center
• Dell Seton Medical Center at UT
• Heart Hospital of Austin
• Lakeway Regional Medical Center
• North Austin Medical Center
• Saint David's Children's Hospital
• South Austin Medical Center
• Saint David's Emergency Center - BeeCave
• Saint David's Emergency Center - Cedar Park
• Saint David's Medical Center
• Saint David's Emergency Center - Pflugerville
• Saint David's Round Rock Medical Center
• Seton Medical Center Austin
• Seton Medical Center Hays
• Seton Medical Center Williamson
• Seton Northwest Hospital
• Seton Southwest Hospital
• Scott & White Hospital - Round Rock
• University Medical Center Brackenridge
• Westlake Medical Center
The table includes a destination of “Other/Missing” for cases where data is either absent, incorrect, or reflects a transport to another facility.
NOTE: Dell Seton Medical Center at UT opened in May 2017, taking the place of University Medical Center Brackenridge.
Organization: City of Austin
Last updated: 2020-11-12T13:29:09.340505
Tags: 911, ambulance, atcems, austin, destinations, emergency-medical-services, ems, hospitals, patient-transports, transports, travis-county
CREATE TABLE table_1 (
"month_key" BIGINT,
"month_year" VARCHAR,
"destination_code" VARCHAR,
"destination_name" VARCHAR,
"transport_count" BIGINT
);Anyone who has the link will be able to view this.