Medicare Advantage, Part D, Medicaid

MA/Part D enrollment, CPSC county grain, every published row with the revision-3 flag

medicare_semantic.vw_enrollment_monthly_county_v3·live·semantic_view

Rows

630,792,948

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS CPSC monthly MA and Part D enrollment at county grain over medicare_silver.enrollment_monthly_county_v4, with CMS's parent names restored as in vw_enrollment_monthly_county_v2. in_revision3_table marks the rows the revision-3 table holds (plan_id <> '', state_code present, a county code present); county_code_system says whether a row carries a FIPS code ('fips'), only an SSA code ('ssa') or none ('none').

Grain

Key	Grain
N/A	1One row per (contract_id, plan_id, state_code, county_fips, county_ssa, report_month): 630,792,948 rows in 243 months, 2006-07..2026-09 (2026-09: 3,398,007 rows, 3,387,662 with in_revision3_table; 2Athena fc666995).

Columns (26)

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
`county_code_system`	string
`in_revision3_table`	boolean
`parent_org_raw_legacy`	string
`text_corrected`	boolean

Query it

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

Item	Value
Typed tools that read it	get_county_view, get_market_share
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_enrollment_monthly_county_v3")`
Raw door	Tools: get_county_view (1.2.1), get_market_share (0.3.1); Athena: medicare_semantic.vw_enrollment_monthly_county_v3 (pin report_month and a partition range on observed_period; in_revision3_table = true for the pre-v4 county totals; county_code_system = 'fips' for any county join)
Company names	`parent_org_raw` `parent_org_raw_legacy` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Read path for county enrollment from 2026-10-07 (get_county_view 1.2.1, get_market_share 0.3.1, both with in_revision3_table AND county_code_system = 'fips'; old vs new identical on Athena). Supersedes vw_enrollment_monthly_county_v2 and medicare_silver.enrollment_monthly_county for reading; both stay live as the rollback.

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