Nursing Home Daily Staffing Data (CMS PBJ)
We turn the CMS Payroll Based Journal into per-facility, per-day nurse staffing records for every US nursing home. One record is one facility's staffing for one calendar day: RN, LPN and CNA hours split between the facility's own employees and agency contractors, next to that day's resident census.
- Size
- 1,303,830 facility-days (one quarter)
- Refresh
- Quarterly
- Price
- $2 per 1,000 records
Who uses this
Plaintiff and long-term-care insurance analysts
Build staffing-risk evidence from a facility's full daily time series, including which days it leaned on agency contractors.
SNF operators and chains
Benchmark hours per resident day against every competitor in the same county or state, on the same days.
Researchers, journalists and policy teams
Study staffing levels, contract-labor dependence, weekend staffing dips, and census trends.
Analysts joining staffing to outcomes
Join records on CCN directly to CMS Care Compare, inspection, and quality datasets.
Sample records
Real records from the source, shown with a subset of the fields. Every run returns the full field set below.
| providerCcn | workDate | state | mdsCensus | totalNurseHours | totalNurseHprd |
|---|---|---|---|---|---|
| 015009 | 2026-01-01 | AL | 52 | 218.35 | 4.199 |
| 015009 | 2026-01-02 | AL | 51 | 207.42 | 4.0671 |
| 015024 | 2026-03-18 | AL | 146 | 496 | 3.3973 |
Sample rows taken from the CMS API on 2026-08-23; the derived totals and per-resident-day ratios are computed exactly as the actor computes them.
Fields
The most used fields in each record. The Apify listing documents the full output schema.
- providerCcn
- CMS Certification Number identifying the facility
- providerName
- Facility name
- workDate
- The calendar day the hours were paid for, ISO 8601
- state
- Two-letter state postal abbreviation
- mdsCensus
- Resident census that day, from Minimum Data Set submissions
- totalNurseHours
- Computed: RN (incl. DON/admin) + LPN (incl. admin) + CNA hours reported that day
- totalNurseHprd
- Computed: totalNurseHours divided by mdsCensus (hours per resident day)
- contractHoursShare
- Computed: share of all reported hours worked by agency/contract staff
How it works
1
Run it on Apify
Open the listing, sign in to Apify, and press Start. The actor reads the public source directly, normalizes each record, and writes the results to your Apify dataset. You can also schedule it to run on a cadence.
2
Filter to what you need
- •providerCcns: CMS Certification Numbers (PROVNUM), up to 100 per run
- •state: two-letter postal abbreviation
- •county: county name as CMS spells it, paired with state
- •facilityNameKeyword: case-insensitive substring on facility name, must be paired with another filter
- •workDateFrom / workDateTo: ISO date range on the work date
- •maxResults: 1 to 50000, sets the cost cap
- •includeRaw: attach the untouched CMS row
- •allowPartialScan: accept a partial sample instead of failing when the page budget runs out
3
Export or connect
Download the dataset as CSV, JSON, or Excel from the Apify console, or pull it straight into your own system through the Apify API and integrations.
Default run with no input returns 100 facility-days from the latest quarter in 2 requests and about 13 seconds, most of which is the mandated 10-second CMS crawl delay. maxResults ranges 1 to 50000. facilityNameKeyword cannot be used alone (must pair with state, county, providerCcns, workDateFrom or workDateTo) and its scan is capped at 10 pages (50,000 rows); a general scan is capped at 40 pages. A run that hits its page cap before maxResults is met fails unless allowPartialScan is set true, in which case the summary reports scanTruncated: true.
Pricing
$2 per 1,000 records
Pay per result, billed through your Apify account at $0.002 per record. You are charged only for the records the run delivers to your dataset, so a filtered run that matches nothing costs nothing. No subscription, no minimum.
Source, refresh, and licence
- Source
- Centers for Medicare & Medicaid Services (CMS): Payroll Based Journal Daily Nurse Staffing
- Size
- 1,303,830 facility-days (about 14,500 facilities), CY2026 Q1 (2026-01-01 to 2026-03-31), counted 2026-08-23
- Refresh
- Quarterly (CMS accrualPeriodicity R/P3M). The distribution read here was last modified 2026-07-29, covering 2026-01-01 to 2026-03-31. Only the CMS-labeled latest quarter is available at a time; a date range outside it returns nothing.
- Licence
- US Government work, public domain: CMS catalog records accessLevel public and license https://www.usa.gov/government-works
- Attribution
- Centers for Medicare & Medicaid Services (CMS)
Questions buyers ask
How current is the nursing home staffing data?
CMS publishes this dataset quarterly. The quarter read by this Actor was last modified 2026-07-29 and covers 2026-01-01 to 2026-03-31; only that most recent quarter is available at a time, and a date range outside it returns nothing.
Does this include agency and contract staffing hours, not just employees?
Yes. Every one of the eight staffing categories carries a total plus an Employee and a Contract split, and the Actor computes totalContractHours and contractHoursShare so contract reliance is visible without extra math.
Can I pull one facility's complete daily staffing history?
Yes. Filter on providerCcns (up to 100 CMS Certification Numbers per run), and records arrive ordered by provider then work date, so each facility's days are contiguous and in sequence.
Related datasets
Nursing Home Deficiency Citations (CMS Health Inspections)
We turn CMS's Health Deficiencies dataset into clean, filtered JSON: every health deficiency citation published for a US nursing home, across the last three inspection cycles.
Nursing homes and senior careNursing Home Penalties and Fines (CMS)
We turn CMS's Penalties dataset into clean records of every civil money penalty and payment denial levied on a US nursing home in the last three years.
Nursing homes and senior careLong-Term Care Facility Characteristics (CMS Form 671)
We turn CMS Form 671 into clean dataset records for every Medicare- and Medicaid-certified long-term care facility in the United States.
Pull the data you need
Run it yourself on Apify, or ask us for a custom extract, a join against another dataset, or a scheduled delivery.
We are not affiliated with or endorsed by Centers for Medicare & Medicaid Services (CMS). The actor reads the public dataset linked above and adds no data of its own.