About this Dataset

Hospital Service Area

The Hospital Service Area data is a summary of calendar year Medicare inpatient hospital fee-for-service and Medicare Advantage claims data. It contains number of discharges, total days of care, and total charges summarized by hospital provider number and the ZIP code of the Medicare beneficiary.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:30:07.086275
Tags: health-care-use-payments, hospitals-facilities, inpatient, medicare, original-medicare

Tables

Hospital Service Area : 2015-12-31

@usgov.hhs_gov_hospital_service_area_c101d.hospital_service_area_2015_12_31

2.48 MB
1,032,305 rows
5 columns

CREATE TABLE hospital_service_area_2015_12_31 (
  "medicare_prov_num" VARCHAR,
  "zip_cd_of_residence" VARCHAR,
  "total_days_of_care" DOUBLE,
  "total_charges" DOUBLE,
  "total_cases" DOUBLE
);

Hospital Service Area : 2016-12-31

@usgov.hhs_gov_hospital_service_area_c101d.hospital_service_area_2016_12_31

5.28 MB
1,048,812 rows
5 columns

CREATE TABLE hospital_service_area_2016_12_31 (
  "medicare_prov_num" VARCHAR,
  "zip_cd_of_residence" VARCHAR,
  "total_days_of_care" VARCHAR,
  "total_charges" VARCHAR,
  "total_cases" VARCHAR
);

Hospital Service Area : 2017-12-31

@usgov.hhs_gov_hospital_service_area_c101d.hospital_service_area_2017_12_31

5.34 MB
1,070,573 rows
5 columns

CREATE TABLE hospital_service_area_2017_12_31 (
  "medicare_prov_num" VARCHAR,
  "zip_cd_of_residence" VARCHAR,
  "total_days_of_care" VARCHAR,
  "total_charges" VARCHAR,
  "total_cases" VARCHAR
);

Hospital Service Area : 2018-12-31

@usgov.hhs_gov_hospital_service_area_c101d.hospital_service_area_2018_12_31

5.31 MB
1,072,899 rows
5 columns

CREATE TABLE hospital_service_area_2018_12_31 (
  "medicare_prov_num" VARCHAR,
  "zip_cd_of_residence" VARCHAR,
  "total_days_of_care" VARCHAR,
  "total_charges" VARCHAR,
  "total_cases" VARCHAR
);

Hospital Service Area : 2019-12-31

@usgov.hhs_gov_hospital_service_area_c101d.hospital_service_area_2019_12_31

5.34 MB
1,066,871 rows
5 columns

CREATE TABLE hospital_service_area_2019_12_31 (
  "medicare_prov_num" VARCHAR,
  "zip_cd_of_residence" VARCHAR,
  "total_days_of_care" VARCHAR,
  "total_charges" VARCHAR,
  "total_cases" VARCHAR
);

Hospital Service Area : 2020-12-31

@usgov.hhs_gov_hospital_service_area_c101d.hospital_service_area_2020_12_31

4.91 MB
972,146 rows
5 columns

CREATE TABLE hospital_service_area_2020_12_31 (
  "medicare_prov_num" VARCHAR,
  "zip_cd_of_residence" VARCHAR,
  "total_days_of_care" VARCHAR,
  "total_charges" VARCHAR,
  "total_cases" VARCHAR
);

Hospital Service Area : 2021-01-01

@usgov.hhs_gov_hospital_service_area_c101d.hospital_service_area_2021_01_01

5.07 MB
1,020,189 rows
5 columns

CREATE TABLE hospital_service_area_2021_01_01 (
  "medicare_prov_num" VARCHAR,
  "zip_cd_of_residence" VARCHAR,
  "total_days_of_care" VARCHAR,
  "total_charges" VARCHAR,
  "total_cases" VARCHAR
);

Hospital Service Area : 2022-01-01

@usgov.hhs_gov_hospital_service_area_c101d.hospital_service_area_2022_01_01

5.43 MB
1,129,953 rows
5 columns

CREATE TABLE hospital_service_area_2022_01_01 (
  "medicare_prov_num" VARCHAR,
  "zip_cd_of_residence" VARCHAR,
  "total_days_of_care" VARCHAR,
  "total_charges" VARCHAR,
  "total_cases" VARCHAR
);

Hospital Service Area : 2023-01-01

@usgov.hhs_gov_hospital_service_area_c101d.hospital_service_area_2023_01_01

5.49 MB
1,139,666 rows
5 columns

CREATE TABLE hospital_service_area_2023_01_01 (
  "medicare_prov_num" VARCHAR,
  "zip_cd_of_residence" VARCHAR,
  "total_days_of_care" VARCHAR,
  "total_charges" VARCHAR,
  "total_cases" VARCHAR
);

Hospital Service Area : 2024-01-01

@usgov.hhs_gov_hospital_service_area_c101d.hospital_service_area_2024_01_01

5.56 MB
1,156,702 rows
5 columns

CREATE TABLE hospital_service_area_2024_01_01 (
  "medicare_prov_num" VARCHAR,
  "zip_cd_of_residence" DOUBLE,
  "total_days_of_care" VARCHAR,
  "total_charges" VARCHAR,
  "total_cases" VARCHAR
);