Query Builder for Mortality ICD-10 Query Module for Utah Counties and Local Health Districts - Crude Rates, Deaths Per 100,000 Population

Step: 1. |2. |3. |4. |5. |6. | Finish 
Overview

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, Office of Vital Records. They include virtually all deaths of Utah residents, regardless of where the death occurred. The causes of death were coded using International Classification of Diseases (ICD) codes.

Getting Started

Follow the steps to narrow your query and display your results. When you are done forming your query, click "Submit" bottom of the screen (last step) to get your query result.
Step 1: Select year (Single Years, 2006) Step 2: Select cause of death (NCHS 50 Leading Causes)

Cause of Death

There are a variety of predefined causes of death to choose from. If causes on the predefined lists do not meet your needs, you may enter your own ICD codes by selecting, (User-defined causes.)
First choose a coding scheme to use for causes of death. Default is all NCHS 50 leading causes.

NCHS Leading Causes of Death

The National Center for Health Statistics (NCHS) has developed a uniform procedure for ranking cause of death. Using the International Classification of Diseases (ICD) coding structure, 113 selected causes of death were consolidated from the entire ICD coding structure. Of these 113 causes a subset of 50 rankable causes were selected to rank deaths for individuals older than one year of age. A subset of 71 rankable causes of death was selected for infant deaths. The rankings denote the most frequently occurring cause of death among causes eligible for ranking. See the help page on the left Navigation for a listing.
NCHS 50 leading causes of death

NCHS Leading Causes of Death

The National Center for Health Statistics (NCHS) has developed a uniform procedure for ranking cause of death. Using the International Classification of Diseases (ICD) coding structure, 113 selected causes of death were consolidated from the entire ICD coding structure. Of these 113 causes a subset of 50 rankable causes were selected to rank deaths for individuals older than one year of age. A subset of 71 rankable causes of death was selected for infant deaths. The rankings denote the most frequently occurring cause of death among causes eligible for ranking. See the help page on the left Navigation for a listing.
NCHS 113 selected causes of death

How to Specify ICD Codes

Enter the codes, use a hyphen to indicate a range of codes, use a space or comma between codes.

For ICD-10 codes: P23 includes all codes under P23 (congenital pneumonia), from P23.0 (Congenital pneumonia due to viral agent) to P23.9 (Congenital pneumonia, unspecified). Because the codes are alpha-numeric and not simply numeric, deaths coded simply (P23) will not be included in a range from P23.0-P23.9. P23-P24 would include all codes under P23 and P24.

For ICD-9 codes: 480 includes all codes under 480 (viral pneumonia), from 480.0 (Pneumonia due to adenovirus) to 480.9 (Viral pneumonia, unspecified). Deaths coded simply 480 will not be included in a range from 480.0-480.9. 480-481 would include all codes under 480 and 481.

For ICD-9 Injury codes: Codes 800 and higher are injury codes. They are referred to as E-codes. To specify E-codes type in the numbers WITHOUT the E. For example: Adverse Effects of Medical Procedures and Care are codes E870-E879. When entering these codes type 870-879.
User defined causes





Step 3: Select age of decedent (Age Adjustment Age Groups)

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

Age adjustment age groups (less than 1, 1-4, 5-14, 15-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75-84, 85+)
Four age groups (0-14,15-44,45-64,65+)
Seven age groups (0, 1-14, 15-24, 25-44, 45-64, 65-84, 85+)
Eight age groups (0-17, 18-24,25-34, 35-44, 45-54, 55-64, 65-74, 75+)
5-year age groups (0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, 85+)

How to Specify Age Groups

Enter whole numbers from 0 to 999.

Use a hyphen to indicate a range of ages (e.g., "5-8" will includes ages 5, 6, 7, and 8).

You may use greater than (>) and less than(<) symbols. An entry of (<1) yields all infants age 0 through 364 days.

You may use a plus sign (+) to indicate all ages equal to or greater than (e.g.,"85+" yields all those aged 85 and over).
Enter custom age group











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 geographic area (Local Health District)

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.

Local health district
County
Step 6: Select how to display the results

Use the drop down list options below to specify how to display the numerical data values on the query results page. If both a Row Values Grouped By and a Column Values Grouped By are specified, then a two dimensional table will be presented in the query results. Regardless of what is selected, a standard data list table will be presented as well as meta data that describes the data sources, data issues, and any data notes. Select the Chart Graphic Type option below if you want a chart graphic to be shown.
Specify how to display the numerical data values.

Column Values Grouped By:
 
Row Values Grouped By:
 Crude Rates, Deaths Per 100,000 Population data values
 

Chart Graphic Type:

Finish: Submit the defined query

Utah Department of Health IBIS Query System, Data Use Agreement

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 of Utah. Activities include informing evidence-based decision making in Utah 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:
  1. Use the data for statistical reporting and analysis only.
  2. Avoid any attempt to identify or contact individual(s) represented in the IBIS-PH query system data.
  3. Avoid disclosure or use of the identity of any individual(s) discovered inadvertently.
  4. 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.
  5. 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.
  6. Report IMMEDIATELY any inadvertent or intentional identity disclosures or violations of this agreement of which I become aware to the Director of the Center for Public Health Data, Utah Department of Health.

I understand that failure to adhere to the above stated agreement items will result in loss of access to UDOH 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, Utah Code Annotated). If I am a Utah state government employee, this may be grounds for immediate dismissal.

Office of Vital Records and Statistics, Center for Health Data, Utah Department of Health, 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's Center for Health Data IBIS-PH web site (http://ibis.health.utah.gov). The information published on this website may be reproduced without permission. Please use the following citation: "Retrieved Mon, 08 September 2008 10:18:35 from Utah Department of Health, Center for Health Data, Indicator-Based Information System for Public Health Web site: http://ibis.health.utah.gov".

Content updated: Tue, 1 Apr 2008 15:14:47 MDT