NM-Tracking - - Average Daily Cold Related Illness Hospital Admissions by Month Query Builder

Step 1: PERIOD: Select year of admission ( : 2022 )

What year grouping do you want to select? Default is single years, most recent year.
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.
Single years
Enter custom year group(s)

Select months.
Single months

Jump to Submit

Step 2: AREA: Select geographic area (: all)

Selecting Geography
Select the geographic areas you want to include. Hold down the control (ctrl) key to make multiple selections.
First choose a geography type. Default is all New Mexico counties.
County
New Mexico health regions

Jump to Submit

Step 3: POPULATION: Select age (: all)

First choose a coding scheme to use for age groups. Default is all 11 age-adjustment age groups.
Age adjustment age groups (less than 1, 1-4, 5-14, 15-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75-84, 85+)
Four age groups (0-14, 15-44, 45-64, 65+)
Seven age groups (less than 1, 1-14, 15-24, 25-44, 45-64, 65-84, 85+)
Eight age groups (0-17, 18-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75+)
DOH VRHS Age Groups (less than 1, 1-4, 5-14, 15-17, 18-19, 20-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75-84, 85+)
Five-year age groups (0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, 85+)
All available age groups (Single years from 0-20, 21-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, 85+)
School age groups (0-17, 18-85+)
Worker age groups (0-15, 16-85+)

Jump to Submit

Step 4: POPULATION: Select Ethnicity/Race (: all)

First choose a coding scheme to use for ethnic groups. Default is Five Ethnicities and Race grouping.
Two Ethnicities, Hispanic and Non-Hispanic
Five Ethnicities and Race

Jump to Submit

Step 5: POPULATION: Select sex

Would you like to include only males or only females in the results? Default includes both.

Jump to Submit

Step 6: Filters: Select Other Criteria Filters ( Filters ) ( Normal Discharge )

First choose a criteria. Default is Status.
Same-day Admit and Discharge
Patient Status, discharged to category
Newborns
Residents
- Resident
  Not all patients are residents of New Mexico. This filter enables selection for just residents when necessary.

Jump to Submit

Step 7: How to display the data

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

About Tracking

General Help

Maps & Publications

Stories & Experiences

Query Builder for - Average Daily Cold Related Illness Hospital Admissions by Month

Query Builder Page Options

Step 1: PERIOD: Select year of admission ( : 2022 )

What year grouping do you want to select? Default is single years, most recent year.

Select months.

Step 2: AREA: Select geographic area (: all)

Selecting Geography
Select the geographic areas you want to include. Hold down the control (ctrl) key to make multiple selections.
First choose a geography type. Default is all New Mexico counties.

Step 3: POPULATION: Select age (: all)

First choose a coding scheme to use for age groups. Default is all 11 age-adjustment age groups.

Step 4: POPULATION: Select Ethnicity/Race (: all)

First choose a coding scheme to use for ethnic groups. Default is Five Ethnicities and Race grouping.

Step 5: POPULATION: Select sex

Would you like to include only males or only females in the results? Default includes both.

Step 6: Filters: Select Other Criteria Filters ( Filters ) ( Normal Discharge )

First choose a criteria. Default is Status.

Resident
Not all patients are residents of New Mexico. This filter enables selection for just residents when necessary.

Step 7: How to display the data

2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999

All counties
Bernalillo
Catron
Chaves
Cibola
Colfax
Curry
De Baca
Dona Ana
Eddy
Grant
Guadalupe
Harding
Hidalgo
Lea
Lincoln
Los Alamos
Luna
McKinley
Mora
Otero
Quay
Rio Arriba
Roosevelt
Sandoval
San Juan
San Miguel
Santa Fe
Sierra
Socorro
Taos
Torrance
Union
Valencia

All age groups
0 years
1 year
2 years
3 years
4 years
5 years
6 years
7 years
8 years
9 years
10 years
11 years
12 years
13 years
14 years
15 years
16 years
17 years
18 years
19 years
20 years
21-24 years
25-29 years
30-34 years
35-39 years
40-44 years
45-49 years
50-54 years
55-59 years
60-64 years
65-69 years
70-74 years
75-79 years
80-84 years
85 yrs and older

Status
Routine Discharge
Transfer to short-term general hospital
Transfer to SNF (skilled nursing facility)
Transfer to an ICF (intermediate care facility)
Transfer to another type of institution
Transfer to home health care
Left against medical advice or discontinued care
Reserved for National Assignment
Admitted as an inpatient to this hospital
Expired
Still a patient or expected to return for o/p services
Expired at home (Valid for Medicare hospice claims)
Expired in a medical facility; e.g. Hospital, SNF
Expired - place unknown (valid for Medicare outpatients)
Discharged/Transferred to federal health care
Discharged/Transferred to hospice
Discharged/Transferred to hospice medical facility
Discharged/Transferred within this institution to a hospital based medicare approved swing bed
Discharged/Transferred to inpatient rehabilitation
Discharged/Transferred to long term care hospital
Discharged/Transferred to nursing facility
Discharged/Transferred to psychiatric hospital
Discharged/Transferred to a crital access hospital
Discharged/Transferred to another type of health care facility

Query Builder Page Options

Step 1: PERIOD: Select year of admission ( : 2022 )

What year grouping do you want to select? Default is single years, most recent year.

Select months.

Step 2: AREA: Select geographic area (: all)

Selecting GeographySelect the geographic areas you want to include. Hold down the control (ctrl) key to make multiple selections.First choose a geography type. Default is all New Mexico counties.

Step 3: POPULATION: Select age (: all)

First choose a coding scheme to use for age groups. Default is all 11 age-adjustment age groups.

Step 4: POPULATION: Select Ethnicity/Race (: all)

First choose a coding scheme to use for ethnic groups. Default is Five Ethnicities and Race grouping.

Step 5: POPULATION: Select sex

Would you like to include only males or only females in the results? Default includes both.

Step 6: Filters: Select Other Criteria Filters ( Filters ) ( Normal Discharge )

First choose a criteria. Default is Status.

ResidentNot all patients are residents of New Mexico. This filter enables selection for just residents when necessary.

Step 7: How to display the data

Primary group by field

Optional secondary group by field

Optional chart graph

Optional Map Visualization

Selecting Geography
Select the geographic areas you want to include. Hold down the control (ctrl) key to make multiple selections.
First choose a geography type. Default is all New Mexico counties.

Resident
Not all patients are residents of New Mexico. This filter enables selection for just residents when necessary.