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

Query Builder for EPHT NCDM Birth Query Module for Utah Counties and Local Health Districts (Term Singletons Only) - Male to Female Sex Ratio at Birth (Term Singletons Only)

Overview

The birth data in this IBIS-Q query module come from the Utah Birth Certificate database. The database is maintained by the Utah Department of Health and Human Services, Office of Vital Records and Statistics. The population data used for the denominator were produced by the Utah Governor's Office of Planning and Budget (GOPB) for years 1980-1999 and the U.S. Census Bureau for years 2000 and later, are considered the most accurate available.

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.

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

  • Select the years you would like to include in your analysis. The default is the most recent year.

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





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











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

  • Mother's Residency

    Mother's residency
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 web site (https://ibis.utah.gov/epht-view/). The information published on this website may be reproduced without permission. Please use the following citation: " Retrieved Sat, 08 March 2025 23:32:26 from Utah Department of Health and Human Services, Indicator-Based Information System for Public Health Web site: https://ibis.utah.gov/epht-view/ ".

Content updated: Mon, 3 Mar 2025 14:25:30 MST
 Department of Health EPHT Query System, Data Use Agreement
Close