Medicare Advantage, Part D, Medicaid

MA monthly enrollment by contract and plan, names as CMS wrote them

medicare_semantic.vw_enrollment_monthly_plan_v2·live·semantic_view

Rows

1,416,620

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS Monthly Enrollment by Contract/Plan: every row of medicare_silver.enrollment_monthly_plan with organization, marketing, plan and parent names restored where CMS's mixed encodings garbled them; the stored values are kept in <column>_legacy.

Grain

Key	Grain
N/A	1One row per (contract_id, plan_id, month) plan-level enrollment count.

Columns (29)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`report_month`	date
`organization_type`	string
`plan_type`	string
`offers_part_d`	boolean
`organization_name_raw`	string
`organization_marketing_name_raw`	string
`plan_name_raw`	string
`parent_org_raw`	string
`contract_effective_date`	date
`enrollment_count`	int
`enrollment_lower_bound`	int
`enrollment_upper_bound`	int
`enrollment_suppression_reason`	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
`organization_name_raw_legacy`	string
`organization_marketing_name_raw_legacy`	string
`plan_name_raw_legacy`	string
`parent_org_raw_legacy`	string
`text_corrected`	boolean

Query it

describe_data_source(source_fqn="medicare_semantic.vw_enrollment_monthly_plan_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_enrollment_monthly_plan_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_plan_v2")`
Raw door	Tool: get_enrollment; Athena: medicare_semantic.vw_enrollment_monthly_plan_v2 (pin report_month)
Company names	`organization_marketing_name_raw` `organization_marketing_name_raw_legacy` `organization_name_raw` `organization_name_raw_legacy` `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): 6,535 rows carry a corrected name; view minus table = 0 (Athena 63a1c21d). get_enrollment 0.3.0 reads it. 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_plan_v2.md · every page in one file: /llms-full.txt