Medicare Advantage, Part D, Medicaid

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

medicare_silver.fact_medicare_monthly_enrollment·live·silver

Rows

583,780

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicare 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.
2January 2026 national: 70,290,546 beneficiaries, 35,705,175 in MA and other plans.

Grain

Key	Grain
N/A	1One row per (release, year, month, bene_geo_lvl, bene_state_abrvtn, bene_fips_cd).

Columns (79)

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

describe_data_source(source_fqn="medicare_silver.fact_medicare_monthly_enrollment")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_medicare_monthly_enrollment WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`year,month,bene_geo_lvl,bene_state_abrvtn,bene_fips_cd`
Join	`how_to_join(source_fqn="medicare_silver.fact_medicare_monthly_enrollment")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_medicare_monthly_enrollment
Note	Register source cms_medicare_monthly_enrollment (w2, serve raw). RAW. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30: 583,780 rows, 3,604,780 suppressed cells = the publisher's '*', 0 duplicate keys, CT planning regions 2022+; Athena 78df6a64, a732994c, e59455d3). Cell reconciliation PASS (59 fields; 54 control totals over the whole file). Registered 2026-09-30.

This page as markdown: /docs-md/data/medicare_silver_fact_medicare_monthly_enrollment.md · every page in one file: /llms-full.txt