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

`medicare_silver.cms_dsnp_lookalike_list_v1` · Medicare Advantage, Part D, Medicaid · status live · 108 rows

Non-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.** One row per contract_year x contract x plan x segment x state.

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.cms_dsnp_lookalike_list_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.cms_dsnp_lookalike_list_v1")` first.