Facility record report · CMS certification number 125010

LEAHI HOSPITAL

HONOLULU, Hawaii · Medicare and Medicaid

Finances, as filed

Not yet extracted for this facility.

Ownership, as filed with CMS

Care Compare

As filed in the CMS file dated 1 August 2026 (Care Compare ownership).

Owner or manager	Role	Type	Ownership percentage	Association
HAWAII HEALTH SYSTEMS CORPORATION	5% OR GREATER DIRECT OWNERSHIP INTEREST	Organization	100%	since 11/03/2007
AZAMA, GARET	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 07/01/2018
CHUN, BRADLEY	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 07/01/2018
SUNADA, JARED	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 07/01/2018
TSUNEISHI, LANI	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 07/01/2018
WALKER, KEN	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 07/01/2019
WOO, JASON	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 07/01/2018
AKIYOSHI, DEREK	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 11/01/2014
HAMAMOTO, MICHAEL	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 03/01/2018
ROSEN, LINDA	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 12/16/2014
SANADA, SEAN	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 01/01/2018
HAWAII HEALTH SYSTEMS CORPORATION	OPERATIONAL/MANAGERIAL CONTROL	Organization	NOT APPLICABLE	since 11/03/2007
GONZALES, VIOLETA	W-2 MANAGING EMPLOYEE	Individual	NOT APPLICABLE	since 03/22/2018

Medicare enrollment

As filed in the CMS file dated 1 August 2026 (Medicare enrollment ownership), under the enrollment of LEAHI HOSPITAL (enrollment ID O20170126002880).

Owner	Individual or organization	Role	Ownership percentage	Association date	Described in the filing as
HAWAII HEALTH SYSTEMS CORPORATION	Organization	5% OR GREATER DIRECT OWNERSHIP INTEREST	100	11/3/2007	Private equity company: No Real estate investment trust: No Holding company: No
BRADLEY A CHUN	Individual	CORPORATE DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	7/1/2018	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
GARET AZAMA	Individual	CORPORATE DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	7/1/2018	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
JARED SUNADA	Individual	CORPORATE DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	7/1/2018	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
JASON WOO	Individual	CORPORATE DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	7/1/2018	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
KEN WALKER	Individual	CORPORATE DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	7/1/2019	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
LANI TSUNEISHI	Individual	CORPORATE DIRECTOR	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	7/1/2018	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
DEREK AKIYOSHI	Individual	CORPORATE OFFICER	100	11/1/2014	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
MICHAEL HAMAMOTO	Individual	CORPORATE OFFICER	100	3/1/2018	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
SEAN SANADA	Individual	CORPORATE OFFICER	100	1/1/2018	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
LINDA ROSEN	Individual	OFFICER	CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.	12/16/2014	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.
HAWAII HEALTH SYSTEMS CORPORATION	Organization	OPERATIONAL/MANAGERIAL CONTROL	100	11/3/2007	Private equity company: No Real estate investment trust: No Holding company: No
VIOLETA GONZALES	Individual	W-2 MANAGING EMPLOYEE	100	3/22/2018	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.

Changes in ownership

1 July 2026: SEAN SANADA no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SEAN SANADA appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
15 May 2023: PATRICIA O'HAGAN no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: VALISA C SAUNDERS no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: AIDA B WEN no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: GARY A OKAMOTO no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: REID KONDO no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: GARY YOSHIOKA no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: DEREK AKIYOSHI no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: AARON KOSEKI no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: CREIGHTON ARITA no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: MICHAEL HAMAMOTO no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: BRADLEY A CHUN appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: VIOLETA GONZALES appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: LANI TSUNEISHI appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: KEN WALKER appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: JARED SUNADA appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: MICHAEL HAMAMOTO appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: GARET AZAMA appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: JASON WOO appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: SEAN SANADA appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv

Inspections

Inspection cycle	Health inspection	Fire safety inspection	Health deficiencies	Fire safety deficiencies
1	25 July 2025	1 August 2024	6	2
2	1 August 2024	14 September 2023	5	0
3	14 September 2023	30 September 2022	7	1

From the Care Compare inspection summary file NH_SurveySummary_Aug2026.csv, processed on 1 August 2026.

Deficiencies cited

18 deficiencies on file, newest inspection first

Inspection date	Inspection type	Tag	Category	What was cited	Scope and severity	Complaint	Corrected	Correction date
25 July 2025	Health	F 0628	Resident Rights Deficiencies	Provide the required documentation or notification related to the resident's needs, appeal rights, or bed-hold policies.	D	No	Deficient, Provider has date of correction	8 September 2025
25 July 2025	Health	F 0656	Resident Assessment and Care Planning Deficiencies	Develop and implement a complete care plan that meets all the resident's needs, with timetables and actions that can be measured.	D	No	Deficient, Provider has date of correction	8 September 2025
25 July 2025	Health	F 0689	Quality of Life and Care Deficiencies	Ensure that a nursing home area is free from accident hazards and provides adequate supervision to prevent accidents.	D	No	Deficient, Provider has date of correction	8 September 2025
25 July 2025	Health	F 0695	Quality of Life and Care Deficiencies	Provide safe and appropriate respiratory care for a resident when needed.	D	No	Deficient, Provider has date of correction	8 September 2025
25 July 2025	Health	F 0761	Pharmacy Service Deficiencies	Ensure drugs and biologicals used in the facility are labeled in accordance with currently accepted professional principles; and all drugs and biologicals must be stored in locked compartments, separately locked, compartments for controlled drugs.	D	No	Deficient, Provider has date of correction	8 September 2025
25 July 2025	Health	F 0812	Nutrition and Dietary Deficiencies	Procure food from sources approved or considered satisfactory and store, prepare, distribute and serve food in accordance with professional standards.	E	No	Deficient, Provider has date of correction	8 September 2025
1 August 2024	Health	F 0609	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Timely report suspected abuse, neglect, or theft and report the results of the investigation to proper authorities.	D	Yes	Deficient, Provider has date of correction	15 September 2024
1 August 2024	Health	F 0610	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Respond appropriately to all alleged violations.	D	Yes	Deficient, Provider has date of correction	15 September 2024
1 August 2024	Health	F 0644	Resident Assessment and Care Planning Deficiencies	Coordinate assessments with the pre-admission screening and resident review program; and referring for services as needed.	D	Yes	Deficient, Provider has date of correction	15 September 2024
1 August 2024	Health	F 0761	Pharmacy Service Deficiencies	Ensure drugs and biologicals used in the facility are labeled in accordance with currently accepted professional principles; and all drugs and biologicals must be stored in locked compartments, separately locked, compartments for controlled drugs.	D	No	Deficient, Provider has date of correction	15 September 2024
1 August 2024	Health	F 0867	Administration Deficiencies	Set up an ongoing quality assessment and assurance group to review quality deficiencies and develop corrective plans of action.	F	Yes	Deficient, Provider has date of correction	15 September 2024
14 September 2023	Health	F 0584	Resident Rights Deficiencies	Honor the resident's right to a safe, clean, comfortable and homelike environment, including but not limited to receiving treatment and supports for daily living safely.	D	No	Deficient, Provider has date of correction	27 October 2023
14 September 2023	Health	F 0609	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Timely report suspected abuse, neglect, or theft and report the results of the investigation to proper authorities.	E	Yes	Deficient, Provider has date of correction	27 October 2023
14 September 2023	Health	F 0610	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Respond appropriately to all alleged violations.	E	Yes	Deficient, Provider has date of correction	27 October 2023
14 September 2023	Health	F 0623	Resident Rights Deficiencies	Provide timely notification to the resident, and if applicable to the resident representative and ombudsman, before transfer or discharge, including appeal rights.	E	No	Deficient, Provider has date of correction	27 October 2023
14 September 2023	Health	F 0732	Nursing and Physician Services Deficiencies	Post nurse staffing information every day.	D	No	Deficient, Provider has date of correction	27 October 2023
14 September 2023	Health	F 0761	Pharmacy Service Deficiencies	Ensure drugs and biologicals used in the facility are labeled in accordance with currently accepted professional principles; and all drugs and biologicals must be stored in locked compartments, separately locked, compartments for controlled drugs.	D	No	Deficient, Provider has date of correction	27 October 2023
14 September 2023	Health	F 0880	Infection Control Deficiencies	Provide and implement an infection prevention and control program.	D	No	Deficient, Provider has date of correction	27 October 2023

From the Care Compare health citations file NH_HealthCitations_Aug2026.csv, processed on 1 August 2026.

Penalties

Not yet extracted for this facility.

Care Compare provider information

Field	As filed
Provider Type	Medicare and Medicaid
Ownership Type	Government - State
Legal Business Name	LEAHI HOSPITAL
Date First Approved to Provide Medicare and Medicaid Services	1969-01-01
Provider Resides in Hospital	N
Continuing Care Retirement Community	N
Urban	Y
County/Parish	Honolulu
Telephone Number	8087338000
Chain Name	HAWAII HEALTH SYSTEMS CORPORATION
Chain ID	250
Provider Changed Ownership in Last 12 Months	N
With a Resident and Family Council	Both
Automatic Sprinkler Systems in All Required Areas	Yes
Number of Certified Beds	155
Average Number of Residents per Day	93.2
Overall Rating	5
Health Inspection Rating	4
QM Rating	4
Long-Stay QM Rating	4
Processing Date	2026-08-01

From the Care Compare Provider Information file NH_ProviderInfo_Aug2026.csv, processed on 1 August 2026.

Every change on this record

1 July 2026: SEAN SANADA no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SEAN SANADA appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
15 May 2023: PATRICIA O'HAGAN no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: VALISA C SAUNDERS no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: AIDA B WEN no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: GARY A OKAMOTO no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: REID KONDO no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: GARY YOSHIOKA no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: DEREK AKIYOSHI no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: AARON KOSEKI no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: CREIGHTON ARITA no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: MICHAEL HAMAMOTO no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: BRADLEY A CHUN appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: VIOLETA GONZALES appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: LANI TSUNEISHI appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: KEN WALKER appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: JARED SUNADA appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: MICHAEL HAMAMOTO appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: GARET AZAMA appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: JASON WOO appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv
15 May 2023: SEAN SANADA appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-05-15.csv

How to read this report

Every figure is printed as the CMS file it came from printed it. Each cost-report figure carries the worksheet, line and column of form CMS-2540 it was read from, so a reader holding the same public file can go to that cell; each Care Compare and Medicare enrollment section names its file and the date CMS stamped on it.

A figure the filing does not carry is left out, and so is a figure whose value the filing’s own arithmetic contradicts. Net income is printed with what the form’s own arithmetic shows about it — plainly where it follows from the lines above it, and, where it does not, beside what the form’s own lines leave unaccounted for. An ownership field left empty carries the dated sentence on CMS’s pause of the expanded Form CMS-855A disclosure. A source that holds nothing for this facility says so in its section.

This report carries no percentile and no score, and it does not place this facility above or below another. The five facilities above are the one comparison it draws: the nearest certified bed counts in the same state at the same fiscal year, listed by name. Nurse staffing is printed in its own section, on its own page, apart from the cost-report figures.

How to cite this report

Velarion Records, LEAHI HOSPITAL — facility record report, CMS certification number 125010. https://velarionrecords.com/facility/125010/report.

Provider information, inspections, deficiencies and penalties: CMS Care Compare, file dated 1 August 2026.
Care Compare ownership: CMS file dated 1 August 2026.
Medicare enrollment ownership: CMS file dated 1 August 2026.
Nurse staffing: CMS Payroll-Based Journal, quarters 2017Q2 to 2026Q1.

Published by VELARIONAI LLC · Andrew Richardson, founder. Corrections: hello@velarionrecords.com, quoting certification number 125010. Velarion Records publishes these records as filed.

Nurse staffing, quarter by quarter

Hours this facility reported to CMS’s Payroll-Based Journal, one row per quarter, oldest first, each with how its figures are derived and the file it came from.

Nurse staffing hours by quarter
Quarter	Quarter ended	Days reported	Resident days	Registered nurse hours	Licensed practical nurse hours	Nurse aide hours	Total nurse hours
2017Q2	30 June 2017	91	9,794	14,990.65	813.3	24,028.7	39,832.65
2017Q3	30 September 2017	92	9,741	15,642.3	779.6	25,003.8	41,425.7
2017Q4	31 December 2017	92	9,186	15,548.95	877.4	23,587.4	40,013.75
2018Q1	31 March 2018	90	9,129	14,942.3	679.4	22,721.1	38,342.8
2018Q2	30 June 2018	91	9,782	16,743.5	962.6	25,786.1	43,492.2
2018Q3	30 September 2018	92	10,077	17,316.5	1,106.8	26,164.7	44,588
2018Q4	31 December 2018	92	10,231	15,956.6	1,057.6	26,169.1	43,183.3
2019Q1	31 March 2019	90	9,549	16,209	510.3	26,076.5	42,795.8
2019Q2	30 June 2019	91	9,601	15,186.5	470	24,724.9	40,381.4
2019Q3	30 September 2019	92	9,821	17,967.1	336	26,335.8	44,638.9
2019Q4	31 December 2019	92	9,843	17,990.2	328	27,135.3	45,453.5
2020Q1	31 March 2020	91	9,678	16,799.6	192	27,164.1	44,155.7
2020Q2	30 June 2020	91	8,853	18,037.35	479	25,970.3	44,486.65
2020Q3	30 September 2020	92	9,199	18,724.55	481	25,705.5	44,911.05
2020Q4	31 December 2020	92	8,967	17,986.35	514	25,805.6	44,305.95
2021Q1	31 March 2021	90	8,378	17,397.95	456	25,478.7	43,332.65
2021Q2	30 June 2021	91	8,170	16,939.3	320	23,792.6	41,051.9
2021Q3	30 September 2021	92	7,982	17,580.75	440	23,956.8	41,977.55
2021Q4	31 December 2021	92	7,977	17,107.7	488.4	22,916.4	40,512.5
2022Q1	31 March 2022	90	7,490	16,467.55	448	22,170.3	39,085.85
2022Q2	30 June 2022	91	7,935	17,365.55	472	22,047.4	39,884.95
2022Q3	30 September 2022	92	8,855	17,012.55	481.5	23,741.8	41,235.85
2022Q4	31 December 2022	92	8,689	15,769.75	328	22,128.6	38,226.35
2023Q1	31 March 2023	90	8,592	15,185.6	489.5	21,670.6	37,345.7
2023Q2	30 June 2023	91	8,857	13,735.85	358.3	21,481.1	35,575.25
2023Q3	30 September 2023	92	9,563	14,451.85	516.3	21,831	36,799.15
2023Q4	31 December 2023	92	9,471	13,305.5	496.5	20,307.4	34,109.4
2024Q1	31 March 2024	91	9,306	13,908.7	400.8	20,770.7	35,080.2
2024Q2	30 June 2024	91	9,380	14,061.65	489.3	20,432.4	34,983.35
2024Q3	30 September 2024	92	9,161	14,853.1	524.4	22,782.9	38,160.4
2024Q4	31 December 2024	92	9,409	13,583.7	510.5	22,265.6	36,359.8
2025Q1	31 March 2025	90	8,953	13,336.5	380	20,675.5	34,392
2025Q2	30 June 2025	91	9,061	15,877.3	342.5	22,094.9	38,314.7
2025Q3	30 September 2025	92	8,595	15,959.8	336	22,159.1	38,454.9
2025Q4	31 December 2025	92	8,697	15,611.6	400	22,727.4	38,739
2026Q1	31 March 2026	90	8,386	15,248.3	228	22,721.5	38,197.8

Nurse staffing hours per resident day by quarter
Quarter	Registered nurse hours per resident day	Licensed practical nurse hours per resident day	Nurse aide hours per resident day	Total nurse hours per resident day
2017Q2	1.530595	0.083041	2.45341	4.067046
2017Q3	1.605821	0.080033	2.566862	4.252715
2017Q4	1.692679	0.095515	2.567755	4.355949
2018Q1	1.636795	0.074422	2.488893	4.20011
2018Q2	1.711664	0.098405	2.636076	4.446146
2018Q3	1.718418	0.109834	2.596477	4.42473
2018Q4	1.559632	0.103372	2.557824	4.220829
2019Q1	1.697455	0.05344	2.73081	4.481705
2019Q2	1.581762	0.048953	2.575242	4.205958
2019Q3	1.829457	0.034212	2.68158	4.54525
2019Q4	1.827715	0.033323	2.756812	4.61785
2020Q1	1.735855	0.019839	2.806789	4.562482
2020Q2	2.037428	0.054106	2.933503	5.025037
2020Q3	2.035498	0.052288	2.79438	4.882167
2020Q4	2.005838	0.057321	2.877841	4.941
2021Q1	2.076623	0.054428	3.041143	5.172195
2021Q2	2.073354	0.039168	2.912191	5.024712
2021Q3	2.202549	0.055124	3.001353	5.259027
2021Q4	2.144628	0.061226	2.872809	5.078664
2022Q1	2.198605	0.059813	2.959987	5.218405
2022Q2	2.188475	0.059483	2.7785	5.026459
2022Q3	1.921237	0.054376	2.681174	4.656787
2022Q4	1.81491	0.037749	2.546737	4.399396
2023Q1	1.767412	0.056972	2.522183	4.346567
2023Q2	1.550847	0.040454	2.425325	4.016625
2023Q3	1.511226	0.053989	2.282861	3.848076
2023Q4	1.404867	0.052423	2.144166	3.601457
2024Q1	1.494595	0.043069	2.231969	3.769632
2024Q2	1.49911	0.052164	2.178294	3.729568
2024Q3	1.62134	0.057243	2.486945	4.165528
2024Q4	1.443692	0.054257	2.366415	3.864364
2025Q1	1.489612	0.042444	2.309338	3.841394
2025Q2	1.752268	0.037799	2.438462	4.228529
2025Q3	1.85687	0.039092	2.578138	4.474101
2025Q4	1.795056	0.045993	2.613246	4.454295
2026Q1	1.818304	0.027188	2.709456	4.554949

How each quarter is derived, and its file

2017Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin; they are read as hrs_lpnadmin. CMS's file labels its last six hours columns hrs_medaide, hrs_medaide_emp, hrs_rn_donadmin, hrs_na_trn, hrs_natrn_emp, hrs_natrn_ctr; they are read by position as Hrs_MedAide_emp, Hrs_MedAide_ctr, Hrs_NAtrn, Hrs_NAtrn_emp, Hrs_NAtrn_ctr, Hrs_MedAide, the order in which each total equals its employee and contract parts on every row. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-06-30.csv
2017Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin, hrs_na_trn; they are read as hrs_lpnadmin, hrs_natrn. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-09-30.csv
2017Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. This file names the totals hrs_lpn_admin, hrs_na_trn; they are read as hrs_lpnadmin, hrs_natrn. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-12-31.csv
2018Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-03-31.csv
2018Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-06-30.csv
2018Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-09-30.csv
2018Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-12-13.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2018-12-13.csv
2019Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-03-13.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-03-13.csv
2019Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-06-30.csv
2019Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-09-30.csv
2019Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-12-31.csv
2020Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-03-31.csv
2020Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-06-30.csv
2020Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-09-30.csv
2020Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-12-31.csv
2021Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-03-31.csv
2021Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-06-30.csv
2021Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-09-30.csv
2021Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. The file's `incomplete` column flags 0 of this facility's days as 1; those days are included as filed. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-12-31.csv
2022Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-01-01.csv
2022Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-06-30.csv
2022Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-09-30.csv
2022Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-12-31.csv
2023Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-01-01.csv
2023Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-06-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-06-01.csv
2023Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-09-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-09-01.csv
2023Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-12-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-12-01.csv
2024Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-01-01.csv
2024Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-04-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-04-01.csv
2024Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-09-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-09-01.csv
2024Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-12-31.csv
2025Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-01-01.csv
2025Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-04-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-04-01.csv
2025Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-07-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-07-01.csv
2025Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-10-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-10-01.csv
2026Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2026-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2026-01-01.csv

← the facility’s full record