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

Query Builder for Utah's Behavioral Risk Factor Surveillance System (BRFSS) Combined Landline and Cell Query Module - HIV test

Overview

The BRFSS Survey data in this IBIS-Q query module is collected and maintained by the Utah Department of Health and Human Services, Division of Data, Systems, and Evaluation. The BRFSS collects uniform, state-specific data on preventive health practices and risk behaviors that are linked to chronic diseases, injuries, and preventable infectious diseases in the adult population.

When to use the HII vs the Utah HPI

The Health Improvement Index (HII) is a composite measure based on nine indicators that describe important drivers of health such as demographics, socioeconomic deprivation, economic disadvantage, resource availability, and opportunity structure by geography (Utah Small Area). Each small area is categorized into one of five HII groups: very low, low, average, high, and very high. The higher the group, the higher the socio-economic disadvantage. The Utah Healthy Places Index (HPI) is based on the California HPI developed by the Public Health Alliance of Southern California. The Utah HPI tool evaluates the relationship between 22 identified key drivers of health and life expectancy at birth and produces a score ranking from 1 to 99 that shows the relative impact of conditions in a selected area compared to all other such places in the state. The Utah HPI score is divided into 4 quartiles where HPI quartile 1 represents communities with less healthy community conditions and quartile 4 represents more healthy community conditions. Both indices can be used to contextualize health outcomes within the context of opportunities and resource availability based on geography. However, there are times when one over the other may be more appropriate. - Use the HII when you are interested in looking at an association with health disparities and economic, educational, and household characteristics. - Use the Utah HPI when you are interested in looking at an association with health outcomes and community conditions such as environment and transportation in addition to economic disadvantage. The HPI and HII are inverse indices so groups with a higher HII score represent higher socio-economic disadvantage whereas groups with a higher HPI quartile represent healthier community conditions.

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.

  • Selecting years

    Select a range of years. Use Ctrl to make multiple selections.

    The year groupings you select here will be used to display your results if you choose "year" below in the display the results step. For instance, if you choose "Single years" here, and choose "Year/Year Groups" in the display the results step, your query results will be displayed for single years, for the range of years you selected. If you select "3-year groups", "5-year groups" or if you enter custom year groups, your query results will be aggregated within those year groups.
    Select the year or years you want to include.

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









    • Sex

      What is your sex?
      Would you like to include only males or only females in the results? Default includes both sexes.

    • SexOri

      Which of the following best represents how you think of yourself: Lesbian or gay, Straight, that is not gay, Bisexual, or Something else

    • LGBTQT

      Do you consider yourself to be transgender and/or Which of the following best represents how you think of yourself: Lesbian or gay, Straight, that is not gay, Bisexual, or Something else?

  • Demographic Characteristics Help

    To query the entire state, leave boxes unchecked.
    Select one or more subgroups to limit results. Default is all characteristics.

    • Select race. Default is all races.

    • Select race. Default is all races.

    • Ethnicity

      Are you Hispanic, Latino/a, or Spanish origin?
      Select ethnicity. Default is all ethnicities.

  • Education

    What is the highest grade or year of school you completed?

    • Select education. Default is all education levels.

    • Income

      What is your annual household income from all sources?
      Select income level. Default is all income levels.

    • Are you married

      What is the ZIP Code where you currently live? In what county do you currently live?
      Select marital status. Default is all.

    • Select poverty level. Default is no poverty level selected.

      • Poverty level 50% FPL

        When calculating poverty for the BRFSS we use the midpoint of the household income category instead of actual income. poverty guidelines are taken annually from the US Department of Human Services. This includes households where the household income is half or less than the federal poverty level.

      • Poverty level 100% FPL

        When calculating poverty for the BRFSS we use the midpoint of the household income category instead of actual income. poverty guidelines are taken annually from the US Department of Human Services. This includes households where the household income is at or less than the federal poverty level.

      • Poverty level 133% FPL

        When calculating poverty for the BRFSS we use the midpoint of the household income category instead of actual income. poverty guidelines are taken annually from the US Department of Human Services. This includes households where the household income is up to 33% higher than the federal poverty level.

      • Poverty level 150% FPL

        When calculating poverty for the BRFSS we use the midpoint of the household income category instead of actual income. poverty guidelines are taken annually from the US Department of Human Services. This includes households where the household income is up to 50% higher than the federal poverty level.

      • Poverty level 185% FPL

        When calculating poverty for the BRFSS we use the midpoint of the household income category instead of actual income. poverty guidelines are taken annually from the US Department of Human Services. This includes households where the household income is up to 85% higher than the federal poverty level.

      • Poverty level 200% FPL

        When calculating poverty for the BRFSS we use the midpoint of the household income category instead of actual income. poverty guidelines are taken annually from the US Department of Human Services. This includes households where the household income is up to double the federal poverty level.

      • Poverty level 250% FPL

        When calculating poverty for the BRFSS we use the midpoint of the household income category instead of actual income. poverty guidelines are taken annually from the US Department of Human Services. This includes households where the household income is up to one and a half times higher than the federal poverty level.

    • Military

      Have you ever served on active duty in the United States Armed Forces, either in the regular military or in a National Guard or military reserve unit?
      Select military service. Default is all.

    • Religion

      Do you consider yourself to be Protestant, Catholic, Jewish, LDS (Latter Day Saints), Some other religion I have not mentioned, No Religion?
      Select religion. Default is all.

    • Rent or Own

      Do you own or rent your home?
      Select rent or own. Default is all.

    • Employment Status

      Are you currently employed for wages, self-employed, out of work for 1 year or more, out of work for less than 1 year, a homemaker, a student, retired, or unable to work?
      Default is all.

  • Select following indicator only if you plan to display your results by this indicator. Default is None. No BRFSS indicator is selected

  • Default is all

  • Health Improvement Index (HII) Help

    HII groups categorize geographic areas based on their socio-economic conditions, with higher scores indicating greater socio-economic disadvantage and a greater need for improvements to advance health equity and reduce health disparities. The HII refers to the overall socio-economic conditions of a geographic area, but health disparities may still exist within the area among different subpopulations.

    * Very high HII: these geographic areas are characterized by very high levels of socio-economic disadvantage. Significant improvements are necessary to address potential disparities and advance health equity in these areas.

    * High HII: these geographic areas are characterized by high levels of socio-economic disadvantage. Improvements are necessary to address potential disparities and advance health equity in these areas.

    * Average HII: these geographic areas are not characterized by socio-economic disadvantages. Adverse health outcomes in these areas should not be classified as health disparities.

    * Low HII: these geographic areas are not characterized by socio-economic disadvantages and are above average in terms of socio-economic conditions. Adverse health outcomes in these areas should not be classified as health disparities.

    * Very low HII: these geographic areas are not characterized by socio-economic disadvantages and are significantly above average in terms of socio-economic conditions. Adverse health outcomes in these areas should not be classified as health disparities.
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.
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 healthcare 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.
Behavioral Risk Factor Surveillance System, The Utah Department of Health and Human Services Division of Data, Systems, and Evaluation Office of Research and Evaluation, Salt Lake City, UT 84114-2101, Telephone: 801-538-9466, Website: http://health.utah.gov/opha/OPHA_BRFSS.htm, Shige Onda Email: sonda@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 Mon, 24 February 2025 14:28:10 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 Feb 2025 11:07:22 MST