data.cms.govHand-written summary

Payroll Based Journal Daily Nurse Staffing

Hours that nursing home staff are paid to work each day, for each facility, by staffing category such as registered nurses and certified nurse aides, plus a daily resident census.

Freshness

Last posted
Period covered
Jan 1, 2026 to Mar 31, 2026
Update frequency
Quarterly

Dates as CMS lists them in its catalog.

Before you use it

  • Nursing homes submit these data every quarter. The daily census is calculated from Minimum Data Set (MDS) submissions.

Columns 33

ColumnWhat it meansType
PROVNUMPROVNUMMedicare provider numberstring
PROVNAMEPROVNAMEProvider namestring
CITYCITYProvider Citystring
STATESTATEPostal abbreviation for Statestring
COUNTY_NAMECOUNTY_NAMEName of Provider County, unique within statestring
COUNTY_FIPSCOUNTY_FIPSFIPS Code for Provider County, unique within statestring
CY_QtrCY_QtrCalendar Quarter (yyyyQq, e.g. 2018Q4)string
WorkDateWorkDateDay for Reported Hours (yyyymmdd)number
MDScensusMDScensusResident Census from MDSnumber
Hrs_RNDONHrs_RNDONTotal Hours for RN Director of Nursingnumber
Hrs_RNDON_empHrs_RNDON_empEmployee Hours for RN Director of Nursingnumber
Hrs_RNDON_ctrHrs_RNDON_ctrContract Hours for RN Director of Nursingnumber
Hrs_RNadminHrs_RNadminHours for RN with administrative dutiesnumber
Hrs_RNadmin_empHrs_RNadmin_empEmployee Hours for RN with administrative dutiesnumber
Hrs_RNadmin_ctrHrs_RNadmin_ctrContract Hours for RN with administrative dutiesnumber
Hrs_RNHrs_RNTotal Hours for RNnumber
Hrs_RN_empHrs_RN_empEmployee Hours for RNnumber
Hrs_RN_ctrHrs_RN_ctrContract Hours for RNnumber
Hrs_LPNadminHrs_LPNadminTotal Hours for LPN w/ admin dutiesnumber
Hrs_LPNadmin_empHrs_LPNadmin_empEmployee Hours for LPN w/ admin dutiesnumber
Hrs_LPNadmin_ctrHrs_LPNadmin_ctrContract Hours for LPN w/ admin dutiesnumber
Hrs_LPNHrs_LPNTotal Hours for LPNnumber
Hrs_LPN_empHrs_LPN_empEmployee Hours for LPNnumber
Hrs_LPN_ctrHrs_LPN_ctrContract Hours for LPNnumber
Hrs_CNAHrs_CNATotal Hours for CNAnumber
Hrs_CNA_empHrs_CNA_empEmployee Hours for CNAnumber
Hrs_CNA_ctrHrs_CNA_ctrContract Hours for CNAnumber
Hrs_NAtrnHrs_NAtrnTotal Hours for Nurse aide in trainingnumber
Hrs_NAtrn_empHrs_NAtrn_empEmployee Hours for Nurse aide in trainingnumber
Hrs_NAtrn_ctrHrs_NAtrn_ctrContract Hours for Nurse aide in trainingnumber
Hrs_MedAideHrs_MedAideTotal Hours for Med Aide/Techniciannumber
Hrs_MedAide_empHrs_MedAide_empEmployee Hours for Med Aide/Techniciannumber
Hrs_MedAide_ctrHrs_MedAide_ctrContract Hours for Med Aide/Techniciannumber

At a glance

Catalog
data.cms.gov
Publisher
Office of Enterprise Data and Analytics (OEDA)
Rows
1,303,830
Columns
33
State column
STATE
Topics
Nursing homes, Hospitals, Spending and use of services, Quality and ratings
Contact
nhstaffing@cms.hhs.gov

API

Free, no key needed. This request returns the first 10 rows as JSON:

https://data.cms.gov/data-api/v1/dataset/7e0d53ba-8f02-4c66-98a5-14a1c997c50d/data?size=10

To keep only one state, filter on the STATE column.

Versions 37

The newest version is the one linked above. Older releases stay on the official site.

  • 2026-01-01posted Jul 29, 2026
  • 2025-10-01posted Apr 29, 2026
  • 2025-07-01posted Feb 5, 2026
  • 2025-04-01posted Nov 20, 2025
  • 2025-01-01posted Sep 11, 2025
  • 2024-12-31posted Apr 30, 2025
  • 2024-09-01posted Apr 2, 2025
  • 2024-04-01posted Oct 31, 2024
Show 29 older versions
  • 2024-01-01posted Jul 31, 2024
  • 2023-12-01posted Apr 24, 2024
  • 2023-09-01posted Jan 31, 2024
  • 2023-06-01posted Oct 25, 2023
  • 2023-01-01posted Jul 26, 2023
  • 2022-12-31posted Apr 26, 2023
  • 2022-09-30posted Mar 6, 2023
  • 2022-06-30posted Oct 26, 2022
  • 2022-01-01posted Jul 27, 2022
  • 2021-12-31posted May 23, 2022
  • 2021-09-30posted Jan 26, 2022
  • 2021-06-30posted Oct 14, 2021
  • 2021-03-31posted Feb 28, 2022
  • 2020-12-31posted Jul 9, 2021
  • 2020-09-30posted Jul 8, 2021
  • 2020-06-30posted Jul 8, 2021
  • 2020-03-31posted Oct 5, 2021
  • 2019-12-31posted Jul 8, 2021
  • 2019-09-30posted Jul 8, 2021
  • 2019-06-30posted Jul 8, 2021
  • 2019-03-13posted Jul 8, 2021
  • 2018-12-13posted Jul 8, 2021
  • 2018-09-30posted Apr 6, 2022
  • 2018-06-30posted Apr 6, 2022
  • 2018-03-31posted Apr 6, 2022
  • 2017-12-31posted Jul 8, 2021
  • 2017-09-30posted Jul 8, 2021
  • 2017-06-30posted Jul 8, 2021
  • 2017-03-31posted Jul 8, 2021

CMS's description

The Payroll Based Journal (PBJ) Nurse Staffing and Non-Nurse Staffing datasets provide information submitted by nursing homes including rehabilitation services on a quarterly basis. The View Data link above includes the hours staff are paid to work each day, for each facility, aggregated by staff reporting category. Examples of reporting categories include Director of Nursing, Administrative Registered Nurses, Registered Nursing, Administrative Licensed Practice Nurses, Licensed Practice Nurses, Certified Nurse Aides, Certified Medication Aides, and Nurse Aides in Training. There are also other non-nurse staff categories provided in the data such as Respiratory Therapist, Occupational Therapist, and Social Worker. The datasets also include a facility’s daily census calculated using the Minimum Data Set (MDS) submission.

Methodology and other documents from CMS:

The summary at the top was written by hand from this description. Record id cms:7e0d53ba-8f02-4c66-98a5-14a1c997c50d. This record as JSON.

Keyboard shortcuts

/
Jump to the search box (or the column filter on a dataset page)
Esc
Clear the search box, or close this panel
↓ ↑
Move through the results from the search box
Enter
Open the highlighted result
?
Show this panel