Medicare Dialysis Facilities

The Medicare Dialysis Facilities data provides information on clinical and patient measures for Medicare-certified ESRD facilities, also known as dialysis…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.MEDICARE_DIALYSIS_FACILITIES on Snowflake and Databricks: eight annual reporting periods (2020–2026) aligned to a single schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.

Key facts

Snowflake	DWV.MEDICARE_DIALYSIS_FACILITIES
Databricks	cms_dwv.medicare_dialysis_facilities
Coverage	Jan 2020 – Dec 2026 (7 of 7 annual reporting periods)
Rows	89,635,229 (total across all reporting periods)
Cadence	Annual
Update pattern	Time-partitioned; each file adds one reporting year
CMS published	2026-01-27
Loaded	2026-01-27
Columns	26 data + 6 lineage
Identifiers	NPI · CCN
File versions	8
License	CMS public data (U.S. Government work)
Platforms	Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Feeds Dataset, start a free trial on Snowflake Marketplace.

Current: CMS last published this feed on 2026-01-27. Coverage is complete through the 2026 reporting year. Next CMS release expected ~Jan 2027.

Time-partitioned feed: each file version covers one reporting year, so history is additive. Query the full table for all years; filter on YEAR for a single period. Do not filter to the latest file only (that would return just the 2026 reporting year).

Sample queries

Snowflake

-- Each file version covers one reporting period; history is additive
SELECT *
FROM DWV.MEDICARE_DIALYSIS_FACILITIES
LIMIT 100;

Databricks

-- Each file version covers one reporting period; history is additive
SELECT *
FROM cms_dwv.medicare_dialysis_facilities
LIMIT 100;

About this feed

The Medicare Dialysis Facilities data provides information on clinical and patient measures for Medicare-certified ESRD facilities, also known as dialysis facilities. It contains data on patient characteristics, treatment patterns, hospitalization, mortality, and transplantation patterns in Medicare-certified dialysis facilities. The following four data files are available for download each year, where yyyy denotes the fiscal year. DFR_Data_FYyyyy.csv file includes all summaries (facility- and regional-level) reported in the Dialysis Facility Report (DFR). The file includes one record for each dialysis facility and is the file recommended for download (i.e., wide format). dfr_facility_socrata_fyyyyy.csv file includes only facility-level summaries reported in the DFR. The file includes one record per measure per year (i.e., long format) and contains more records than most spreadsheet programs can handle, which will result in an incomplete load of data. Use of a database or statistical software is required. dfr_us_state_socrata_fyyyyyy.csv file includes state- and national-level summaries reported in DFR. The file includes one record per measure per year (i.e., long format). dfr_network_socrata_fyyyyyy.csv file includes ESRD network-level summaries reported in the DFR. The file includes one record per measure per year (i.e., long format).

Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Hospitals & Facilities, Outpatient Facilities, End Stage Renal Disease Facilities, Chronic Conditions Theme: Medicare

Coverage timeline

2020–2026 🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

7 of 7 annual reporting periods present, no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2026-01-01 – 2026-12-31	2026-01-27	2026-01-27	✓
2025-01-01 – 2025-12-31	2025-09-10	2025-10-18
2025-01-01 – 2025-12-31	2025-06-24	2025-06-24
2024-01-01 – 2024-12-31	2024-02-29	2024-03-06
2023-01-01 – 2023-12-31	2023-03-06	2023-08-29
2022-01-01 – 2022-12-31	2022-02-10	2023-08-29
2021-01-01 – 2021-12-31	2021-07-20	2023-08-29
2020-01-01 – 2020-12-31	2021-01-04	2023-08-29

Data dictionary

📋 26 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Medicare Dialysis Facilities data dictionary.

Data columns

Column	Type
STATE	TEXT
CCN	NUMBER
PROVIDER_NAME	TEXT
CITY	TEXT
OWNERSHIP_TYPE	TEXT
ESRD_NETWORK	NUMBER
NPI	NUMBER
CHAIN	TEXT
MODALITY	TEXT
ALTERNATE_CCNS	TEXT
MEASURE	TEXT
MEASURE_SCORE	NUMBER
YEAR	TEXT
MEASURE_ID	TEXT
PROVFS	NUMBER
PROVNAME	TEXT
PROVCITY	TEXT
NETWORK	NUMBER
CHAIN_NAME	TEXT
CHAINNAM	TEXT
MODAL_F	TEXT
ALTERNATE_CCN_S_	TEXT
ALT_CCNS	TEXT
_LABEL_	TEXT
COL1	NUMBER
YEAR_S_COVERED_BY_THE_MEASURE	TEXT

Lineage columns (present on every feed table)

Column	Type	Description
ROW_ID	TEXT	Unique row ID for this table (PK)
FILE_ID	TEXT	Source file; joins to FEEDS_FILES.ID (FK)
FILE_FEED_ID	TEXT	Parent feed; joins to FEEDS.ID (FK)
FILE_NAME	TEXT	Source file name as published by CMS
ROWNUM	NUMBER	Row number within the source file
CREATED_AT	TIMESTAMP_NTZ	Timestamp when the record was loaded

Row-level lineage

Every row in this table traces to the exact CMS source file that produced it. The FILE_ID column joins to the FEEDS_FILES catalog table, and FILE_FEED_ID joins to the FEEDS master table:

Trace any row back to its source file and reporting period:

Snowflake

SELECT d.STATE, d.CCN, d.PROVIDER_NAME,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.MEDICARE_DIALYSIS_FACILITIES d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Databricks

SELECT d.state, d.ccn, d.provider_name,
       ff.temporal_start, ff.temporal_end, ff.cms_feed_modified
FROM cms_dwv.medicare_dialysis_facilities d
JOIN cms_dwv.feeds_files ff ON d.file_id = ff.id;

Source & provenance

Published by the Centers for Medicare & Medicaid Services (bureau 009:38).

• Official CMS documentation

• Fy26%20dfr Guide

Frequently asked questions

How often is Medicare Dialysis Facilities updated?

Annually. CMS last published this feed on 2026-01-27, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.

What years does Medicare Dialysis Facilities cover?

2020 through 2026: seven annual reporting periods with no gaps. Each reporting year arrives as its own file version, and all years remain queryable side by side.

How many records are in Medicare Dialysis Facilities?

89,635,229 rows across all eight reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count; no deduplication needed.

How do I get Medicare Dialysis Facilities data?

It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.MEDICARE_DIALYSIS_FACILITIES directly; no pipeline setup required.

Related feeds

Comprehensive End-Stage Renal Disease Care Model DataEnd-Stage Renal Disease Facility Aggregation Group PerformanceManaging Clinician Aggregation Group PerformanceProvider of Services File - Clinical LaboratoriesAmbulatory Surgical Centers and Independent Free Standing Emergency Departments Enrolled in Medicare As Hospital Providers

Get this feed

1. Start a free trial on Snowflake Marketplace or purchase via Databricks

2. Mount the share; the database and DWV schema appear in your account immediately

3. Run the sample query above; no ETL, no pipeline maintenance

Questions about this feed? Contact us at [e-mail].

---

Part of the CMS Data Feeds Dataset; 280+ feeds · 245B+ records · updated daily. Back to the full catalog →