Medicare Advantage, Part D, Medicaid

MA/Part D enrollment, CPSC county grain, parent names as CMS wrote them

medicare_semantic.vw_enrollment_monthly_county_v2·live·semantic_view

Rows

629,025,628

Columns

History

N/A

Card

nocolumns only

Typed tools

Superseded by medicare_semantic.vw_enrollment_monthly_county_v3 (2026-10-07) for reading: the same corrected parent names (every month x parent equal, Athena 52eb622d) over the revision-4 table, which also keeps the rows CMS publishes with no State, no Plan ID or no county code. Filter v3 to in_revision3_table = true for this view's rows. Kept live as the rollback; get_county_view read it until 1.2.1..

What it is

1CMS CPSC (Contract/Plan/State/County) monthly MA and Part D enrollment at county grain: every row of medicare_silver.enrollment_monthly_county with parent_org_raw restored where CMS's mixed encodings garbled it, and the stored value kept in parent_org_raw_legacy.

Grain

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

Columns (24)

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

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_enrollment_monthly_county_v2")`
Raw door	Tool: get_county_view (parent names); Athena: medicare_semantic.vw_enrollment_monthly_county_v2 (pin report_month and a partition range on observed_period)
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	Versioned view (Data Tracker small-served-fixes lane, 2026-10-01, defect ENRTXT-1): 516,636 rows carry a corrected parent name; view minus table = 0 (Athena 63a1c21d). The table is unchanged; the decoder is fixed from the next load. Record docs/reference/source-audit/source-mastery/records/medicare_enrollment.json (served_corrections).

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