Medicare Advantage, Part D, Medicaid

CMS Monthly Enrollment by State: Medicare eligibles and MA, other and PDP enrollment by state

medicare_silver.ma_pdp_enrollment_by_state_v1·live·silver

Rows

6,565

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS's own monthly state totals of Medicare eligibles and of enrollees in Medicare Advantage, in 'other' plans (1876 Cost, PACE, demonstrations) and in stand-alone PDPs, per state and territory.
2The external state-level rail for CPSC county enrollment: it prints totals CPSC suppresses, and it carries eligibles, which CPSC does not.

Grain

Key	Grain
N/A	1One state or territory x report_month, as CMS totals it (eligibles, MA enrolled, other enrolled, PDP enrolled). 26,565 rows, 118 months 2016-10..2026-09 (Athena c59eb5a8, 2026-10-13).

Columns (29)

Column	Type	Meaning
`state_name`	string
`state_code`	string
`ssa_state_code`	string
`fips_state_code`	string
`eligibles`	bigint
`eligibles_suppressed`	boolean
`eligibles_raw`	string
`ma_enrolled`	bigint
`ma_enrolled_suppressed`	boolean
`ma_enrolled_raw`	string
`other_enrolled`	bigint
`other_enrolled_suppressed`	boolean
`other_enrolled_raw`	string
`pdp_enrolled`	bigint
`pdp_enrolled_suppressed`	boolean
`pdp_enrolled_raw`	string
`report_month`	date
`file_version`	string
`source_member`	string
`source_page_url`	string
`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

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`report_month,state_code`
Join	`how_to_join(source_fqn="medicare_silver.ma_pdp_enrollment_by_state_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_pdp_enrollment_by_state_v1
Note	Registered 2026-10-13 by the Data Tracker registration lane (PR claude/tracker-registration-2026-10-13) after the cloud load of #3567: 6,565 rows = the dry run, months 2016-10..2026-09 less 2017-02/03 (Athena c59eb5a8). Door RAW, World W3.

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