End-Stage Renal Disease Facility Aggregation Group Performance

The End-Stage Renal Disease (ESRD) Facility Aggregation Group Performance dataset provides performance information in the End-Stage Renal Disease (ESRD)…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.ENDSTAGE_RENAL_DISEASE_FACILITY_AGGREGATION_GROUP_PERFORMANCE on Snowflake and Databricks: 13 snapshot releases spanning 2021–2024, 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.ENDSTAGE_RENAL_DISEASE_FACILITY_AGGREGATION_GROUP_PERFORMANCE
Databricks	cms_dwv.endstage_renal_disease_facility_aggregation_group_performance
Coverage	Jul 2021 – Dec 2024
Cadence	Semiannual
Update pattern	Full-refresh; each file replaces the prior snapshot
CMS published	2025-12-22
Loaded	2025-12-22
Columns	31 data + 6 lineage
File versions	13
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.

Final release: this feed covers a program that has ended; the dataset is complete. CMS last published it on 2025-12-22. ETC Model terminated effective 2025-12-31 per CY 2026 ESRD PPS Final Rule

Full-refresh feed: each file version is a complete snapshot and newer files supersede older ones. Filter to the latest file (see the sample query) to avoid double-counting across versions.

Sample queries

Snowflake

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM DWV.ENDSTAGE_RENAL_DISEASE_FACILITY_AGGREGATION_GROUP_PERFORMANCE
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM cms_dwv.endstage_renal_disease_facility_aggregation_group_performance
WHERE file_id IN (
  SELECT id FROM cms_dwv.feeds_files WHERE is_latest = 1
)
LIMIT 100;

About this feed

The End-Stage Renal Disease (ESRD) Facility Aggregation Group Performance dataset provides performance information in the End-Stage Renal Disease (ESRD) Treatment Choices (ETC) Model. The dataset includes information on Performance Payment Adjustment (PPA), Modality Performance Score (MPS), home dialysis rate, and transplant rate, as well as the individual components of each rate for each model participant ESRD facility aggregation group. All ESRD facilities within the same aggregation group share the same performance information. The supplementary aggregation group crosswalk file may be used to map aggregation groups to individual ETC Participant ESRD facilities.

Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Hospitals & Facilities, Outpatient Facilities, Clinics, End Stage Renal Disease Facilities, Value-Based Care, Coordinated Care, Service Delivery Models Theme: Medicare

Coverage timeline

2021 🟩 · 2022 🟩 · 2023 🟩 · 2024 🟩

4 of 4 years with snapshot releases, no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2025-12-22	2025-12-22	2025-12-22	✓
Snapshot as of 2025-07-01	2025-07-01	2025-10-18
Snapshot as of 2025-06-30	2025-06-30	2025-06-30
Snapshot as of 2025-06-09	2025-06-09	2025-06-17
Snapshot as of 2024-08-09	2024-08-09	2025-06-17
Snapshot as of 2024-02-20	2024-02-20	2025-06-17
Snapshot as of 2023-11-30	2023-11-30	2025-06-17
Snapshot as of 2023-11-30	2023-11-30	2025-06-17
Snapshot as of 2025-06-09	2025-06-09	2025-06-09
Snapshot as of 2024-08-09	2024-08-09	2024-08-09

Show 3 earlier file versions

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2024-02-20	2024-02-20	2024-02-20
Snapshot as of 2023-11-30	2023-11-30	2023-11-30
Snapshot as of 2023-11-30	2023-11-30	2023-11-30

Data dictionary

📋 31 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official End-Stage Renal Disease Facility Aggregation Group Performance data dictionary.

Data columns

Column	Type
AGG_ID	TEXT
HRR_NUM_MY	NUMBER
HDR_MY	NUMBER
HDR_DNM_MY	NUMBER
HDR_NUM_MY	NUMBER
HD_NUM_MY	NUMBER
SD_NUM_MY	NUMBER
NOCD_NUM_MY	NUMBER
TR_MY_ACHSCR	NUMBER
TR_MY_IMPSCR	NUMBER
TWR_DNM_MY	NUMBER
TWR_NUM_MY	NUMBER
LDT_DNM_MY	NUMBER
LDT_NUM_MY	NUMBER
BENECNT_LDT_MY	NUMBER
HEI_HDR	NUMBER
HDR_DELIS_DIFF	NUMBER
HDR_DELIS_MY	NUMBER
HDR_DNM_DELIS_MY	NUMBER
HDR_NUM_DELIS_MY	NUMBER
HEI_TR	NUMBER
TR_DELIS_DIFF	NUMBER
TR_DELIS_MY	NUMBER
TWR_DNM_DELIS_MY	NUMBER
TWR_NUM_DELIS_MY	NUMBER
LDT_DNM_DELIS_MY	NUMBER
LDT_NUM_DELIS_MY	NUMBER
MPS	NUMBER
PPA	NUMBER
PPA_PERIOD	NUMBER
MY	NUMBER

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.AGG_ID, d.HRR_NUM_MY, d.HDR_MY,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.ENDSTAGE_RENAL_DISEASE_FACILITY_AGGREGATION_GROUP_PERFORMANCE d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Databricks

SELECT d.agg_id, d.hrr_num_my, d.hdr_my,
       ff.temporal_start, ff.temporal_end, ff.cms_feed_modified
FROM cms_dwv.endstage_renal_disease_facility_aggregation_group_performance 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 data dictionary

• Esrd Treatment Choices Etc Model Methodology

Frequently asked questions

How often is End-Stage Renal Disease Facility Aggregation Group Performance updated?

Semiannually. CMS last published this feed on 2025-12-22, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.

What years does End-Stage Renal Disease Facility Aggregation Group Performance cover?

2021 through 2024.

How many records are in End-Stage Renal Disease Facility Aggregation Group Performance?

Count the current snapshot yourself once the share is mounted:

Snowflake

SELECT COUNT(*)
FROM DWV.ENDSTAGE_RENAL_DISEASE_FACILITY_AGGREGATION_GROUP_PERFORMANCE d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID
WHERE ff.IS_LATEST = 1;

Databricks

SELECT COUNT(*)
FROM cms_dwv.endstage_renal_disease_facility_aggregation_group_performance d
JOIN cms_dwv.feeds_files ff ON d.file_id = ff.id
WHERE ff.is_latest = 1;

How do I get End-Stage Renal Disease Facility Aggregation Group Performance 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.ENDSTAGE_RENAL_DISEASE_FACILITY_AGGREGATION_GROUP_PERFORMANCE directly; no pipeline setup required.

Related feeds

Managing Clinician Aggregation Group PerformanceComprehensive End-Stage Renal Disease Care Model DataMedicare Dialysis FacilitiesProvider of Services File - Clinical LaboratoriesAmbulatory Specialty Model Participants

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 →