Facility record report · CMS certification number 265609

ASPIRE SENIOR LIVING MALDEN

MALDEN, Missouri · Medicare and Medicaid

Finances, as filed

From this facility’s Medicare cost reports on form CMS-2540, each figure with the worksheet, line and column it was read from.

Cost report for 1 January 2024 to 31 December 2024 — a reporting period of 365 days, on form CMS-2540-10, settled, processed by CMS on 29 August 2025.

Revenue and expenses, fiscal year 2024
Figure	As filed	Where it comes from
Total patient revenue	$2,751,611	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$64,599	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,687,012	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$3,072,269	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$385,257	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$21,680	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$363,577	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$363,577 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2024
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Bed days available, all components	25,620	CMS-2540-10 worksheet S300001 line 800 column 200
Medicare (Title XVIII) patient days	622	CMS-2540-10 worksheet S300001 line 800 column 400
Medicaid (Title XIX) patient days	10,284	CMS-2540-10 worksheet S300001 line 800 column 500
Other-payer patient days	939	CMS-2540-10 worksheet S300001 line 800 column 600
Total patient days, all components	11,845	CMS-2540-10 worksheet S300001 line 800 column 700
Medicare discharges	16	CMS-2540-10 worksheet S300001 line 800 column 900
Medicaid discharges	38	CMS-2540-10 worksheet S300001 line 800 column 1000
Other-payer discharges	12	CMS-2540-10 worksheet S300001 line 800 column 1100
Total discharges, all components	66	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	38.88	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	270.63	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	179.47	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1437303, read from the public cost report file SNF10FY2024.zip.

Cost report for 1 January 2023 to 31 December 2023 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 27 August 2024.

Revenue and expenses, fiscal year 2023
Figure	As filed	Where it comes from
Total patient revenue	$2,196,197	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$225,312	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$1,970,885	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,519,864	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$548,979	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$10,606	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$538,373	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$538,373 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2023
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	10,618	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	34	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	57.92	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	591.36	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	312.29	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1393193, read from the public cost report file SNF10FY2023.zip.

Cost report for 1 January 2022 to 31 December 2022 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 11 October 2023.

Revenue and expenses, fiscal year 2022
Figure	As filed	Where it comes from
Total patient revenue	$2,198,090	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$20,713	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,177,377	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,511,470	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$334,093	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$11,294	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$322,799	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$322,799 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2022
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	11,097	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	57	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	46.76	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	502.47	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	194.68	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1365914, read from the public cost report file SNF10FY2022.zip.

Cost report for 1 June 2021 to 31 December 2021 — a reporting period of 213 days, not a full year, on form CMS-2540-10, settled, processed by CMS on 23 September 2022.

Revenue and expenses, fiscal year 2021
Figure	As filed	Where it comes from
Total patient revenue	$1,384,420	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$166,243	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$1,218,177	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$1,398,964	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$180,787	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$152	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$180,635	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$180,635 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2021
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	6,390	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	37	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	52.89	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	285.12	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	172.7	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1333860, read from the public cost report file SNF10FY2021.zip.

Cost report for 1 January 2020 to 31 December 2020 — a reporting period of 365 days, on form CMS-2540-10, settled, processed by CMS on 18 June 2021.

Revenue and expenses, fiscal year 2020
Figure	As filed	Where it comes from
Total patient revenue	$2,367,587	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$232,493	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,135,094	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,676,304	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$541,210	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$527,678	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$13,532	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$13,532 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2020
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	11,612	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	94	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	58.07	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	160.5	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	123.53	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1286400, read from the public cost report file SNF10FY2020.zip.

Cost report for 1 January 2019 to 31 December 2019 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 20 May 2020.

Revenue and expenses, fiscal year 2019
Figure	As filed	Where it comes from
Total patient revenue	$3,325,885	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$470,916	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,854,969	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,883,452	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$28,483	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$9,307	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$19,176	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$19,176 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2019
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	15,358	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	116	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	57.95	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	183.02	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	132.4	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1255841, read from the public cost report file SNF10FY2019.zip.

Cost report for 1 January 2018 to 31 December 2018 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 17 July 2019.

Revenue and expenses, fiscal year 2018
Figure	As filed	Where it comes from
Total patient revenue	$3,198,510	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$542,642	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,655,868	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,813,724	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$157,856	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$9,567	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$148,289	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$148,289 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2018
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	14,723	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	44	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	53.32	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	1,150.4	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	334.61	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1237280, read from the public cost report file SNF10FY2018.zip.

Cost report for 1 January 2017 to 31 December 2017 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 19 July 2018.

Revenue and expenses, fiscal year 2017
Figure	As filed	Where it comes from
Total patient revenue	$3,302,991	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$660,178	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,642,813	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,824,250	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$181,437	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$5,796	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$175,641	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$175,641 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2017
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	15,474	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	104	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	53.45	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	525.64	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	148.79	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1199713, read from the public cost report file SNF10FY2017.zip.

Cost report for 1 January 2016 to 31 December 2016 — a reporting period of 365 days, on form CMS-2540-10, settled, processed by CMS on 31 May 2017.

Revenue and expenses, fiscal year 2016
Figure	As filed	Where it comes from
Total patient revenue	$3,276,167	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$469,368	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,806,799	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,855,711	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$48,912	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$11,147	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$37,765	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$37,765 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2016
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	16,114	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	79	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	81.27	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	237.23	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	203.97	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1158772, read from the public cost report file SNF10FY2016.zip.

Cost report for 1 January 2015 to 31 December 2015 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 25 July 2016.

Revenue and expenses, fiscal year 2015
Figure	As filed	Where it comes from
Total patient revenue	$2,532,984	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$305,425	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,227,559	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,514,801	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$287,242	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$9,310	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$277,932	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$277,932 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2015
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	13,107	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	90	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	28.87	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	230.92	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	145.63	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1137035, read from the public cost report file SNF10FY2015.zip.

Cost report for 1 January 2014 to 31 December 2014 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 22 June 2015.

Revenue and expenses, fiscal year 2014
Figure	As filed	Where it comes from
Total patient revenue	$2,553,166	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$213,249	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,339,917	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,565,444	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$225,527	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$4,289	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$221,238	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$221,238 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2014
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	13,976	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	84	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	55.29	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	258.23	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	166.38	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1099136, read from the public cost report file SNF10FY2014.zip.

Cost report for 1 January 2013 to 31 December 2013 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 24 June 2014.

Revenue and expenses, fiscal year 2013
Figure	As filed	Where it comes from
Total patient revenue	$2,647,283	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$401,611	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,245,672	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,476,411	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$230,739	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$11,278	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$219,461	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$219,461 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2013
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	14,324	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	113	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	60.37	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	133.14	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	126.76	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1067504, read from the public cost report file SNF10FY2013.zip.

Cost report for 1 January 2012 to 31 December 2012 — a reporting period of 365 days, on form CMS-2540-10, settled, processed by CMS on 23 July 2013.

Revenue and expenses, fiscal year 2012
Figure	As filed	Where it comes from
Total patient revenue	$2,256,859	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$260,826	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$1,996,033	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,496,033	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$500,000	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$11,304	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$488,696	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$488,696 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2012
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	12,916	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	90	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	66.92	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	159.23	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	143.51	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1041694, read from the public cost report file SNF10FY2012.zip.

Cost report for 1 January 2011 to 31 December 2011 — a reporting period of 364 days, on form CMS-2540-10, settled, processed by CMS on 26 October 2012.

Revenue and expenses, fiscal year 2011
Figure	As filed	Where it comes from
Total patient revenue	$2,127,908	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$347,546	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$1,780,362	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,148,177	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$367,815	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$6,428	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$361,387	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$361,387 (CMS-2540-10 worksheet G300000 line 3100 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 26 less 27 through 30) on 204,018 of the 204,018 reports filed on Form CMS-2540-10 in publication years 2011-2025 that file every line it is computed from (100%).

Beds, days and discharges, fiscal year 2011
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	12,618	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	113	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	43.13	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	140.27	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	111.66	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1013986, read from the public cost report file SNF10FY2011.zip.

Cost report for 1 January 2010 to 31 December 2010 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 26 July 2011.

Revenue and expenses, fiscal year 2010
Figure	As filed	Where it comes from
Net patient revenue	$2,131,353	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$2,251,625	CMS-2540-96 worksheet G200002 line 1500 column 200
Net income from service to patients	−$120,272	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$6,917	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: −$113,355 (CMS-2540-96 worksheet G300000 line 3200 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 5 plus 26 less 31) on 192,460 of the 192,462 reports filed on Form CMS-2540-96 in publication years 1995-2012 that file every line it is computed from (99.99%); on 2 of them the filed figure and that arithmetic differ, by a median of $46,907, and those figures are not shown. A further 2,252 reports file net income without filing net income from service to patients (Worksheet G-3 line 5), so the arithmetic cannot be applied to them and their figure is shown as filed.

Beds, days and discharges, fiscal year 2010
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	14,135	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	124	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	36	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	143.38	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	113.99	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 412876, read from the public cost report file SNFFY2010.zip.

Cost report for 1 January 2009 to 31 December 2009 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 27 May 2010.

Revenue and expenses, fiscal year 2009
Figure	As filed	Where it comes from
Net patient revenue	$2,407,407	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$2,353,892	CMS-2540-96 worksheet G200002 line 1500 column 200
Net income from service to patients	$53,515	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$7,424	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: $60,939 (CMS-2540-96 worksheet G300000 line 3200 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 5 plus 26 less 31) on 192,460 of the 192,462 reports filed on Form CMS-2540-96 in publication years 1995-2012 that file every line it is computed from (99.99%); on 2 of them the filed figure and that arithmetic differ, by a median of $46,907, and those figures are not shown. A further 2,252 reports file net income without filing net income from service to patients (Worksheet G-3 line 5), so the arithmetic cannot be applied to them and their figure is shown as filed.

Beds, days and discharges, fiscal year 2009
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	14,269	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	136	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	47.33	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	131.43	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	104.92	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 370884, read from the public cost report file SNFFY2009.zip.

Cost report for 1 January 2008 to 31 December 2008 — a reporting period of 365 days, on form CMS-2540-96, settled, processed by CMS on 1 June 2009.

Revenue and expenses, fiscal year 2008
Figure	As filed	Where it comes from
Net patient revenue	$2,353,269	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$2,370,121	CMS-2540-96 worksheet G200002 line 1500 column 200
Net income from service to patients	−$16,852	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$6,611	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: −$10,241 (CMS-2540-96 worksheet G300000 line 3200 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 5 plus 26 less 31) on 192,460 of the 192,462 reports filed on Form CMS-2540-96 in publication years 1995-2012 that file every line it is computed from (99.99%); on 2 of them the filed figure and that arithmetic differ, by a median of $46,907, and those figures are not shown. A further 2,252 reports file net income without filing net income from service to patients (Worksheet G-3 line 5), so the arithmetic cannot be applied to them and their figure is shown as filed.

Beds, days and discharges, fiscal year 2008
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	15,185	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	199	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	39.9	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	99.02	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	76.31	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 341129, read from the public cost report file SNFFY2008.zip.

Cost report for 1 January 2007 to 31 December 2007 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 11 June 2008.

Revenue and expenses, fiscal year 2007
Figure	As filed	Where it comes from
Net patient revenue	$1,731,704	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$1,966,229	CMS-2540-96 worksheet G200002 line 1500 column 200
Net income from service to patients	−$234,525	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$4,745	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: −$229,780 (CMS-2540-96 worksheet G300000 line 3200 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 5 plus 26 less 31) on 192,460 of the 192,462 reports filed on Form CMS-2540-96 in publication years 1995-2012 that file every line it is computed from (99.99%); on 2 of them the filed figure and that arithmetic differ, by a median of $46,907, and those figures are not shown. A further 2,252 reports file net income without filing net income from service to patients (Worksheet G-3 line 5), so the arithmetic cannot be applied to them and their figure is shown as filed.

Beds, days and discharges, fiscal year 2007
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	12,270	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	167	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	47.38	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	157.04	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	73.47	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 312866, read from the public cost report file SNFFY2007.zip.

Cost report for 1 January 2006 to 31 December 2006 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 17 December 2007.

Revenue and expenses, fiscal year 2006
Figure	As filed	Where it comes from
Net patient revenue	$1,607,051	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$1,886,542	CMS-2540-96 worksheet G200002 line 1500 column 100
Net income from service to patients	−$279,491	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$6,425	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: −$273,066 (CMS-2540-96 worksheet G300000 line 3200 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 5 plus 26 less 31) on 192,460 of the 192,462 reports filed on Form CMS-2540-96 in publication years 1995-2012 that file every line it is computed from (99.99%); on 2 of them the filed figure and that arithmetic differ, by a median of $46,907, and those figures are not shown. A further 2,252 reports file net income without filing net income from service to patients (Worksheet G-3 line 5), so the arithmetic cannot be applied to them and their figure is shown as filed.

Beds, days and discharges, fiscal year 2006
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	11,477	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	218	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	47.08	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	117.88	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	52.65	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 298775, read from the public cost report file SNFFY2006.zip.

Cost report for 1 January 2005 to 31 December 2005 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 13 December 2006.

Revenue and expenses, fiscal year 2005
Figure	As filed	Where it comes from
Net patient revenue	$1,849,353	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$1,977,224	CMS-2540-96 worksheet G200002 line 1500 column 100
Net income from service to patients	−$127,871	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$5,970	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: −$121,901 (CMS-2540-96 worksheet G300000 line 3200 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 5 plus 26 less 31) on 192,460 of the 192,462 reports filed on Form CMS-2540-96 in publication years 1995-2012 that file every line it is computed from (99.99%); on 2 of them the filed figure and that arithmetic differ, by a median of $46,907, and those figures are not shown. A further 2,252 reports file net income without filing net income from service to patients (Worksheet G-3 line 5), so the arithmetic cannot be applied to them and their figure is shown as filed.

Beds, days and discharges, fiscal year 2005
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	16,065	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	212	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	67.11	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	124.48	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	75.78	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 268638, read from the public cost report file SNFFY2005.zip.

Cost report for 1 January 2004 to 31 December 2004 — a reporting period of 365 days, on form CMS-2540-96, settled, processed by CMS on 26 January 2006.

Revenue and expenses, fiscal year 2004
Figure	As filed	Where it comes from
Net patient revenue	$2,004,994	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$1,989,554	CMS-2540-96 worksheet G200002 line 1500 column 100
Net income from service to patients	$15,440	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$80,332	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: $95,772 (CMS-2540-96 worksheet G300000 line 3200 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 5 plus 26 less 31) on 192,460 of the 192,462 reports filed on Form CMS-2540-96 in publication years 1995-2012 that file every line it is computed from (99.99%); on 2 of them the filed figure and that arithmetic differ, by a median of $46,907, and those figures are not shown. A further 2,252 reports file net income without filing net income from service to patients (Worksheet G-3 line 5), so the arithmetic cannot be applied to them and their figure is shown as filed.

Beds, days and discharges, fiscal year 2004
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	17,054	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	248	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	96.77	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	109.73	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	68.77	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 241555, read from the public cost report file SNFFY2004.zip.

Cost report for 1 January 2003 to 31 December 2003 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 15 November 2005.

Revenue and expenses, fiscal year 2003
Figure	As filed	Where it comes from
Net patient revenue	$1,565,044	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$1,771,240	CMS-2540-96 worksheet G200002 line 1500 column 100
Net income from service to patients	−$206,196	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$25,570	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: −$180,626 (CMS-2540-96 worksheet G300000 line 3200 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 5 plus 26 less 31) on 192,460 of the 192,462 reports filed on Form CMS-2540-96 in publication years 1995-2012 that file every line it is computed from (99.99%); on 2 of them the filed figure and that arithmetic differ, by a median of $46,907, and those figures are not shown. A further 2,252 reports file net income without filing net income from service to patients (Worksheet G-3 line 5), so the arithmetic cannot be applied to them and their figure is shown as filed.

Beds, days and discharges, fiscal year 2003
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	16,176	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	100	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	33.6	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	369.79	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	161.76	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 236888, read from the public cost report file SNFFY2003.zip.

Cost report for 1 January 2002 to 31 December 2002 — a reporting period of 364 days, on form CMS-2540-96, settled, processed by CMS on 17 November 2005.

Revenue and expenses, fiscal year 2002
Figure	As filed	Where it comes from
Net patient revenue	$1,745,702	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$1,850,157	CMS-2540-96 worksheet G200002 line 1500 column 100
Net income from service to patients	−$104,455	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$92,892	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: −$11,563 (CMS-2540-96 worksheet G300000 line 3200 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 5 plus 26 less 31) on 192,460 of the 192,462 reports filed on Form CMS-2540-96 in publication years 1995-2012 that file every line it is computed from (99.99%); on 2 of them the filed figure and that arithmetic differ, by a median of $46,907, and those figures are not shown. A further 2,252 reports file net income without filing net income from service to patients (Worksheet G-3 line 5), so the arithmetic cannot be applied to them and their figure is shown as filed.

Beds, days and discharges, fiscal year 2002
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	17,972	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	100	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	38.91	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	375.47	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	179.72	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 237047, read from the public cost report file SNFFY2002.zip.

Cost report for 1 October 2001 to 31 December 2001 — a reporting period of 91 days, not a full year, on form CMS-2540-96, settled, processed by CMS on 16 June 2004.

None of these figures is carried on this report.

CMS report record 182462, read from the public cost report file SNFFY2002.zip.

Cost report for 1 January 2000 to 31 December 2000 — a reporting period of 365 days, on form CMS-2540-96, settled, processed by CMS on 28 July 2003.

Revenue and expenses, fiscal year 2000
Figure	As filed	Where it comes from
Net patient revenue	$1,728,948	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$1,893,904	CMS-2540-96 worksheet G200002 line 1500 column 100
Net income from service to patients	−$164,956	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$1,143	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: −$163,813 (CMS-2540-96 worksheet G300000 line 3200 column 100). As filed, net income for the period equals net income from service to patients plus total other income, less total other expenses (Worksheet G-3 lines 5 plus 26 less 31) on 192,460 of the 192,462 reports filed on Form CMS-2540-96 in publication years 1995-2012 that file every line it is computed from (99.99%); on 2 of them the filed figure and that arithmetic differ, by a median of $46,907, and those figures are not shown. A further 2,252 reports file net income without filing net income from service to patients (Worksheet G-3 line 5), so the arithmetic cannot be applied to them and their figure is shown as filed.

Beds, days and discharges, fiscal year 2000
Figure	As filed	Where it comes from
Total facility beds, all components	70	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	18,495	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	4	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	40	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, all patients, in days	4,623.75	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 153858, read from the public cost report file SNFFY2000.zip.

Five facilities of a similar size in Missouri, fiscal year 2024

Chosen for having certified bed counts closest to this facility’s, listed by name. Every one filed for the same fiscal year; the day each year ends differs and is shown. Each figure is that facility’s own filing.

Facility	Total facility beds	Total patient days	Net patient revenue	Total operating expenses	Net income from service to patients	Period ended
ASPIRE SENIOR LIVING ADVANCE	70	12,149	$2,931,036	$3,219,321	−$288,285	31 December 2024
ASPIRE SENIOR LIVING EAST PRAIRIE	70	9,312	$2,552,951	$2,779,705	−$226,754	31 December 2024
ASPIRE SENIOR LIVING MALDEN	70	11,845	$2,687,012	$3,072,269	−$385,257	31 December 2024
CHAFFEE NURSING CENTER	71	21,974	$6,499,713	$5,229,803	$1,269,910	31 December 2024
DAYBREAK NURSING CENTER	70	22,921	$4,495,415	$4,265,262	$230,153	31 December 2024
GIDEON CARE CENTER	72	22,595	$5,153,778	$4,946,614	$207,164	31 December 2024

Where each column comes from, on every filing in this table: Total facility beds: CMS-2540-10 worksheet S300001 line 800 column 100 · Total patient days: CMS-2540-10 worksheet S300001 line 800 column 700 · Net patient revenue: CMS-2540-10 worksheet G300000 line 300 column 100 · Total operating expenses: CMS-2540-10 worksheet G300000 line 400 column 100 · Net income from service to patients: CMS-2540-10 worksheet G300000 line 500 column 100.

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
CALVERT, GREGG	5% OR GREATER INDIRECT OWNERSHIP INTEREST	Individual	12%	since 06/01/2021
HARRIS, JERRY	5% OR GREATER INDIRECT OWNERSHIP INTEREST	Individual	10%	since 06/01/2021
STEELE, SHERI	5% OR GREATER INDIRECT OWNERSHIP INTEREST	Individual	8%	since 06/01/2021
CALVERT, GREGG	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 06/01/2021
HARRIS, JERRY	CORPORATE OFFICER	Individual	NOT APPLICABLE	since 06/01/2021
CALVERT, GREGG	W-2 MANAGING EMPLOYEE	Individual	NOT APPLICABLE	since 06/01/2021
HARRIS, JERRY	W-2 MANAGING EMPLOYEE	Individual	NOT APPLICABLE	since 06/01/2021

Medicare enrollment

As filed in the CMS file dated 1 August 2026 (Medicare enrollment ownership), under the enrollment of ASPIRE SENIOR LIVING MALDEN LLC (enrollment ID O20210722003257).

Owner	Individual or organization	Role	Ownership percentage	Association date	Described in the filing as
CHP SNF OPCO HOLDINGS LLC	Organization	5% OR GREATER DIRECT OWNERSHIP INTEREST	100	6/1/2021	Private equity company: No Real estate investment trust: No Holding company: Yes
CHP SNF HOLDINGS LLC	Organization	5% OR GREATER INDIRECT OWNERSHIP INTEREST	70	6/1/2021	Private equity company: No Real estate investment trust: No Holding company: Yes
CHP SNFCO LLC	Organization	5% OR GREATER INDIRECT OWNERSHIP INTEREST	100	6/1/2021	Private equity company: No Real estate investment trust: No Holding company: Yes
GREGG J CALVERT	Individual	5% OR GREATER INDIRECT OWNERSHIP INTEREST	12	6/1/2021	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.
JERRY W HARRIS	Individual	5% OR GREATER INDIRECT OWNERSHIP INTEREST	10	6/1/2021	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 V BRODY	Individual	5% OR GREATER INDIRECT OWNERSHIP INTEREST	24.64	6/1/2021	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.
SHERI L STEELE	Individual	5% OR GREATER INDIRECT OWNERSHIP INTEREST	8	6/1/2021	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.
VICTOR S SHEVLYAGIN	Individual	5% OR GREATER INDIRECT OWNERSHIP INTEREST	8.4	6/1/2021	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.
GREGG J CALVERT	Individual	CORPORATE OFFICER	50	6/1/2021	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.
JERRY W HARRIS	Individual	CORPORATE OFFICER	50	6/1/2021	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.
BARBARA J BROWN	Individual	OTHER	0	6/1/2021	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 A BROWN	Individual	OTHER	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.	6/1/2021	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.
GREGG J CALVERT	Individual	W-2 MANAGING EMPLOYEE	50	6/1/2021	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.
JERRY W HARRIS	Individual	W-2 MANAGING EMPLOYEE	50	6/1/2021	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

No change in ownership appears in the CMS files on record since 20 September 2022.

Inspections

Inspection cycle	Health inspection	Fire safety inspection	Health deficiencies	Fire safety deficiencies
1	16 May 2025	16 May 2025	10	4
2	20 June 2024	20 June 2024	10	2
3	28 April 2023	28 April 2023	9	3

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

Deficiencies cited

29 deficiencies on file, newest inspection first

Inspection date	Inspection type	Tag	Category	What was cited	Scope and severity	Complaint	Corrected	Correction date
16 May 2025	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	30 June 2025
16 May 2025	Health	F 0641	Resident Assessment and Care Planning Deficiencies	Ensure each resident receives an accurate assessment.	D	No	Deficient, Provider has date of correction	30 June 2025
16 May 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	30 June 2025
16 May 2025	Health	F 0755	Pharmacy Service Deficiencies	Provide pharmaceutical services to meet the needs of each resident and employ or obtain the services of a licensed pharmacist.	D	No	Deficient, Provider has date of correction	30 June 2025
16 May 2025	Health	F 0759	Pharmacy Service Deficiencies	Ensure medication error rates are not 5 percent or greater.	D	No	Deficient, Provider has date of correction	30 June 2025
16 May 2025	Health	F 0806	Nutrition and Dietary Deficiencies	Ensure each resident receives and the facility provides food that accommodates resident allergies, intolerances, and preferences, as well as appealing options.	D	No	Deficient, Provider has date of correction	30 June 2025
16 May 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.	D	No	Deficient, Provider has date of correction	30 June 2025
16 May 2025	Health	F 0880	Infection Control Deficiencies	Provide and implement an infection prevention and control program.	D	No	Deficient, Provider has date of correction	30 June 2025
16 May 2025	Health	F 0883	Infection Control Deficiencies	Develop and implement policies and procedures for flu and pneumonia vaccinations.	D	No	Deficient, Provider has date of correction	30 June 2025
16 May 2025	Health	F 0909	Environmental Deficiencies	Regularly inspect all bed frames, mattresses, and bed rails (if any) for safety; and all bed rails and mattresses must attach safely to the bed frame.	D	No	Deficient, Provider has date of correction	30 June 2025
20 June 2024	Health	F 0572	Resident Rights Deficiencies	Give residents a notice of rights, rules, services and charges.	C	No	Deficient, Provider has date of correction	4 August 2024
20 June 2024	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	4 August 2024
20 June 2024	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.	C	No	Deficient, Provider has date of correction	4 August 2024
20 June 2024	Health	F 0641	Resident Assessment and Care Planning Deficiencies	Ensure each resident receives an accurate assessment.	D	No	Deficient, Provider has date of correction	4 August 2024
20 June 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	4 August 2024
20 June 2024	Health	F 0700	Quality of Life and Care Deficiencies	Try different approaches before using a bed rail. If a bed rail is needed, the facility must (1) assess a resident for safety risk; (2) review these risks and benefits with the resident/representative; (3) get informed consent; and (4) Correctly install and maintain the bed rail.	D	No	Deficient, Provider has date of correction	4 August 2024
20 June 2024	Health	F 0803	Nutrition and Dietary Deficiencies	Ensure menus must meet the nutritional needs of residents, be prepared in advance, be followed, be updated, be reviewed by dietician, and meet the needs of the resident.	C	No	Deficient, Provider has date of correction	4 August 2024
20 June 2024	Health	F 0806	Nutrition and Dietary Deficiencies	Ensure each resident receives and the facility provides food that accommodates resident allergies, intolerances, and preferences, as well as appealing options.	D	No	Deficient, Provider has date of correction	4 August 2024
20 June 2024	Health	F 0925	Environmental Deficiencies	Make sure there is a pest control program to prevent/deal with mice, insects, or other pests.	C	No	Deficient, Provider has date of correction	4 August 2024
20 June 2024	Health	F 0947	Nursing and Physician Services Deficiencies	Ensure nurse aides have the skills they need to care for residents, and give nurse aides education in dementia care and abuse prevention.	D	No	Deficient, Provider has date of correction	4 August 2024
28 April 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	10 June 2023
28 April 2023	Health	F 0645	Resident Assessment and Care Planning Deficiencies	PASARR screening for Mental disorders or Intellectual Disabilities	D	No	Deficient, Provider has date of correction	10 June 2023
28 April 2023	Health	F 0658	Resident Assessment and Care Planning Deficiencies	Ensure services provided by the nursing facility meet professional standards of quality.	D	No	Deficient, Provider has date of correction	10 June 2023
28 April 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	10 June 2023
28 April 2023	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.	F	No	Deficient, Provider has date of correction	10 June 2023
28 April 2023	Health	F 0814	Nutrition and Dietary Deficiencies	Dispose of garbage and refuse properly.	F	No	Deficient, Provider has date of correction	10 June 2023
28 April 2023	Health	F 0883	Infection Control Deficiencies	Develop and implement policies and procedures for flu and pneumonia vaccinations.	D	No	Deficient, Provider has date of correction	10 June 2023
28 April 2023	Health	F 0887	Infection Control Deficiencies	Educate residents and staff on COVID-19 vaccination, offer the COVID-19 vaccine to eligible residents and staff after education, and properly document each resident and staff member's vaccination status.	D	No	Deficient, Provider has date of correction	10 June 2023
28 April 2023	Health	F 0947	Nursing and Physician Services Deficiencies	Ensure nurse aides have the skills they need to care for residents, and give nurse aides education in dementia care and abuse prevention.	D	No	Deficient, Provider has date of correction	10 June 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	For profit - Corporation
Legal Business Name	ASPIRE SENIOR LIVING MALDEN LLC
Date First Approved to Provide Medicare and Medicaid Services	1995-03-27
Provider Resides in Hospital	N
Continuing Care Retirement Community	N
Urban	N
County/Parish	Dunklin
Telephone Number	5732765115
Chain Name	ASPIRE SENIOR LIVING
Chain ID	51
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	58
Average Number of Residents per Day	40.8
Overall Rating	3
Health Inspection Rating	4
QM Rating	1
Long-Stay QM Rating	1
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

29 August 2025: A cost report was filed for fiscal year 2024, on form CMS-2540-10. SNF10FY2024.zip
27 August 2024: A cost report was filed for fiscal year 2023, on form CMS-2540-10. SNF10FY2023.zip
11 October 2023: A cost report was filed for fiscal year 2022, on form CMS-2540-10. SNF10FY2022.zip
23 September 2022: A cost report was filed for fiscal year 2021, on form CMS-2540-10. SNF10FY2021.zip
31 January 2022: A cost report was filed for fiscal year 2021, on form CMS-2540-10. SNF10FY2021.zip
18 June 2021: A cost report was filed for fiscal year 2020, on form CMS-2540-10. SNF10FY2020.zip
20 May 2020: A cost report was filed for fiscal year 2019, on form CMS-2540-10. SNF10FY2019.zip
17 July 2019: A cost report was filed for fiscal year 2018, on form CMS-2540-10. SNF10FY2018.zip
19 July 2018: A cost report was filed for fiscal year 2017, on form CMS-2540-10. SNF10FY2017.zip
31 May 2017: A cost report was filed for fiscal year 2016, on form CMS-2540-10. SNF10FY2016.zip
25 July 2016: A cost report was filed for fiscal year 2015, on form CMS-2540-10. SNF10FY2015.zip
22 June 2015: A cost report was filed for fiscal year 2014, on form CMS-2540-10. SNF10FY2014.zip
24 June 2014: A cost report was filed for fiscal year 2013, on form CMS-2540-10. SNF10FY2013.zip
23 July 2013: A cost report was filed for fiscal year 2012, on form CMS-2540-10. SNF10FY2012.zip
26 October 2012: A cost report was filed for fiscal year 2011, on form CMS-2540-10. SNF10FY2011.zip
26 July 2011: A cost report was filed for fiscal year 2010, on form CMS-2540-96. SNFFY2010.zip
27 May 2010: A cost report was filed for fiscal year 2009, on form CMS-2540-96. SNFFY2009.zip
1 June 2009: A cost report was filed for fiscal year 2008, on form CMS-2540-96. SNFFY2008.zip
11 June 2008: A cost report was filed for fiscal year 2007, on form CMS-2540-96. SNFFY2007.zip
17 December 2007: A cost report was filed for fiscal year 2006, on form CMS-2540-96. SNFFY2006.zip
13 December 2006: A cost report was filed for fiscal year 2005, on form CMS-2540-96. SNFFY2005.zip
26 January 2006: A cost report was filed for fiscal year 2004, on form CMS-2540-96. SNFFY2004.zip
17 November 2005: A cost report was filed for fiscal year 2002, on form CMS-2540-96. SNFFY2002.zip
15 November 2005: A cost report was filed for fiscal year 2003, on form CMS-2540-96. SNFFY2003.zip
16 June 2004: A cost report was filed for fiscal year 2001, on form CMS-2540-96. SNFFY2002.zip
9 February 2004: A cost report was filed for fiscal year 2001, on form CMS-2540-96. SNFFY2001.zip
28 July 2003: A cost report was filed for fiscal year 2000, on form CMS-2540-96. SNFFY2000.zip

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, ASPIRE SENIOR LIVING MALDEN — facility record report, CMS certification number 265609. https://velarionrecords.com/facility/265609/report.

Cost report figures: CMS Healthcare Cost Report Information System, form CMS-2540-10, publication year 2024, file SNF10FY2024.zip.
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 265609. 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	3,758	1,081.47	2,047.07	8,444.57	11,573.11
2017Q2	30 June 2017	91	3,656	1,020.79	2,118.55	8,566.66	11,706
2017Q3	30 September 2017	92	4,190	933.65	2,341.88	8,748.27	12,023.8
2017Q4	31 December 2017	92	3,900	973.63	2,559.72	7,967.05	11,500.4
2018Q1	31 March 2018	90	3,536	1,208	2,674.86	7,780.49	11,663.35
2018Q2	30 June 2018	91	3,469	1,036.72	2,328.58	8,288.96	11,654.26
2018Q3	30 September 2018	92	3,943	956.47	2,557.8	8,385.42	11,899.69
2018Q4	31 December 2018	92	4,117	1,008.85	2,369.79	8,526.64	11,905.28
2019Q1	31 March 2019	90	4,035	838.85	2,386.79	8,379.49	11,605.13
2019Q2	30 June 2019	91	3,770	1,009.72	2,885.9	8,642.9	12,538.52
2019Q3	30 September 2019	92	3,802	857.41	2,811.79	8,108.65	11,777.85
2019Q4	31 December 2019	92	3,822	964.43	2,487.64	8,644.74	12,096.81
2020Q1	31 March 2020	91	3,363	710.99	2,763	8,064.13	11,538.12
2020Q2	30 June 2020	91	3,054	874.42	2,428.05	7,464.9	10,767.37
2020Q3	30 September 2020	92	2,743	988.12	2,432.93	7,077.6	10,498.65
2020Q4	31 December 2020	92	2,469	904.11	2,450.63	6,783.84	10,138.58
2021Q1	31 March 2021	90	2,113	1,227.76	1,819.13	6,055.35	9,102.24
2021Q2	30 June 2021	91	2,253	1,193.69	1,690.2	6,687.31	9,571.2
2021Q3	30 September 2021	92	2,526	905.25	2,111.78	7,669.85	10,686.88
2022Q1	31 March 2022	90	2,788	1,619.49	1,782.96	7,518.1	10,920.55
2022Q2	30 June 2022	91	2,713	1,163.8	2,187.5	9,213.9	12,565.2
2022Q3	30 September 2022	92	2,719	1,380.2	2,562.3	8,418	12,360.5
2022Q4	31 December 2022	92	2,732	1,477.1	2,337.1	7,417.6	11,231.8
2023Q1	31 March 2023	90	2,769	1,563.8	2,317.9	7,548.5	11,430.2
2023Q2	30 June 2023	91	2,685	1,632.75	2,168.25	7,484.75	11,285.75
2023Q3	30 September 2023	92	2,579	1,185.2	2,759.3	7,104.4	11,048.9
2023Q4	31 December 2023	92	2,506	1,395.8	2,782	6,896.8	11,074.6
2024Q1	31 March 2024	91	2,457	1,893.5	3,016.6	6,685.7	11,595.8
2024Q2	30 June 2024	91	2,973	1,243.3	2,921.8	7,358.4	11,523.5
2024Q3	30 September 2024	92	3,404	1,354.2	2,918.7	8,258.3	12,531.2
2024Q4	31 December 2024	92	3,462	1,464.7	2,594	8,414.9	12,473.6
2025Q1	31 March 2025	90	3,458	961.8	2,439.8	8,082.2	11,483.8
2025Q2	30 June 2025	91	3,599	1,275.1	2,284.2	8,647.6	12,206.9
2025Q3	30 September 2025	92	3,522	1,236.2	2,400	8,582.4	12,218.6
2025Q4	31 December 2025	92	3,645	1,150.4	2,533	9,059.7	12,743.1
2026Q1	31 March 2026	90	3,671	1,480.4	2,065.2	9,009.1	12,554.7

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.287778	0.544723	2.247092	3.079593
2017Q2	0.27921	0.579472	2.343178	3.20186
2017Q3	0.222828	0.558921	2.087893	2.869642
2017Q4	0.249649	0.656338	2.042833	2.948821
2018Q1	0.341629	0.756465	2.200365	3.298459
2018Q2	0.298853	0.671254	2.389438	3.359545
2018Q3	0.242574	0.648694	2.12666	3.017928
2018Q4	0.245045	0.575611	2.071081	2.891737
2019Q1	0.207893	0.591522	2.076701	2.876116
2019Q2	0.26783	0.765491	2.292546	3.325867
2019Q3	0.225516	0.739555	2.132733	3.097804
2019Q4	0.252336	0.650874	2.261837	3.165047
2020Q1	0.211415	0.821588	2.397898	3.430901
2020Q2	0.28632	0.795039	2.444303	3.525661
2020Q3	0.360233	0.88696	2.580241	3.827433
2020Q4	0.366185	0.99256	2.747606	4.106351
2021Q1	0.581051	0.860923	2.86576	4.307733
2021Q2	0.529822	0.7502	2.96818	4.248202
2021Q3	0.358373	0.836017	3.036362	4.230752
2022Q1	0.580879	0.639512	2.696593	3.916984
2022Q2	0.428972	0.806303	3.396203	4.631478
2022Q3	0.507613	0.942369	3.095991	4.545973
2022Q4	0.540666	0.855454	2.715081	4.111201
2023Q1	0.564753	0.837089	2.726074	4.127916
2023Q2	0.608101	0.807542	2.787616	4.203259
2023Q3	0.459558	1.069911	2.754711	4.28418
2023Q4	0.556983	1.110136	2.752115	4.419234
2024Q1	0.770655	1.227757	2.721083	4.719495
2024Q2	0.418197	0.982778	2.475076	3.876051
2024Q3	0.397826	0.857432	2.426058	3.681316
2024Q4	0.423079	0.749278	2.430647	3.603004
2025Q1	0.278138	0.705552	2.337247	3.320937
2025Q2	0.354293	0.634676	2.402779	3.391748
2025Q3	0.350994	0.681431	2.436797	3.469222
2025Q4	0.31561	0.694925	2.485514	3.496049
2026Q1	0.403269	0.562572	2.454127	3.419967

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
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
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