Medicare Advantage, Part D, Medicaid

CMS D-SNP look-alike lists CY2022-2026 (plan-level % dual eligible)

medicare_silver.cms_dsnp_lookalike_list_v1·live·silver

Rows

108

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Non-SNP MA plans whose January enrollment is at least the threshold share dual eligible (80% CY2022-2024, 70% CY2025, 60% CY2026): total enrollment and % dual, the only public plan-level dual share.

Grain

Key	Grain
N/A	1One row per contract_year x contract x plan x segment x state.

Columns (18)

Column	Type	Meaning
`contract_year`	int
`edition`	string
`threshold_share`	double
`contract_id`	string
`plan_id`	string
`segment_id`	string
`parent_organization_raw`	string
`legal_entity_name`	string
`state_code`	string
`total_enrollment_january`	int
`dual_share_january`	double
`dual_share_raw`	string
`publisher_row_number`	int
`source_url`	string
`sha256_content_hash`	string
`bronze_object_key`	string
`parse_revision`	int
`parser_artifact_hash`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_year,contract_id,plan_id,segment_id,state_code`
Join	`how_to_join(source_fqn="medicare_silver.cms_dsnp_lookalike_list_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.cms_dsnp_lookalike_list_v1
Company names	`parent_organization_raw` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Registered 2026-10-12 under register source cms_dsnp_lookalike_list (W3; Ben's yes, switch-on stage 1.2). Serving takes effect with the next MCP bridge release.

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