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.
 
 
To Use These Spreadsheets
The Maryland spreadsheets will take a minute or so to open. On these spreadsheets, RN = Registered Nurse, LPN = Licensed Practical Nurse, GNA = Geriatric Nurse Aide, and CNA = Certified Nurse Aide.  

There are actually two spreadsheet pages here.  The Daily spreadsheet includes staffing data for every day in the quarter for every nursing home that has turned in information to CMS before the time limit for that quarter.  The Quarterly spreadsheet gives a summary of the pertinent data. This spreadsheet page contains just one line for each nursing home with state percentages and averages.

To toggle between the two spreadsheet pages, go to the bottom left corner of either spreadsheet page and click on the Daily or the Quarterly button.

These links will automatically open your finder when you click on them and will then give you the option of selecting where to save the downloaded spreadsheet.  We suggest that you create a folder where you’d like to keep them prior to clicking on the link.  

2019

District of Columbia:  

First Quarter:  January 1 – March 31   To download this spreadsheet, CLICK HERE Analysis-DC-2019 Q1 

Second Quarter:  April 1 – June 30     To download this spreadsheet, click ->   Analysis-DC-2019 Q2 

Second Quarter Report:  April 1 – June 30    To download this spreadsheet, click ->  DC-Q2-2019-PstaffingREPORT-11-21.pdf

Maryland:

First Quarter:  January 1 – March 31  To view this spreadsheet, click here ->   Analysis-MD-2019 Q1

Second Quarter:  April 1 – June 30  To view this spreadsheet, click here ->     Analysis-MD-2019 Q2

Second Quarter Report:  April 1 – June 30  To view this spreadsheet, click here ->   MD-Q2-2019-PstaffingREPORT-11-19.pdf


2018

District of Columbia:  

First Quarter:  January 1 – March 31   To download this spreadsheet, click ->  Analysis – DC – 2018 Q1

Second Quarter:  April 1 – June 30     To download this spreadsheet, click ->  Analysis – DC – 2018 Q2

Third Quarter:  July 1 – Sept. 30         To download this spreadsheet, click ->   Analysis – DC – 2018 Q3                                                

Fourth Quarter: Oct. 1 – Dec. 31    To download this spreadsheet, click ->  Analysis – DC – 2018 Q4

Maryland:

First Quarter:  January 1 – March 31  To download this spreadsheet, click here ->   Analysis – MD – 2018 Q1

Second Quarter:  April 1 – June 30    To download this spreadsheet, click here ->   Analysis – DC – 2018 Q2

Third Quarter:  July 1 – Sept. 30       To download this spreadsheet, click here ->    Analysis – DC – 2018 Q3

Fourth Quarter:  Oct. 1 – Dec. 31       To download this spreadsheet, click here ->    Analysis – MD – 2018 Q4

 


2017

District of Columbia:  

First Quarter:  January 1 – March 31 To download this spreadsheet, click ->   Analysis – DC – 2017 Q1

Second Quarter:  April 1 – June 30   To download this spreadsheet, click ->   Analysis – DC – 2017 Q2

Third Quarter:  July 1 – Sept. 30       To download this spreadsheet, click ->   Analysis – DC – 2017 Q3                                                  

Fourth Quarter: Oct. 1 – Dec. 31        To download this spreadsheet, click ->   Analysis – DC – 2017 Q4

Maryland:

 First Quarter: January 1 – March 31 To download this spreadsheet, click here ->   Analysis – MD – 2017 Q1

 Second Quarter: April 1 – June 30   To download this spreadsheet, click here ->   Analysis – MD – 2017 Q2

 Third Quarter:  July 1 – Sept. 30     To download this spreadsheet, click here ->   Analysis – MD – 2017 Q3

 Fourth Quarter: Oct. 1 – Dec. 31      To download this spreadsheet,click here ->     Analysis – MD – 2017 Q4