Query Builder for Birth Query Module for Utah Counties and Local Health Districts - Percentage With Prenatal Care in the First Trimester

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

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, 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, and 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" bottom of the screen (last step) to get your query result.
Step 1: Select year (Year, 2007) Step 2: Select mother's age group (Mother's age group)

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

Maternal age groups (Under 15, 15-17, 18-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50+)

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 3: Select mother characteristics

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

Education
Less than High School (0-11 years)
High School Graduate (12 years)
Some College (13-15 years)
College Graduate (16+ years)
Marital status
Married
Not Married
Hispanic origin
Hispanic
Non-Hispanic

Body Mass Index

Body mass index (BMI) is measure of body fat based on height and weight that applies to both adult men and women.

BMI Categories: Underweight: 21+ years - BMI less than 18.5. Under 21 years - BMI under 5th percentile. Normal: 21+ years - BMI 18.5-24.9. Under 21 years - BMI 5th to 85th percentile. Overweight: 21+ years - 25.0 - 29.9. Under 21 years - BMI 85th to 95th percentile. Obese: 21+ years - BMI 30.0 +. Under 21 years - 95th percentile or over.

Online calculator: http://www.nhlbisupport.com/bmi/bmicalc.htm

Adult BMI: http://www.cdc.gov/nccdphp/dnpa/bmi/index.htm

Child/Teen BMI: http://www.cdc.gov/nccdphp/dnpa/bmi/bmi-for-age.htm
Pre-pregnancy body mass index (BMI)
Underweight
Normal
Overweight
Obese

Adequate Weight Gain

This measure is based on the Institute of Medicine's 1990 recommendations for weight gain during pregnancy. The measure is based upon maternal prepregnancy body mass index and amount of weight gained during pregnancy. The IOM recommendations are as follows:

Prepregnancy BMI: _____ Recommended weight gain:




Less than 19.8 _________ 28 - 40 pounds




19.8 to 26.1 ___________ 25 - 35 pounds




26.1 to 29.1 ___________ 15 - 25 pounds




29.1 or greater _________ 0 - 15 pounds

Weight gain below the recommended amount is considered inadequate. Weight gain above the recommended amount is considered excessive.

Weight gain within the recommended weight gain range has been associated with positive birth outcomes.
Adequacy of weight gain during pregnancy
Inadequate
Adequate
Excessive
Tobacco use during pregnancy
Yes
No
Alcohol use during pregnancy
Yes
No

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.
Parity
0
1
2
3 or more
Step 4: Select infant characteristics

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

Infant sex
Both male and female
Male
Female

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

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.
Age of gestation

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.
Size at gestational age
Small
Apporpriate
Large
Single or multiple birth
Single Birth
Twins
Triplets
Quadruplets
Quintuplets or higher
Step 5: Select health care system characteristics

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.
Number of prenatal care visits
Adequacy of prenatal care (Kotelchuck method)
Inadequate
Adequate
Not Determined
Adequate Plus

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.
Facility where infant born
Tertiary care hospitals
Non-tertiary care
Birth method
Place of birth
Type of birth attendant

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.
Interpregnancy interval

Select from list of intervals

Step 6: Select resident or occurent births (Resident, All live births to Utah resident mothers regardless of where they occurred)

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 resident births
All live births to Utah resident mothers regardless of where they occurred
All occurent births
All live births that occured in Utah regardless of the mother's residency status.
All resident births in Utah
All live births to Utah resident mothers which occurred in Utah.
Step 7: Select mother's geographic area (Birth Residence Local Health District)

Selecting Geography

Select the geographic areas you want to include. Hold down the control (ctrl) key to make multiple selections.
Select the geographic areas you would like to include in your analysis.

Mother's Residency

Mother's residency
Mother's residency: local health district
Mother's residency: county

Birth Occurrence

Where the birth occurred
Birth occurrence: local health district
Birth occurrence: county
Urban/Rural residence
Both
Urban
Rural
Step 8: 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:
 Percentage With Prenatal Care in the First Trimester 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 Thu, 21 August 2008 19:52:12 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: Fri, 28 Mar 2008 23:30:03 MDT