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.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"datahub-austintexas-gov/ems-transport-count-by-destination-jtkc-5pgh\".\"ems_transport_count_by_destination\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.