Facility record report · CMS certification number 335427

ONEIDA HEALTH REHABILITATION AND EXTENDED CARE

ONEIDA, New York · 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
BACH, JANICE	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 01/01/2013
BELL, NADINE	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 01/01/2012
DUGAN, CHRIS	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 09/01/2023
HEDGLON, PETER	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 01/01/1985
KALLET, MICHAEL	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 01/01/1987
KOERNIG, FELISSA	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 09/01/2023
POTTER, STEVEN	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 01/01/2005
RATNARAJAH, DANIEL	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 01/01/2009
SCHAAL, TODD	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 09/01/2023
WELLS, MARGARET	CORPORATE DIRECTOR	Individual	NOT APPLICABLE	since 09/01/2023
KOERNIG, FELISSA	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 09/01/2023
SWEET, JEREMIAH	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 07/31/2017
KOERNIG, FELISSA	OPERATIONAL/MANAGERIAL CONTROL	Individual	NOT APPLICABLE	since 09/01/2023
SWEET, JEREMIAH	W-2 MANAGING EMPLOYEE	Individual	NOT APPLICABLE	since 07/31/2017

Medicare enrollment

As filed in the CMS file dated 1 August 2026 (Medicare enrollment ownership), under the enrollment of ONEIDA HEALTH SYSTEMS INC (enrollment ID O20070718000204).

Owner	Individual or organization	Role	Ownership percentage	Association date	Described in the filing as
CHRIS DUGAN	Individual	CORPORATE DIRECTOR	0	9/1/2023	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.
DANIEL RATNARAJAH	Individual	CORPORATE DIRECTOR	0	1/1/2009	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.
FELISSA KOERNIG	Individual	CORPORATE DIRECTOR	0	9/1/2023	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.
JANICE E BACH	Individual	CORPORATE DIRECTOR	0	1/1/2013	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.
MARGARET WELLS	Individual	CORPORATE DIRECTOR	0	9/1/2023	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 KALLET	Individual	CORPORATE DIRECTOR	0	1/1/1987	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.
NADINE BELL	Individual	CORPORATE DIRECTOR	0	1/1/2012	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.
PETER HEDGLON	Individual	CORPORATE DIRECTOR	0	1/1/1985	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.
STEVEN POTTER	Individual	CORPORATE DIRECTOR	0	1/1/2005	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.
TODD SCHAAL	Individual	CORPORATE DIRECTOR	0	9/1/2023	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.
FELISSA KOERNIG	Individual	CORPORATE OFFICER	0	9/1/2023	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.
JEREMIAH SWEET	Individual	CORPORATE 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.	7/31/2017	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.
FELISSA KOERNIG	Individual	OPERATIONAL/MANAGERIAL CONTROL	0	9/1/2023	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.
JEREMIAH SWEET	Individual	W-2 MANAGING EMPLOYEE	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/31/2017	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: JEREMIAH SWEET no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: JEREMIAH SWEET no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: JEREMIAH SWEET appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: JEREMIAH SWEET appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 December 2023: JONATHAN SCHILLER no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: JONATHAN SCHILLER no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: JONATHAN SCHILLER no longer appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: AMANDA LARSON no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: TODD SCHAAL appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: FELISSA KOERNIG appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: FELISSA KOERNIG appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: FELISSA KOERNIG appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: MARGARET WELLS appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: CHRIS DUGAN appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv

Inspections

Inspection cycle	Health inspection	Fire safety inspection	Health deficiencies	Fire safety deficiencies
1	27 January 2026	27 January 2026	9	11
2	12 April 2024	12 April 2024	16	9
3	25 January 2022	25 January 2022	1	4

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

Deficiencies cited

26 deficiencies on file, newest inspection first

Inspection date	Inspection type	Tag	Category	What was cited	Scope and severity	Complaint	Corrected	Correction date
27 January 2026	Health	F 0578	Resident Rights Deficiencies	Honor the resident's right to request, refuse, and/or discontinue treatment, to participate in or refuse to participate in experimental research, and to formulate an advance directive.	D	No	Deficient, Provider has date of correction	20 March 2026
27 January 2026	Health	F 0580	Resident Rights Deficiencies	Immediately tell the resident, the resident's doctor, and a family member of situations (injury/decline/room, etc.) that affect the resident.	D	Yes	Deficient, Provider has date of correction	20 March 2026
27 January 2026	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	20 March 2026
27 January 2026	Health	F 0684	Quality of Life and Care Deficiencies	Provide appropriate treatment and care according to orders, resident’s preferences and goals.	D	No	Deficient, Provider has date of correction	20 March 2026
27 January 2026	Health	F 0686	Quality of Life and Care Deficiencies	Provide appropriate pressure ulcer care and prevent new ulcers from developing.	D	No	Deficient, Provider has date of correction	20 March 2026
27 January 2026	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	Yes	Deficient, Provider has date of correction	20 March 2026
27 January 2026	Health	F 0690	Quality of Life and Care Deficiencies	Provide appropriate care for residents who are continent or incontinent of bowel/bladder, appropriate catheter care, and appropriate care to prevent urinary tract infections.	D	No	Deficient, Provider has date of correction	20 March 2026
27 January 2026	Health	F 0692	Quality of Life and Care Deficiencies	Provide enough food/fluids to maintain a resident's health.	D	No	Deficient, Provider has date of correction	20 March 2026
27 January 2026	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	20 March 2026
25 April 2025	Health	F 0578	Resident Rights Deficiencies	Honor the resident's right to request, refuse, and/or discontinue treatment, to participate in or refuse to participate in experimental research, and to formulate an advance directive.	J	Yes	Past Non-Compliance	15 April 2025
12 April 2024	Health	F 0582	Resident Rights Deficiencies	Give residents notice of Medicaid/Medicare coverage and potential liability for services not covered.	C	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	Health	F 0583	Resident Rights Deficiencies	Keep residents' personal and medical records private and confidential.	D	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	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	30 May 2024
12 April 2024	Health	F 0677	Quality of Life and Care Deficiencies	Provide care and assistance to perform activities of daily living for any resident who is unable.	E	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	Health	F 0679	Quality of Life and Care Deficiencies	Provide activities to meet all resident's needs.	D	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	Health	F 0684	Quality of Life and Care Deficiencies	Provide appropriate treatment and care according to orders, resident’s preferences and goals.	D	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	Health	F 0686	Quality of Life and Care Deficiencies	Provide appropriate pressure ulcer care and prevent new ulcers from developing.	D	Yes	Deficient, Provider has date of correction	30 May 2024
12 April 2024	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	30 May 2024
12 April 2024	Health	F 0725	Nursing and Physician Services Deficiencies	Provide enough nursing staff every day to meet the needs of every resident; and have a licensed nurse in charge on each shift.	E	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	Health	F 0760	Pharmacy Service Deficiencies	Ensure that residents are free from significant medication errors.	D	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	Health	F 0791	Quality of Life and Care Deficiencies	Provide or obtain dental services for each resident.	D	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	Health	F 0804	Nutrition and Dietary Deficiencies	Ensure food and drink is palatable, attractive, and at a safe and appetizing temperature.	D	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	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.	D	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	Health	F 0880	Infection Control Deficiencies	Provide and implement an infection prevention and control program.	E	No	Deficient, Provider has date of correction	30 May 2024
12 April 2024	Health	F 0925	Environmental Deficiencies	Make sure there is a pest control program to prevent/deal with mice, insects, or other pests.	E	No	Deficient, Provider has date of correction	30 May 2024
25 January 2022	Health	F 0582	Resident Rights Deficiencies	Give residents notice of Medicaid/Medicare coverage and potential liability for services not covered.	D	No	Deficient, Provider has date of correction	18 February 2022

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

Penalties

Penalty date	Type	Fine amount	Payment denial began	Payment denial, days	Fine ID
25 April 2025	Fine	$16,153			22423

From the Care Compare penalties file NH_Penalties_Aug2026.csv, processed on 1 August 2026.

Care Compare provider information

Field	As filed
Provider Type	Medicare and Medicaid
Ownership Type	Non profit - Corporation
Legal Business Name	ONEIDA HEALTH SYSTEMS INC
Date First Approved to Provide Medicare and Medicaid Services	1974-08-05
Provider Resides in Hospital	Y
Continuing Care Retirement Community	N
Urban	Y
County/Parish	Madison
Telephone Number	3153636000
Provider Changed Ownership in Last 12 Months	N
With a Resident and Family Council	Resident
Automatic Sprinkler Systems in All Required Areas	Yes
Number of Certified Beds	160
Average Number of Residents per Day	150.2
Overall Rating	1
Health Inspection Rating	2
QM Rating	3
Long-Stay QM Rating	2
Short-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: JEREMIAH SWEET no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: JEREMIAH SWEET no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: JEREMIAH SWEET appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: JEREMIAH SWEET appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 December 2023: JONATHAN SCHILLER no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: JONATHAN SCHILLER no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: JONATHAN SCHILLER no longer appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: AMANDA LARSON no longer appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: TODD SCHAAL appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: FELISSA KOERNIG appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: FELISSA KOERNIG appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: FELISSA KOERNIG appears as OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: MARGARET WELLS appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.csv
1 December 2023: CHRIS DUGAN appears as DIRECTOR in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2023-12-01.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, ONEIDA HEALTH REHABILITATION AND EXTENDED CARE — facility record report, CMS certification number 335427. https://velarionrecords.com/facility/335427/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 2017Q1 to 2026Q1.

Published by VELARIONAI LLC · Andrew Richardson, founder. Corrections: hello@velarionrecords.com, quoting certification number 335427. 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
2017Q1	31 March 2017	90	13,880	11,701.86	11,988.09	33,583.27	57,273.22
2017Q2	30 June 2017	91	13,775	11,958.62	11,423.5	32,728.29	56,110.41
2017Q3	30 September 2017	92	13,854	11,844.66	10,957.98	34,749.74	57,552.38
2018Q1	31 March 2018	90	13,471	8,888.75	13,246.17	33,287.69	55,422.61
2018Q2	30 June 2018	91	13,655	10,081.22	12,962.51	33,535.17	56,578.9
2018Q3	30 September 2018	92	14,108	11,689.75	15,367.97	34,268.05	61,325.77
2018Q4	31 December 2018	92	14,002	10,992.87	15,356.71	33,793.69	60,143.27
2019Q2	30 June 2019	91	13,332	10,545.8	13,694.5	31,270.4	55,510.7
2019Q3	30 September 2019	92	13,169	10,962.2	12,590.99	30,203.43	53,756.62
2019Q4	31 December 2019	92	13,971	11,856.58	13,348.02	31,622.64	56,827.24
2020Q3	30 September 2020	92	13,196	9,960.06	14,201.2	23,493.46	47,654.72
2020Q4	31 December 2020	92	12,467	9,624.23	13,613.05	24,519.08	47,756.36
2021Q1	31 March 2021	90	11,576	10,331.4	11,799.82	24,460.68	46,591.9
2021Q2	30 June 2021	91	12,194	9,956.73	12,513.41	24,137.84	46,607.98
2021Q3	30 September 2021	92	10,638	7,639.91	9,160.69	23,611.27	40,411.87
2021Q4	31 December 2021	92	9,488	6,659.61	7,787.03	18,497.17	32,943.81
2022Q1	31 March 2022	90	8,785	6,518.26	10,414.78	21,596.47	38,529.51
2022Q4	31 December 2022	92	9,800	6,998.43	9,237.71	17,686.29	33,922.43
2023Q1	31 March 2023	90	8,736	7,094.85	8,712.06	16,735.35	32,542.26
2023Q2	30 June 2023	91	9,160	6,875.06	8,727.79	17,321.75	32,924.6
2023Q3	30 September 2023	92	10,507	7,267.03	9,210.26	20,490.04	36,967.33
2023Q4	31 December 2023	92	10,753	7,816.39	10,611.77	23,789.61	42,217.77
2024Q1	31 March 2024	91	11,630	7,285.74	9,904.77	21,131.89	38,322.4
2024Q2	30 June 2024	91	11,778	7,515.82	10,759.63	24,254.06	42,529.51
2024Q3	30 September 2024	92	11,829	6,991.37	10,829.88	25,023.83	42,845.08
2024Q4	31 December 2024	92	12,326	7,764.36	11,143.48	25,795.79	44,703.63
2025Q1	31 March 2025	90	12,616	8,098.33	10,466.65	28,260.97	46,825.95
2025Q2	30 June 2025	91	13,005	8,071.03	10,819.26	30,230.02	49,120.31
2025Q3	30 September 2025	92	13,615	7,505.41	11,419.22	26,210.94	45,135.57
2026Q1	31 March 2026	90	13,519	7,492.97	12,663.07	22,712.96	42,869

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
2017Q1	0.843073	0.863695	2.419544	4.126313
2017Q2	0.868139	0.829292	2.375919	4.073351
2017Q3	0.854963	0.790961	2.508282	4.154207
2018Q1	0.659843	0.98331	2.471063	4.114216
2018Q2	0.73828	0.949287	2.455889	4.143457
2018Q3	0.82859	1.089309	2.42898	4.346879
2018Q4	0.785093	1.096751	2.41349	4.295334
2019Q2	0.791014	1.02719	2.345515	4.163719
2019Q3	0.832425	0.956108	2.293525	4.082058
2019Q4	0.848657	0.955409	2.263449	4.067514
2020Q3	0.754779	1.076175	1.780347	3.6113
2020Q4	0.771976	1.091927	1.966719	3.830622
2021Q1	0.892484	1.019335	2.113051	4.02487
2021Q2	0.816527	1.026194	1.979485	3.822206
2021Q3	0.718172	0.861129	2.219522	3.798822
2021Q4	0.701898	0.820724	1.949533	3.472155
2022Q1	0.741976	1.185518	2.458335	4.385829
2022Q4	0.714126	0.942623	1.804723	3.461472
2023Q1	0.812139	0.99726	1.915677	3.725076
2023Q2	0.750552	0.952816	1.891021	3.594389
2023Q3	0.691637	0.876583	1.950132	3.518353
2023Q4	0.726903	0.986866	2.21237	3.926139
2024Q1	0.626461	0.851657	1.817015	3.295133
2024Q2	0.638124	0.913536	2.059268	3.610928
2024Q3	0.591036	0.915536	2.115465	3.622037
2024Q4	0.629917	0.904063	2.092795	3.626775
2025Q1	0.641909	0.829633	2.24009	3.711632
2025Q2	0.62061	0.831931	2.324492	3.777033
2025Q3	0.55126	0.838723	1.925152	3.315136
2026Q1	0.554255	0.936687	1.680077	3.171019

How each quarter is derived, and its file

2017Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-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. This file names the totals hrs_rn_donadmin, hrs_lpn_admin, hrs_na_trn; they are read as hrs_rndon, hrs_lpnadmin, hrs_natrn. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2017-03-31.csv
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
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
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
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
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
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