IBIS-PH - Query Builder - Utah COVID-19 Test - Percent Positivity (Test/Test Method)

Overview

Getting Started

CDC proposes three methods for calculating percent positivity. The UDOH uses the third method of number of people tested positive over the number of people tested. The analysis is restricted to PCR and Antigen tests. For a person that has a positive test, their first positive test is used. If there is no positive result for that individual, then their first negative result is used. To calculate the reported 7-day rolling average percent positivity rate, the UDOH tallies the number of people who tested positive in 7 days, divided by the total number of people tested in the same 7 day.

The total number of people who tested positive will not total the total number of cases reported in the state. This discrepancy is due to ongoing investigations and confirmatory testing.

Case and lab data are updated weekly on Thursdays using reported case data

Not all labs are reported with complete demographic and geographic data, tests with incomplete variables will be reported with "unknown". These data may be subsequently reported and updated retroactively.

All data are preliminary and subject to change.

For help or any questions about the COVID-19 queries, please email IBIS@utah.gov

For step by step instruction about how to use COVID-19 queries, please go to https://ibis.utah.gov/ibisph-view/pdf/resource/query/COVID_Queries_Instructions_2.pdf

Step 1: Enter start lab collection date

(01/01/2020)

Enter start lab collection date (mm/dd/yyyy)

Step 2: Enter end lab collection date

(Today)

Enter end case lab collection date (mm/dd/yyyy)

Step 3: Select year/week

Year
Week

Step 4: Select demographic characteristics

Step 5: Select geographic area

First choose a geography type. Default is all Utah residents, regardless of place of hospitalization.
Local health district
County
Small area

Step 6: How to display the data

(Grouped By: Lab Collection Date. Chart: None. Map: Default 2015)

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.

Data queries

Publications search

Query Builder for Utah COVID-19 Test - Percent Positivity (Test/Test Method)

Overview

Getting Started

Step 1: Enter start lab collection date

Enter start lab collection date (mm/dd/yyyy)

Step 2: Enter end lab collection date

Enter end case lab collection date (mm/dd/yyyy)

Step 3: Select year/week

Step 4: Select demographic characteristics

Select one or more subgroups to limit results. Default is all characteristics.

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

Select ethnicity. Default is all ethnicities.

Select one or more subgroups to limit results. Default is all characteristics.

Select Sex. Default is all

Step 5: Select geographic area

First choose a geography type. Default is all Utah residents, regardless of place of hospitalization.

Step 6: How to display the data

Utah IBIS-PH

Utah DHHS

State of Utah

IBIS other

Base Map

Overlays

Labels

Roads

Water

Area Boundaries

Area Selections

All weeks
Week 0
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Week 12
Week 13
Week 14
Week 15
Week 16
Week 17
Week 18
Week 19
Week 20
Week 21
Week 22
Week 23
Week 24
Week 25
Week 26
Week 27
Week 28
Week 29
Week 30
Week 31
Week 32
Week 33
Week 34
Week 35
Week 36
Week 37
Week 38
Week 39
Week 40
Week 41
Week 42
Week 43
Week 44
Week 45
Week 46
Week 47
Week 48
Week 49
Week 50
Week 51
Week 52

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

1-1 Brigham City
1-2.1 Box Elder County (Other) V2
1-2.2 Tremonton
1-3.1 Logan V2
1-3.2 North Logan
1-4.1 Cache County (Other)/Rich County (All) V2
1-4.2 Hyrum
1-4.3 Smithfield
12-5 Ben Lomond
12-6.1 Weber County (East)
12-6.2 Morgan County
12-7 Ogden (Downtown)
12-8 South Ogden
12-9 Roy/Hooper
12-10 Riverdale
3-11 Clearfield Area/Hooper
3-12 Layton/South Weber
3-13.1 Kaysville/Fruit Heights
3-13.2 Syracuse
3-14.1 Centerville
3-14.2 Farmington
3-15.1 North Salt Lake
3-15.2 Woods Cross/West Bountiful
3-16 Bountiful
4-17 Salt Lake City (Rose Park)
4-18 Salt Lake City (Avenues)
4-19.1 Salt Lake City (Foothill/East Bench)
4-20 Magna
4-21.1 Salt Lake City (Glendale) V2
4-22.1 West Valley (Center)
4-22.2 West Valley (West) V2
4-23.1 West Valley (East) V2
4-24.1 Salt Lake City (Downtown) V2
4-24.2 Salt Lake City (Southeast Liberty)
4-25 South Salt Lake
4-26.1 Salt Lake City (Sugar House)
4-26.2 Millcreek (South)
4-26.3 Millcreek (East)
4-27.1 Holladay V2
4-28 Cottonwood
4-29.1 Kearns V2
4-30 Taylorsville (East)/Murray (West)
4-30.1 Taylorsville (West)
4-31 Murray
4-32 Midvale
4-33.2 West Jordan (Northeast) V2
4-34.1 West Jordan (Southeast)
4-34.2 West Jordan (West)/Copperton
4-35.1 South Jordan V2
4-35.2 Daybreak
4-36.1 Sandy (West)
4-36.2 Sandy (Center) V2
4-37 Sandy (Northeast)
4-38 Sandy (Southeast)
4-39.1 Draper
4-39.2 Riverton/Bluffdale
4-39.3 Herriman
8-40.1 Tooele County (Other)
8-40.2 Tooele Valley
10-41.1 Eagle Mountain/Cedar Valley
10-41.2 Lehi
10-41.3 Saratoga Springs
10-42.1 American Fork
10-42.2 Alpine
10-43 Pleasant Grove/Lindon
10-44 Orem (North)
10-45 Orem (West)
10-46 Orem (East)
10-47 Provo/BYU
10-48.1 Provo (West City Center)
10-48.2 Provo (East City Center)
10-49.1 Salem City
10-49.2 Spanish Fork
10-49.3 Springville
10-49.4 Mapleton
10-50.1 Utah County (South) V2
10-50.2 Payson
7-51.1 Park City
7-51.2 Summit County (East)
11-52 Wasatch County
9-53.1 Daggett and Uintah County
9-53.2 Duchesne County
2-54.1 Nephi/Mona
2-54.2 Delta/Fillmore
2-54.3 Sanpete Valley
2-54.4 Central (Other)
2-55.1 Richfield/Monroe/Salina
5.1-56.1 Carbon County
5.1-56.2 Emery County
5.1-57.1 Grand County
13-57.3 Blanding/Monticello
13-57.4 San Juan (Other)
6-58 St. George
6-59.1 Washington County (Other) V2
6-59.2 Washington City
6-59.3 Hurricane/La Verkin
6-59.4 Ivins/Santa Clara
6-60 Cedar City
6-61 Southwest LHD (Other)

Data queries

Publications search

Query Builder for Utah COVID-19 Test - Percent Positivity (Test/Test Method)

Overview

Getting Started

Step 1: Enter start lab collection date

Enter start lab collection date (mm/dd/yyyy)

Step 2: Enter end lab collection date

Enter end case lab collection date (mm/dd/yyyy)

Step 3: Select year/week

Step 4: Select demographic characteristics

Select one or more subgroups to limit results. Default is all characteristics.

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

Select ethnicity. Default is all ethnicities.

Select one or more subgroups to limit results. Default is all characteristics.

Select Sex. Default is all

Step 5: Select geographic area

First choose a geography type. Default is all Utah residents, regardless of place of hospitalization.

Step 6: How to display the data

Primary group by field

Optional secondary group by field

Optional chart graph

Optional map graph

Available Measures

Utah IBIS-PH

Utah DHHS

State of Utah

IBIS other