Skip to Main Content
Contact Us Search

Top 25 MS-DRGs

The following Excel Pivot Profiles were developed using the patient discharge data file aggregated at the hospital level. The files display the total number of discharges, average charge per stay, average charge per day and average length of stay for the top 25 Medicare-Severity Diagnosis Related Groups (MS-DRGs) for each hospital and for the state as a whole.

On October 1, 2007 the Centers for Medicare & Medicaid Services (CMS) replaced the current 538 Diagnosis Related Groups (DRGs) with 745 MS-DRGs. The grouper software is updated by CMS at the beginning of each federal fiscal year (October 1st); because of this change the Top 25 MS-DRG reports are based on discharges from October 1st of one year through September 30th of the following year.

Excel Pivot Profiles

Three Easy Steps to Use Pivot Profiles

  1. Download Pivot Profile, preferably to your desktop.
  2. From Pivot worksheet, select variables using drop-down boxes.
  3. Go to Profile worksheet to view results.

If you need technical assistance, please call HIRC at (916) 326-3802.
Files formatted for earlier versions of Excel may be obtained by request to HIRC.

Data Download

  • Oct.1, 2013 – Sept. 30, 2014 (MS-DRG Version 31-32) MS Excel 5.4 MB
  • Oct. 1, 2012 - Sept. 30, 2013 (MS-DRG Version 30-31) MS Excel 5.47 MB
  • Oct. 1, 2011 - Sept. 30, 2012 (MS-DRG Version 29-30) MS Excel 5.44 MB
  • Oct. 1, 2010 - Sept. 30, 2011 (MS-DRG Version 28-29) MS Excel 5.3 MB
  • Oct. 1, 2009 - Sept. 30, 2010 (MS-DRG Version 27-28) MS Excel 5.33 MB
  • Oct. 1, 2008 - Sept. 30, 2009 (MS-DRG Version 26-27) MS Excel 5.38 MB
  • Jan 1 2008 - Sept 30 2008 (MS-DRG Version 25) MS Excel 5.29 MB

PDF Reports and Benchmark MS-DRGs

These reports display individual hospitals’ total number of discharges, for a statewide benchmark set of the top 25 MS-DRGs, and they include average charge per stay, average charge per day, and average length of stay. These were also developed from the patient discharge data file, aggregated at the hospital level.

Search HID Data