Medicare Advantage, Part D, Medicaid

CMS MA and PDP Enrollment by State/County/Contract (SCC), full version

medicare_silver.ma_pdp_enrollment_by_state_county_contract_v1·live·silver

Rows

143,610,809

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS's monthly enrollment by contract and the enrollee's county of residence (the payment county, not the service area), for MA (incl.
21876 Cost, HCPP, PACE, MSA, PFFS, LI NET) and stand-alone PDP contracts, with organization type and plan type per contract-county.
3The full version keeps the rows of 10 or fewer as suppressed cells.
4Heavy: pin report_month.

Grain

Key	Grain
N/A	1One program (MA or PDP) x contract x county of residence x report_month, as CMS prints the full SCC file. 2143,610,809 rows: MA 2006-10..2026-09, PDP 2007-01..2026-09, 240 distinct months (Athena c59eb5a8, 2026-10-13).

Columns (27)

Column	Type	Meaning
`program`	string
`county_name`	string
`state_code`	string
`contract_id`	string
`organization_name`	string
`organization_type`	string
`plan_type`	string
`ssa_county_code`	string
`fips_county_code`	string
`ssa_county_code_raw`	string
`fips_county_code_raw`	string
`enrolled`	bigint
`enrolled_suppressed`	boolean
`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_county_contract_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_pdp_enrollment_by_state_county_contract_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`report_month,program,contract_id,state_code,county_name,ssa_county_code,fips_county_code,plan_type`
Join	`how_to_join(source_fqn="medicare_silver.ma_pdp_enrollment_by_state_county_contract_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_pdp_enrollment_by_state_county_contract_v1 (pin report_month; 143.6M rows)
Company names	`organization_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Registered 2026-10-13 by the Data Tracker registration lane (PR claude/tracker-registration-2026-10-13) after the cloud load of #3567: 143,610,809 rows = the dry run (Athena c59eb5a8). Door RAW, World W3.

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