About this Dataset

Medicare Monthly Enrollment

The Medicare Monthly Enrollment data provides current monthly information on the number of Medicare beneficiaries with hospital/medical coverage and prescription drug coverage, available for several geographic areas including national, state/territory, and county. The hospital/medical coverage data can be broken down further by health care delivery (Original Medicare versus Medicare Advantage and Other Health Plans) and the prescription drug coverage data can be examined by those enrolled in stand-alone Prescription Drug Plans and those enrolled in Medicare Advantage Prescription Drug plans. The dataset provides monthly and yearly enrollee trends.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:25:08.291891
Tags: beneficiary-enrollment, counties, health-equity, medicare, medicare-advantage, medicare-prescription-drug, national, original-medicare, states-territories

Tables

Medicare Monthly Enrollment : 2025-06-01

@usgov.hhs_gov_medicare_monthly_enrollment_9dde0.medicare_monthly_enrollment_2025_06_01

83.77 MB
540,399 rows
54 columns

CREATE TABLE medicare_monthly_enrollment_2025_06_01 (
  "year" BIGINT,
  "month" VARCHAR,
  "bene_geo_lvl" VARCHAR,
  "bene_state_abrvtn" VARCHAR,
  "bene_state_desc" VARCHAR,
  "bene_county_desc" VARCHAR,
  "bene_fips_cd" VARCHAR,
  "tot_benes" VARCHAR,
  "orgnl_mdcr_benes" VARCHAR,
  "ma_and_oth_benes" VARCHAR,
  "aged_tot_benes" VARCHAR,
  "aged_esrd_benes" VARCHAR,
  "aged_no_esrd_benes" VARCHAR,
  "dsbld_tot_benes" VARCHAR,
  "dsbld_esrd_and_esrd_only_benes" VARCHAR,
  "dsbld_no_esrd_benes" VARCHAR,
  "male_tot_benes" VARCHAR,
  "female_tot_benes" VARCHAR,
  "white_tot_benes" VARCHAR,
  "black_tot_benes" VARCHAR,
  "api_tot_benes" VARCHAR,
  "hspnc_tot_benes" VARCHAR,
  "natind_tot_benes" VARCHAR,
  "othr_tot_benes" VARCHAR,
  "age_lt_25_benes" VARCHAR,
  "age_25_to_44_benes" VARCHAR,
  "age_45_to_64_benes" VARCHAR,
  "age_65_to_69_benes" VARCHAR,
  "age_70_to_74_benes" VARCHAR,
  "age_75_to_79_benes" VARCHAR,
  "age_80_to_84_benes" VARCHAR,
  "age_85_to_89_benes" VARCHAR,
  "age_90_to_94_benes" VARCHAR,
  "age_gt_94_benes" VARCHAR,
  "dual_tot_benes" VARCHAR,
  "full_dual_tot_benes" VARCHAR,
  "part_dual_tot_benes" VARCHAR,
  "nodual_tot_benes" VARCHAR,
  "a_b_tot_benes" VARCHAR,
  "a_b_orgnl_mdcr_benes" VARCHAR,
  "a_b_ma_and_oth_benes" VARCHAR,
  "a_tot_benes" VARCHAR,
  "a_orgnl_mdcr_benes" VARCHAR,
  "a_ma_and_oth_benes" VARCHAR,
  "b_tot_benes" VARCHAR,
  "b_orgnl_mdcr_benes" VARCHAR,
  "b_ma_and_oth_benes" VARCHAR,
  "prscrptn_drug_tot_benes" VARCHAR,
  "prscrptn_drug_pdp_benes" VARCHAR,
  "prscrptn_drug_mapd_benes" VARCHAR,
  "prscrptn_drug_deemed_eligible_full_lis_benes" VARCHAR,
  "prscrptn_drug_full_lis_benes" VARCHAR,
  "prscrptn_drug_partial_lis_benes" VARCHAR,
  "prscrptn_drug_no_lis_benes" VARCHAR
);