# Medicare Monthly Enrollment (national, state, county), 2013-2026

`medicare_silver.fact_medicare_monthly_enrollment` · Medicare Advantage, Part D, Medicaid · status live · 583,780 rows

Medicare beneficiaries by county, state and nation, monthly from 2013-01 (plus person-year rows): total, Original Medicare vs MA and other plans, aged / disabled / ESRD, demographics, dual status and Part D. January 2026 national: 70,290,546 beneficiaries, 35,705,175 in MA and other plans.

**Grain.** One row per (release, year, month, bene_geo_lvl, bene_state_abrvtn, bene_fips_cd).

| column | type | meaning |
|---|---|---|
| year | int |  |
| month | string |  |
| month_num | int |  |
| period_type | string |  |
| period_start | date |  |
| bene_geo_lvl | string |  |
| bene_state_abrvtn | string |  |
| bene_state_desc | string |  |
| bene_county_desc | string |  |
| bene_fips_cd | string |  |
| tot_benes | bigint |  |
| orgnl_mdcr_benes | bigint |  |
| ma_and_oth_benes | bigint |  |
| aged_tot_benes | bigint |  |
| aged_esrd_benes | bigint |  |
| aged_no_esrd_benes | bigint |  |
| dsbld_tot_benes | bigint |  |
| dsbld_esrd_and_esrd_only_benes | bigint |  |
| dsbld_no_esrd_benes | bigint |  |
| male_tot_benes | bigint |  |
| female_tot_benes | bigint |  |
| white_tot_benes | bigint |  |
| black_tot_benes | bigint |  |
| api_tot_benes | bigint |  |
| hspnc_tot_benes | bigint |  |
| natind_tot_benes | bigint |  |
| othr_tot_benes | bigint |  |
| age_lt_25_benes | bigint |  |
| age_25_to_44_benes | bigint |  |
| age_45_to_64_benes | bigint |  |
| age_65_to_69_benes | bigint |  |
| age_70_to_74_benes | bigint |  |
| age_75_to_79_benes | bigint |  |
| age_80_to_84_benes | bigint |  |
| age_85_to_89_benes | bigint |  |
| age_90_to_94_benes | bigint |  |
| age_gt_94_benes | bigint |  |
| dual_tot_benes | bigint |  |
| full_dual_tot_benes | bigint |  |
| part_dual_tot_benes | bigint |  |
| nodual_tot_benes | bigint |  |
| qmb_only_benes | bigint |  |
| qmb_plus_benes | bigint |  |
| slmb_only_benes | bigint |  |
| slmb_plus_benes | bigint |  |
| qdwi_qi_benes | bigint |  |
| othr_full_dual_mdcd_benes | bigint |  |
| a_b_tot_benes | bigint |  |
| a_b_orgnl_mdcr_benes | bigint |  |
| a_b_ma_and_oth_benes | bigint |  |
| a_tot_benes | bigint |  |
| a_orgnl_mdcr_benes | bigint |  |
| a_ma_and_oth_benes | bigint |  |
| b_tot_benes | bigint |  |
| b_orgnl_mdcr_benes | bigint |  |
| b_ma_and_oth_benes | bigint |  |
| prscrptn_drug_tot_benes | bigint |  |
| prscrptn_drug_pdp_benes | bigint |  |
| prscrptn_drug_mapd_benes | bigint |  |
| prscrptn_drug_deemed_eligible_full_lis_benes | bigint |  |
| prscrptn_drug_full_lis_benes | bigint |  |
| prscrptn_drug_partial_lis_benes | bigint |  |
| prscrptn_drug_no_lis_benes | bigint |  |
| suppressed_measure_count | int |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_medicare_monthly_enrollment WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_medicare_monthly_enrollment")` first.