Medicare Advantage, Part D, Medicaid

MA/Part D enrollment — plan grain

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

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS monthly MA and Part D enrollment at contract-plan-month grain.
2Direct guarded queries support plan-level population filters and as-reported parent rollups;
3SNP status comes from a separate membership source.

Grain

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

Columns (24)

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

Query it

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

Item	Value
Typed tools that read it	get_enrollment, get_stars_rollup, prove_ma_enrollment_trend
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_silver.enrollment_monthly_plan")`
Raw door	Athena read-only via query_substrate: medicare_silver.enrollment_monthly_plan
Company names	`organization_marketing_name_raw` `organization_name_raw` `parent_org_raw` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Live guarded query execution and ten-year parent rollups verified; 300 as-reported parent labels and 1486 parent-year records. Evidence: docs/product/2026-09-11-studio-ma-source-bound.ACTUAL.json. Live means queryable, not analytically certified.

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