About this Dataset

Medicare Inpatient Hospitals - By Geography And Service

The Medicare Inpatient Hospitals by Geography and Service dataset provides information on hospital discharges for Original Medicare Part A beneficiaries by IPPS hospitals. This dataset contains information on the number of discharges, payments, and submitted charges organized by geography and Medicare Severity Diagnosis Related Group (DRG).
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:22:16.255496
Tags: health-care-use-payments, health-equity, hospitals-facilities, inpatient, medicare, national, original-medicare, states-territories

Tables

Medicare Inpatient Hospitals - By Geography And Service : 2022-12-01

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__19a6a808

838.76 kB
26,260 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__19a6a808 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);

Medicare Inpatient Hospitals - By Geography And Service : 2021-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__1f12bff0

848.6 kB
26,574 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__1f12bff0 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);

Medicare Inpatient Hospitals - By Geography And Service : 2018-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__262fdd37

909.08 kB
28,197 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__262fdd37 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);

Medicare Inpatient Hospitals - By Geography And Service : 2019-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__2f3079c1

906.93 kB
27,936 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__2f3079c1 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);

Medicare Inpatient Hospitals - By Geography And Service : 2020-12-23

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__423f1c60

872.65 kB
26,859 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__423f1c60 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);

Medicare Inpatient Hospitals - By Geography And Service : 2016-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__4eb6014c

922.59 kB
28,601 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__4eb6014c (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);

Medicare Inpatient Hospitals - By Geography And Service : 2014-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__6e8396c1

922.26 kB
28,493 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__6e8396c1 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);

Medicare Inpatient Hospitals - By Geography And Service : 2017-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__934d5aef

907.74 kB
28,280 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__934d5aef (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);

Medicare Inpatient Hospitals - By Geography And Service : 2015-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__961ce19e

920.82 kB
28,727 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__961ce19e (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);

Medicare Inpatient Hospitals - By Geography And Service : 2013-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__ba81036c

962.08 kB
28,487 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__ba81036c (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);

Medicare Inpatient Hospitals - By Geography And Service : 2023-12-01

@usgov.hhs_gov_medicare_inpatient_hospitals_by_geography_and__214926a1.medicare_inpatient_hospitals_by_geography_and_service__be6de084

863.67 kB
26,479 rows
9 columns

CREATE TABLE medicare_inpatient_hospitals_by_geography_and_service__be6de084 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" DOUBLE,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "drg_cd" BIGINT,
  "drg_desc" VARCHAR,
  "tot_dschrgs" BIGINT,
  "avg_submtd_cvrd_chrg" DOUBLE,
  "avg_tot_pymt_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE
);