# CMS Medicare Dialysis Facilities Roster

`vlada_curated.dim_dialysis_facility` · Provider identity · status live · 125,408 rows

CMS Medicare Dialysis Facilities (Dialysis Facility Reports): the annual roster of every Medicare-certified dialysis facility published by CMS on data.cms.gov. The mastered base table preserves one row per (observed_period, ccn) across FY2009-FY2026; the curated source_fqn is a current-vintage view.

**Grain.** One row per (observed_period, ccn) — 18 annual FY vintages 2009-2026.

| column | type | meaning |
|---|---|---|
| ccn | string |  |
| provider_name | string |  |
| city | string |  |
| state_cd | string |  |
| ownership_type | string |  |
| is_for_profit | boolean |  |
| esrd_network | string |  |
| npi | string |  |
| chain_organization | string |  |
| modality | string |  |
| alternate_ccns | string |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM vlada_curated.dim_dialysis_facility WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.dim_dialysis_facility")` first.