IBIS-PH - Query Builder - Emergency Department Encounter for Primary Care Sensitive Conditions Query Module for Utah Small Areas - Crude Rates

Overview

The inpatient discharge data in this IBIS-Q query module come from all Utah licensed hospitals. The database is maintained by the Utah Department of Health and Human Services, Healthcare Information and Analysis Programs. The population data used for the denominator were produced by ESRI ZIP Code data provided annual population estimates for ZIP Code areas by sex and age groups, are considered the most accurate available.

As of November 22, 2017, the IBIS system has been updated to use an algorithm which uses both ZIP and county information to designate Local Health District (LHD) and Utah Small Area. Queries by LHD or Small Area may yield different numbers than in prior months. For more information go to https://ibis.utah.gov/ibisph-view/pdf/resource/Algorithm.pdf

This module uses the NYU ED classification algorithm to report ED data. The algorithm was developed with the advice of a panel of emergency medicine and primary care physicians, and it is based on an examination of a sample of almost 6,000 full patient ED records. Each case was classified into Emergent Primary Care Treatable, Emergent ED Care Needed but Not Preventable/Avoidable, Emergent ED Care Needed but Preventable/Avoidable, Psych, Alcohol and Drug Related, Mental Health Related, Injury, Unclassified.

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.

!*!*!*!*!*!*!*POPULATION DATA ALERT!*!*!*!*!*!*!*
On August 21, 2024, population estimates for 2020 and later have been updated to IBIS Version 2023. For more information, go to https://ibis.utah.gov/ibisph-view/query/PopEst.html.

Step 1: Select year

(2014)

What year grouping do you want to select? Default is single years, most recent year.
Single years
Enter Custom Year Group(s)

Step 2: Select ED primary care sensitive conditions

Predefined Causes of ED Encounters/Hospitalizations
There are several predefined causes to choose from. If causes on the predefined list does not meet your needs, you may enter your own ICD codes by selecting, User-defined causes.
Which ED primary care sensitive conditions do you want to include in the analysis:
9 groups ED primary care sensitive conditions
5 groups ED PCS conditions

Step 3: Select age

First choose a coding scheme to use for age groups.(Default is age adjustment age groups, all ages.)
13 age groups (Less than 1, 1-4, 5-9, 10-14, 15-17, 18-19, 20-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75+)

Step 4: Select sex

Would you like to include only males or only females in the results? Default includes both sexes.
Both Male and Female
Male
Female

Step 5: Select primary payer

Step 6: Select discharge status

to home or self care, routine discharge
to another short-term general hospital
to skilled nursing facility
to an intermediate care
to another type of institution
to home under care of home health service
left against medical advice
to home under care of home IV provider
expired

Step 7: Select Utah Small Area

Default is all Utah Small Areas
Utah Small Areas

Step 8: How to display the data

(Grouped By: Year x ED primary care sensitive conditions category. Chart: None. Map: Default 2015)

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.

Data queries

Publications search

Query Builder for Emergency Department Encounter for Primary Care Sensitive Conditions Query Module for Utah Small Areas - Crude Rates - ED Treat and Release Encounters

Overview

Overview

Getting Started

Step 1: Select year

What year grouping do you want to select? Default is single years, most recent year.

Step 2: Select ED primary care sensitive conditions

Step 3: Select age

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

Step 4: Select sex

Would you like to include only males or only females in the results? Default includes both sexes.

Step 5: Select primary payer

Step 6: Select discharge status

Step 7: Select Utah Small Area

Default is all Utah Small Areas

Step 8: How to display the data

Utah IBIS-PH

Utah DHHS

State of Utah

IBIS other

All Small Areas
1-1 Brigham City
1-2.1 Box Elder County (Other) V2
1-2.2 Tremonton
1-3.1 Logan V2
1-3.2 North Logan
1-4.1 Cache County (Other)/Rich County (All) V2
1-4.2 Hyrum
1-4.3 Smithfield
12-5 Ben Lomond
12-6.1 Weber County (East)
12-6.2 Morgan County
12-7 Ogden (Downtown)
12-8 South Ogden
12-9 Roy/Hooper
12-10 Riverdale
3-11 Clearfield Area/Hooper
3-12 Layton/South Weber
3-13.1 Kaysville/Fruit Heights
3-13.2 Syracuse
3-14.1 Centerville
3-14.2 Farmington
3-15.1 North Salt Lake
3-15.2 Woods Cross/West Bountiful
3-16 Bountiful
4-17 Salt Lake City (Rose Park)
4-18 Salt Lake City (Avenues)
4-19.1 Salt Lake City (Foothill/East Bench)
4-20 Magna
4-21.1 Salt Lake City (Glendale) V2
4-22.1 West Valley (Center)
4-22.2 West Valley (West) V2
4-23.1 West Valley (East) V2
4-24.1 Salt Lake City (Downtown) V2
4-24.2 Salt Lake City (Southeast Liberty)
4-25 South Salt Lake
4-26.1 Salt Lake City (Sugar House)
4-26.2 Millcreek (South)
4-26.3 Millcreek (East)
4-27.1 Holladay V2
4-28 Cottonwood
4-29.1 Kearns V2
4-30 Taylorsville (East)/Murray (West)
4-30.1 Taylorsville (West)
4-31 Murray
4-32 Midvale
4-33.2 West Jordan (Northeast) V2
4-34.1 West Jordan (Southeast)
4-34.2 West Jordan (West)/Copperton
4-35.1 South Jordan V2
4-35.2 Daybreak
4-36.1 Sandy (West)
4-36.2 Sandy (Center) V2
4-37 Sandy (Northeast)
4-38 Sandy (Southeast)
4-39.1 Draper
4-39.2 Riverton/Bluffdale
4-39.3 Herriman
8-40.1 Tooele County (Other)
8-40.2 Tooele Valley
10-41.1 Eagle Mountain/Cedar Valley
10-41.2 Lehi
10-41.3 Saratoga Springs
10-42.1 American Fork
10-42.2 Alpine
10-43 Pleasant Grove/Lindon
10-44 Orem (North)
10-45 Orem (West)
10-46 Orem (East)
10-47 Provo/BYU
10-48.1 Provo (West City Center)
10-48.2 Provo (East City Center)
10-49.1 Salem City
10-49.2 Spanish Fork
10-49.3 Springville
10-49.4 Mapleton
10-50.1 Utah County (South) V2
10-50.2 Payson
7-51.1 Park City
7-51.2 Summit County (East)
11-52 Wasatch County
9-53.1 Daggett and Uintah County
9-53.2 Duchesne County
2-54.1 Nephi/Mona
2-54.2 Delta/Fillmore
2-54.3 Sanpete Valley
2-54.4 Central (Other)
2-55.1 Richfield/Monroe/Salina
5.1-56.1 Carbon County
5.1-56.2 Emery County
5.1-57.1 Grand County
13-57.3 Blanding/Monticello
13-57.4 San Juan (Other)
6-58 St. George
6-59.1 Washington County (Other) V2
6-59.2 Washington City
6-59.3 Hurricane/La Verkin
6-59.4 Ivins/Santa Clara
6-60 Cedar City
6-61 Southwest LHD (Other)

Data queries

Publications search

Query Builder for Emergency Department Encounter for Primary Care Sensitive Conditions Query Module for Utah Small Areas - Crude Rates - ED Treat and Release Encounters

Overview

Overview

Getting Started

Step 1: Select year

What year grouping do you want to select? Default is single years, most recent year.

Step 2: Select ED primary care sensitive conditions

Predefined Causes of ED Encounters/Hospitalizations

Step 3: Select age

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

Step 4: Select sex

Would you like to include only males or only females in the results? Default includes both sexes.

Step 5: Select primary payer

Step 6: Select discharge status

Step 7: Select Utah Small Area

Default is all Utah Small Areas

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