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

Query Builder for Utah's Pregnancy Risk Assessment and Monitoring Survey (PRAMS) Query Module - Exercise Before Pregnancy (2009 and later)

Overview

The PRAMS data is maintained by the Utah Department of Health and Human Services, Reproductive Health Program. PRAMS is an ongoing population-based risk factor surveillance system designed to identify and monitor selected maternal experiences that occur before and during pregnancy and experiences of the child's early infancy. The data used for the denominator are from birth records.

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 year or years you want to include.

  • 7 age groups (0-17, 18-19, 20-24, 25-29, 30-34, 35-39, 40+)

  • Select one or more characteristics to limit results: (Default is all characteristics)

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.

Available Measures

Defines the primary measure value to display in the map and graph.
Maternal and Infant Health Program, Division of Family Health and Preparedness, Utah Department of Health and Human Services, Salt Lake City, UT 84114-2002, Telephone: 801-273-2871, Fax: 801-274-0674, Website: https://mihp.utah.gov/, Contact: Laurie Baksh, Email: lbaksh@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 Wed, 26 March 2025 7:48:20 from Utah Department of Health and Human Services, Indicator-Based Information System for Public Health website: https://ibis.utah.gov/ibisph-view/ ".

Content updated: Mon, 24 Mar 2025 16:48:58 MDT
 Department of Health and Human Services IBIS query system, data use agreement
Close