UT-EPHT - Query Builder - Small Area Income and Poverty Estimates (SAIPE) Query Module for Utah Counties and Local Health Districts

Overview

This query module allows the user to query data from the United States Census Bureau's Small Area Income and Poverty Estimates (SAIPE) program, 1-year estimates.

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.

Step 1: Select year

( 2022 )

Select years.

Step 2: Select age groups

( All ages )

All ages
Under 18 years

Step 3: Select geographic area

(Geographic Area: all)

First choose a geography type. Default is entire Utah State.
County
Local health district

Step 4: How to display the data

To display a map, you must select Geographic Area in Display By (category) and None in Group By (series)

Display By (category) 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.
Group By (series) 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.
Chart 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.
Map 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.
Primary Measure Available Measures Defines the primary measure value to display in the map and graph.

Public Data

Secure Data

My EPHT

Query Builder for Small Area Income and Poverty Estimates (SAIPE) Query Module for Utah Counties and Local Health Districts - Percentage of Persons Living in Poverty

Overview

Overview

Getting Started

Step 1: Select year

Select years.

Step 2: Select age groups

Step 3: Select geographic area

First choose a geography type. Default is entire Utah State.

Step 4: How to display the data

Utah EPHT

Utah DOH

Legal

Other

Base Map

Overlays

Labels

Roads

Water

Area Boundaries

Area Selections

Beaver
Box Elder
Cache
Carbon
Daggett
Davis
Duchesne
Emery
Garfield
Grand
Iron
Juab
Kane
Millard
Morgan
Piute
Rich
Salt Lake
San Juan
Sanpete
Sevier
Summit
Tooele
Uintah
Utah
Wasatch
Washington
Wayne
Weber

Public Data

Secure Data

My EPHT

Query Builder for Small Area Income and Poverty Estimates (SAIPE) Query Module for Utah Counties and Local Health Districts - Percentage of Persons Living in Poverty

Overview

Overview

Getting Started

Step 1: Select year

Select years.

Step 2: Select age groups

Step 3: Select geographic area

First choose a geography type. Default is entire Utah State.

Step 4: How to display the data

Primary group by field

Optional secondary group by field

Optional chart graph

Optional map graph

Available Measures

Utah EPHT

Utah DOH

Legal

Other