EMS - Quarterly Clinical Measures - Trauma Alert

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.austintexas.gov
Id 43eg-euh2
Name EMS - Quarterly Clinical Measures - Trauma Alert
Attribution Austin-Travis County EMS
Category Public Safety
Tags ems, atcems, clinical data, clinical performance, clinical measures, patient care, trauma, alert
Created 2017-01-17T22:03:22Z
Publication Date 2017-01-18T16:13:49Z

Description

This table contains data describing ATCEMS management of Trauma Alert patients. In this setting, “Trauma Alert” refers to injured patients who meet Physiological or Anatomical criteria for transport to a Trauma Center per City of Austin/Travis County EMS System Clinical Operating Guidelines.

Columns

| Included | Schema Type    | Field Name                           | Name                                             | Data Type     | Render Type   |
| ======== | ============== | ==================================== | ================================================ | ============= | ============= |
| Yes      | numeric metric | fiscal_quarter_key                   | Fiscal Quarter Key                               | number        | number        |
| No       |                | fiscal_quarter                       | Fiscal Quarter                                   | text          | text          |
| Yes      | time           | fiscal_quarter_start_date            | Fiscal Quarter Start Date                        | calendar_date | calendar_date |
| No       |                | fiscal_quarter_end_date              | Fiscal Quarter End Date                          | calendar_date | calendar_date |
| Yes      | numeric metric | count_trauma_alert                   | Count - Trauma Alerts                            | number        | number        |
| Yes      | numeric metric | count_scene_time_compliance          | Count - Trauma Alert Scene Interval Compliance   | number        | number        |
| Yes      | numeric metric | percent_scene_time_compliance        | Percent – Trauma Alert Scene Interval Compliance | percent       | percent       |
| Yes      | numeric metric | percent_scene_time_compliance_target | Trauma Alert Scene Interval Compliance Target    | percent       | percent       |
| Yes      | numeric metric | count_specialty_center               | Count - Trauma Center Transports                 | number        | number        |
| Yes      | numeric metric | percent_specialty_center             | Percent - Trauma Center Transports               | percent       | percent       |
| Yes      | numeric metric | percent_specialty_center_target      | Trauma Center Transport Compliance Target        | percent       | percent       |
| Yes      | numeric metric | average_interval_call_to_door        | Average Call to Door Interval (Minutes)          | number        | number        |
| Yes      | numeric metric | average_interval_call_to_door_target | Call to Door Interval Target                     | number        | number        |

Time Field

Value = fiscal_quarter_start_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = fiscal_quarter_end_date,fiscal_quarter

Data Commands

series e:43eg-euh2 d:2013-10-01T00:00:00.000Z m:average_interval_call_to_door=34.44 m:count_trauma_alert=170 m:percent_scene_time_compliance_target=90 m:count_specialty_center=169 m:fiscal_quarter_key=201401 m:count_scene_time_compliance=147 m:percent_specialty_center=99.41 m:percent_scene_time_compliance=86.47 m:average_interval_call_to_door_target=45 m:percent_specialty_center_target=95

series e:43eg-euh2 d:2014-01-01T00:00:00.000Z m:average_interval_call_to_door=33 m:count_trauma_alert=143 m:percent_scene_time_compliance_target=90 m:count_specialty_center=142 m:fiscal_quarter_key=201402 m:count_scene_time_compliance=127 m:percent_specialty_center=99.3 m:percent_scene_time_compliance=88.81 m:average_interval_call_to_door_target=45 m:percent_specialty_center_target=95

series e:43eg-euh2 d:2014-04-01T00:00:00.000Z m:average_interval_call_to_door=35.92 m:count_trauma_alert=166 m:percent_scene_time_compliance_target=90 m:count_specialty_center=166 m:fiscal_quarter_key=201403 m:count_scene_time_compliance=151 m:percent_specialty_center=100 m:percent_scene_time_compliance=90.96 m:average_interval_call_to_door_target=45 m:percent_specialty_center_target=95

Meta Commands

metric m:fiscal_quarter_key p:integer l:"Fiscal Quarter Key" d:"Row identifier – numeric representation of fiscal quarter in <yyyyqq> format." t:dataTypeName=number

metric m:count_trauma_alert p:integer l:"Count - Trauma Alerts" d:"Count of Trauma Alert patients." t:dataTypeName=number

metric m:count_scene_time_compliance p:integer l:"Count - Trauma Alert Scene Interval Compliance" d:"Count of Trauma Alert patients with a scene interval less than 15 minutes. Scene interval starts when the first ATCEMS personnel arrive on scene, and ends when ATCEMS personnel depart the scene." t:dataTypeName=number

metric m:percent_scene_time_compliance p:float l:"Percent – Trauma Alert Scene Interval Compliance" d:"Percent of Trauma Alert patients with a scene interval less than 15 minutes." t:dataTypeName=percent

metric m:percent_scene_time_compliance_target p:float l:"Trauma Alert Scene Interval Compliance Target" d:"Target performance level for compliance with scene time goal for Trauma Alert patients." t:dataTypeName=percent

metric m:count_specialty_center p:integer l:"Count - Trauma Center Transports" d:"Count of Trauma Alert patients who are transported to a system approved Trauma Center." t:dataTypeName=number

metric m:percent_specialty_center p:float l:"Percent - Trauma Center Transports" d:"Percent of Trauma Alert patients who are transported to a system approved Trauma Center." t:dataTypeName=percent

metric m:percent_specialty_center_target p:float l:"Trauma Center Transport Compliance Target" d:"Target specialty center transport rate for Trauma Alert patients." t:dataTypeName=percent

metric m:average_interval_call_to_door p:float l:"Average Call to Door Interval (Minutes)" d:"Average interval between first 911 call and arrival at the receiving facility for Trauma Alert patients, measured in decimal minutes (e.g. 37.7 minutes)." t:dataTypeName=number

metric m:average_interval_call_to_door_target p:float l:"Call to Door Interval Target" d:"Target for Average Call to Door Interval." t:dataTypeName=number

entity e:43eg-euh2 l:"EMS - Quarterly Clinical Measures - Trauma Alert" t:attribution="Austin-Travis County EMS" t:url=https://data.austintexas.gov/api/views/43eg-euh2

property e:43eg-euh2 t:meta.view d:2017-09-25T07:26:37.634Z v:averageRating=0 v:name="EMS - Quarterly Clinical Measures - Trauma Alert" v:attribution="Austin-Travis County EMS" v:id=43eg-euh2 v:category="Public Safety"

property e:43eg-euh2 t:meta.view.owner d:2017-09-25T07:26:37.634Z v:displayName="Austin-Travis County EMS" v:lastNotificationSeenAt=1504211956 v:profileImageUrlLarge=/api/users/4zcf-8die/profile_images/LARGE v:profileImageUrlSmall=/api/users/4zcf-8die/profile_images/TINY v:id=4zcf-8die v:screenName="Austin-Travis County EMS" v:profileImageUrlMedium=/api/users/4zcf-8die/profile_images/THUMB

property e:43eg-euh2 t:meta.view.tableauthor d:2017-09-25T07:26:37.634Z v:displayName="Austin-Travis County EMS" v:lastNotificationSeenAt=1504211956 v:profileImageUrlLarge=/api/users/4zcf-8die/profile_images/LARGE v:roleName=publisher_stories v:profileImageUrlSmall=/api/users/4zcf-8die/profile_images/TINY v:id=4zcf-8die v:screenName="Austin-Travis County EMS" v:profileImageUrlMedium=/api/users/4zcf-8die/profile_images/THUMB

Top Records

| fiscal_quarter_key | fiscal_quarter | fiscal_quarter_start_date | fiscal_quarter_end_date | count_trauma_alert | count_scene_time_compliance | percent_scene_time_compliance | percent_scene_time_compliance_target | count_specialty_center | percent_specialty_center | percent_specialty_center_target | average_interval_call_to_door | average_interval_call_to_door_target | 
| ================== | ============== | ========================= | ======================= | ================== | =========================== | ============================= | ==================================== | ====================== | ======================== | =============================== | ============================= | ==================================== | 
| 201401             | 2014-Q1        | 2013-10-01T00:00:00       | 2013-12-31T23:59:50     | 170                | 147                         | 86.47                         | 90.00                                | 169                    | 99.41                    | 95.00                           | 34.44                         | 45.00                                | 
| 201402             | 2014-Q2        | 2014-01-01T00:00:00       | 2014-03-31T23:59:59     | 143                | 127                         | 88.81                         | 90.00                                | 142                    | 99.30                    | 95.00                           | 33.00                         | 45.00                                | 
| 201403             | 2014-Q3        | 2014-04-01T00:00:00       | 2014-06-30T23:59:59     | 166                | 151                         | 90.96                         | 90.00                                | 166                    | 100.00                   | 95.00                           | 35.92                         | 45.00                                | 
| 201404             | 2014-Q4        | 2014-07-01T00:00:00       | 2014-09-30T23:59:59     | 171                | 149                         | 87.13                         | 90.00                                | 171                    | 100.00                   | 95.00                           | 36.45                         | 45.00                                | 
| 201501             | 2015-Q1        | 2014-10-01T00:00:00       | 2014-12-31T23:59:50     | 161                | 149                         | 92.55                         | 90.00                                | 161                    | 100.00                   | 95.00                           | 36.21                         | 45.00                                | 
| 201502             | 2015-Q2        | 2015-01-01T00:00:00       | 2015-03-31T23:59:59     | 156                | 138                         | 88.46                         | 90.00                                | 154                    | 98.72                    | 95.00                           | 39.71                         | 45.00                                | 
| 201503             | 2015-Q3        | 2015-04-01T00:00:00       | 2015-06-30T23:59:59     | 152                | 128                         | 84.21                         | 90.00                                | 152                    | 100.00                   | 95.00                           | 35.05                         | 45.00                                | 
| 201504             | 2015-Q4        | 2015-07-01T00:00:00       | 2015-09-30T23:59:59     | 175                | 158                         | 90.29                         | 90.00                                | 173                    | 98.86                    | 95.00                           | 35.10                         | 45.00                                | 
| 201601             | 2016-Q1        | 2015-10-01T00:00:00       | 2015-12-31T23:59:50     | 137                | 129                         | 94.16                         | 90.00                                | 137                    | 100.00                   | 95.00                           | 44.03                         | 45.00                                | 
| 201602             | 2016-Q2        | 2016-01-01T00:00:00       | 2016-03-31T23:59:59     | 155                | 139                         | 89.68                         | 90.00                                | 154                    | 99.35                    | 95.00                           | 33.42                         | 45.00                                |