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

Query Builder for Birth-Death Linked Infant Mortality (Death Cohort) Query Module for Utah Counties and Local Health Districts by Mother's Race and Medicaid Status - Neonatal Mortality Rate (age 0-27 days)

Overview

The death data in this IBIS-Q query module come from the Utah Death Certificate database. The Utah Department of Health and Human Services, Office of Vital Records and Statistics maintains the database. Infant mortality is the number of infants who died before they were 365 days old (from 0 through 364 days of age).

Birth-Death Linked Infant Mortality (Death Cohort, or Period File) provides the number of infant deaths that occurred during a particular year (regardless of the year of birth). This module gives the number of infant deaths during the year per 1,000 live births during the same year.

Getting Started

Follow the steps to narrow your query and display your results. When you are done forming your query, click "Submit" at the bottom of the screen (last step) to get your query result.

  • Select the years you would like to include in your analysis. The default is all single years.

  • How to Specify Year Groups

    Enter the year groups by which you would like the data gathered. Use a hyphen to indicate a range of ages (e.g., '1989-1991' will include years 1989, 1990, and 1991.)





  • Select the races and medicaid status you would like to include in your analysis.

    • Race Ethnicity in Combination

      Race and ethnicity collection can be very complex. Depending on the purpose of the data, IBIS-PH users can use different levels of granularity. If the purpose is to provide a more accurate picture of the OVERALL minority population in Utah, we advise using the combined race/ethnicity selection.

  • Select other characteristics of the mother that you would like to include in your analysis. The default is all characteristics.

    • Select from list of age groups

    • Education level coding has been changed from year 2009. DO NOT combine 2009 and after data with previous years data on this selection

  • Parity

    Parity is the number of previous live-born children a woman has delivered. Select 0 if looking for information about the first child born to a woman.

  • Select the infant characteristics you would like to include in the analysis. The default is all characteristics.

  • Birth Weight

    Normal Birth Weight: Live-born infants whose birth weight was equal to or greater than 2500 grams (about 5.5 lbs.)

    Low Birth Weight: Live-born infants whose birth weight was less than 2500 grams (about 5.5 lbs.)

    Very Low Birth Weight: Live-born infants whose birth weight was less than 1500 grams (about 3.3 lbs.)

    Extremely Low Birth Weight: Live-born infants whose birth weight was less than 1000 grams (about 2.2 lbs.)

  • Gestational Age

    Gestational Age is the period of time a baby is carried in the uterus or the duration of the pregnancy, measured from the first day of the last menstrual period. Full-term gestation is between 37 and 42 weeks.

    • Select from list of ages

  • Size for Gestational Age

    Small for gestational age (SGA) is a term used to describe a baby who is smaller than the usual amount for the number of weeks of pregnancy. SGA babies usually have birthweights below the 10th percentile for babies of the same gestational age. This means that they are smaller than 90 percent of all other babies of the same gestational age.

    Large for gestational age (LGA) is a term used to describe a baby who is larger than the usual amount for the number of weeks of pregnancy. LGA babies usually have birthweights above the 90th percentile for babies of the same gestational age. This means that they weigh more than 90 percent of all other babies of the same gestational age.

    • Select from list of sets

  • Select the health care system characteristics you want to include in your analysis. The default is all characteristics.

  • Number of Prenatal Care Visits

    ACOG recommends the following prenatal care visit schedule:

    1 visit per month (every 4 weeks) until week 28

    2 visits per month (every 2 to 3 weeks) from weeks 28 to 36

    1 visit per week from week 36 until birth

    Certain medical conditions in pregnancy may necessitate more visits.

    • Trimester coding has been changed from year 2009. DO NOT combine 2009 and after data with previous years data on this selection.

    • Kotelchunk method coding has been changed from year 2009. DO NOT combine 2009 and after data with previous years data on this selection

  • Facility Where Infant Born

    A tertiary care facility is a hospital with a unit that has continuously available personnel and equipment to provide life support for as long as needed. Tertiary care facilities are able to provide care to newborn infants with birthweights less than 1000 grams or gestational ages less than 28 weeks.

    • Birth method coding has been changed from year 2009. DO NOT combine 2009 and after data with previous years data on this selection.

    • Birth attendant coding has been changed from year 2009. DO NOT combine 2009 and after data with previous years data on this selection.

  • Interpregnancy Interval

    The interpregnancy interval is the time (in months) between the completion of one pregnancy resulting in a live born infant and conception of the next pregnancy.

    • Select from list of intervals

  • Definitions

    This option allows you to query birth data based on the residency status of the mother and whether or not the birth took place in Utah

    Term Definitions: * All Resident Births: all births to mothers who are Utah residents * All Utah Births: all births that occured in Utah regardless of the mother's residency status * All Resident Births in Utah: all births that occured in Utah to Utah mothers
    Select they type of residence you would like to include in your analysis. Click on the term to see a more detailed explanation. The default is resident births.

    • All live births to Utah resident mothers regardless of where they occurred.

    • All live births in Utah regardless of residence status.


  • Select the geographic areas you would like to include in your analysis..

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.

Available Measures

Defines the primary measure value to display in the map and graph.
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 EPHT 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 EPHT query system data.
  3. Avoid disclosure or use of the identity of any individual(s) discovered inadvertently.
  4. Avoid linkage of EPHT query system data with other data that, after linkage, might allow identification of an individual represented in the EPHT 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, Department of Health.

I understand that failure to adhere to the above stated agreement items will result in loss of access to DOH 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's Center for Health Data IBIS-PH web site (http://epht.health.utah.gov). The information published on this website may be reproduced without permission. Please use the following citation: " Retrieved Sun, 24 November 2024 12:17:33 from Utah Department of Health, Center for Health Data, Indicator-Based Information System for Public Health Web site: http://epht.health.utah.gov ".

Content updated: Fri, 8 Nov 2024 16:19:06 MST