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

Query Builder for Utah Lab-Confirmed COVID-19 Cases - Count

Getting Started

The counts and analyses below are restricted to confirmed COVID-19 cases. UDOH considers any person with a positive SARS-CoV2 PCR or antigen test to be a confirmed case.

Utah's LHDs may also report their own case data. Local reports should be considered the most up to date and accurate information for their local area due to small differences in case classifications at any given time

Case data is displayed by the date the first positive laboratory result is reported to public health. There will be small differences in cases by date as public health receives additional information

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

Not all cases are able to be interviewed, and some data are not routinely collected for all cases such as hospitalizations, geographic area, and comorbidities. Because of this an "Unknown" represents either a case that was not able to be interviewed or a case that was interviewed but that particular data was not collected (due to high case counts or an individual deciding not to report that data).

The deaths reported in IBIS are limited to confirmed cases with no alternative cause of death noted on the death certificate or reported by the Office of the Medical Examiner. The counts reported in IBIS will be lower than the counts reported on the public dashboard, as the public dashboard includes probable cases in the death count as well. These counts are provisional and subject to change as investigations are completed. For more information on how COVID-19 deaths are registered in the state of Utah, visit [https://coronavirus.utah.gov/]

In this query, deaths are reported by the day UDOH was notified of their first positive test, not the date of death as reported on [https://coronavirus.utah.gov/]. Deaths often occur days to weeks after they are first diagnosed with COVID-19.

Race/ethnicity data: race categories are not mutually exclusive and will not sum to the total cases, as cases can identify as more than one race. "Other race" includes cases that identified as a race not listed. "Unknown race" captures cases for whom race data was not provided or collected.

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]

  • Enter start date (mm/dd/yyyy)


  • Enter end date (mm/dd/yyyy)


  • 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.

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







    • Select ethnicity. Default is all ethnicities.

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

    • Select Sex. Default is all

  • Comorbidities

    Data on pre-existing conditions are gathered from a variety of sources, including case interviews and medical records (when available). Case interviews are conducted by many public health investigators across state and local health departments to determine what potential medical risk factors cases may have had prior to developing COVID-19. Data gathered through interviews is self-reported by cases and is dependent on willingness to share this information with health departments. This is not a complete list of conditions and rates may change as public health collects more data and performs additional analysis.

    Examples of persons with compromised immune systems include those with cancer and transplant patients who are taking certain immunosuppressive drugs, persons living with HIV/AIDS, and those with inherited diseases that affect the immune system. Chronic pulmonary conditions include uncontrolled asthma, emphysema, and COPD. Examples of persons with a disability include those with dementia, seizure disorders, cognitive impairment, and Alzheimer's disease. Psychological/psychiatric conditions include schizophrenia, major depressive disorder, and bipolar disorder

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

    • Select hospitalization. Default is all

  • COVID-19 Death Count

    The deaths reported in IBIS are limited to confirmed cases with no alternative cause of death noted on the death certificate or reported by the Office of the Medical Examiner. The counts reported in IBIS will be lower than the counts reported on the public dashboard, as the public dashboard includes probable cases in the death count as well. These counts are provisional and subject to change as investigations are completed. For more information on how COVID-19 deaths are registered in the state of Utah, visit [https://coronavirus.utah.gov/COVID-19-deaths/]
    COVID-19 death


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

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.
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. Activities include informing evidence-based decision making in the State 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 Data, Systems, and Evaluation, Utah Department of Health and Human Services.

I understand that failure to adhere to the above stated agreement items will result in loss of access to DHHS 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, Code Annotated). If I am a state government employee, this may be grounds for immediate dismissal.
Office of Communicable Diseases, Utah Department of Health and Human Services | Telephone: 801-538-6191 | Website: epi.utah.gov | Email: epi@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 Tue, 03 December 2024 11:20:16 from Utah Department of Health and Human Services, Indicator-Based Information System for Public Health website: https://ibis.utah.gov/ibisph-view/ ".

Content updated: Wed, 21 Aug 2024 17:03:46 MDT