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
Staff by job title by quarter
Sample of 25 rows out of about 5,925,452
· 8 columns
| cy_quarter | ccn | job_code | emp_ctr | staff | hours | staff_days | footnote_days |
|---|---|---|---|---|---|---|---|
| 2020Q2 | 015009 | 1 | 1 | 3 | 1332.29 | 179 | 0 |
| 2020Q2 | 015009 | 5 | 1 | 2 | 563.42 | 67 | 0 |
| 2020Q2 | 015009 | 6 | 1 | 1 | 588.75 | 75 | 0 |
| 2020Q2 | 015009 | 7 | 1 | 5 | 2587.0 | 291 | 0 |
| 2020Q2 | 015009 | 7 | 2 | 1 | 2.5 | 1 | 0 |
| 2020Q2 | 015009 | 8 | 1 | 1 | 143.25 | 17 | 0 |
| 2020Q2 | 015009 | 9 | 1 | 9 | 3802.25 | 441 | 0 |
| 2020Q2 | 015009 | 10 | 1 | 27 | 10250.66 | 1346 | 0 |
| 2020Q2 | 015009 | 10 | 2 | 2 | 699.1 | 93 | 0 |
| 2020Q2 | 015009 | 11 | 1 | 1 | 240.52 | 34 | 0 |
| 2020Q2 | 015009 | 14 | 1 | 2 | 654.75 | 88 | 0 |
| 2020Q2 | 015009 | 17 | 1 | 6 | 1903.0 | 174 | 0 |
| 2020Q2 | 015009 | 17 | 2 | 1 | 548.75 | 44 | 0 |
| 2020Q2 | 015009 | 28 | 1 | 1 | 217.0 | 30 | 0 |
| 2020Q2 | 015009 | 29 | 1 | 1 | 94.0 | 19 | 0 |
| 2020Q2 | 015009 | 30 | 1 | 1 | 508.0 | 66 | 0 |
| 2020Q2 | 015009 | 31 | 1 | 1 | 464.25 | 56 | 0 |
| 2020Q2 | 015010 | 1 | 1 | 6 | 2921.25 | 365 | 0 |
| 2020Q2 | 015010 | 2 | 2 | 1 | 48.0 | 15 | 0 |
| 2020Q2 | 015010 | 5 | 1 | 1 | 520.0 | 65 | 0 |
| 2020Q2 | 015010 | 6 | 1 | 7 | 3358.25 | 393 | 0 |
| 2020Q2 | 015010 | 7 | 1 | 9 | 2306.25 | 287 | 0 |
| 2020Q2 | 015010 | 9 | 1 | 17 | 6714.25 | 851 | 0 |
| 2020Q2 | 015010 | 10 | 1 | 67 | 20667.0 | 2894 | 0 |
| 2020Q2 | 015010 | 10 | 2 | 1 | 440.0 | 56 | 0 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing