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

Query Builder for Emergency Department Encounter Query Module for Utah Counties and Local Health Districts - Total Charges (sum) - ED Encounters

Overview

The emergency department patient encounter data in this IBIS-Q query module come from all Utah licensed hospitals. The database is maintained by the Utah Department of Health and Human Services, Bureau of Emergency Medical Services.

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.

{{style color:red !*!*!*!*!*!*!*POPULATION DATA ALERT!*!*!*!*!*!*!*[[br]] On August 21, 2024, population estimates for 2020 and later have been updated to IBIS Version 2023. For more information, go to [https://ibis.utah.gov/ibisph-view/query/PopEst.html]. }}

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

    • Select month. Default is the month(s) specified in Step 1.

  • Injury ED Visits

    Diagnosis code in any field is one of the following codes: S00-S99; T07-T34; T36-T50 with a 6th character of 1, 2, 3, or 4 (exceptions: T36.9, T37.9, T39.9, T41.4, T42.7, T43.9, T45.9, T47.9, or T49.9 which are included if the code has a 5th character of 1, 2, 3, or 4); T51-T76; T79; O9A.2-O9A.5; T84.04; or M97 [[br]]OR[[br]] external cause code in any field is one of the following: V00-V99, W00-X58, X71-X83, X92-Y09, Y21-Y33, Y35-Y38. The codes must have a 7th character of A, B, C, or missing, which reflects initial encounter, active treatment
    First choose a coding scheme to use for Diagnosis. Default is all diagnoses.











  • Injury ED Visits

    Diagnosis code in any field is one of the following codes: S00-S99; T07-T34; T36-T50 with a 6th character of 1, 2, 3, or 4 (exceptions: T36.9, T37.9, T39.9, T41.4, T42.7, T43.9, T45.9, T47.9, or T49.9 which are included if the code has a 5th character of 1, 2, 3, or 4); T51-T76; T79; O9A.2-O9A.5; T84.04; or M97 [[br]]OR[[br]] external cause code in any field is one of the following: V00-V99, W00-X58, X71-X83, X92-Y09, Y21-Y33, Y35-Y38. The codes must have a 7th character of A, B, C, or missing, which reflects initial encounter, active treatment
    First choose a coding scheme to use for procedures. Default is all procedures.











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











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


  • First choose a geography type. Default is all Utah residents, regardless of place of hospitalization.

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.

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.
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 EPHT 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 EPHT query system data.
  3. Avoid disclosure or use of the identity of any individual(s) discovered inadvertently.
  4. Avoid linkage of EPHT query system data with other data that, after linkage, might allow identification of an individual represented in the EPHT 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 the Center for Public Health Data, Department of Health.

I understand that failure to adhere to the above stated agreement items will result in loss of access to DOH 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.
Healthcare Information & Analysis Programs, Office of Research & Evaluation, Utah Department of Health and Human Services | Telephone: 801-538-7048 | Website: healthcarestats.utah.gov | Email: healthcarestat@utah.gov
The information provided above is from the Utah Department of Health's Center for Health Data IBIS-PH web site (http://epht.health.utah.gov). The information published on this website may be reproduced without permission. Please use the following citation: " Retrieved Thu, 21 November 2024 17:29:42 from Utah Department of Health, Center for Health Data, Indicator-Based Information System for Public Health Web site: http://epht.health.utah.gov ".

Content updated: Fri, 11 Oct 2024 16:16:41 MDT