IBIS-PH - Query Builder - Utah Trauma Registry Query Module - Length of Stay in Days (Mean, Median, and Standard Deviation)

Overview

Trauma Data

The Trauma Registry data in this IBIS-Q query module come from all acute care hospitals that operate in Utah. Each record represents a trauma patient who sustained an injury and met Utah's Trauma Registry inclusion criteria (http://www.utahtrauma.org/publicResources/documents/UtahTraumaDataDictionary2014.pdf, Page 11). The database is maintained by the Utah Department of Health and Human Services, Bureau of Emergency Medical Services and Preparedness.

Getting Started

Follow the steps to narrow your query and display your results. When you are done forming your query, click "Submit" at the bottom of the screen (last step) to get your query result.

Step 1: Select year

( 2023 )

Step 2: Select demographic characteristics

(Age Group: all)

Step 3: Select location

Step 4: Select situation

Step 5: Select outcome

Step 6: Select patient outcome

Alive
Dead
Not

Step 7: Select geographic area

(Geographic Area: all)

First choose a geography type. Default is all.
County

Step 8: How to display the data

To display a map, you must select Geographic Area in Display By (category) and None in Group By (series)

Display By (category) Primary group by field Defines the data's primary grouping dimension. The primary grouping is required and also controls the ordering of the result's data rows. In MS-Excel and other graphing packages this is typically referred to as the the "dataset's category". If viewing in a 2-d table layout then this value/dimension is associated with table's "row" values. Others will refer to this value as the first "cross by" or the first dimension.
Group By (series) Optional secondary group by field Defines the 2nd field (or dimension) to be used to group and aggregate values by. MS-Excel chart users will commonly refer to this as the dataset's "series" field. If viewing in a 2-d table layout then this field is associated with data table's value columns. Series group bys are optional. Maps and some charts, like the "Pie" chart, are currently not programmed to handle datasets that have more than one group by e.g. they only work with the primary category type group by being specified.
Chart Optional chart graph Defines the optional chart graphic to display. NOTE: Maps and some charts, like the "Pie" chart, are currently not programmed to handle datasets that have more than one group by e.g. they only work with the primary category type group by being specified. All other charts will only work with a maximum of 2 group bys e.g. if the fixed group by exists then the series group by can NOT be used with charting or maps.
Map Optional map graph Defines the optional map graphic to display. NOTE: Maps are only available when the category is set to a geographical area and does not have a series defined.
Primary Measure Available Measures Defines the primary measure value to display in the map and graph.

The data and information provided through the IBIS-PH Query System are intended to support any individuals or entities engaged in activities designed solely to enhance the well-being of a specific community, which may include the State. Activities include informing evidence-based decision making in the State to plan and improve health service delivery, evaluate health care interventions and systems, and inform health policy decisions. Other uses are not permissible.

As an IBIS-PH Query System user, I AGREE TO:

Use the data for statistical reporting and analysis only.
Avoid any attempt to identify or contact individual(s) represented in the IBIS-PH query system data.
Avoid disclosure or use of the identity of any individual(s) discovered inadvertently.
Avoid linkage of IBIS-PH query system data with other data that, after linkage, might allow identification of an individual represented in the IBIS-PH query system data.
Use appropriate safeguards to prevent the inappropriate use or disclosure of individual(s) represented in the data, including when disclosing IBIS-PH Query System data to others.
Report IMMEDIATELY any inadvertent or intentional identity disclosures or violations of this agreement of which I become aware to the Director of Data, Systems, and Evaluation, Utah Department of Health and Human Services.

I understand that failure to adhere to the above stated agreement items will result in loss of access to DHHS Internet databases, and I may be subject to legal penalties. Any use, release, or publication of health data contrary to the provisions stated is a class B misdemeanor, with subsequent violations being class A misdemeanors punishable by a fine of up to $5,000 per offense (Chapter 23, Title 26, Code Annotated). If I am a state government employee, this may be grounds for immediate dismissal.

Data queries

Publications search

Query Builder for Utah Trauma Registry Query Module - Length of Stay in Days (Mean, Median, and Standard Deviation)

Overview

Trauma Data

Getting Started

Step 1: Select year

Step 2: Select demographic characteristics

Select one or more subgroups to limit results. Default is all characteristics.

First choose a coding scheme to use for age groups. Default is age adjustment age groups, all ages.

Select sex. Default is all.

Select Utah resident status. Default is all.

Select Primary Method of Payment. Default is all.

Step 3: Select location

Select one or more subgroups to limit results. Default is all characteristics.

Select Location Population Density. Default is all.

Select Location Type. Default is all.

Step 4: Select situation

Select one or more subgroups to limit results. Default is all.

Select Trauma Type. Default is all.

First choose a coding scheme. Default is cause of injury categories.

First choose the ICD diagnosis code system

First choose a coding scheme. Default is cause of injury categories.

Select transport mode. Default is all.

Select Hospital Transfer. Default is all.

Step 5: Select outcome

Select one or more subgroups to limit results. Default is all characteristics.

Select ED Disposition. Default is All.

Select HD Disposition. Default is all

Step 6: Select patient outcome

Step 7: Select geographic area

First choose a geography type. Default is all.

Step 8: How to display the data

Utah IBIS-PH

Utah DHHS

State of Utah

IBIS other

2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023

All
Animal related
Assaulted by another person (excludes gunshot or stabbing assault)
Bicycle crash (includes bicycle vs. MV)
Burn (electric, thermal or chemical)
Crushed or caught between objects
Chemical Burns
Diving related
Near Drowning
Explosive force
Fall (from one level to another or ground level)
Foreign body
Gunshot wound
Hanging
Farm or heavy equipment or power tools
Motorcycle crash (includes MC vs. MV)
Motor vehicle Auto or Truck crash
Not Applicable
Not Recorded
Other cause not listed
Other vehicular cause (includes ATV, 3-wheel or 4-wheel)
Pedestrian (not bicycle vs. MV)
Smoke inhalation
Sporting injury
Stab wound (includes cut, slice or pierce)
Struck against object
Unknown

All counties
Beaver
Box Elder
Cache
Carbon
Daggett
Davis
Duchesne
Emery
Garfield
Grand
Iron
Juab
Kane
Millard
Morgan
Piute
Rich
Salt Lake
San Juan
Sanpete
Sevier
Summit
Tooele
Uintah
Utah
Wasatch
Washington
Wayne
Weber

Data queries

Publications search

Query Builder for Utah Trauma Registry Query Module - Length of Stay in Days (Mean, Median, and Standard Deviation)

Overview

Trauma Data

Getting Started

Step 1: Select year

Step 2: Select demographic characteristics

Select one or more subgroups to limit results. Default is all characteristics.

First choose a coding scheme to use for age groups. Default is age adjustment age groups, all ages.

Select sex. Default is all.

Select Utah resident status. Default is all.

Select Primary Method of Payment. Default is all.

Step 3: Select location

Select one or more subgroups to limit results. Default is all characteristics.

Select Location Population Density. Default is all.

Select Location Type. Default is all.

Step 4: Select situation

Select one or more subgroups to limit results. Default is all.

Select Trauma Type. Default is all.

First choose a coding scheme. Default is cause of injury categories.

First choose the ICD diagnosis code system

First choose a coding scheme. Default is cause of injury categories.

Select transport mode. Default is all.

Select Hospital Transfer. Default is all.

Step 5: Select outcome

Select one or more subgroups to limit results. Default is all characteristics.

Select ED Disposition. Default is All.

Select HD Disposition. Default is all

Step 6: Select patient outcome

Step 7: Select geographic area

First choose a geography type. Default is all.

Step 8: How to display the data

Primary group by field

Optional secondary group by field

Optional chart graph

Optional map graph

Available Measures

Utah IBIS-PH

Utah DHHS

State of Utah

IBIS other