# Special Needs Plans by plan and month, current CMS vintage, with D-SNP integration status, small-cell bounds and Under-11 rows

`medicare_semantic.vw_snp_data_v3` · Medicare Advantage, Part D, Medicaid · status live · 195,628 rows

CMS's monthly SNP Comprehensive Report at parse revision 3, the current CMS vintage of each month: every SNP plan since 2007-05 with SNP type, specialty diseases, enrollment and states (Plan ID at three digits), the D-SNP integration status (CO / HIDE / FIDE, from 2022-07), applicable integrated plan, partial-dual-only and D-SNP-only-contract flags (from 2025-01), the [0, 10] bound on a blank enrollment cell, and CMS's Under-11 aggregate rows flagged synthetic_under_11_row. get_snp_plan_details and get_enrollment read this view from 2026-10-05.

**Grain.** One row per (contract_id, plan_id, segment_id, snp_type, state_list_raw, report_month) for real rows and one per (snp_type, report_month) for Under-11 rows; 195,628 rows over 233 months 2007-05..2026-09, 698 Under-11 rows, equal to medicare_silver.snp_data_v2 WHERE is_current row for row (Athena 0d8b8098, a97849fd).

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| report_month | date |  |
| contract_name_raw | string |  |
| organization_type | string |  |
| plan_name_raw | string |  |
| plan_type | string |  |
| plan_geographic_name | string |  |
| state_list_raw | string |  |
| plan_enrollment | int |  |
| snp_type | string |  |
| specialty_diseases | string |  |
| dsnp_integration_status | string |  |
| applicable_integrated_plan | boolean |  |
| partial_dual_only | boolean |  |
| dsnp_only_contract | boolean |  |
| plan_enrollment_lower_bound | int |  |
| plan_enrollment_upper_bound | int |  |
| enrollment_suppression_reason | string |  |
| synthetic_under_11_row | boolean |  |
| 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 |  |

Tools that read it: get_stars_rollup

Query it: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_snp_data_v3 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_snp_data_v3")` first.