Skip directly to searchSkip directly to the site navigationSkip directly to the page's main content

Query Builder for Years of Potential Life Lost (YPLL - Premature Mortality) Before Age 75 for Utah Small Areas - Rate of Potential Life Lost per 100,000 Population

Overview

The mortality data in this IBIS-Q query module have been derived from death certificates in participation with the National Vital Statistics System, and are maintained and provided by the Utah Department of Health and Human Services, Office of Vital Records. They include virtually all deaths of Utah residents, regardless of where the death occurred. The causes of death were classified using International Classification of Diseases (ICD-10) codes. The small area 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.

"Utah Small Areas" refers to a set of geographic areas in Utah with population sizes ranging from approximately 15,000 to 60,000 persons. These geographic areas are especially useful for doing public health assessment in communities within Utah's urban counties. Utah Small Area population numbers are not available for race, ethnicity, or single year of age.

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

!*!*!*!*!*!*!*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.

  • What year grouping do you want to select? Default is the most recent year group

  • Default is all Utah Small Areas

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

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.

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.

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.

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.
Office of Vital Records and Statistics, Division of Data, Systems, and Evaluation, Utah Department of Health and Human Services, Salt Lake City, UT 84114-1012, Telephone: 801-538-6843, Website: http://health.utah.gov/vitalrecords/, Email: vrequest@utah.gov
The information provided above is from the Utah Department of Health and Human Services IBIS-PH website (https://ibis.utah.gov/ibisph-view/). The information published on this website may be reproduced without permission. Please use the following citation: " Retrieved Tue, 29 April 2025 22:04:43 from Utah Department of Health and Human Services, Indicator-Based Information System for Public Health website: https://ibis.utah.gov/ibisph-view/ ".

Content updated: Tue, 22 Apr 2025 11:06:16 MDT