Data Doughnut
Data catalog › Nursing homes

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

See the desks →

Job title codes Sample of 25 rows out of about 32 · 2 columns
job_codejob_title
1Administrator
2Medical Director
3Other Physician
4Physician Assistant
5RN Director of Nursing
6RN with Administrative Duties
7Registered Nurse
8LPN with Administrative Duties
9Licensed Practical/Vocational Nurse
10Certified Nurse Aide
11Nurse Aide in Training
12Medication Aide/Technician
13Nurse Practitioner
14Clinical Nurse Specialist
15Pharmacist
16Dietitian
17Paid Feeding Assistant (dictionary: Food Service Worker)
18Occupational Therapist
19Occupational Therapy Assistant
20Occupational Therapy Aide
21Physical Therapist
22Physical Therapy Assistant
23Physical Therapy Aide
24Respiratory Therapist
25Respiratory Therapy Technician

Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.

See pricing