Indiana Hospital Discharge Data Files

This release of the public, hospital discharge data sets consists of 11 files. All data files are self-extracting "zip" files and are in Microsoft Access (.mdb) format. The "look-up" tables are in Excel (.xls) format. The DIAGNOSIS_ID.xls file is also "zipped" for faster downloading.

 

File Name Description
APRDRG 2007 Winzip Icon 2.1 mb Discharge data summarized by Hospital, APR-DRG, Severity and Primary Payer**
MS-DRG 2007 Winzip Icon 1.6 mb Discharge data summarized by Hospital, MS-DRG* and Primary Payer**
DIAGNOSIS 2007 Winzip Icon 3.1 mb Discharge data summarized by Hospital,  Principal Diagnosis and Primary Payer**
PROCEDURES 2007 Winzip Icon 1.3 mb Discharge data summarized by Hospital, Principal Procedure and Primary Payer**
APRDRG ID Microsoft Excel Icon 47 kb Code number and description of the APR-DRGs
MS-DRG ID Microsoft Excel Icon 104 kb Code number and description of the new MS-DRGs
DIAGNOSIS ID Winzip Icon 366 kb Code number (ICD-9-CM) and description of the Principal Diagnoses
PROCEDURES ID Microsoft Excel Icon 414 kb Code number (ICD-9-CM) and description of the Principal Procedures
HOSPITAL ID 2007 Microsoft Excel Icon 78 kb Code number, name, and county of the facilities
VARIABLES ID 2007 Microsoft Excel Icon 25 kb Names (labels) and descriptions of the data set variables
PAYER1 ID 2007 Microsoft Excel Icon 21 kb Code number and description of the Primary Payers**

All negative numbers and those charges reported as "$0.00" have been changed to "missing." 
 
*In October 2007, the DRG system was drastically changed by the federal government and is now known as the MS-DRG system.  [MS-DRG = Medicare Severity Diagnosis Related Groups].   Assignment to one of the new MS-DRGs is intended to be more closely associated with the severity of the patient’s condition. There is no one-to-one crosswalk from the DRG system to the new MS-DRG system.  Please see the MS-DRG_ID file for the new definitions.  The Indiana Hospital Association regrouped all diagnoses to the new MS-DRG system so that data would be consistent for all of calendar year 2007.

**The groupings for payers have changed from those in prior years due to the adoption of the UB-04 billing form in place of the UB-92 approximately mid-year.  Please see the PAYER1_ID_2007 file for this year's codes.