IBIS-PH Query System Contents and Usage

The IBIS-PH Query System provides a simple-to-use interface that allows a user to step through data selection options and perform custom queries of Utah's public health databases.

What is a custom query?

A custom query is an interface (set of pages) where the user can select a dataset (birth) and a measure (count) and then limit the results to a year, age group, local health district, etc. to obtain specific data. Available datasets are listed below as well as on the left navigation buttons. Measures can include rates, counts, survey topics, top 10 lists, averages, etc. The limiting selections depend on the dataset. For example, mortality data can be limited by year, cause of death, age, gender, and geography (county, local health district, Utah Small Areas).

Basic steps to follow:

1. Select the dataset using the left navigation buttons.
2. Select a measure. Click on one of the blue bars to see a list of measures. The most commonly used measures are listed under the "Quick Selection" bar. Use the "Advanced Selection" bar to find measures for Utah Small Areas, race/ethnicity, maps, etc. For datasets that also have injury measures click on the "Injury Selection" bar or choose "Injury" from the left navigation buttons.
3. Build your query. After selecting a measure you will see a page with a series of numbered steps (blue bars). Click on a step bar to expand the step. Make selections to build your query.
4. View and/or modify your results. From the results page you can select/change a chart, export to Excel, use the Query Definition button to modify your query selections, or start a new query. For more information about these features and step-by-step examples see the IBIS-PH Query System Tutorials page.

See the Query Help page or the Query Tips page for more query system information.

Datasets currently included (or under consideration):

• Population Estimates (includes general, Utah Small Area, and race/ethnicity)
• Birth (includes general, Utah Small Area, race, and Medicaid)
• Fetal Death
• Infant Death (includes general, Utah Small Area, race, Medicaid, and birth-death linked)
• Mortality (includes general, Utah Small Area, injury, ICD-10, and ICD-9)
• Inpatient Hospital Discharge (includes general, Utah Small Area, and injury)
• Emergency Department Encounter (includes general, Utah Small Area, and injury)
• Emergency Department Encounters for Primary Care Sensitive Conditions (includes general and Utah Small Area)
• BRFSS (Behavioral Risk Factor Surveillance System)
• UHAS (Utah Healthcare Access Survey)
• PRAMS (Pregnancy Risk Assessment and Monitoring System)
• YRBS (Youth Risk Behavior Survey)
• Utah Cancer Registry
• National Toxic Substance Incidents Program

Data uses:

The information is intended to support evidenced-based decision making in Utah to plan and improve service delivery, evaluate health care systems, and inform policy decisions. Acceptable uses of the data are listed in the Data Use Agreement. For a list of other possible uses see the Indicator Reports Contents and Usage page.

Data Stewards:

Data Stewards are those individuals responsible for the various datasets available in the IBIS-PH Custom Queries.