About this Dataset

Medicare Geographic Variation - By National, State & County

The Medicare Geographic Variation by National, State & County dataset provides information on the geographic differences in the use and quality of health care services for the Original Medicare population. This dataset contains demographic, spending, use, and quality indicators at the state level (including the District of Columbia, Puerto Rico, and the Virgin Islands) and the county level.

Spending is standardized to remove geographic differences in payment rates for individual services as a source of variation. In general, total standardized per capita costs are less than actual per capita costs because the extra payments Medicare made to hospitals were removed, such as payments for medical education (both direct and indirect) and payments to hospitals that serve a disproportionate share of low-income patients. Standardization does not adjust for differences in beneficiaries’ health status.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:18:24.257233
Tags: counties, health-care-use-payments, health-equity, medicare, national, original-medicare, states-territories

Tables

Medicare Geographic Variation - By National, State & County : 2023-01-01

@usgov.hhs_gov_medicare_geographic_variation_by_national_stat_10523f77.medicare_geographic_variation_by_national_state_county_714af761

41.15 MB
33,639 rows
247 columns

CREATE TABLE medicare_geographic_variation_by_national_state_county_714af761 (
  "year" BIGINT,
  "bene_geo_lvl" VARCHAR,
  "bene_geo_desc" VARCHAR,
  "bene_geo_cd" DOUBLE,
  "bene_age_lvl" VARCHAR,
  "benes_total_cnt" VARCHAR,
  "benes_wth_ptaptb_cnt" VARCHAR,
  "benes_ffs_cnt" VARCHAR,
  "benes_ma_cnt" VARCHAR,
  "ma_prtcptn_rate" VARCHAR,
  "bene_avg_age" VARCHAR,
  "bene_feml_pct" VARCHAR,
  "bene_male_pct" VARCHAR,
  "bene_race_wht_pct" VARCHAR,
  "bene_race_black_pct" VARCHAR,
  "bene_race_hspnc_pct" VARCHAR,
  "bene_race_othr_pct" VARCHAR,
  "bene_dual_pct" VARCHAR,
  "bene_avg_risk_scre" VARCHAR,
  "tot_mdcr_pymt_amt" VARCHAR,
  "tot_mdcr_stdzd_pymt_amt" VARCHAR,
  "tot_mdcr_pymt_pc" VARCHAR,
  "tot_mdcr_stdzd_pymt_pc" VARCHAR,
  "ip_mdcr_pymt_amt" VARCHAR,
  "ip_mdcr_pymt_pct" VARCHAR,
  "ip_mdcr_pymt_pc" VARCHAR,
  "ip_mdcr_pymt_per_user" VARCHAR,
  "ip_mdcr_stdzd_pymt_amt" VARCHAR,
  "ip_mdcr_stdzd_pymt_pct" VARCHAR,
  "ip_mdcr_stdzd_pymt_pc" VARCHAR,
  "ip_mdcr_stdzd_pymt_per_user" VARCHAR,
  "benes_ip_cvrd_stay_cnt" VARCHAR,
  "benes_ip_pct" VARCHAR,
  "ip_cvrd_stays_per_1000_benes" VARCHAR,
  "ip_cvrd_days_per_1000_benes" VARCHAR,
  "acute_hosp_readmsn_cnt" VARCHAR,
  "acute_hosp_readmsn_pct" VARCHAR,
  "benes_er_visits_cnt" VARCHAR,
  "er_visits_per_1000_benes" VARCHAR,
  "benes_er_visits_pct" VARCHAR,
  "op_mdcr_pymt_amt" VARCHAR,
  "op_mdcr_pymt_pct" VARCHAR,
  "op_mdcr_pymt_pc" VARCHAR,
  "op_mdcr_pymt_per_user" VARCHAR,
  "op_mdcr_stdzd_pymt_amt" VARCHAR,
  "op_mdcr_stdzd_pymt_pct" VARCHAR,
  "op_mdcr_stdzd_pymt_pc" VARCHAR,
  "op_mdcr_stdzd_pymt_per_user" VARCHAR,
  "benes_op_cnt" VARCHAR,
  "benes_op_pct" VARCHAR,
  "op_visits_per_1000_benes" VARCHAR,
  "asc_mdcr_pymt_amt" VARCHAR,
  "asc_mdcr_pymt_pct" VARCHAR,
  "asc_mdcr_pymt_pc" VARCHAR,
  "asc_mdcr_pymt_per_user" VARCHAR,
  "asc_mdcr_stdzd_pymt_amt" VARCHAR,
  "asc_mdcr_stdzd_pymt_pct" VARCHAR,
  "asc_mdcr_stdzd_pymt_pc" VARCHAR,
  "asc_mdcr_stdzd_pymt_per_user" VARCHAR,
  "benes_asc_cnt" VARCHAR,
  "benes_asc_pct" VARCHAR,
  "asc_evnts_per_1000_benes" VARCHAR,
  "snf_mdcr_pymt_amt" VARCHAR,
  "snf_mdcr_pymt_pct" VARCHAR,
  "snf_mdcr_pymt_pc" VARCHAR,
  "snf_mdcr_pymt_per_user" VARCHAR,
  "snf_mdcr_stdzd_pymt_amt" VARCHAR,
  "snf_mdcr_stdzd_pymt_pct" VARCHAR,
  "snf_mdcr_stdzd_pymt_pc" VARCHAR,
  "snf_mdcr_stdzd_pymt_per_user" VARCHAR,
  "benes_snf_cnt" VARCHAR,
  "benes_snf_pct" VARCHAR,
  "snf_cvrd_stays_per_1000_benes" VARCHAR,
  "snf_cvrd_days_per_1000_benes" VARCHAR,
  "irf_mdcr_pymt_amt" VARCHAR,
  "irf_mdcr_pymt_pct" VARCHAR,
  "irf_mdcr_pymt_pc" VARCHAR,
  "irf_mdcr_pymt_per_user" VARCHAR,
  "irf_mdcr_stdzd_pymt_amt" VARCHAR,
  "irf_mdcr_stdzd_pymt_pct" VARCHAR,
  "irf_mdcr_stdzd_pymt_pc" VARCHAR,
  "irf_mdcr_stdzd_pymt_per_user" VARCHAR,
  "benes_irf_cnt" VARCHAR,
  "benes_irf_pct" VARCHAR,
  "irf_cvrd_stays_per_1000_benes" VARCHAR,
  "irf_cvrd_days_per_1000_benes" VARCHAR,
  "ltch_mdcr_pymt_amt" VARCHAR,
  "ltch_mdcr_pymt_pct" VARCHAR,
  "ltch_mdcr_pymt_pc" VARCHAR,
  "ltch_mdcr_pymt_per_user" VARCHAR,
  "ltch_mdcr_stdzd_pymt_amt" VARCHAR,
  "ltch_mdcr_stdzd_pymt_pct" VARCHAR,
  "ltch_mdcr_stdzd_pymt_pc" VARCHAR,
  "ltch_mdcr_stdzd_pymt_per_user" VARCHAR,
  "benes_ltch_cnt" VARCHAR,
  "benes_ltch_pct" VARCHAR,
  "ltch_cvrd_stays_per_1000_benes" VARCHAR,
  "ltch_cvrd_days_per_1000_benes" VARCHAR,
  "hh_mdcr_pymt_amt" VARCHAR,
  "hh_mdcr_pymt_pct" VARCHAR
);