About this Dataset

Medicare Dialysis Facilities

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.

Note: This full dataset 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.
Organization: U.S. Department of Health & Human Services
Last updated: 2024-03-02T02:09:09.475872
Tags: chronic-conditions, end-stage-renal-disease-facilities, hospitals-facilities, medicare, original-medicare, outpatient-facilities

Tables

Medicare Dialysis Facilities : 2021-12-30

@usgov.hhs_gov_medicare_dialysis_facilities_79b67.medicare_dialysis_facilities_2021_12_30

45.55 MB
9,701,304 rows
14 columns

CREATE TABLE medicare_dialysis_facilities_2021_12_30 (
  "state" VARCHAR,
  "ccn" BIGINT,
  "provider_name" VARCHAR,
  "city" VARCHAR,
  "ownership_type" VARCHAR,
  "esrd_network" BIGINT,
  "npi" VARCHAR,
  "chain_name" VARCHAR,
  "modality" VARCHAR,
  "alternate_ccn_s" DOUBLE  -- Alternate CCN(s),
  "measure" VARCHAR,
  "measure_score" DOUBLE,
  "year_s_covered_by_the_measure" VARCHAR  -- Year(s) Covered By The Measure,
  "measure_id" VARCHAR
);

Medicare Dialysis Facilities : 2022-12-31

@usgov.hhs_gov_medicare_dialysis_facilities_79b67.medicare_dialysis_facilities_2022_12_31

39.48 MB
10,821,384 rows
14 columns

CREATE TABLE medicare_dialysis_facilities_2022_12_31 (
  "state" VARCHAR,
  "ccn" BIGINT,
  "provider_name" VARCHAR,
  "city" VARCHAR,
  "ownership_type" VARCHAR,
  "esrd_network" BIGINT,
  "npi" VARCHAR,
  "chain" VARCHAR,
  "modality" VARCHAR,
  "alternate_ccns" DOUBLE,
  "measure" VARCHAR,
  "measure_score" DOUBLE,
  "year" VARCHAR,
  "measure_id" VARCHAR
);

Medicare Dialysis Facilities : 2023-01-01

@usgov.hhs_gov_medicare_dialysis_facilities_79b67.medicare_dialysis_facilities_2023_01_01

43.78 MB
11,716,731 rows
14 columns

CREATE TABLE medicare_dialysis_facilities_2023_01_01 (
  "state" VARCHAR,
  "ccn" BIGINT,
  "provider_name" VARCHAR,
  "city" VARCHAR,
  "ownership_type" VARCHAR,
  "esrd_network" BIGINT,
  "npi" VARCHAR,
  "chain" VARCHAR,
  "modality" VARCHAR,
  "alternate_ccns" DOUBLE,
  "measure" VARCHAR,
  "measure_score" DOUBLE,
  "year" VARCHAR,
  "measure_id" VARCHAR
);

Medicare Dialysis Facilities : 2024-01-01

@usgov.hhs_gov_medicare_dialysis_facilities_79b67.medicare_dialysis_facilities_2024_01_01

43.04 MB
11,679,242 rows
14 columns

CREATE TABLE medicare_dialysis_facilities_2024_01_01 (
  "state" VARCHAR,
  "ccn" BIGINT,
  "provider_name" VARCHAR,
  "city" VARCHAR,
  "ownership_type" VARCHAR,
  "esrd_network" BIGINT,
  "npi" VARCHAR,
  "chain" VARCHAR,
  "modality" VARCHAR,
  "alternate_ccns" DOUBLE,
  "measure" VARCHAR,
  "measure_score" DOUBLE,
  "year" VARCHAR,
  "measure_id" VARCHAR
);