# State duals knowledge base: filing patterns (how a state rule shows up in CY2027 D-SNP filings)

`medicare_silver.state_duals_kb_filing_patterns_v2` · State programs · status live · 49 rows

For each deep state, how a state Medicaid / SMAC rule shows up in the CY2027 D-SNP filings: the expected pattern, the measured share of plan segments that match (n_plans, n_match, observed_share), the top-5 plans, the exceptions and their reading, with the evidence query ids. confidence grades the causal reading rule -> filing. An exception is a question for the plan or the state, never 'noncompliant'.

**Grain.** Key pattern_id: state x plan_year x rule x filing field; the unit counted is a D-SNP plan segment unless match_definition says otherwise.

| column | type | meaning |
|---|---|---|
| pattern_id | string |  |
| state_code | string |  |
| plan_year | int |  |
| rule_id | string |  |
| related_rule_ids | string |  |
| filing_domain | string |  |
| filing_field | string |  |
| applies_to_dsnp_type | string |  |
| expected_pattern | string |  |
| match_definition | string |  |
| n_plans | int |  |
| n_match | int |  |
| observed_share | double |  |
| top5_plans | string |  |
| top5_match | int |  |
| exceptions | string |  |
| exception_reading | string |  |
| explanation | string |  |
| confidence | string |  |
| evidence_query_ids | string |  |
| observed_at | string |  |
| spine_ref | string |  |
| parse_revision | int |  |
| seed_file | string |  |
| seed_sha256 | string |  |

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