Payroll-Based Staffing DatA for Maryland & District of Columbia Nursing homes

Note:  This staffing data includes only the direct care staff.  Data for RN and LPN Administrative Hours have not been included.

In the past, data on nursing home staffing was reported to the Center for Medicare & Medicaid Services (CMS).  CMS then posted that information on the Nursing Home Compare website.  Those staffing levels were entirely self-reported by the nursing homes themselves with no outside verification.  In 2017, CMS began collecting and disseminating staffing figures for U.S. nursing homes through direct day-by-day actual payroll data.  This makes the current information, while still not perfect, much more reliable than anything we previously had. CMS is posting this data for each quarter of a given year.  The most recent quarter posted was the third quarter of 2017 (July 1-September 30). The data for that quarter are available here in three separate files. 

Full Spreadsheet of all Maryland Nursing homes

Required Minimum Staffing Hours in Maryland are 2.0 Hours of Care Per Person Per Day
This is a large Excel spreadsheet containing the full list of all Maryland nursing homes with payroll figures for each day during the 3rd quarter of 2017.  Day staffing hours are color coded according to staffing levels.  Low staffing on week-ends, homes with days below 2.0, homes with all days above 3.0, homes with all days above 4.0, and homes with errors in staffing figures are indicated. Within this spreadsheet, one can find the staffing levels for any given nursing home during this time period.

Full Spreadsheet of all District of Columbia Nursing homes

Required Minimum Staffing Hours in DC are 4.1 Hours of Care Per Person Per Day
This is an Excel spreadsheet containing the full list of all DCnursing homes with payroll figures for each day during the 3rd quarter of 2017.  Day staffing hours are color coded according to staffing levels.  Low staffing on week-ends, homes with days below 2.0, homes with all days above 3.0, homes with all days above 4.0, and homes with errors in staffing figures are indicated. Within this spreadsheet, one can find the staffing levels for any given nursing home during this time period.
 

Analysis Spreadsheet

This is a much shorter spreadsheet that contains the analysis of the data presented in the larger spreadsheet.  It contains just a single row for each individual nursing home.  This includes the total staffing hours average for the third quarter and whether or not the nursing home 
  • had a pattern of low staffing on week-ends
  • had any days below the required 2.0 hours per resident per day
  • had all days between 3.0 and 3.99
  • had all days between 4.0 and 4.99
  • included any data errors
  • the ownership status (for-profit, non-profit, or government run)

This spreadsheet contains the state totals in each category.  

To view the Maryland spreadsheet, click here

To view the District of Columbia spreadsheet, click here

 

The Reports

The Reports are PDF document that include brief research findings on staffing levels and summarize the information in the spreadsheets.