CMS Payroll-Based Journal
Nursing home staffing hours
Nurse and aide hours each home reported from payroll, rolled up by quarter — often clearer than star ratings alone.
Published by CMS Payroll-Based Journal
Finest detail facility
Tables 6
How we use this · on 1 desk
“Which homes are short on nurses and losing Medicare pay for it?”
Where you'll see it
- CareSite Ops: Low scores + thin staffing, Nursing homes: Risk
- AI & Spreadsheets: at Level 3, link it into Excel or Google Sheets, download it, or ask your AI assistant about it
What we added
- Staffing set next to each home's quality pay score and inspections on the same page
- Quarter-by-quarter history kept
Employees vs contract staff by quarter
Sample of 25 rows out of about 364,192
· 14 columns
| cy_quarter | ccn | state | days_with_staff | staff | employees | contract_staff | hours | employee_hours | contract_hours | employees_prior_q | employees_kept_from_prior_q | staff_prior_q | staff_kept_from_prior_q |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020Q2 | 015009 | AL | 91 | 65 | 61 | 4 | 24599.49 | 23349.14 | 1250.35 | No data | No data | No data | No data |
| 2020Q2 | 015010 | AL | 91 | 115 | 106 | 9 | 40635.0 | 37645.5 | 2989.5 | No data | No data | No data | No data |
| 2020Q2 | 015012 | AL | 91 | 71 | 62 | 9 | 22939.8 | 21434.82 | 1504.98 | No data | No data | No data | No data |
| 2020Q2 | 015014 | AL | 91 | 99 | 86 | 13 | 31072.87 | 29056.34 | 2016.53 | No data | No data | No data | No data |
| 2020Q2 | 015015 | AL | 91 | 94 | 80 | 14 | 29770.16 | 28971.83 | 798.33 | No data | No data | No data | No data |
| 2020Q2 | 015016 | AL | 91 | 167 | 131 | 36 | 52647.05 | 46887.08 | 5759.97 | No data | No data | No data | No data |
| 2020Q2 | 015019 | AL | 91 | 127 | 110 | 17 | 34381.28 | 32470.05 | 1911.23 | No data | No data | No data | No data |
| 2020Q2 | 015023 | AL | 91 | 147 | 138 | 9 | 58326.56 | 56851.0 | 1475.56 | No data | No data | No data | No data |
| 2020Q2 | 015024 | AL | 91 | 118 | 105 | 13 | 50906.32 | 48434.66 | 2471.66 | No data | No data | No data | No data |
| 2020Q2 | 015027 | AL | 91 | 135 | 123 | 12 | 44126.64 | 41711.25 | 2415.39 | No data | No data | No data | No data |
| 2020Q2 | 015028 | AL | 91 | 99 | 90 | 9 | 26610.74 | 25608.91 | 1001.83 | No data | No data | No data | No data |
| 2020Q2 | 015031 | AL | 91 | 209 | 183 | 26 | 70483.51 | 63947.5 | 6536.01 | No data | No data | No data | No data |
| 2020Q2 | 015032 | AL | 91 | 135 | 120 | 15 | 39828.84 | 37539.3 | 2289.54 | No data | No data | No data | No data |
| 2020Q2 | 015034 | AL | 91 | 84 | 74 | 10 | 30281.75 | 28294.9 | 1986.85 | No data | No data | No data | No data |
| 2020Q2 | 015035 | AL | 91 | 136 | 123 | 13 | 49877.79 | 47428.83 | 2448.96 | No data | No data | No data | No data |
| 2020Q2 | 015037 | AL | 91 | 57 | 57 | 0 | 16323.54 | 16323.54 | 0.0 | No data | No data | No data | No data |
| 2020Q2 | 015040 | AL | 91 | 125 | 107 | 18 | 30303.54 | 27600.04 | 2703.5 | No data | No data | No data | No data |
| 2020Q2 | 015042 | AL | 91 | 132 | 110 | 22 | 37206.89 | 35218.01 | 1988.88 | No data | No data | No data | No data |
| 2020Q2 | 015044 | AL | 91 | 95 | 72 | 23 | 20073.76 | 18950.96 | 1122.8 | No data | No data | No data | No data |
| 2020Q2 | 015045 | AL | 91 | 88 | 88 | 0 | 36290.3 | 36290.3 | 0.0 | No data | No data | No data | No data |
| 2020Q2 | 015047 | AL | 91 | 112 | 100 | 12 | 37645.79 | 33837.9 | 3807.89 | No data | No data | No data | No data |
| 2020Q2 | 015048 | AL | 91 | 100 | 89 | 11 | 31146.66 | 28943.05 | 2203.61 | No data | No data | No data | No data |
| 2020Q2 | 015049 | AL | 91 | 98 | 81 | 17 | 29234.47 | 26647.0 | 2587.47 | No data | No data | No data | No data |
| 2020Q2 | 015050 | AL | 91 | 105 | 64 | 41 | 24178.05 | 20492.78 | 3685.27 | No data | No data | No data | No data |
| 2020Q2 | 015053 | AL | 91 | 96 | 91 | 5 | 37680.3 | 37045.05 | 635.25 | No data | No data | No data | No data |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing