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

Query Builder for Trauma Registry Data - Count of Injuries

Query Builder Page Options

  • Filter the dataset to injury cause(s) or intent(s) if desired.

  • STIPDA

    STIPDA stands for "State and Territorial Injury Program Directors Association." STIPDA injury causes can be defined using ICD-9 codes. The list of injuries and ICD9 codes are available in the help links on the left.

  • ISS

    ISS codes are injury severity classifications. 1-8=Minor Injury, 9-15=Moderate, 16-24=Major, and ISS codes greater than 24 indicate severe injuries.

Jump to Submit

  • If you'd like to display your results by geographic areas, choose one of the selections, below, and then also select "Geography" in the final step, "How to display the data."

Jump to Submit

  • What years do you want to select?

  • Imputed Years

    For the Imputed Years version of the year variable, records that were missing the year value for date of ED admission were assigned the year value for year of injury. This was done for about 4% of records.









  • Select months

Jump to Submit

  • You may drill-down in this section to filter your selections to desired age, sex, race or Hispanic ethnicity population. Skip if no filter is desired.

    • If you'd like to display your results by age groups, choose from one of the age groupings, below, and then also select "Age Group" in the final step, "How to display the data."

    • Choose from the selections below if you'd like to filter your dataset to only males or females.

    • New Mexico Race/Ethnicity Coding

      Starting in 2000, the New Mexico Department of Health developed recommendations for standard categories for the presentation of data by race and Hispanic ethnicity.

      For purposes of presentation, race and ethnicity will be presented together using the following five major categories and labels:

      American Indian or Alaska Native

      Asian or Pacific Islander

      Black or African American

      Hispanic

      White

      The Hispanic category includes no other races but White. The White category may be interpreted as "White, non-Hispanic." And the non-White race categories include both Hispanic and non-Hispanic persons.

      Choose from the selections below if you'd like to filter your dataset to one or more race groups.

Jump to Submit

  • Filter the dataset to health system features if desired.

Jump to Submit

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 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.
The data and information provided through the NM-IBIS 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 State of New Mexico. Allowed activities include informing evidence-based decision making in New Mexico 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 NM-IBIS 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 NM-IBIS query system data.
  3. Avoid disclosure or use of the identity of any individual(s) discovered inadvertently.
  4. Avoid linkage of NM-IBIS query system data with other data that, after linkage, might allow identification of an individual represented in the NM-IBIS query system data.
  5. Use appropriate safeguards to prevent the identification of any individual(s) represented in the data, including when disclosing NM-IBIS 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 Epidemiology and Response Division, New Mexico Department of Health, (505) 827-0006.

Emergency Medical Systems Bureau, Epidemiology and Response Division, New Mexico Department of Health1301 Siler Rd., Bldg. F, Santa Fe, NM, 87507, contact Liana Lujan, e-mail: liana.lujan@state.nm.us