IBIS-PH - Query Builder - Utah Prevention Needs Assessment (PNA) Query Module

Overview

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: Filter to at-risk versus not at-risk

( Dating Violence: Physically hurt by someone you were dating or going out with )

Physically hurt by someone you were dating or going out with
Not physically hurt by someone you were dating or going out with' **excludes those who did not date

Step 2: Select year

Select the year or years you want to include.

Step 3: Grade

8th grade
10th grade
12th grade

Step 4: Select sex/sex orientation/transgender

Step 5: Select age

Select age to include. Default is all ages.

Step 6: Select another PNA indicator

(Selected PNA indicator: all)

Step 7: Select race, race alone/ethnicity

Step 8: Select geographic area

(Geographic Area: all)

First choose a geography type. Default is all local health districts.
Local health district
Urban/Rural

Step 9: 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.

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:

Use the data for statistical reporting and analysis only.
Avoid any attempt to identify or contact individual(s) represented in the IBIS-PH query system data.
Avoid disclosure or use of the identity of any individual(s) discovered inadvertently.
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.
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.
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.

Data queries

Publications search

Query Builder for Utah Prevention Needs Assessment (PNA) Query Module - Dating Violence

Overview

Getting Started

Step 1: Filter to at-risk versus not at-risk

Step 2: Select year

Select the year or years you want to include.

Step 3: Grade

Step 4: Select sex/sex orientation/transgender

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

Select sex. Default is all

Select sex orientation. Default is all.

Default is all.

Step 5: Select age

Select age to include. Default is all ages.

Step 6: Select another PNA indicator

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

Step 7: Select race, race alone/ethnicity

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

Select race. Default is all.

Select race alone/ethnicity. Default is all.

Select ethnicity. Default is all.

Step 8: Select geographic area

First choose a geography type. Default is all local health districts.

Step 9: How to display the data

Utah IBIS-PH

Utah DHHS

State of Utah

IBIS other

Data queries

Publications search

Query Builder for Utah Prevention Needs Assessment (PNA) Query Module - Dating Violence

Overview

Getting Started

Step 1: Filter to at-risk versus not at-risk

Step 2: Select year

Select the year or years you want to include.

Step 3: Grade

Step 4: Select sex/sex orientation/transgender

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

Select sex. Default is all

Select sex orientation. Default is all.

Default is all.

Step 5: Select age

Select age to include. Default is all ages.

Step 6: Select another PNA indicator

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

Step 7: Select race, race alone/ethnicity

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

Select race. Default is all.

Select race alone/ethnicity. Default is all.

Select ethnicity. Default is all.

Step 8: Select geographic area

First choose a geography type. Default is all local health districts.

Step 9: 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