About this Dataset

Medicare Inpatient Hospitals - By Provider And Service

The Medicare Inpatient Hospitals by Provider and Service dataset provides information on inpatient discharges for Original Medicare Part A beneficiaries by IPPS hospitals. It includes information on the use, payment, and hospital charges for more than 3,000 U.S. hospitals that received IPPS payments. The data are organized by hospital and Medicare Severity Diagnosis Related Group (DRG).

Hospitals determine what they will charge for items and services provided to patients, and these charges are the amount the hospital bills for an item or service. The Total Payment Amount includes the DRG amount, claim per diem amount, beneficiary primary payer claim payment amount, beneficiary Part A (Hospital Insurance) coinsurance amount, beneficiary deductible amount, beneficiary blood deductible amount and diagnosis related group outlier amount.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:19:43.321777
Tags: health-care-use-payments, health-equity, hospitals-facilities, inpatient, medicare, original-medicare

Tables

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

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_and_s_f6003d82.medicare_inpatient_hospitals_by_provider_and_service_2013_12_31

6.23 MB
207,896 rows
15 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_and_service_2013_12_31 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_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 Provider And Service : 2014-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_and_s_f6003d82.medicare_inpatient_hospitals_by_provider_and_service_2014_12_31

6.08 MB
202,683 rows
15 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_and_service_2014_12_31 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_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 Provider And Service : 2015-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_and_s_f6003d82.medicare_inpatient_hospitals_by_provider_and_service_2015_12_31

5.99 MB
199,807 rows
15 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_and_service_2015_12_31 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_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 Provider And Service : 2016-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_and_s_f6003d82.medicare_inpatient_hospitals_by_provider_and_service_2016_12_31

5.91 MB
196,460 rows
15 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_and_service_2016_12_31 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_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 Provider And Service : 2017-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_and_s_f6003d82.medicare_inpatient_hospitals_by_provider_and_service_2017_12_31

5.91 MB
196,086 rows
15 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_and_service_2017_12_31 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_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 Provider And Service : 2018-12-31

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_and_s_f6003d82.medicare_inpatient_hospitals_by_provider_and_service_2018_12_31

5.8 MB
192,069 rows
15 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_and_service_2018_12_31 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_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
);