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 HPRD | 3.66 (3.63) |
| Total Direct Care Staff HPRD | 3.40 (3.36) |
| Total RN HPRD | 0.59 (0.59) |
| RN Care Staff HPRD (excl. Admin/DON) | 0.40 (0.40) |
| % Providers ≥ 4.1 HPRD | 26.7% (25.6%) |
| MDS Census (Daily Avg.) | 1,187,769 (1,194,492) |
| NHs Reporting PBJ Data | 14,595 (14,699) |
| State | Total Census | Total Nurse Staff HPRD | Rank: Total Nurse Staff HPRD | % Providers ≥ 4.1 HPRD | RN Staff HPRD | % Contract |
|---|---|---|---|---|---|---|
| Alaska | 651 | 6.13 | 1 | 100.0% | 1.78 | 10.6% |
| Alabama | 20,606 | 3.73 | 26 | 28.3% | 0.53 | 3.0% |
| Arkansas | 15,753 | 3.93 | 16 | 28.8% | 0.36 | 2.1% |
| Arizona | 11,026 | 3.95 | 15 | 34.5% | 0.64 | 7.0% |
| California | 96,514 | 4.16 | 10 | 49.3% | 0.49 | 4.1% |
| Colorado | 14,633 | 3.68 | 30 | 27.7% | 0.79 | 9.8% |
| Connecticut | 19,385 | 3.64 | 35 | 19.2% | 0.63 | 7.1% |
| DC | 1,981 | 4.29 | 6 | 76.5% | 1.13 | 7.8% |
| Delaware | 3,690 | 3.99 | 13 | 30.2% | 0.86 | 15.2% |
| Florida | 71,003 | 3.78 | 23 | 22.1% | 0.64 | 5.8% |
| Georgia | 29,516 | 3.42 | 47 | 12.2% | 0.41 | 11.4% |
| Hawaii | 2,882 | 4.33 | 5 | 64.1% | 1.41 | 9.8% |
| Iowa | 19,979 | 3.68 | 31 | 26.7% | 0.70 | 8.3% |
| Idaho | 3,879 | 3.92 | 17 | 35.1% | 0.77 | 6.4% |
| Illinois | 59,862 | 3.22 | 51 | 17.2% | 0.66 | 10.4% |
| Indiana | 35,044 | 3.61 | 38 | 16.9% | 0.57 | 7.2% |
| Kansas | 14,619 | 3.88 | 19 | 38.5% | 0.65 | 8.2% |
| Kentucky | 20,597 | 3.72 | 27 | 22.0% | 0.63 | 8.9% |
| Louisiana | 22,130 | 3.56 | 43 | 13.8% | 0.24 | 5.8% |
| Massachussetts | 32,483 | 3.71 | 28 | 18.5% | 0.63 | 12.9% |
| Maryland | 22,291 | 3.70 | 29 | 26.1% | 0.75 | 15.0% |
| Maine | 5,055 | 4.49 | 4 | 64.7% | 1.02 | 22.9% |
| Michigan | 33,450 | 3.86 | 21 | 32.9% | 0.67 | 5.5% |
| Minnesota | 19,563 | 4.11 | 11 | 48.2% | 0.99 | 9.5% |
| Missouri | 33,091 | 3.19 | 52 | 16.8% | 0.39 | 8.8% |
| Mississippi | 14,433 | 3.88 | 20 | 39.0% | 0.53 | 8.1% |
| Montana | 3,169 | 3.58 | 41 | 31.0% | 0.76 | 14.4% |
| North Carolina | 33,061 | 3.59 | 40 | 21.7% | 0.50 | 15.7% |
| North Dakota | 4,418 | 4.56 | 3 | 65.8% | 0.84 | 13.5% |
| Nebraska | 9,410 | 4.03 | 12 | 39.9% | 0.70 | 14.1% |
| New Hampshire | 5,690 | 3.77 | 24 | 34.2% | 0.72 | 18.3% |
| New Jersey | 38,971 | 3.60 | 39 | 25.6% | 0.64 | 15.4% |
| New Mexico | 5,217 | 3.41 | 49 | 13.4% | 0.60 | 7.8% |
| Nevada | 5,540 | 3.83 | 22 | 43.8% | 0.68 | 5.7% |
| New York | 96,597 | 3.50 | 45 | 17.3% | 0.63 | 16.3% |
| Ohio | 63,571 | 3.54 | 44 | 18.8% | 0.56 | 8.9% |
| Oklahoma | 15,545 | 3.74 | 25 | 23.0% | 0.33 | 4.5% |
| Oregon | 5,967 | 4.72 | 2 | 87.4% | 0.67 | 12.4% |
| Pennsylvania | 65,420 | 3.58 | 42 | 24.6% | 0.66 | 18.3% |
| Puerto Rico | 139 | 4.26 | 7 | 50.0% | 2.95 | 1.4% |
| Rhode Island | 6,871 | 3.68 | 32 | 16.0% | 0.74 | 11.5% |
| South Carolina | 15,479 | 3.65 | 34 | 27.5% | 0.53 | 7.9% |
| South Dakota | 4,694 | 3.67 | 33 | 17.4% | 0.79 | 8.7% |
| Tennessee | 24,317 | 3.63 | 36 | 18.9% | 0.53 | 8.0% |
| Texas | 83,708 | 3.26 | 50 | 10.7% | 0.34 | 5.1% |
| Utah | 5,480 | 3.98 | 14 | 42.3% | 1.08 | 11.5% |
| Virginia | 27,374 | 3.42 | 48 | 22.4% | 0.50 | 11.0% |
| Vermont | 2,327 | 4.21 | 8 | 55.9% | 0.77 | 28.0% |
| Washington | 12,871 | 4.19 | 9 | 50.5% | 0.82 | 9.1% |
| Wisconsin | 16,747 | 3.91 | 18 | 38.2% | 0.92 | 11.3% |
| West Virginia | 9,130 | 3.45 | 46 | 20.0% | 0.62 | 8.0% |
| Wyoming | 1,941 | 3.63 | 37 | 18.2% | 0.82 | 8.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
- Data provided are the averages for the quarter (three month period).
- If a facility is not listed, it has not provided appropriate staffing data to CMS.
- This report includes nurse Admin and DON, NA in Training, and Med Aide/Tech. in the total nurse staff hours.
- 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.