About this Dataset

Medicare Inpatient Hospitals - By Provider

The Medicare Inpatient Hospitals by Provider 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.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:24:44.268246
Tags: health-care-use-payments, health-equity, hospitals-facilities, inpatient, medicare, original-medicare

Tables

Medicare Inpatient Hospitals - By Provider : 2013-12-02

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_a8983.medicare_inpatient_hospitals_by_provider_2013_12_02

524.44 kB
3,381 rows
32 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_2013_12_02 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "tot_benes" DOUBLE,
  "tot_submtd_cvrd_chrg" DOUBLE,
  "tot_pymt_amt" DOUBLE,
  "tot_mdcr_pymt_amt" DOUBLE,
  "tot_dschrgs" BIGINT,
  "tot_cvrd_days" DOUBLE,
  "tot_days" DOUBLE,
  "bene_avg_age" DOUBLE,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);

Medicare Inpatient Hospitals - By Provider : 2014-12-02

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_a8983.medicare_inpatient_hospitals_by_provider_2014_12_02

520.55 kB
3,359 rows
32 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_2014_12_02 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "tot_benes" DOUBLE,
  "tot_submtd_cvrd_chrg" DOUBLE,
  "tot_pymt_amt" DOUBLE,
  "tot_mdcr_pymt_amt" DOUBLE,
  "tot_dschrgs" BIGINT,
  "tot_cvrd_days" DOUBLE,
  "tot_days" DOUBLE,
  "bene_avg_age" DOUBLE,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);

Medicare Inpatient Hospitals - By Provider : 2015-12-02

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_a8983.medicare_inpatient_hospitals_by_provider_2015_12_02

515.98 kB
3,316 rows
32 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_2015_12_02 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "tot_benes" DOUBLE,
  "tot_submtd_cvrd_chrg" DOUBLE,
  "tot_pymt_amt" DOUBLE,
  "tot_mdcr_pymt_amt" DOUBLE,
  "tot_dschrgs" BIGINT,
  "tot_cvrd_days" DOUBLE,
  "tot_days" DOUBLE,
  "bene_avg_age" DOUBLE,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);

Medicare Inpatient Hospitals - By Provider : 2016-12-02

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_a8983.medicare_inpatient_hospitals_by_provider_2016_12_02

512.86 kB
3,287 rows
32 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_2016_12_02 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "tot_benes" DOUBLE,
  "tot_submtd_cvrd_chrg" DOUBLE,
  "tot_pymt_amt" DOUBLE,
  "tot_mdcr_pymt_amt" DOUBLE,
  "tot_dschrgs" BIGINT,
  "tot_cvrd_days" DOUBLE,
  "tot_days" DOUBLE,
  "bene_avg_age" DOUBLE,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);

Medicare Inpatient Hospitals - By Provider : 2017-12-02

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_a8983.medicare_inpatient_hospitals_by_provider_2017_12_02

1.23 MB
3,257 rows
57 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_2017_12_02 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "tot_benes" DOUBLE,
  "tot_submtd_cvrd_chrg" DOUBLE,
  "tot_pymt_amt" DOUBLE,
  "tot_mdcr_pymt_amt" DOUBLE,
  "tot_dschrgs" BIGINT,
  "tot_cvrd_days" DOUBLE,
  "tot_days" DOUBLE,
  "bene_avg_age" DOUBLE,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_cc_bh_adhd_othcd_v1_pct" DOUBLE,
  "bene_cc_bh_alcohol_drug_v1_pct" DOUBLE,
  "bene_cc_bh_tobacco_v1_pct" DOUBLE,
  "bene_cc_bh_alz_nonalzdem_v2_pct" DOUBLE,
  "bene_cc_bh_anxiety_v1_pct" DOUBLE,
  "bene_cc_bh_bipolar_v1_pct" DOUBLE,
  "bene_cc_bh_mood_v2_pct" DOUBLE,
  "bene_cc_bh_depress_v1_pct" DOUBLE,
  "bene_cc_bh_pd_v1_pct" DOUBLE,
  "bene_cc_bh_ptsd_v1_pct" DOUBLE,
  "bene_cc_bh_schizo_othpsy_v1_pct" DOUBLE,
  "bene_cc_ph_asthma_v2_pct" DOUBLE,
  "bene_cc_ph_afib_v2_pct" DOUBLE,
  "bene_cc_ph_cancer6_v2_pct" DOUBLE,
  "bene_cc_ph_ckd_v2_pct" DOUBLE,
  "bene_cc_ph_copd_v2_pct" DOUBLE,
  "bene_cc_ph_diabetes_v2_pct" DOUBLE,
  "bene_cc_ph_hf_nonihd_v2_pct" DOUBLE,
  "bene_cc_ph_hyperlipidemia_v2_pct" DOUBLE,
  "bene_cc_ph_hypertension_v2_pct" DOUBLE,
  "bene_cc_ph_ischemicheart_v2_pct" DOUBLE,
  "bene_cc_ph_osteoporosis_v2_pct" DOUBLE,
  "bene_cc_ph_parkinson_v2_pct" DOUBLE,
  "bene_cc_ph_arthritis_v2_pct" DOUBLE,
  "bene_cc_ph_stroke_tia_v2_pct" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);

Medicare Inpatient Hospitals - By Provider : 2018-12-02

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_a8983.medicare_inpatient_hospitals_by_provider_2018_12_02

1.22 MB
3,249 rows
57 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_2018_12_02 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "tot_benes" DOUBLE,
  "tot_submtd_cvrd_chrg" DOUBLE,
  "tot_pymt_amt" DOUBLE,
  "tot_mdcr_pymt_amt" DOUBLE,
  "tot_dschrgs" BIGINT,
  "tot_cvrd_days" DOUBLE,
  "tot_days" DOUBLE,
  "bene_avg_age" DOUBLE,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_cc_bh_adhd_othcd_v1_pct" DOUBLE,
  "bene_cc_bh_alcohol_drug_v1_pct" DOUBLE,
  "bene_cc_bh_tobacco_v1_pct" DOUBLE,
  "bene_cc_bh_alz_nonalzdem_v2_pct" DOUBLE,
  "bene_cc_bh_anxiety_v1_pct" DOUBLE,
  "bene_cc_bh_bipolar_v1_pct" DOUBLE,
  "bene_cc_bh_mood_v2_pct" DOUBLE,
  "bene_cc_bh_depress_v1_pct" DOUBLE,
  "bene_cc_bh_pd_v1_pct" DOUBLE,
  "bene_cc_bh_ptsd_v1_pct" DOUBLE,
  "bene_cc_bh_schizo_othpsy_v1_pct" DOUBLE,
  "bene_cc_ph_asthma_v2_pct" DOUBLE,
  "bene_cc_ph_afib_v2_pct" DOUBLE,
  "bene_cc_ph_cancer6_v2_pct" DOUBLE,
  "bene_cc_ph_ckd_v2_pct" DOUBLE,
  "bene_cc_ph_copd_v2_pct" DOUBLE,
  "bene_cc_ph_diabetes_v2_pct" DOUBLE,
  "bene_cc_ph_hf_nonihd_v2_pct" DOUBLE,
  "bene_cc_ph_hyperlipidemia_v2_pct" DOUBLE,
  "bene_cc_ph_hypertension_v2_pct" DOUBLE,
  "bene_cc_ph_ischemicheart_v2_pct" DOUBLE,
  "bene_cc_ph_osteoporosis_v2_pct" DOUBLE,
  "bene_cc_ph_parkinson_v2_pct" DOUBLE,
  "bene_cc_ph_arthritis_v2_pct" DOUBLE,
  "bene_cc_ph_stroke_tia_v2_pct" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);

Medicare Inpatient Hospitals - By Provider : 2023-12-01

@usgov.hhs_gov_medicare_inpatient_hospitals_by_provider_a8983.medicare_inpatient_hospitals_by_provider_2023_12_01

1.13 MB
3,093 rows
57 columns

CREATE TABLE medicare_inpatient_hospitals_by_provider_2023_12_01 (
  "rndrng_prvdr_ccn" BIGINT,
  "rndrng_prvdr_org_name" VARCHAR,
  "rndrng_prvdr_st" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_zip5" BIGINT,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" BIGINT,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "tot_benes" BIGINT,
  "tot_submtd_cvrd_chrg" BIGINT,
  "tot_pymt_amt" BIGINT,
  "tot_mdcr_pymt_amt" BIGINT,
  "tot_dschrgs" BIGINT,
  "tot_cvrd_days" BIGINT,
  "tot_days" BIGINT,
  "bene_avg_age" DOUBLE,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_cc_bh_adhd_othcd_v1_pct" DOUBLE,
  "bene_cc_bh_alcohol_drug_v1_pct" DOUBLE,
  "bene_cc_bh_tobacco_v1_pct" DOUBLE,
  "bene_cc_bh_alz_nonalzdem_v2_pct" DOUBLE,
  "bene_cc_bh_anxiety_v1_pct" DOUBLE,
  "bene_cc_bh_bipolar_v1_pct" DOUBLE,
  "bene_cc_bh_mood_v2_pct" DOUBLE,
  "bene_cc_bh_depress_v1_pct" DOUBLE,
  "bene_cc_bh_pd_v1_pct" DOUBLE,
  "bene_cc_bh_ptsd_v1_pct" DOUBLE,
  "bene_cc_bh_schizo_othpsy_v1_pct" DOUBLE,
  "bene_cc_ph_asthma_v2_pct" DOUBLE,
  "bene_cc_ph_afib_v2_pct" DOUBLE,
  "bene_cc_ph_cancer6_v2_pct" DOUBLE,
  "bene_cc_ph_ckd_v2_pct" DOUBLE,
  "bene_cc_ph_copd_v2_pct" DOUBLE,
  "bene_cc_ph_diabetes_v2_pct" DOUBLE,
  "bene_cc_ph_hf_nonihd_v2_pct" DOUBLE,
  "bene_cc_ph_hyperlipidemia_v2_pct" DOUBLE,
  "bene_cc_ph_hypertension_v2_pct" DOUBLE,
  "bene_cc_ph_ischemicheart_v2_pct" DOUBLE,
  "bene_cc_ph_osteoporosis_v2_pct" DOUBLE,
  "bene_cc_ph_parkinson_v2_pct" DOUBLE,
  "bene_cc_ph_arthritis_v2_pct" DOUBLE,
  "bene_cc_ph_stroke_tia_v2_pct" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);