Facility record report · CMS certification number 165523

Estherville Community Care Center

Estherville, Iowa · 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 6 November 2025.

Revenue and expenses, fiscal year 2024
Figure	As filed	Where it comes from
Total patient revenue	$4,420,792	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$587,545	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$3,833,247	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$3,509,968	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	$323,279	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$4,868	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	$328,147	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: $328,147 (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	46	CMS-2540-10 worksheet S300001 line 800 column 100
Bed days available, all components	16,836	CMS-2540-10 worksheet S300001 line 800 column 200
Medicare (Title XVIII) patient days	1,756	CMS-2540-10 worksheet S300001 line 800 column 400
Medicaid (Title XIX) patient days	7,121	CMS-2540-10 worksheet S300001 line 800 column 500
Other-payer patient days	3,282	CMS-2540-10 worksheet S300001 line 800 column 600
Total patient days, all components	12,159	CMS-2540-10 worksheet S300001 line 800 column 700
Medicare discharges	33	CMS-2540-10 worksheet S300001 line 800 column 900
Medicaid discharges	44	CMS-2540-10 worksheet S300001 line 800 column 1000
Other-payer discharges	18	CMS-2540-10 worksheet S300001 line 800 column 1100
Total discharges, all components	95	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	53.21	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	161.84	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	127.99	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1442007, 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 20 May 2025.

Revenue and expenses, fiscal year 2023
Figure	As filed	Where it comes from
Total patient revenue	$3,603,175	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$661,213	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,941,962	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$3,336,370	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$394,408	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$65,848	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$328,560	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$328,560 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	10,391	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	43	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	41.92	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	1,003.43	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	241.65	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1421752, 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 26 April 2024.

Revenue and expenses, fiscal year 2022
Figure	As filed	Where it comes from
Total patient revenue	$3,767,796	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$838,028	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,929,768	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$3,407,302	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$477,534	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$3,640	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$473,894	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$473,894 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	11,204	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	67	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	70.84	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	388.82	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	167.22	CMS-2540-10 worksheet S300001 line 800 column 1600

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

Cost report for 14 May 2021 to 31 December 2021 — a reporting period of 231 days, not a full year, on form CMS-2540-10, settled, processed by CMS on 17 October 2022.

Revenue and expenses, fiscal year 2021
Figure	As filed	Where it comes from
Total patient revenue	$2,419,092	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$444,329	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$1,974,763	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$1,866,032	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	$108,731	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$84,169	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	$192,900	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: $192,900 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	7,428	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	42	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	104.92	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	433.7	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	176.86	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1335351, 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 21 April 2022.

Revenue and expenses, fiscal year 2020
Figure	As filed	Where it comes from
Total patient revenue	$3,387,197	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$328,383	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$3,058,814	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,819,173	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	$239,641	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$488,800	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	$728,441	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: $728,441 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	10,344	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	71	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	63.88	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	311.71	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	145.69	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1313584, 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 13 August 2021.

Revenue and expenses, fiscal year 2019
Figure	As filed	Where it comes from
Total patient revenue	$3,247,824	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$423,386	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,824,438	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$3,021,128	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$196,690	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$2,451	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$194,239	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$274,536 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	10,432	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	68	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	63.82	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	204.88	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	153.41	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1293570, 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 21 August 2019.

Revenue and expenses, fiscal year 2018
Figure	As filed	Where it comes from
Total patient revenue	$3,138,056	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$416,775	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,721,281	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,689,872	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	$31,409	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$7,522	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	$38,931	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$21,268 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	10,580	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	88.79	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	212.65	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	185.61	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1241555, 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 25 July 2018.

Revenue and expenses, fiscal year 2017
Figure	As filed	Where it comes from
Total patient revenue	$2,226,168	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$304,862	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$1,921,306	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,172,702	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$251,396	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$2,749	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$248,647	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$302,436 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	9,264	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	30	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	55.17	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	1,273.75	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	308.8	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1202647, 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 17 July 2017.

Revenue and expenses, fiscal year 2016
Figure	As filed	Where it comes from
Total patient revenue	$1,783,638	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$88,769	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$1,694,869	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$1,837,744	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$142,875	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$4,304	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$138,571	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$1,530,041 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	9,933	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	30	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	39.31	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	6,146	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	331.1	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1168921, 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 4 August 2016.

Revenue and expenses, fiscal year 2015
Figure	As filed	Where it comes from
Total patient revenue	$1,981,865	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$93,179	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$1,888,686	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$1,916,390	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$27,704	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$55,369	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	$27,665	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$24,551 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	11,124	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	33.93	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	542.54	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	252.82	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1139794, 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 25 July 2015.

Revenue and expenses, fiscal year 2014
Figure	As filed	Where it comes from
Total patient revenue	$2,103,520	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$89,717	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,013,803	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,028,436	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	−$14,633	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$5,977	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	−$8,656	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: −$8,656 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	11,835	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	46	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	121.63	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	299	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	257.28	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1104590, 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 7 August 2014.

Revenue and expenses, fiscal year 2013
Figure	As filed	Where it comes from
Total patient revenue	$2,246,731	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$89,208	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,157,523	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,097,418	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	$60,105	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$188,568	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	$248,673	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: $248,673 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	13,456	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	58	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	45.86	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	448.83	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	232	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1075257, 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,332,566	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$98,612	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,233,954	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,101,101	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	$132,853	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$30,866	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	$163,719	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: $163,719 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	14,523	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	46	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	42.33	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	834.09	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	315.72	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1042110, 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 27 September 2012.

Revenue and expenses, fiscal year 2011
Figure	As filed	Where it comes from
Total patient revenue	$2,303,531	CMS-2540-10 worksheet G300000 line 100 column 100
Contractual allowances and discounts	$31,641	CMS-2540-10 worksheet G300000 line 200 column 100
Net patient revenue	$2,271,890	CMS-2540-10 worksheet G300000 line 300 column 100
Total operating expenses	$2,200,790	CMS-2540-10 worksheet G300000 line 400 column 100
Net income from service to patients	$71,100	CMS-2540-10 worksheet G300000 line 500 column 100
Total other income	$29,945	CMS-2540-10 worksheet G300000 line 2500 column 100
Net income after other income	$101,045	CMS-2540-10 worksheet G300000 line 2600 column 100

Net income: $101,045 (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	60	CMS-2540-10 worksheet S300001 line 800 column 100
Total patient days, all components	15,186	CMS-2540-10 worksheet S300001 line 800 column 700
Total discharges, all components	58	CMS-2540-10 worksheet S300001 line 800 column 1200
Average length of stay, Medicare, in days	42.69	CMS-2540-10 worksheet S300001 line 800 column 1400
Average length of stay, Medicaid, in days	444.6	CMS-2540-10 worksheet S300001 line 800 column 1500
Average length of stay, all patients, in days	261.83	CMS-2540-10 worksheet S300001 line 800 column 1600

CMS report record 1012740, 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 8 August 2011.

Revenue and expenses, fiscal year 2010
Figure	As filed	Where it comes from
Net patient revenue	$2,292,727	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$2,204,550	CMS-2540-96 worksheet G200002 line 1500 column 200
Net income from service to patients	$88,177	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$91,695	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: $179,872 (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	60	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	16,044	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	34	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	64	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	1,094	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	471.88	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 414857, 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 July 2010.

Revenue and expenses, fiscal year 2009
Figure	As filed	Where it comes from
Net patient revenue	$2,319,250	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$2,195,417	CMS-2540-96 worksheet G200002 line 1500 column 200
Net income from service to patients	$123,833	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$12,916	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: $136,749 (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	60	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	16,836	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	58	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	42.41	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	630.63	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	290.28	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 383980, 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 14 July 2009.

Revenue and expenses, fiscal year 2008
Figure	As filed	Where it comes from
Net patient revenue	$2,032,225	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$2,028,434	CMS-2540-96 worksheet G200002 line 1500 column 200
Net income from service to patients	$3,791	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$9,031	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: $12,822 (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	60	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	15,257	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	40	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	30.52	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	825.56	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	381.43	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 350384, 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 12 August 2008.

Revenue and expenses, fiscal year 2007
Figure	As filed	Where it comes from
Net patient revenue	$2,124,811	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$2,065,843	CMS-2540-96 worksheet G200002 line 1500 column 200
Net income from service to patients	$58,968	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$7,573	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: $66,541 (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	60	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	16,220	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	41	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	32.15	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	864.25	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	395.61	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 323660, 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 15 February 2008.

Revenue and expenses, fiscal year 2006
Figure	As filed	Where it comes from
Net patient revenue	$2,061,250	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$2,003,689	CMS-2540-96 worksheet G200002 line 1500 column 100
Net income from service to patients	$57,561	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$7,647	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: $65,208 (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	60	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	16,532	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	41	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	32.68	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	534.5	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	403.22	CMS-2540-96 worksheet S300001 line 900 column 1600

CMS report record 302308, 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 14 June 2007.

Revenue and expenses, fiscal year 2005
Figure	As filed	Where it comes from
Net patient revenue	$1,979,749	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$2,051,192	CMS-2540-96 worksheet G200002 line 1500 column 100
Net income from service to patients	−$71,443	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$8,130	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: −$63,313 (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	60	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	17,802	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	44	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	18.03	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	1,192.43	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	404.59	CMS-2540-96 worksheet S300001 line 900 column 1600

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

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

Revenue and expenses, fiscal year 2004
Figure	As filed	Where it comes from
Net patient revenue	$486,373	CMS-2540-96 worksheet G300000 line 300 column 100
Total operating expenses	$529,859	CMS-2540-96 worksheet G200002 line 1500 column 200
Net income from service to patients	−$43,486	CMS-2540-96 worksheet G300000 line 500 column 100
Total other income	$3,806	CMS-2540-96 worksheet G300000 line 2600 column 100

Net income, stated at moderate confidence: −$39,680 (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	60	CMS-2540-96 worksheet S300001 line 900 column 100
Total patient days, all components	4,198	CMS-2540-96 worksheet S300001 line 900 column 700
Total discharges, all components	30	CMS-2540-96 worksheet S300001 line 900 column 1200
Average length of stay, Medicare, in days	19.29	CMS-2540-96 worksheet S300001 line 900 column 1400
Average length of stay, Medicaid, in days	1,049	CMS-2540-96 worksheet S300001 line 900 column 1500
Average length of stay, all patients, in days	139.93	CMS-2540-96 worksheet S300001 line 900 column 1600

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

Five facilities of a similar size in Iowa, 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
ACCURA HEALTHCARE OF LAKE CITY LLC	46	14,483	$4,502,734	$4,152,316	$350,418	31 December 2024
ASPIRE OF ESTHERVILLE	46	12,159	$3,833,247	$3,509,968	$323,279	31 December 2024
BLOOMFIELD CARE CENTER	48	5,044	$1,571,129	$1,811,229	−$240,100	31 December 2024
FELLOWSHIP VILLAGE	48	14,995	$4,249,880	$4,431,335	−$181,455	31 December 2024
GOOD SAMARITAN SOCIETY-VILLISCA	46	14,248	$4,621,031	$4,008,253	$612,778	31 December 2024
PREMIER ESTATES 508 LLC	46	10,765	$3,196,565	$3,817,448	−$620,883	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
ESTHERVILLE PROPCO, LLC	ADP OF THE SNF	Organization	NOT APPLICABLE	since 11/01/2025
GENSTAR HEALTHCARE MGMT	ADP OF THE SNF	Organization	NOT APPLICABLE	since 11/24/2025
GOLDBERGER, SHELDON	ADP OF THE SNF	Individual	NOT APPLICABLE	since 11/01/2025
GS ESTHERVILLE HOLDINGS LLC	ADP OF THE SNF	Organization	NOT APPLICABLE	since 11/01/2025
KABRICK, JENNIFER	ADP OF THE SNF	Individual	NOT APPLICABLE	since 11/01/2025
KUGLER, AARON	ADP OF THE SNF	Individual	NOT APPLICABLE	since 11/01/2025
PRABHAKARAN, MADHAN	ADP OF THE SNF	Individual	NOT APPLICABLE	since 11/01/2025
YAGER, SALLY	ADP OF THE SNF	Individual	NOT APPLICABLE	since 11/01/2025
GS ESTHERVILLE HOLDINGS LLC	DIRECT OWNERSHIP INTEREST	Organization	NOT APPLICABLE	since 11/01/2025
GOLDBERGER, SHELDON	INDIRECT OWNERSHIP INTEREST	Individual	NOT APPLICABLE	since 11/01/2025
KUGLER, AARON	INDIRECT OWNERSHIP INTEREST	Individual	NOT APPLICABLE	since 11/01/2025
GENSTAR HEALTHCARE MGMT	OPERATIONAL/MANAGERIAL CONTROL	Organization	NOT APPLICABLE	since 11/01/2025
GOLDBERGER, SHELDON	OPERATIONAL/MANAGERIAL CONTROL	Individual	NOT APPLICABLE	since 11/01/2025
GS ESTHERVILLE HOLDINGS LLC	OPERATIONAL/MANAGERIAL CONTROL	Organization	NOT APPLICABLE	since 11/01/2025
KABRICK, JENNIFER	OPERATIONAL/MANAGERIAL CONTROL	Individual	NOT APPLICABLE	since 11/01/2025
KUGLER, AARON	OPERATIONAL/MANAGERIAL CONTROL	Individual	NOT APPLICABLE	since 11/01/2025
PRABHAKARAN, MADHAN	OPERATIONAL/MANAGERIAL CONTROL	Individual	NOT APPLICABLE	since 11/01/2025
YAGER, SALLY	OPERATIONAL/MANAGERIAL CONTROL	Individual	NOT APPLICABLE	since 11/01/2025

Medicare enrollment

As filed in the CMS file dated 1 August 2026 (Medicare enrollment ownership), under the enrollment of ESTHERVILLE OPCO LLC (enrollment ID O20260223001817).

Owner	Individual or organization	Role	Ownership percentage	Association date	Described in the filing as
AARON KUGLER	Individual	ADP OF THE SNF	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.	11/1/2025	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.
ESTHERVILLE PROPCO, LLC	Organization	ADP OF THE SNF	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.	11/1/2025	Private equity company: No Real estate investment trust: No Holding company: No
GENSTAR HEALTHCARE MGMT	Organization	ADP OF THE SNF	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.	11/24/2025	Private equity company: No Real estate investment trust: No Holding company: No
GS ESTHERVILLE HOLDINGS LLC	Organization	ADP OF THE SNF	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.	11/1/2025	Private equity company: No Real estate investment trust: No Holding company: Yes
JENNIFER KABRICK	Individual	ADP OF THE SNF	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.	11/1/2025	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.
MADHAN PRABHAKARAN	Individual	ADP OF THE SNF	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.	11/1/2025	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.
SALLY YAGER	Individual	ADP OF THE SNF	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.	11/1/2025	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.
SHELDON GOLDBERGER	Individual	ADP OF THE SNF	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.	11/1/2025	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.
GS ESTHERVILLE HOLDINGS LLC	Organization	DIRECT OWNERSHIP INTEREST	100	11/1/2025	Private equity company: No Real estate investment trust: No Holding company: Yes
AARON KUGLER	Individual	INDIRECT OWNERSHIP INTEREST	50	11/1/2025	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.
SHELDON GOLDBERGER	Individual	INDIRECT OWNERSHIP INTEREST	50	11/1/2025	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.
AARON KUGLER	Individual	OPERATIONAL/MANAGERIAL CONTROL	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.	11/1/2025	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.
GENSTAR HEALTHCARE MGMT	Organization	OPERATIONAL/MANAGERIAL CONTROL	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.	11/1/2025	Private equity company: No Real estate investment trust: No Holding company: No
GS ESTHERVILLE HOLDINGS LLC	Organization	OPERATIONAL/MANAGERIAL CONTROL	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.	11/1/2025	Private equity company: No Real estate investment trust: No Holding company: Yes
JENNIFER KABRICK	Individual	OPERATIONAL/MANAGERIAL CONTROL	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.	11/1/2025	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.
MADHAN PRABHAKARAN	Individual	OPERATIONAL/MANAGERIAL CONTROL	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.	11/1/2025	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.
SALLY YAGER	Individual	OPERATIONAL/MANAGERIAL CONTROL	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.	11/1/2025	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.
SHELDON GOLDBERGER	Individual	OPERATIONAL/MANAGERIAL CONTROL	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.	11/1/2025	Private equity company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Real estate investment trust: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle. Holding company: CMS paused the expanded ownership disclosure on Form CMS-855A in guidance dated December 11, 2025; this field has not been filed under the current cycle.

Changes in ownership

1 July 2026: BEACON HEALTH MANAGEMENT LLC no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: BLACK HAWK HEALTHCARE, LLC no longer appears as 5% OR GREATER DIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: KASSIDY SPURGIN no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: BRUCE E WERTHEIM no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: BRUCE E WERTHEIM no longer appears as 5% OR GREATER INDIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: AARON KUGLER appears as INDIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: AARON KUGLER appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: AARON KUGLER appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: GS ESTHERVILLE HOLDINGS LLC appears as DIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: GS ESTHERVILLE HOLDINGS LLC appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: GS ESTHERVILLE HOLDINGS LLC appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: ESTHERVILLE PROPCO, LLC appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SHELDON GOLDBERGER appears as INDIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SHELDON GOLDBERGER appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SHELDON GOLDBERGER appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: JENNIFER KABRICK appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: JENNIFER KABRICK appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: MADHAN PRABHAKARAN appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: MADHAN PRABHAKARAN appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SALLY YAGER appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SALLY YAGER appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: GENSTAR HEALTHCARE MGMT appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: GENSTAR HEALTHCARE MGMT appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv

Inspections

Inspection cycle	Health inspection	Fire safety inspection	Health deficiencies	Fire safety deficiencies
1	25 September 2025	25 September 2025	8	11
2	12 December 2024	12 December 2024	6	12
3	5 October 2023	5 October 2023	9	4

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

Deficiencies cited

23 deficiencies on file, newest inspection first

Inspection date	Inspection type	Tag	Category	What was cited	Scope and severity	Complaint	Corrected	Correction date
10 June 2026	Health	F 0689	Quality of Life and Care Deficiencies	Ensure that a nursing home area is free from accident hazards and provides adequate supervision to prevent accidents.	G	Yes	Deficient, Provider has date of correction	30 June 2026
19 March 2026	Health	F 0558	Resident Rights Deficiencies	Reasonably accommodate the needs and preferences of each resident.	D	Yes	Deficient, Provider has date of correction	1 April 2026
19 March 2026	Health	F 0628	Resident Rights Deficiencies	Provide the required documentation or notification related to the resident's needs, appeal rights, or bed-hold policies.	D	Yes	Deficient, Provider has date of correction	1 April 2026
25 September 2025	Health	F 0600	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Protect each resident from all types of abuse such as physical, mental, sexual abuse, physical punishment, and neglect by anybody.	D	No	Past Non-Compliance	18 August 2025
25 September 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	1 October 2025
25 September 2025	Health	F 0644	Resident Assessment and Care Planning Deficiencies	Coordinate assessments with the pre-admission screening and resident review program; and referring for services as needed.	D	No	Deficient, Provider has date of correction	1 October 2025
25 September 2025	Health	F 0699	Quality of Life and Care Deficiencies	Provide care or services that was trauma informed and/or culturally competent.	D	No	Deficient, Provider has date of correction	16 October 2025
25 September 2025	Health	F 0883	Infection Control Deficiencies	Develop and implement policies and procedures for flu and pneumonia vaccinations.	D	Yes	Deficient, Provider has date of correction	16 October 2025
12 December 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.	D	No	Deficient, Provider has date of correction	24 December 2024
12 December 2024	Health	F 0636	Resident Assessment and Care Planning Deficiencies	Assess the resident completely in a timely manner when first admitted, and then periodically, at least every 12 months.	E	No	Deficient, Provider has date of correction	24 December 2024
12 December 2024	Health	F 0851	Administration Deficiencies	Electronically submit to CMS complete and accurate direct care staffing information, based on payroll and other verifiable and auditable data.	F	No	Deficient, Provider has date of correction	24 December 2024
12 December 2024	Health	F 0880	Infection Control Deficiencies	Provide and implement an infection prevention and control program.	D	No	Deficient, Provider has date of correction	24 December 2024
17 October 2024	Health	F 0567	Resident Rights Deficiencies	Honor the resident's right to manage his or her financial affairs.	D	Yes	Deficient, Provider has date of correction	5 November 2024
6 September 2024	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.	G	Yes	Deficient, Provider has date of correction	18 September 2024
5 October 2023	Health	F 0582	Resident Rights Deficiencies	Give residents notice of Medicaid/Medicare coverage and potential liability for services not covered.	D	No	Deficient, Provider has date of correction	7 December 2023
5 October 2023	Health	F 0607	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Develop and implement policies and procedures to prevent abuse, neglect, and theft.	E	No	Deficient, Provider has date of correction	7 December 2023
5 October 2023	Health	F 0641	Resident Assessment and Care Planning Deficiencies	Ensure each resident receives an accurate assessment.	D	No	Deficient, Provider has date of correction	7 December 2023
5 October 2023	Health	F 0644	Resident Assessment and Care Planning Deficiencies	Coordinate assessments with the pre-admission screening and resident review program; and referring for services as needed.	D	No	Deficient, Provider has date of correction	7 December 2023
5 October 2023	Health	F 0655	Resident Assessment and Care Planning Deficiencies	Create and put into place a plan for meeting the resident's most immediate needs within 48 hours of being admitted	D	No	Deficient, Provider has date of correction	7 December 2023
5 October 2023	Health	F 0726	Nursing and Physician Services Deficiencies	Ensure that nurses and nurse aides have the appropriate competencies to care for every resident in a way that maximizes each resident's well being.	E	No	Deficient, Provider has date of correction	7 December 2023
5 October 2023	Health	F 0868	Administration Deficiencies	Have the Quality Assessment and Assurance group have the required members and meet at least quarterly	E	No	Deficient, Provider has date of correction	7 December 2023
5 October 2023	Health	F 0943	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Give their staff education on dementia care, and what abuse, neglect, and exploitation are; and how to report abuse, neglect, and exploitation.	E	No	Deficient, Provider has date of correction	7 December 2023
31 August 2023	Health	F 0610	Freedom from Abuse, Neglect, and Exploitation Deficiencies	Respond appropriately to all alleged violations.	D	Yes	Deficient, Provider has date of correction	16 September 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	ESTHERVILLE OPCO LLC
Date First Approved to Provide Medicare and Medicaid Services	2004-02-01
Provider Resides in Hospital	N
Continuing Care Retirement Community	N
Urban	N
County/Parish	Emmet
Telephone Number	7123623594
Provider Changed Ownership in Last 12 Months	Y
With a Resident and Family Council	Both
Automatic Sprinkler Systems in All Required Areas	Yes
Number of Certified Beds	46
Average Number of Residents per Day	39.4
Overall Rating	2
Health Inspection Rating	2
QM Rating	2
Long-Stay QM Rating	2
Short-Stay QM Rating	2
Processing Date	2026-08-01

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

Every change on this record

1 July 2026: BEACON HEALTH MANAGEMENT LLC no longer appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: BLACK HAWK HEALTHCARE, LLC no longer appears as 5% OR GREATER DIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: KASSIDY SPURGIN no longer appears as W-2 MANAGING EMPLOYEE in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: BRUCE E WERTHEIM no longer appears as CORPORATE OFFICER in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: BRUCE E WERTHEIM no longer appears as 5% OR GREATER INDIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: AARON KUGLER appears as INDIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: AARON KUGLER appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: AARON KUGLER appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: GS ESTHERVILLE HOLDINGS LLC appears as DIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: GS ESTHERVILLE HOLDINGS LLC appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: GS ESTHERVILLE HOLDINGS LLC appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: ESTHERVILLE PROPCO, LLC appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SHELDON GOLDBERGER appears as INDIRECT OWNERSHIP INTEREST in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SHELDON GOLDBERGER appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SHELDON GOLDBERGER appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: JENNIFER KABRICK appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: JENNIFER KABRICK appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: MADHAN PRABHAKARAN appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: MADHAN PRABHAKARAN appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SALLY YAGER appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: SALLY YAGER appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: GENSTAR HEALTHCARE MGMT appears as ADP OF THE SNF in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: GENSTAR HEALTHCARE MGMT appears as OPERATIONAL/MANAGERIAL CONTROL in the Medicare enrollment ownership file. Skilled_Nursing_Facility_All_Owners_:_2026-07-01.csv
1 July 2026: enrollment_id changed from O20210715001833 to O20260223001817. Skilled_Nursing_Facility_Enrollments_:_2026-07-01.csv
6 November 2025: A cost report was filed for fiscal year 2024, on form CMS-2540-10. SNF10FY2024.zip
20 May 2025: A cost report was filed for fiscal year 2023, on form CMS-2540-10. SNF10FY2023.zip
26 April 2024: A cost report was filed for fiscal year 2022, on form CMS-2540-10. SNF10FY2022.zip
17 October 2022: A cost report was filed for fiscal year 2021, on form CMS-2540-10. SNF10FY2021.zip
21 April 2022: A cost report was filed for fiscal year 2021, on form CMS-2540-10. SNF10FY2021.zip
21 April 2022: A cost report was filed for fiscal year 2020, on form CMS-2540-10. SNF10FY2020.zip
13 August 2021: A cost report was filed for fiscal year 2019, on form CMS-2540-10. SNF10FY2019.zip
21 August 2019: A cost report was filed for fiscal year 2018, on form CMS-2540-10. SNF10FY2018.zip
25 July 2018: A cost report was filed for fiscal year 2017, on form CMS-2540-10. SNF10FY2017.zip
17 July 2017: A cost report was filed for fiscal year 2016, on form CMS-2540-10. SNF10FY2016.zip
4 August 2016: A cost report was filed for fiscal year 2015, on form CMS-2540-10. SNF10FY2015.zip
25 July 2015: A cost report was filed for fiscal year 2014, on form CMS-2540-10. SNF10FY2014.zip
7 August 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
27 September 2012: A cost report was filed for fiscal year 2011, on form CMS-2540-10. SNF10FY2011.zip
8 August 2011: A cost report was filed for fiscal year 2010, on form CMS-2540-96. SNFFY2010.zip
27 July 2010: A cost report was filed for fiscal year 2009, on form CMS-2540-96. SNFFY2009.zip
14 July 2009: A cost report was filed for fiscal year 2008, on form CMS-2540-96. SNFFY2008.zip
12 August 2008: A cost report was filed for fiscal year 2007, on form CMS-2540-96. SNFFY2007.zip
15 February 2008: A cost report was filed for fiscal year 2006, on form CMS-2540-96. SNFFY2006.zip
14 June 2007: A cost report was filed for fiscal year 2005, on form CMS-2540-96. SNFFY2005.zip
11 April 2006: A cost report was filed for fiscal year 2004, on form CMS-2540-96. SNFFY2005.zip
31 January 2006: A cost report was filed for fiscal year 2004, on form CMS-2540-96. SNFFY2004.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, Estherville Community Care Center — facility record report, CMS certification number 165523. https://velarionrecords.com/facility/165523/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 165523. 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	2,076	2,041.15	2,605.25	6,668.75	11,315.15
2017Q2	30 June 2017	91	1,945	989.75	2,383.67	5,172.91	8,546.33
2017Q3	30 September 2017	92	2,345	1,213	2,628.25	5,845.67	9,686.92
2017Q4	31 December 2017	92	2,930	2,332.75	1,733	6,138.5	10,204.25
2018Q1	31 March 2018	90	2,592	2,537.5	1,304	5,508.08	9,349.58
2018Q2	30 June 2018	91	2,776	2,220.75	1,219.25	5,872	9,312
2018Q3	30 September 2018	92	2,594	2,319.75	1,362.75	5,967.75	9,650.25
2019Q1	31 March 2019	90	2,674	2,580	1,192	6,020.75	9,792.75
2019Q2	30 June 2019	91	2,671	2,502.25	1,060.75	5,804.08	9,367.08
2019Q3	30 September 2019	92	2,660	2,469	1,121.5	6,250.42	9,840.92
2019Q4	31 December 2019	92	2,472	2,655.75	1,107.25	5,938.77	9,701.77
2020Q1	31 March 2020	91	2,795	1,950.75	1,883	5,172.52	9,006.27
2020Q2	30 June 2020	91	2,787	1,659.01	1,885.5	6,176.17	9,720.68
2020Q3	30 September 2020	92	2,426	1,847	1,496.25	5,802.37	9,145.62
2020Q4	31 December 2020	92	2,332	1,368.02	2,143.75	5,956.66	9,468.43
2021Q1	31 March 2021	90	2,319	857.25	2,070.25	5,803.15	8,730.65
2021Q2	30 June 2021	91	2,472	1,180.18	1,765.94	4,900.67	7,846.79
2021Q3	30 September 2021	92	2,833	1,946.75	1,014.75	6,244.75	9,206.25
2021Q4	31 December 2021	92	3,418	1,154.5	1,754.75	6,371.25	9,280.5
2022Q1	31 March 2022	90	2,948	1,197.5	1,755.25	6,859.25	9,812
2022Q2	30 June 2022	91	3,067	346.5	594.25	2,140.98	3,081.73
2022Q3	30 September 2022	92	2,656	1,866.5	1,102.25	6,575.75	9,544.5
2022Q4	31 December 2022	92	2,626	2,426.5	718.25	5,619.12	8,763.87
2023Q1	31 March 2023	90	2,726	1,194.5	684.25	5,531	7,409.75
2023Q2	30 June 2023	91	2,510	2,232.5	318.75	4,928.25	7,479.5
2023Q3	30 September 2023	92	2,613	2,000.75	912.75	5,122.75	8,036.25
2023Q4	31 December 2023	92	2,706	1,358	1,807.5	5,011.75	8,177.25
2024Q1	31 March 2024	91	3,321	1,415.5	1,981.75	5,303	8,700.25
2024Q2	30 June 2024	91	2,681	1,510	1,787.25	5,299.5	8,596.75
2024Q3	30 September 2024	92	2,825	1,507.5	1,687	5,245.5	8,440
2024Q4	31 December 2024	92	3,317	1,899	1,923.75	6,880.75	10,703.5
2025Q1	31 March 2025	90	3,405	2,559.5	2,588	6,816.5	11,964
2025Q2	30 June 2025	91	3,175	2,566.25	2,597.5	6,494.75	11,658.5
2025Q3	30 September 2025	92	3,243	2,324.75	2,725	6,701.25	11,751
2025Q4	31 December 2025	92	3,486	2,196.91	1,512.16	4,245.23	7,954.3
2026Q1	31 March 2026	90	3,542	3,210.73	2,091.85	6,653.92	11,956.5

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.983213	1.254937	3.212307	5.450458
2017Q2	0.508869	1.225537	2.659594	4.394
2017Q3	0.517271	1.120789	2.492823	4.130883
2017Q4	0.79616	0.591468	2.095051	3.482679
2018Q1	0.978974	0.503086	2.125031	3.607091
2018Q2	0.799982	0.439211	2.115274	3.354467
2018Q3	0.894275	0.525347	2.300598	3.72022
2019Q1	0.964847	0.445774	2.251589	3.66221
2019Q2	0.936821	0.397136	2.172999	3.506956
2019Q3	0.928195	0.421617	2.349782	3.699594
2019Q4	1.074333	0.447917	2.402415	3.924664
2020Q1	0.697943	0.673703	1.850633	3.222279
2020Q2	0.595267	0.676534	2.216064	3.487865
2020Q3	0.761336	0.616756	2.391744	3.769835
2020Q4	0.58663	0.919275	2.554314	4.060219
2021Q1	0.369664	0.892734	2.502436	3.764834
2021Q2	0.477419	0.714377	1.982472	3.174268
2021Q3	0.687169	0.358189	2.204289	3.249647
2021Q4	0.337771	0.513385	1.864029	2.715184
2022Q1	0.406208	0.595404	2.326747	3.328358
2022Q2	0.112977	0.193756	0.69807	1.004803
2022Q3	0.702748	0.415004	2.475809	3.593562
2022Q4	0.924029	0.273515	2.139802	3.337346
2023Q1	0.438188	0.251009	2.02898	2.718177
2023Q2	0.889442	0.126992	1.963446	2.97988
2023Q3	0.765691	0.349311	1.960486	3.075488
2023Q4	0.501848	0.66796	1.852088	3.021896
2024Q1	0.426227	0.596733	1.596808	2.619768
2024Q2	0.563223	0.666636	1.976688	3.206546
2024Q3	0.533628	0.597168	1.856814	2.987611
2024Q4	0.572505	0.579967	2.07439	3.226862
2025Q1	0.751689	0.760059	2.001909	3.513656
2025Q2	0.808268	0.81811	2.045591	3.671969
2025Q3	0.716852	0.840271	2.066374	3.623497
2025Q4	0.630209	0.433781	1.217794	2.281784
2026Q1	0.906474	0.590584	1.878577	3.375635

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
2019Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-03-13.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-03-13.csv
2019Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-06-30.csv
2019Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-09-30.csv
2019Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2019-12-31.csv
2020Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-03-31.csv
2020Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-06-30.csv
2020Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-09-30.csv
2020Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2020-12-31.csv
2021Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-03-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-03-31.csv
2021Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-06-30.csv
2021Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-09-30.csv
2021Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. The file's `incomplete` column flags 0 of this facility's days as 1; those days are included as filed. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2021-12-31.csv
2022Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-01-01.csv
2022Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-06-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-06-30.csv
2022Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-09-30.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-09-30.csv
2022Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2022-12-31.csv
2023Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-01-01.csv
2023Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-06-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-06-01.csv
2023Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-09-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-09-01.csv
2023Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-12-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2023-12-01.csv
2024Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-01-01.csv
2024Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-04-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-04-01.csv
2024Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-09-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-09-01.csv
2024Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-12-31.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2024-12-31.csv
2025Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-01-01.csv
2025Q2: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-04-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-04-01.csv
2025Q3: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-07-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-07-01.csv
2025Q4: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-10-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2025-10-01.csv
2026Q1: From CMS file Payroll_Based_Journal_Daily_Nurse_Staffing_:_2026-01-01.csv: days_reported = distinct WorkDate rows for this PROVNUM and CY_Qtr; resident_days = sum of MDScensus over those days; hours = each Hrs_* column summed over those days; rn_hours = Hrs_RNDON + Hrs_RNadmin + Hrs_RN; lpn_hours = Hrs_LPNadmin + Hrs_LPN; aide_hours = Hrs_CNA + Hrs_NAtrn + Hrs_MedAide; total_nurse_hours = rn_hours + lpn_hours + aide_hours; each *_hprd = its hours / resident_days, rounded to 6 decimal places, null when resident_days is 0. Payroll_Based_Journal_Daily_Nurse_Staffing_:_2026-01-01.csv

← the facility’s full record