Medicare Advantage, Part D, Medicaid

MA monthly enrollment by contract, names as CMS wrote them

medicare_semantic.vw_monthly_contract_enrollment_summary_v2·live·semantic_view

Rows

203,758

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS Monthly Enrollment by Contract: every row of medicare_silver.monthly_contract_enrollment_summary with organization, marketing and parent names restored where CMS's 2006-2019 files carry DOS glyphs; the stored values are kept in <column>_legacy.

Grain

Key	Grain
N/A	1One row per (contract_id, report_month) — CMS Monthly Enrollment by Contract (member counts). 2CERTIFIED 2026-06-03.

Columns (34)

Column	Type	Meaning
`contract_id`	string
`report_month`	date
`organization_type`	string
`plan_type`	string
`organization_name_raw`	string
`organization_marketing_name_raw`	string
`parent_org_raw`	string
`contract_effective_date`	date
`offers_part_d`	boolean
`enrollment_count`	int
`enrollment_lower_bound`	int
`enrollment_upper_bound`	int
`enrollment_suppression_reason`	string
`ma_only_count`	int
`ma_only_lower_bound`	int
`ma_only_upper_bound`	int
`ma_only_suppression_reason`	string
`part_d_count`	int
`part_d_lower_bound`	int
`part_d_upper_bound`	int
`part_d_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
`parent_org_raw_legacy`	string
`text_corrected`	boolean

Query it

describe_data_source(source_fqn="medicare_semantic.vw_monthly_contract_enrollment_summary_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_monthly_contract_enrollment_summary_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_monthly_contract_enrollment_summary_v2")`
Raw door	Tool: get_enrollment (contract grain); Athena: medicare_semantic.vw_monthly_contract_enrollment_summary_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): 1,452 rows carry a corrected name; view minus table = 0 (Athena 63a1c21d). Record docs/reference/source-audit/source-mastery/records/medicare_enrollment.json (served_corrections).

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