HDDBCntyHospNCDM Inpatient Hospital Discharge Query Module for Utah Counties and Local Health DistrictsUtah hospital inpatient data from UB-92, by County/LHD, 1992-presentNovember 1, 2005CHD_OHCSconfig/srv/ibis-q/modules/hddb/HDDB_CV.cfgsas0test0sasdatahddball_r2017saspopdatapop_comdis_month_2017query/selection/hddb/EPHTHDDBSelection.htmlInpatient Hospital DischargesCountEPHT NCDM Asthma CountNumber of inpatient hospital discharges during the time period.CountHosp_AsthmaEPHT NCDM Asthma CountNumber of inpatient hospital discharges during the time period.funcdata_frame/CountHosp_cv.defdata_whereayear >1991 and asthma not in (9999) and dutcnty in (1)LHD_1COLOR_NO_OPTIONSHighLowSame_2015SA_1COLOR_NO_OPTIONSCNTY_1COLOR_NO_OPTIONSDEFAULTALLAgeGrp13GeoResInjIntentAgeGrpProxyAgeGrp11AgeGrpProxyAgeGrp14HospData
Utah Inpatient Hospital Discharge Data, Office of Health Care Statistics,
Utah Department of Health
8Meth2015ICD Stands for International Classification of Diseases. It is a coding system maintained by the World Health Organization and the U.S. National Center for Health Statistics used to classify causes of death on death certificates and diagnoses, injury causes, and medical procedures for hospital and emergency department visits. These codes are updated every decade or so to account for advances in medical technology. The U.S. is currently using the 10th revision (ICD-10) to code causes of death. The 9th revision (ICD-9) has been used for hospital and emergency department visits until 3rd quarter of 2015. The ICD-10 was used from the 4th quarter of 2015.
Starting with the 2015 data, the methodology for grouping payers was simplified to follow HCUP categorization. Because of this, users should be cautious about performing comparisons between 2015 and previous years. The most substantial change has been the elimination of the Blue Cross/Blue Shield and Managed Care categories. This field is subject to change in the future as refinements are made to the methodology.GeoLHD_2015Prior to 2015 San Juan County was part of the Southeast Local Health District. In 2015 the San Juan County Local Health District was formed. Data reported are for all years using the current boundaries.HDDBDataThe Hospital Discharge Database (HDDB) contains the consolidated information on complete billing, medical codes, and personal characteristics describing a patient, the services received, and charges billed for each inpatient hospital stay. The OHCS receives discharge data quarterly from hospitals in various format and media. The data are converted into a standardized format. The data are validated through a process of automated editing and report verification. Each record is subjected to a series of edits that check for accuracy, consistency, completeness, and conformity with the definitions specified in the Data Submittal Manual. Records failing the edit check are returned to the data supplier for corrections of comment.
CovValDiagCode
Coverage and Validity of Diagnosis Codes: Since the data come from the billing
forms, all visits or encounters have a Diagnosis code making coverage great.
There is some difference of opinion regarding whether some providers may emphasize
Diagnosis codes that yield higher reimbursements. The hospital and ED data are
considered "Administrative Data" because they were created for use in billing
and remittance of payment. As such, they were not constructed for public health
surveillance purposes primarily, and are weak in some areas, such as external
cause of injury and race or ethnicity. But, in general, they are extremely
valuable and reasonably complete and valid.
OverviewThe inpatient discharge data in this IBIS-Q query module comes from all Utah
licensed hospitals. The database is maintained by the Utah Department of Health,
Office of Health Care Statistics. The population estimates for years 1980-1999
were produced by the Utah Governor's Office of Planning and Budget (GOPB). For years 2000 and later the
population estimates are provided by the National Center for Health Statistics (NCHS)
through a collaborative agreement with the U.S. Census Bureau.Getting StartedFollow the steps to narrow your query and display your results. When you are done
forming your query, click "Submit" bottom of the screen (last step) to get your
query result.
{{style color:red
!*!*!*!*!*!*!*POPULATION DATA ALERT!*!*!*!*!*!*!*[[br]]
On October 10, 2018, estimates for 2010 and later have been
updated to the IBIS Version 2017 population estimates. For more information,
go to [http://ibis.health.utah.gov/query/PopEst.html].
}}
AdmissionYearMonthSelect admission year and monthAdmissionYear2016Select one or more subgroups to limit results. Default is all characteristics.Admission yearsAdmissionYearSelect year. Default is the year(s) specified in Step 1.Filter by MonthAll years in the selected date rangeAdmissionYear4Admission monthsAdmissionMonthSelect monthFilter by admission monthAll months AdmissionMonth4ICDSelect ICD codeICD910Would you like to include only ICD-9 or only ICD-10 codes in the results? Default includes bothFilter by ICD9 or ICD10ICDAgeGrp_NCDMSelect ageAgeGrpProxyAgeGrpNCDMAgeGrpProxyFirst choose a coding scheme to use for age groups.(Default is age adjustment age groups, all ages.)Filter by sub population groupNCDM age groups (0-4, 5-14, 15-34, 35-64, 65+)AgeGrpNCDMAll age groupsAgeGrpNCDM5NCDM age groups (0-4, 5-14, 15-24, 25-44, 45-64, 65-84, 85+)AgeGrpNCDM2All age groupsAgeGrpNCDM255-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+)AgeGrp18All age groupsAgeGrp186AgeGrp9Enter custom age groupHow to Specify Age GroupsEnter 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).
AgeGrp935SexSelect sexWould you like to include only males or only females in the results? Default includes both sexes.Filter by sub population groupBoth male and femaleSexHospDischargeStatSelect discharge statusHospDischargeStatPriPayerSelect primary payerPriPayerGeoSelect geographic areaGeoProxyGeoLHDGeoProxyFirst choose a geography type. Default is all Utah residents, regardless of place of hospitalization.Utah Resident HospitalizationsLocal health districtGeoLHDAll local health districtsGeoLHD6CountyGeoCntyAll countiesGeoCnty6AdmissionYearAdmission YearsList of years starting with 1992 and going to the present.1992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016.TotalAdmissionYearGrp33-Admission Year GroupsYears Grouped in lots of 3 starting in 1992 and going to present.AdmissionYearProxy199211993-199521996-199831999-200142002-200452005-200762008-201072011-20138.Total9AdmissionYearGrp55-Admission Year GroupsYears Grouped in lots of 5 starting in 1992 and going to present.AdmissionYearProxy1992-199311994-199821999-200332004-200842009-20135.Total6AdmissionYear9Custom Admission Year GroupsCustom year selections. This can be a range, groups, or a series of listsAdmissionYearProxy12345.Total6AdmissionMonthAdmission months1January2February3March4April5May6June7July8August9September10October11November12December.TotalICDICD Codes9ICD-910ICD-1099Unknown.TotalAgeGrpProxyAge GroupAgeGrpNCDMNCDM Age GroupsAgeGrpProxy10-425-14 years315-34 years435-64 years565+99Unknown.TotalAgeGrpNCDM2NCDM Age Groups AgeGrpProxy10-425-14 years315-24 years425-44 years545-64 years665-84 years785+99Unknown.TotalAgeGrp185-Year Age GroupsAgeGrpProxy10-4 years25-9 years310-14 years415-19 years520-24 years625-29 years730-34 years835-39 years940-44 years1045-49 years1150-54 years1255-59 years1360-64 years1465-69 years1570-74 years1675-79 years1780-84 years1885+ yearsOtherUnknown.TotalAgeGrp9Custom Age GroupAgeGrpProxy12345678910.Total11SexSex1Male2Female9Unknown.TotalPriPayerPrimary Payer1Medicare2Medicaid3Other Government4Blue Cross/Blue Shield5Other Commercial6Managed Care7Self Pay8Charity/Unclassified9Industrial and Worker's Compensation10CHIP12Unknown.TotalHospDischargeStatDischarge Status1to home or self care, routine discharge2to another short-term general hospital3to skilled nursing facility4to an intermediate care5to another type of institution6to home under care of home health service7left against medical advice8to home under care of home IV provider10expired11unknown.TotalGeoProxyGeographic AreaGeoLHDLocal Health DistrictGeoProxy1.0Bear River LHD12.0Central Utah LHD23.0Davis County LHD34.0Salt Lake County LHD413.0San Juan, LHD 55.1Southeast Utah LHD 76.0Southwest Utah LHD87.0Summit County LHD98.0Tooele County LHD109.0TriCounty LHD1110.0Utah County LHD1211.0Wasatch County LHD1312.0Weber-Morgan LHD1499.0Other Utah, County Not Specified999.0Utah Non-Resident9999.0Unknown Residence.TotalGeoCntyCountyGeoProxy1Beaver2Box Elder3Cache4Carbon5Daggett6Davis7Duchesne8Emery9Garfield10Grand11Iron12Juab13Kane14Millard15Morgan16Piute17Rich18Salt Lake19San Juan20Sanpete21Sevier22Summit23Tooele24Uintah25Utah26Wasatch27Washington28Wayne29Weber99Other Utah, County Not Specified999Utah Non-Resident9999Unknown Residence.Total1561057409000hddb/EPHTHDDBCntyHosp/CountHosp_AsthmaCountHosp_Asthma70350AdmissionYearCount