LTCCC’s Q2 2023 Staffing Report provides user-friendly files containing data on: 1) Nurse staff levels (RN, LPN, and CNA, including Admin & DON, NA in Training, Med Aide/Tech.), including contract staff ratios; 2) Important non-nursing staff levels, including administrators and activities staff; 3) Summary nurse and non-nurse staffing data at the state, CMS region, and national levels; 4) Turnover rates, weekend staffing levels, staffing ratings, and other data. 5) A staffing alert with our key findings from Q2 2023.

Download US nursing home staffing datasets by clicking the purple buttons below. Files can be modified to isolate locations and identify variables of interest. For example, a file can be filtered and sorted to identify nursing homes in a selected state and/or county with the highest or lowest RN staffing levels.

See table below for state summary data on total nurse staff HPRD (hours per resident day), RN HPRD, and % Contract Staff Hours.

Source: CMS payroll-based journal data.

Q2 2023 Staffing Summary US Avg. (Previous quarter)
Total Nurse Staff HPRD3.66 (3.63)
Total Direct Care Staff HPRD3.40 (3.36)
Total RN HPRD0.59 (0.59)
RN Care Staff HPRD (excl. Admin/DON)0.40 (0.40)
% Providers ≥ 4.1 HPRD26.7% (25.6%)
MDS Census (Daily Avg.)1,187,769 (1,194,492)
NHs Reporting PBJ Data14,595 (14,699)
StateTotal CensusTotal Nurse Staff HPRDRank: Total Nurse Staff HPRD% Providers ≥ 4.1 HPRDRN Staff HPRD% Contract
Alaska6516.131100.0%1.7810.6%
Alabama20,6063.732628.3%0.533.0%
Arkansas15,7533.931628.8%0.362.1%
Arizona11,0263.951534.5%0.647.0%
California96,5144.161049.3%0.494.1%
Colorado14,6333.683027.7%0.799.8%
Connecticut19,3853.643519.2%0.637.1%
DC1,9814.29676.5%1.137.8%
Delaware3,6903.991330.2%0.8615.2%
Florida71,0033.782322.1%0.645.8%
Georgia29,5163.424712.2%0.4111.4%
Hawaii2,8824.33564.1%1.419.8%
Iowa19,9793.683126.7%0.708.3%
Idaho3,8793.921735.1%0.776.4%
Illinois59,8623.225117.2%0.6610.4%
Indiana35,0443.613816.9%0.577.2%
Kansas14,6193.881938.5%0.658.2%
Kentucky20,5973.722722.0%0.638.9%
Louisiana22,1303.564313.8%0.245.8%
Massachussetts32,4833.712818.5%0.6312.9%
Maryland22,2913.702926.1%0.7515.0%
Maine5,0554.49464.7%1.0222.9%
Michigan33,4503.862132.9%0.675.5%
Minnesota19,5634.111148.2%0.999.5%
Missouri33,0913.195216.8%0.398.8%
Mississippi14,4333.882039.0%0.538.1%
Montana3,1693.584131.0%0.7614.4%
North Carolina33,0613.594021.7%0.5015.7%
North Dakota4,4184.56365.8%0.8413.5%
Nebraska9,4104.031239.9%0.7014.1%
New Hampshire5,6903.772434.2%0.7218.3%
New Jersey38,9713.603925.6%0.6415.4%
New Mexico5,2173.414913.4%0.607.8%
Nevada5,5403.832243.8%0.685.7%
New York96,5973.504517.3%0.6316.3%
Ohio63,5713.544418.8%0.568.9%
Oklahoma15,5453.742523.0%0.334.5%
Oregon5,9674.72287.4%0.6712.4%
Pennsylvania65,4203.584224.6%0.6618.3%
Puerto Rico1394.26750.0%2.951.4%
Rhode Island6,8713.683216.0%0.7411.5%
South Carolina15,4793.653427.5%0.537.9%
South Dakota4,6943.673317.4%0.798.7%
Tennessee24,3173.633618.9%0.538.0%
Texas83,7083.265010.7%0.345.1%
Utah5,4803.981442.3%1.0811.5%
Virginia27,3743.424822.4%0.5011.0%
Vermont2,3274.21855.9%0.7728.0%
Washington12,8714.19950.5%0.829.1%
Wisconsin16,7473.911838.2%0.9211.3%
West Virginia9,1303.454620.0%0.628.0%
Wyoming1,9413.633718.2%0.828.4%

National Staffing Data Summary

The national staffing averages for Q2 2023 are 3.66 total nurse staff HPRD, 0.59 RN staff HPRD. This falls short of the amount of time needed to ensure that residents receive clinical care (4.10 hours total care staff HPRD and 0.75 RN HPRD), according to a landmark 2001 federal study.

More notes on the information provided

  1. Data provided are the averages for the quarter (three month period).
  2. If a facility is not listed, it has not provided appropriate staffing data to CMS.
  3. This report includes nurse Admin and DON, NA in Training, and Med Aide/Tech. in the total nurse staff hours.
  4. See the Notes & Glossary tabs in each file for more information about the data.

To access staffing reports from previous quarters, visit LTCCC’s Staffing Page.