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
Nurse hours, employees vs contract
Sample of 25 rows out of about 534,850
· 13 columns
| cy_quarter | ccn | days_reported | avg_census | rn_emp | rn_ctr | lpn_emp | lpn_ctr | aide_emp | aide_ctr | total_emp | total_ctr | contract_share |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2017Q1 | 015009 | 90 | 50.455555555555556 | 3500.2700000000004 | 0.0 | 4985.420000000001 | 0.0 | 13792.82 | 0.0 | 22278.510000000002 | 0.0 | 0.0 |
| 2017Q1 | 015012 | 90 | 47.37777777777778 | 2867.8199999999997 | 0.0 | 4627.889999999999 | 0.0 | 13492.610000000002 | 0.0 | 20988.32 | 0.0 | 0.0 |
| 2017Q1 | 015015 | 90 | 95.58888888888889 | 3338.400000000001 | 20.75 | 7562.950000000003 | 11.5 | 15961.849999999995 | 0.0 | 26863.199999999997 | 32.25 | 0.001199087578010407 |
| 2017Q1 | 015016 | 90 | 121.44444444444444 | 4548.110000000001 | 0.0 | 10610.640000000005 | 0.0 | 27216.020000000004 | 0.0 | 42374.77000000001 | 0.0 | 0.0 |
| 2017Q1 | 015019 | 90 | 100.41111111111111 | 4949.769999999999 | 0.0 | 7098.76 | 0.0 | 18664.82 | 0.0 | 30713.35 | 0.0 | 0.0 |
| 2017Q1 | 015023 | 90 | 139.96666666666667 | 11197.989999999998 | 24.87 | 8485.509999999998 | 363.29999999999995 | 39869.39000000001 | 0.0 | 59552.89 | 388.16999999999996 | 0.006475861454568871 |
| 2017Q1 | 015024 | 90 | 149.27777777777777 | 4592.199999999999 | 0.0 | 13449.53 | 0.0 | 36176.96000000001 | 0.0 | 54218.69 | 0.0 | 0.0 |
| 2017Q1 | 015027 | 90 | 113.72222222222223 | 2764.2 | 0.0 | 9225.979999999998 | 12.0 | 24884.999999999985 | 0.0 | 36875.17999999998 | 12.0 | 0.00032531627519371246 |
| 2017Q1 | 015028 | 90 | 78.06666666666666 | 6914.490000000001 | 0.0 | 4164.620000000001 | 0.0 | 11205.309999999996 | 0.0 | 22284.42 | 0.0 | 0.0 |
| 2017Q1 | 015031 | 90 | 167.75555555555556 | 10506.5 | 0.0 | 14218.25 | 0.0 | 31056.5 | 0.0 | 55781.25 | 0.0 | 0.0 |
| 2017Q1 | 015032 | 90 | 124.1 | 7203.610000000001 | 0.0 | 5145.3 | 0.0 | 19698.01999999999 | 0.0 | 32046.92999999999 | 0.0 | 0.0 |
| 2017Q1 | 015034 | 90 | 65.0111111111111 | 3404.2999999999997 | 0.0 | 5896.330000000001 | 0.0 | 17487.65 | 0.0 | 26788.280000000002 | 0.0 | 0.0 |
| 2017Q1 | 015035 | 90 | 109.95555555555555 | 5541.5 | 0.0 | 11896.0 | 0.0 | 28872.5 | 0.0 | 46310.0 | 0.0 | 0.0 |
| 2017Q1 | 015037 | 90 | 60.266666666666666 | 1835.6100000000004 | 0.0 | 6026.690000000002 | 231.74 | 12690.460000000001 | 0.0 | 20552.760000000002 | 231.74 | 0.011149654790829704 |
| 2017Q1 | 015040 | 90 | 110.95555555555555 | 5189.25 | 0.0 | 4657.510000000001 | 0.0 | 15792.880000000001 | 0.0 | 25639.640000000003 | 0.0 | 0.0 |
| 2017Q1 | 015042 | 90 | 87.2 | 3796.0499999999997 | 0.0 | 8617.609999999995 | 8.0 | 22665.85000000001 | 0.0 | 35079.51 | 8.0 | 0.00022800136002811255 |
| 2017Q1 | 015043 | 90 | 49.266666666666666 | 1589.2599999999998 | 995.5999999999999 | 3490.5099999999998 | 1297.1 | 10195.159999999998 | 24.5 | 15274.929999999997 | 2317.2 | 0.1317179898056688 |
| 2017Q1 | 015045 | 90 | 88.5 | 3065.4099999999994 | 0.0 | 8369.810000000003 | 0.0 | 18846.12 | 0.0 | 30281.340000000004 | 0.0 | 0.0 |
| 2017Q1 | 015047 | 90 | 99.81111111111112 | 4334.809999999999 | 4.0 | 8424.45 | 40.0 | 23580.159999999993 | 0.0 | 36339.41999999999 | 44.0 | 0.0012093420574536427 |
| 2017Q1 | 015048 | 90 | 90.55555555555556 | 3264.7100000000005 | 0.0 | 7273.86 | 0.0 | 22776.5 | 0.0 | 33315.07 | 0.0 | 0.0 |
| 2017Q1 | 015049 | 90 | 96.2 | 6193.0 | 0.0 | 7139.0 | 0.0 | 18689.25 | 0.0 | 32021.25 | 0.0 | 0.0 |
| 2017Q1 | 015050 | 90 | 70.82222222222222 | 1315.0 | 0.0 | 5328.229999999998 | 0.0 | 10059.279999999997 | 0.0 | 16702.509999999995 | 0.0 | 0.0 |
| 2017Q1 | 015053 | 90 | 73.08888888888889 | 3873.4700000000003 | 0.0 | 9118.239999999998 | 0.0 | 16331.200000000004 | 0.0 | 29322.910000000003 | 0.0 | 0.0 |
| 2017Q1 | 015060 | 90 | 58.91111111111111 | 541.75 | 0.0 | 3777.8800000000006 | 0.0 | 10472.979999999994 | 0.0 | 14792.609999999995 | 0.0 | 0.0 |
| 2017Q1 | 015063 | 90 | 93.55555555555556 | 7183.809999999999 | 0.0 | 3082.8600000000006 | 0.0 | 11990.840000000007 | 0.0 | 22257.510000000006 | 0.0 | 0.0 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing