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

Query Builder for Query Module for Preliminary Blood Lead Test Result - Count of Blood Lead Tests

Overview

These preliminary lab reported values are based on available blood lead test results from adults and children. These values are continuously being reported through electronic lab records, which are only a fraction of the final total counts. For further information about blood lead testing in children, please go to the EPHT topic page.

Getting Started

Follow the steps to narrow your query and display your results. When you are done selecting your query, click "Submit" at the bottom of the screen to view your results.

  • Default is all ages

  • Default is both.

  • Default includes all.

  • Default includes all.

  • Default includes all levels (measured in micrograms per deciliter).

  • Default includes all.

  • Default includes both confirmed, uncomfirmed and unknown blood lead tests.

  • Default is all Utah counties

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.
Utah Environmental Public Health Tracking Network, Utah Department of Health and Human Services, P.O. Box 142104, Salt Lake City, UT 84114-2104, Telephone: 801-538-6191, Email: eep@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, 19 April 2025 7:07:36 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: Tue, 8 Apr 2025 09:10:48 MDT
 Department of Health EPHT Query System, Data Use Agreement
Close