# Special Needs Plans by plan and month, parse revision 3 (D-SNP integration status, small-cell bounds, Under-11 rows)

`medicare_silver.snp_data_v2` · Medicare Advantage, Part D, Medicaid · status live · 195,628 rows

CMS's monthly SNP Comprehensive Report at parse revision 3: every SNP plan since 2007-05 with SNP type, specialty diseases, enrollment and states (Plan ID at three digits), plus 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. The tools read medicare_semantic.vw_snp_data_v3, this table's current vintage (card medicare_snp_data_v3).

**Grain.** One row per (contract_id, plan_id, segment_id, snp_type, state_list_raw, report_month) among is_current real rows; 195,628 current rows over 233 months 2007-05..2026-09 = the served 194,930 rows one for one plus CMS's 698 Under-11 rows (Athena a3e5cf73, 43cbe058).

| 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 |  |
| is_current | boolean |  |

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