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 Counties - 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. For years 2000 and later the population estimates are provided by the National Center for Health Statistics (NCHS) through a collaborative agreement with the U.S. Census Bureau.

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

  • Utah Resident Deaths

    For Utah public health assessment, typically only Utah residents are included in analyses of death data.

    Death records for Utah residents who died while they were visiting outside the state are included in the Utah death dataset. Interstate exchange of vital records takes place between all 50 U.S. states and territories as part of the National Vital Statistics System (NVSS).
    First choose a geography type. Default is all Utah residents, regardless of place of death.

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.
Utah Environmental Public Health Tracking Network, Utah Department of Health and Human Services, P.O. Box 142104, Salt Lake City, UT 84114-2104, Telephone: 801-538-6191, Email: eep@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, 22 April 2025 7:47:51 from Utah Department of Health and Human Services, Indicator-Based Information System for Public Health website: https://ibis.utah.gov/ibisph-view/ ".

Content updated: Mon, 21 Apr 2025 14:25:14 MDT
 Department of Health and Human Services IBIS query system, data use agreement
Close