Medicare Advantage, Part D, Medicaid

MA/Part D enrollment — CPSC county grain

medicare_silver.enrollment_monthly_county·live·silver·Medicare Advantage & Part D Enrollment

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

Superseded by medicare_semantic.vw_enrollment_monthly_county_v3 over medicare_silver.enrollment_monthly_county_v4 (CPSC parse revision 4, rebuilt from bronze 2026-10-07, #3244) for reading. This revision-3 table drops the rows CMS publishes with no State, no Plan ID or no county code (1,767,320 rows in 243 months, CPSC-1/2) and holds an SSA code in county_fips on 24,297 rows in 2008-06..2009-08 (CPSC-3). v3 with in_revision3_table = true returns exactly this table's rows and figures in every month (Athena 2a9288a2). Kept live as the rollback and as the table the monthly CPSC load writes..

What it is

1CMS CPSC (Contract/Plan/State/County) monthly MA + Part D enrollment at county grain.
2The substrate behind get_enrollment_trend and the MA enrollment-trend proof rail.
3Includes EGHP (flagged); excludes Original Medicare (FFS).
4County cells with <=10 enrollees are CMS-suppressed (`*`) and carried as bounds [1,10] via enrollment_lower_bound/upper_bound + suppression_reason_code='redacted_small_cell'.

Grain

Key	Grain
N/A	1One row per (contract_id, plan_id, state_code, county_fips, month) enrollment count.

Columns (22)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`state_code`	string
`county_fips`	string
`report_month`	date
`enrollment_count`	int
`enrollment_lower_bound`	int
`enrollment_upper_bound`	int
`suppression_reason_code`	string
`parent_org_raw`	string
`enrollment_grain_era`	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
`county_ssa`	string
`county_name_raw`	string

Query it

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

Item	Value
Typed tools that read it	get_landscape_benefit_change, get_landscape_exits, get_stars_rollup, prove_ma_enrollment_trend
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_silver.enrollment_monthly_county")`
Raw door	Tool: get_enrollment_trend; Athena: medicare_silver.enrollment_monthly_county
Company names	`parent_org_raw` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	County form of the catalogued aggregate medicare_silver.fact_ma_enrollment (source_id medicare_ma_enrollment). row_count null (a code comment cites ~612M rows, not catalog-measured).

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