The Montana State Epidemiological Online Data System website provides users with
a relatively simple to use data viewing and download tool. In order to adopt the
latest organizational structure for the data system, indicators in the online data
system are organized according to the Center for Substance Abuse Prevention’s Strategic
Prevention Framework (SPF) Model. With indicators classified into three main categories:
a) consumption indicators (substance use estimates), b) consequence indicators (substance
related consequences), or c) causal factors (predictor variables of substance use
and abuse). Additionally, indicators are categorized into three substance types:
a) alcohol, b) tobacco, or c) illicit drugs. It should be noted, however, that data
historically collected through the Montana Prevention Needs Assessment (MPNA) Survey
that are more specifically related to the Hawkins and Catalano Risk and Protective
Factor Model are also included in the online data system as well. These data can
be queried using the “Search by Risk Factor” tab (see below for more information
about search features).
For a printable PDF version of these instructions, please click
There are several different methods for searching and browsing the system through
the tabs above. Each search option provides different strengths. In general, the
Indicator Browse search option provides the most flexibility. Brief descriptions
of the search options offered by each tab are provided below.
View Data – The “View Data” tab provides a dropdown
menu containing links to all of the available indicators within the online data
tool, in alphabetical order. This method of searching the indicators within the
database provides easy accessibility for users who know the names of the indicators
they are interested in querying.
Indicator Browse (Recommended)– The
“Indicator Browse” tab provides a list of all the indicators in the system as well,
but also provides general information about the indicator. By default, the Indicator
Browse feature provides: a) the Indicator Type (consumption, consequence
or causal factor), b) the Substance Type (alcohol, tobacco or illicit
drugs), and c) any specific Risk Factors the indicator is related
to. Users can also view a description and definition of the indicator and/or source
information by checking the “Show Description” and/or “Show Source”
checkboxes at the top of the frame. Another useful feature of the Indicator Browse
tab is the ability to sort indicators by any of the attributes displayed. For example,
clicking on the column header for “Indicator Type” sorts all of the indicators
by the indicator type attribute (consumption, consequence or causal factor). Similarly,
clicking on the column header for “Substance Type” sorts all of the indicators
by substance type (alcohol, tobacco, or illicit drugs).
Indicator Search – The “Indicator Search” tab provides
an indicator searching mechanism for users who are interested in identifying data
related to a particular “Indicator Type” and/or “Substance Type.”
Searches can specify one or multiple indicator and/or substance types as desired.
Search By Risk Factor – The “Search By Risk Factor”
tab allows users to find indicators related to specific risk factors from the Hawkins
and Catalano Risk and Protective Factor Model. The indicators linked to the Risk
and Protective Factor Model have historically been collected in Montana by various
agencies, including the Chemical Dependency Bureau, Addictive and Mental Disorders
Division, which administers the biannual Montana Prevention Needs Assessment (PNA)
Survey. Additional information on risk and protective factors, PNA data, and electronic
versions of profile reports can be found at the Montana Prevention Resource Center
Website at http://www.prevention.mt.gov. To find additional information, data, and
reports, go to the Montana Prevention Resource Center Website, select the "Statistics"
toolbar, and then select the link for "Montana Prevention Needs Assessment." Please
note that not all indicators are associated with a specific risk or protective factor.
Viewing the Data
For most indicators in the online data system, a variety of data viewing options
are available. For example, users might be interested in viewing a trend in the
indicator for a particular county or comparing a county (or multiple counties) to
the state. Alternatively, users may be interested in comparing a county and a region
to the state or in examining data at the state level by a demographic variable such
as age group or gender.
Step 1: Specifying Data Levels. After choosing an indicator to view, you
will be asked to specify a data level using the “Data Level” drop
box menu for that particular indicator. The data system will automatically provide
the data level choices that are available for the indicator you have chosen. For
example, when county and region data are available, the drop box menu will allow
choices for examining trends over time within counties (and comparing counties to
the state), within regions, or for comparing counties and regions. On the other
hand, if the indicator is only available at the state and national levels, the choices
will be limited accordingly. A brief description of the most common data viewing
levels available is provided below:
State and County Data – Allows examination of trends
within a single or multiple counties, as well as county-to-county and county-to-state
2)State and Health Planning Region Data - Allows
examination of trends within a single Health Planning Region, as well as region-to-state
3)State and Judicial District Region Data – Allows
examination of trends within a single Judicial District Region, as well as region-to-state
4)State and MACO Region Data – Allows examination
of trends within a MACO Region, as well as region-to-state comparisons.
5)State and School Superintendent Region Data – Allows
examination of trends within a single School Superintendent Region, as well as region-to-state
6) State and County/Region Data by “Demographic”
– Provides state and county/region data for demographic categories available for
the indicator. For example, “State and Region Data by Gender” would allow viewing
of state and regional data for males and females. When choosing a demographic data
level, the system will provide an additional dropdown box (labeled “View”) for selecting
either a specific demographic category (e.g., only males or only females), or for
comparing across “all” demographic categories (e.g., males and females in the same
Step 2: Selecting a Chart or Data Presentation. Once an indicator and data
level are specified, the system will present chart and map options that are available
for the indicator. Two types of data charts are available through the online data
tool. These include: a) trend charts showing values on the chosen indicator over
time for a particular geography (county, region, state and/or nation), or demographic
group (age or gender), and b) maps showing the relative rates of an indicator across
the state by either county or region.
Helpful Tip: These charts can be saved as images and be inserted into documents
County and Region Charts – For county and region
charts, up to three counties/regions can be selected for comparison. The state values
are provided by default as well for easy comparisons between the selected counties/regions
and the state.
To Chart: Simply choose the counties and/or regions you would like to examine
and click the “Draw Chart” button. For charts presenting state and
national data only, simply click the “Draw Chart” button.
Reading the Charts: For charts presenting county-to-county or region-to-region
comparisons, the lines represent the selected counties or regions as well as the
state rate for the indicator. The blue bars show the range of all the
counties (when creating a county-to-county chart) or regions (when creating a region-to-region
chart). The range essentially illustrates what the highest rate and lowest rate
were in a given year across all counties (for county-to-county charts) or regions
(for region-to-region charts). Range bars are not provided for charts showing both
counties and regions together.
2) Map Instructions – The “Map” presentation option presents
a map comparing counties or regions across the state on the chosen indicator for
a specific year.
To Map: Simply choose the year from the drop box menu and click the “Draw
Reading the Maps: The maps present the relative rates of each county or
region across the state. Counties or regions with relatively high rates
are shaded in red, counties or regions with relatively low rates are shaded in green,
and counties with intermediate rates are shaded in yellow or orange.
Demographic Data Charts – Some indicators can be
examined by demographic categories such as age or gender. In particular, youth survey
indicators are typically available for grades 6, 8, 10 and 12.
To Chart: When demographic data is available for an indicator, you will have
an option to choose a data level with demographic data (e.g., “State and Region
by Grade Data”). In selecting a demographic data option, you will be asked to specify
a “View” from a drop down menu that presents the different demographic
data options available for that indicator. If you choose to view “All”
levels of the demographic category, a bar chart will be displayed which presents
the data grouped by demographic categories for up to five years of values. Next,
choose the region of interest (if applicable) and click the “Draw Chart”
button. If you choose to view a particular demographic group (when available), such
as 10th graders, you will be able to create a trend chart or map for
that specific demographic group as described in the county/region charts and map
Step 3: Viewing or Downloading the Data. The online data tool allows users
to view data associated with charts, or download entire datasets for an indicator.
Viewing Data from Charts - To view the data presented
in a chart of map, simply check the “Show Chart Table” checkbox in
the chart dialogue box, then click the “Draw Chart” button. A data
table presenting the values within the chart will display below the chart image.
These data can be copied and pasted into a spreadsheet for use if desired.
Downloading Datasets – To download the entire dataset
for an indicator, simply click on the “download data” link found below
the chart and/or map dialogue boxes. The data file will export as a comma separated
values data file.
Charting Limitations Associated with Single Values and Missing Data
When viewing trend charts, the system is designed to show
trends over time. When only a single data point is available for an area (county,
state or region), the chart will not properly display the value of that area.
When there are missing values in the dataset for the area
you have chosen to view, the charting program will extrapolate those missing values
in the trend chart by drawing a line between the values that exist for other years.
The extrapolated portion of the trend chart will appear as a grey line giving the
trend line for that area a two-toned appearance.
In cases where data appear to be missing from a chart or a grey line appears in
the chart, we recommend users check the “Show Chart Table” box and redraw the chart.
This will allow the user to examine the actual values (or missing values) for the
area of interest for each year of available data.