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: 2023-05-12T00:52:43.774319
Tags: health-care-use-payments, 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_050f3198.medicare_inpatient_hospitals_by_provider_and_service_2013_12_31

5.94 MB
207896 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_050f3198.medicare_inpatient_hospitals_by_provider_and_service_2014_12_31

5.8 MB
202683 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_050f3198.medicare_inpatient_hospitals_by_provider_and_service_2015_12_31

5.71 MB
199807 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_050f3198.medicare_inpatient_hospitals_by_provider_and_service_2016_12_31

5.64 MB
196460 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_050f3198.medicare_inpatient_hospitals_by_provider_and_service_2017_12_31

5.63 MB
196086 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
);