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

Query Builder for Injury Mortality ICD-10 Query Module for Utah Small Areas - Count

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 coded using International Classification of Diseases (ICD) codes.

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]

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

  • Selecting years

    Select a range of years. Use Ctrl to make multiple selections.

    The year groupings you select here will be used to display your results if you choose "year" below in the display the results step. For instance, if you choose "Single years" here, and choose "Year/Year Groups" in the display the results step, your query results will be displayed for single years, for the range of years you selected. If you select "3-year groups", "5-year groups" or if you enter custom year groups, your query results will be aggregated within those year groups.





  • First choose a coding scheme to use for injury causes of death. (Default is all injury causes)

    • Select TBI cause of death

      • TBI

        ICD-10 codes V01-Y36, Y85-Y87, Y89, U01-U03 as underlying cause of death AND one of the following codes as a contributing cause: S01, S02.0, S02.1, S02.3, S02.7-S02.9, S04.0, S06, S07.0, S07.1, S07.8, S07.9, S09.7-S09.9, T90.1, T90.2, T90.4, T90.5, T90.8, T90.9

      • TBI Fall

        ICD-10 codes W00-W19, X80, Y01, Y30 as underlying cause of death AND one of the following codes as a contributing cause: S01, S02.0, S02.1, S02.3, S02.7-S02.9, S04.0, S06, S07.0, S07.1, S07.8, S07.9, S09.7-S09.9, T90.1, T90.2, T90.4, T90.5, T90.8, T90.9

      • TBI Firearm

        ICD-10 codes W32-W34, X72-X74, X93-X95, Y22-Y24, Y35.0, U01.4 as underlying cause of death AND one of the following codes as a contributing cause: S01, S02.0, S02.1, S02.3, S02.7-S02.9, S04.0, S06, S07.0, S07.1, S07.8, S07.9, S09.7-S09.9, T90.1, T90.2, T90.4, T90.5, T90.8, T90.9

      • TBI MVTC

        ICD-10 codes V02-V04 (.1, .9), V09.2, V12-V14 (.3 t0.9), V19 (.4-.6), V20-V28 (.3-.9), V29 (.4-.9), V30-V39 (.4-.9), V40-V49 (.4,-.9), V50-V59 (.4-.9), V60-V69 (.4-.9), V70-V79 (.4-.9), V80 (.3-.5), V81.1, V82.1, V83-V86 (.0-.3), V87 (.0-.8), V89.2 as underlying cause of death AND one of the following codes as a contributing cause: S01, S02.0, S02.1, S02.3, S02.7-S02.9, S04.0, S06, S07.0, S07.1, S07.8, S07.9, S09.7-S09.9, T90.1, T90.2, T90.4, T90.5, T90.8, T90.9

      • TBI Struck

        ICD-10 codes W20-W22, W50-W52, X79, Y00, Y04, Y29, Y35.3 as underlying cause of death AND one of the following codes as a contributing cause: S01, S02.0, S02.1, S02.3, S02.7-S02.9, S04.0, S06, S07.0, S07.1, S07.8, S07.9, S09.7-S09.9, T90.1, T90.2, T90.4, T90.5, T90.8, T90.9

      • TBI Homicide

        ICD-10 codes X85-Y09, Y87.1, U01-U02 as underlying cause of death AND one of the following codes as a contributing cause: S01, S02.0, S02.1, S02.3, S02.7-S02.9, S04.0, S06, S07.0, S07.1, S07.8, S07.9, S09.7-S09.9, T90.1, T90.2, T90.4, T90.5, T90.8, T90.9

      • TBI Suicide

        ICD-10 codes X60-X84, Y87.0, U03 as underlying cause of death AND one of the following codes as a contributing cause: S01, S02.0, S02.1, S02.3, S02.7-S02.9, S04.0, S06, S07.0, S07.1, S07.8, S07.9, S09.7-S09.9, T90.1, T90.2, T90.4, T90.5, T90.8, T90.9

      • Select drug overdose cause of death

        • Drug overdose involving any drug

          Includes deaths resulting from unintentional or intentional overdose of a drug, being given the wrong drug, taking a drug in error, or taking a drug inadvertently. (ICD-10 codes X40-X44, X60-X64, X85, Y10-Y14 as underlying cause of death

        • Drug overdose involving any opioid

          ICD-10 codes X40-X44, X60-X64, X85, Y10-Y14 as underlying cause of death AND one of the following codes as a contributing cause of death: T40.0, T40.1, T40.2, T40.3, T40.4, T40.6

        • Drug overdose involving heroin

          ICD-10 codes X40-X44, X60-X64, X85, Y10-Y14 as underlying cause of death AND T40.1 as a contributing cause of death

        • Drug overdose involving all opioids other than heroin

          ICD-10 codes X40-X44, X60-X64, X85, Y10-Y14 as underlying cause of death AND one of the following codes as a contributing cause of death: T40.0, T40.2, T40.3, T40.4, T40.6

        • Drug overdose involving natural and semi-synthetic opioids

          Includes such drugs as morphine, codeine, hydrocodone, and oxycodone (ICD-10 codes X40-X44, X60-X64, X85, Y10-Y14 as underlying cause of death AND T40.2 as a contributing cause of death

        • Drug overdose involving methadone

          ICD-10 codes X40-X44, X60-X64, X85, Y10-Y14 as underlying cause of death AND T40.3 as a contributing cause of death

        • Drug overdose involving synthetic opioids other than methadone

          Includes such drugs as fentanyl, fentanyl analogs, and tramadol (ICD-10 codes X40-X44, X60-X64, X85, Y10-Y14 as underlying cause of death AND T40.4 as a contributing cause of death

        • Drug overdose involving cocaine (non-opioid)

          ICD-10 codes X40-X44, X60-X64, X85, Y10-Y14 as underlying cause of death AND T40.5 as a contributing cause of death

        • Drug overdose involving psychostimulants with abuse potential (non-opioid)

          Includes drugs such as methamphetamine, amphetamine, and methylphenidate (ICD-10 codes X40-X44, X60-X64, X85, Y10-Y14 as underlying cause of death AND T43.6 as a contributing cause of death

        • Drug overdose involving benzodiazepines (non-opioid)

          ICD-10 codes X40-X44, X60-X64, X85, Y10-Y14 as underlying cause of death AND T42.4 as a contributing cause of death

      • Select from list of intentions

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

      • 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).




















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

      • Default is all Utah Small Areas

        • To get the HII map please select "ADI" on "Map" on last step "How to display the data" step.

      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.
      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. Activities include informing evidence-based decision making in the State 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 Data, Systems, and Evaluation, Utah Department of Health and Human Services.

      I understand that failure to adhere to the above stated agreement items will result in loss of access to DHHS 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, Code Annotated). If I am a state government employee, this may be grounds for immediate dismissal.
      Office of Vital Records and Statistics, Utah Department of Health and Human Services | Telephone: 801-538-6105 | Website: vitalrecords.utah.gov | 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, 05 November 2024 0:47:29 from Utah Department of Health and Human Services, Indicator-Based Information System for Public Health website: https://ibis.utah.gov/ibisph-view/ ".

      Content updated: Fri, 1 Nov 2024 09:57:59 MDT