DataStockroom
Healthcare

U.S. Nursing Home Financial Benchmarks

CMS nursing homes linked to ownership and skilled nursing financial reports, with state and ownership-group margin benchmarks.

Primary rows
14,690
Primary fields
33
Coverage
US
Source snapshot
Oct 3, 2026

Each primary row: One CMS-certified nursing home in the captured facility inventory.

Sample data

Download sample

100 sample rows as CSV · all 33 primary fields.

facilities.csvPreview: 25 rows · 33 fields
Row
1
345466
Willowbrook Rehabilitation and Care
333 EAST LEE AVENUE OPCO LLC
333 East Lee Street
Yadkinville
NC
27055
+13366798028
For profit - Partnership
76
70.9
—
Medicare and Medicaid
AVARDIS HEALTH
843
38
4
—
4
—
2
—
3
—
2026-08-01
36.1255
-80.655
—
2540-24:snf24_fy2025.zip:6554
2540-24
2025-12-31
—
false
2
465115
The Terrace Transitional
BEAVER VALLEY HOSPITAL
400 East 5350 South
Ogden
UT
84405
+18014799855
For profit - Corporation
120
92.8
—
Medicare and Medicaid
THE ENSIGN GROUP
507
342
3
—
2
—
4
—
5
—
2026-08-01
41.1667
-111.97
—
2540-24:snf24_fy2025.zip:3531
2540-24
2025-12-31
0.116915
true
3
445130
NHC HEALTHCARE, SPARTA
NHC HEALTHCARE-SPARTA LLC
34 GRACEY ST
SPARTA
TN
38583
+19318362211
For profit - Limited Liability company
96
92.3
—
Medicare and Medicaid
NATIONAL HEALTHCARE CORPORATION
364
69
3
—
3
—
4
—
4
—
2026-08-01
35.925
-85.46
—
2540-24:snf24_fy2025.zip:6606
2540-24
2025-12-31
0.141497
true
4
225455
CRANEVILLE REHABILITATION AND SKILLED CARE CENTER
GAHCR II DALTON SNF TRS SUB LLC
265 MAIN STREET
DALTON
MA
01226
+14136843212
For profit - Individual
89
63.9
—
Medicare and Medicaid
BANECARE MANAGEMENT
68
7
4
—
4
—
3
—
2
—
2026-08-01
42.4726
-73.177
—
2540-24:snf24_fy2025.zip:4663
2540-24
2025-12-31
-0.113201
true
5
055742
HARBOR VILLA CARE CENTER
CASA PACIFICA NURSING CENTER LLC
861 S. HARBOR BLVD
ANAHEIM
CA
92805
+17146358131
For profit - Limited Liability company
99
89.5
—
Medicare and Medicaid
CAMBRIDGE HEALTHCARE SERVICES
98
32
2
—
2
—
3
—
4
—
2026-08-01
33.8234
-117.92
—
2540-24:snf24_fy2025.zip:8059
2540-24
2025-12-31
0.021869
true
— Empty cell · does not mean zero or no[] / {} Empty collection0 / false Recorded values
Download sample documentation (ZIP)

Included data

  • 14,690 facilities link by six-character CCN to 55,857 financial reports, ownership relationships and chain summaries.
  • Financial records include FY2022–2023 public-use reports and later HCRIS reports using form-specific financial definitions.
  • 480 benchmark rows show state and ownership-group cohorts, eligible report counts and margin medians; groups with fewer than five observations have no median.

What’s in the package

  • facilities.csv14,690 rows · 33 fields
  • ownership.csv249,452 rows · 12 fields

    One reported ownership or management relationship; interests can overlap.

  • chains.csv610 rows · 6 fields

    One captured CMS chain ID summary.

  • financial_reports.csv55,857 rows · 35 fields

    One captured PUF or form-specific HCRIS report record, including all statuses and periods.

  • benchmarks.csv480 rows · 6 fields

    One inventory-state/ownership cohort, with explicit eligible margin denominator.

For facility ratings, staffing and inspection fields, see U.S. Nursing Homes. The facility inventory and some cost reports overlap. View the related package →

Companion table fields

ownership.csv12 fields
FieldDefinition & format

Ownership Record ID

ownership_record_id

Source ownership-file SHA-256 plus row ordinal; edition-specific

Type
identifier
Format
Text identifier; preserve leading zeros and letters
Blank cells
Missing or unavailable
Populated · full table
249,452 / 249,452 (100.00%)

CCN

ccn

CMS Certification Number (CCN)

Type
identifier
Format
Six-character alphanumeric CMS certification identifier; preserve leading zeros
Blank cells
Missing or unavailable
Populated · full table
249,452 / 249,452 (100.00%)

Provider Name

provider_name

Facility name published by CMS; may differ from its legal business or chain name.

Type
text
Format
UTF-8 text; source case retained
Blank cells
Missing or unavailable
Populated · full table
249,452 / 249,452 (100.00%)

Owner Role

owner_role

Published role of the named owner or manager in relation to the facility; different roles can produce multiple relationships.

Type
text
Format
UTF-8 text; source case retained
Blank cells
Missing or unavailable
Populated · full table
249,452 / 249,452 (100.00%)

Owner Type

owner_type

Published organization/individual ownership category; a placeholder may indicate unavailable ownership data.

Type
text
Format
UTF-8 text; source case retained
Blank cells
Missing or unavailable
Populated · full table
248,794 / 249,452 (99.74%)

Owner Name

owner_name

Published owner or manager name; not a unique person/company identifier.

Type
text
Format
UTF-8 text; source case retained
Blank cells
Missing or unavailable
Populated · full table
70,176 / 249,452 (28.13%)

Ownership Percentage

ownership_percentage

Numeric percentage points, where published; never sum direct/indirect interests

Type
decimal
Format
Base-10 decimal; no currency symbols
Unit
percentage points (0–100 scale)
Blank cells
Missing or unavailable
Populated · full table
16,344 / 249,452 (6.55%)

Ownership Percentage Missing Reason

ownership_percentage_missing_reason

source_blank, not_applicable, not_provided or invalid_source_value

Type
text
Format
UTF-8 text; source case retained
Blank cells
Numeric percentage is available
Populated · full table
233,108 / 249,452 (93.45%)

Association Date

association_date

ISO date parsed from the source since MM/DD/YYYY wording

Type
date
Format
YYYY-MM-DD
Blank cells
Missing or unavailable
Populated · full table
248,773 / 249,452 (99.73%)

Association Date Missing Reason

association_date_missing_reason

source_blank, not_provided or invalid_source_value

Type
text
Format
UTF-8 text; source case retained
Blank cells
Association date is available
Populated · full table
679 / 249,452 (0.27%)

Processing Date

processing_date

CMS processing date associated with this publication; not necessarily the observation date of every measure.

Type
date
Format
YYYY-MM-DD
Blank cells
Missing or unavailable
Populated · full table
249,452 / 249,452 (100.00%)

Individual name withheld

individual_name_withheld

Individual owner names are withheld; role, percentage and association date remain.

Type
boolean
Blank cells
Not reported, not applicable or unavailable
Populated · full table
249,452 / 249,452 (100.00%)
chains.csv6 fields
FieldDefinition & format

Chain ID

chain_id

CMS chain ID

Type
identifier
Format
Text identifier; preserve leading zeros and letters
Blank cells
Missing or unavailable
Populated · full table
610 / 610 (100.00%)

Chain Names

chain_names

Distinct published names for this ID, separated by semicolons

Type
text
Format
Semicolon-separated values; no implied ordering/ranking
Blank cells
Missing or unavailable
Populated · full table
610 / 610 (100.00%)

Facility Count

facility_count

Number of facilities in this captured Provider Information file

Type
integer
Format
Base-10 integer
Unit
count
Blank cells
Missing or unavailable
Populated · full table
610 / 610 (100.00%)

States

states

Distinct state/territory codes, separated by semicolons

Type
text
Format
Semicolon-separated values; no implied ordering/ranking
Blank cells
Missing or unavailable
Populated · full table
610 / 610 (100.00%)

Certified Beds Known Total

certified_beds_known_total

Sum of nonmissing certified beds; not a complete total if missing count is nonzero

Type
integer
Format
Base-10 integer
Unit
beds
Blank cells
Missing or unavailable
Populated · full table
610 / 610 (100.00%)

Facilities Missing Beds

facilities_missing_beds

Facilities without a usable certified-beds value

Type
integer
Format
Base-10 integer
Unit
beds
Blank cells
Missing or unavailable
Populated · full table
610 / 610 (100.00%)
financial_reports.csv35 fields
FieldDefinition & format

Report id

report_id

Source namespace, archive and report ID or PUF row; separate forms never collide.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,857 / 55,857 (100.00%)

Form

form

CMS cost report form 2540-10 or 2540-24.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,857 / 55,857 (100.00%)

Source archive

source_archive

Exact source file or ZIP filename.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,857 / 55,857 (100.00%)

Source row number

source_row_number

One-based row ordinal in the report header source.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,857 / 55,857 (100.00%)

Rpt rec num

rpt_rec_num

Published HCRIS record ID preserved as text.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,857 / 55,857 (100.00%)

CCN

ccn

Six-character CMS certification identifier, including leading zeros.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,857 / 55,857 (100.00%)

Period begin

period_begin

Reported period beginning date, normalized to ISO.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,851 / 55,857 (99.99%)

Period end

period_end

Reported period ending date, normalized to ISO.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,851 / 55,857 (99.99%)

Processed date

processed_date

Reported HCRIS processed date.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,838 / 55,857 (99.97%)

Receipt date

receipt_date

Reported HCRIS receipt date.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,838 / 55,857 (99.97%)

Report status code

report_status_code

Published HCRIS report status code.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,838 / 55,857 (99.97%)

Utilization code

utilization_code

Published HCRIS utilization code.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,838 / 55,857 (99.97%)

Balance sheet basis

balance_sheet_basis

PUF balance-sheet aggregates and raw Worksheet G column 1 differ; retain this basis before comparing assets/liabilities.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,857 / 55,857 (100.00%)

Net patient revenue

net_patient_revenue

PUF net_patient_revenue; HCRIS coordinate ('G300000', '00300', '00100'). Literal reported value, never imputed.

Type
decimal
Unit
USD
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,059 / 55,857 (98.57%)

Operating expenses

operating_expenses

PUF less_total_operating_expense; HCRIS coordinate ('G300000', '00400', '00100'). Literal reported value, never imputed.

Type
decimal
Unit
USD
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,094 / 55,857 (98.63%)

Net patient service income

net_patient_service_income

PUF net_income_from_service_to_patients; HCRIS coordinate ('G300000', '00500', '00100'). Literal reported value, never imputed.

Type
decimal
Unit
USD
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,095 / 55,857 (98.64%)

Net income

net_income

PUF net_income; HCRIS coordinate ('G300000', '03100 for 2540-10; 03200 for 2540-24', '00100'). Literal reported value, never imputed.

Type
decimal
Unit
USD
Blank cells
Not reported, not applicable or unavailable
Populated · full table
54,942 / 55,857 (98.36%)

Cash on hand

cash_on_hand

PUF cash_on_hand_and_in_banks; HCRIS coordinate ('G000000', '00100', '00100'). Literal reported value, never imputed. PUF balance-sheet aggregation and raw column 1 can have different scopes; see balance_sheet_basis.

Type
decimal
Unit
USD
Blank cells
Not reported, not applicable or unavailable
Populated · full table
53,540 / 55,857 (95.85%)

Total assets

total_assets

PUF total_assets; HCRIS coordinate ('G000000', '03400', '00100'). Literal reported value, never imputed. PUF balance-sheet aggregation and raw column 1 can have different scopes; see balance_sheet_basis.

Type
decimal
Unit
USD
Blank cells
Not reported, not applicable or unavailable
Populated · full table
54,863 / 55,857 (98.22%)

Total liabilities

total_liabilities

PUF total_liabilities; HCRIS coordinate ('G000000', '05000', '00100'). Literal reported value, never imputed. PUF balance-sheet aggregation and raw column 1 can have different scopes; see balance_sheet_basis.

Type
decimal
Unit
USD
Blank cells
Not reported, not applicable or unavailable
Populated · full table
49,616 / 55,857 (88.83%)

Snf beds

snf_beds

PUF snf_number_of_beds; HCRIS coordinate ('S300001', '00100', '00100'). Literal reported value, never imputed.

Type
decimal
Unit
beds
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,023 / 55,857 (98.51%)

Snf days

snf_days

PUF snf_days_total; HCRIS coordinate ('S300001', '00100', '00700'). Literal reported value, never imputed.

Type
decimal
Unit
days
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,095 / 55,857 (98.64%)

Snf medicare days

snf_medicare_days

Form 2540-10: PUF SNF Title XVIII days or Worksheet S-3 Part I line 1 column 4. Form 2540-24: sum of reported SNF FFS line 1 and HMO line 2, column 4; blank if either component is absent. See the components and day basis.

Type
decimal
Unit
days
Blank cells
Not reported, not applicable or unavailable
Populated · full table
52,357 / 55,857 (93.73%)

Snf medicaid days

snf_medicaid_days

Form 2540-10: PUF SNF Title XIX days or Worksheet S-3 Part I line 1 column 5. Form 2540-24: sum of reported SNF FFS line 1 and HMO line 2, column 5; blank if either component is absent. See the components and day basis.

Type
decimal
Unit
days
Blank cells
Not reported, not applicable or unavailable
Populated · full table
47,019 / 55,857 (84.18%)

Report period days

report_period_days

Inclusive length calculated from reported beginning and ending dates.

Type
integer
Unit
days
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,851 / 55,857 (99.99%)

Annual period

annual_period

True for an inclusive period of 360-370 days.

Type
boolean
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,857 / 55,857 (100.00%)

Annual margin eligible

annual_margin_eligible

Annual period, positive reported net patient revenue and nonblank patient-service income.

Type
boolean
Blank cells
Not reported, not applicable or unavailable
Populated · full table
55,857 / 55,857 (100.00%)

Annual patient service margin

annual_patient_service_margin

Reported patient-service income divided by positive net patient revenue, rounded to six decimals; annual eligible reports only.

Type
decimal
Unit
fraction
Blank cells
Not reported, not applicable or unavailable
Populated · full table
48,987 / 55,857 (87.70%)

Snf medicaid day share

snf_medicaid_day_share

Full SNF Medicaid days divided by positive reported SNF total days, rounded to six decimals. Form 2540-24 requires both FFS and HMO cells; no absent component is assumed zero.

Type
decimal
Unit
fraction
Blank cells
Not reported, not applicable or unavailable
Populated · full table
47,019 / 55,857 (84.18%)

Snf medicare ffs days

snf_medicare_ffs_days

Form 2540-24 Worksheet S-3 Part I line 1 column 4: reported SNF Medicare FFS inpatient days. Not separately extracted for Form 2540-10; a missing source cell stays blank.

Type
decimal
Unit
days
Blank cells
Not reported, not applicable or unavailable
Populated · full table
10,753 / 55,857 (19.25%)

Snf medicare hmo days

snf_medicare_hmo_days

Form 2540-24 Worksheet S-3 Part I line 2 column 4: reported SNF Medicare HMO inpatient days. Not separately extracted for Form 2540-10; a missing source cell stays blank.

Type
decimal
Unit
days
Blank cells
Not reported, not applicable or unavailable
Populated · full table
8,117 / 55,857 (14.53%)

SNF Medicare day basis

snf_medicare_day_basis

Derived extraction basis: form_2540_10_program_days for the older form; ffs_plus_hmo when both newer-form components are reported; incomplete_ffs_hmo_components otherwise. Incomplete components leave the combined Medicare total blank.

Type
text
Format
Derived code: form_2540_10_program_days, ffs_plus_hmo or incomplete_ffs_hmo_components
Blank cells
Always populated; identifies the form-specific extraction and component completeness.
Populated · full table
55,857 / 55,857 (100.00%)

Snf medicaid ffs days

snf_medicaid_ffs_days

Form 2540-24 Worksheet S-3 Part I line 1 column 5: reported SNF Medicaid FFS inpatient days. Not separately extracted for Form 2540-10; a missing source cell stays blank.

Type
decimal
Unit
days
Blank cells
Not reported, not applicable or unavailable
Populated · full table
9,880 / 55,857 (17.69%)

Snf medicaid hmo days

snf_medicaid_hmo_days

Form 2540-24 Worksheet S-3 Part I line 2 column 5: reported SNF Medicaid HMO inpatient days. Not separately extracted for Form 2540-10; a missing source cell stays blank.

Type
decimal
Unit
days
Blank cells
Not reported, not applicable or unavailable
Populated · full table
5,985 / 55,857 (10.71%)

SNF Medicaid day basis

snf_medicaid_day_basis

Derived extraction basis: form_2540_10_program_days for the older form; ffs_plus_hmo when both newer-form components are reported; incomplete_ffs_hmo_components otherwise. Incomplete components leave the combined Medicaid total and Medicaid share blank.

Type
text
Format
Derived code: form_2540_10_program_days, ffs_plus_hmo or incomplete_ffs_hmo_components
Blank cells
Always populated; identifies the form-specific extraction and component completeness.
Populated · full table
55,857 / 55,857 (100.00%)
benchmarks.csv6 fields
FieldDefinition & format

State

state

Facility inventory state.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
480 / 480 (100.00%)

Ownership type

ownership_type

Facility inventory ownership classification, not ownership at the financial reporting date.

Type
text
Blank cells
Not reported, not applicable or unavailable
Populated · full table
480 / 480 (100.00%)

Facility count

facility_count

Captured inventory facilities in this state/ownership cohort.

Type
integer
Blank cells
Not reported, not applicable or unavailable
Populated · full table
480 / 480 (100.00%)

Eligible margin count

eligible_margin_count

Facilities whose latest captured report meets annual margin eligibility.

Type
integer
Unit
fraction
Blank cells
Not reported, not applicable or unavailable
Populated · full table
480 / 480 (100.00%)

Median patient service margin

median_patient_service_margin

Median of rounded latest annual eligible margins, provided only with at least five observations. Reporting years can differ; this is a captured-cohort comparison.

Type
decimal
Unit
fraction
Blank cells
Not reported, not applicable or unavailable
Populated · full table
235 / 480 (48.96%)

Minimum benchmark count

minimum_benchmark_count

Minimum eligible observations required to publish a median.

Type
integer
Blank cells
Not reported, not applicable or unavailable
Populated · full table
480 / 480 (100.00%)

Field coverage

Download field coverage (CSV)

Data notes

Coverage counts use the full tables. They exclude blank cells and empty JSON collections; zero and false count as populated.

  • Coverage is CMS-certified nursing homes and skilled nursing facilities, not all assisted-living businesses.
  • Facility and ownership snapshots have different dates from the financial reports. Financials describe a facility or healthcare complex, not its consolidated corporate parent.
  • Benchmark medians combine the latest eligible reports from different reporting years. Short periods and missing inputs are excluded; extreme reported margins are retained.
  • Public-use balance-sheet aggregates and raw Worksheet G values can differ. Form-specific payer-day totals remain blank when required components are missing.
  • Individual owner names are withheld. Direct and indirect ownership interests overlap. CMS geocoding footnote 22 denotes ZIP-based coordinates.