State programs

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·live·silver

Rows

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1For 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.
2An exception is a question for the plan or the state, never 'noncompliant'.

Grain

Key	Grain
N/A	1Key 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.

Columns (25)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`pattern_id`
Join	`how_to_join(source_fqn="medicare_silver.state_duals_kb_filing_patterns_v2")`
Raw door	Athena (read-only via query_substrate): medicare_silver.state_duals_kb_filing_patterns_v2
Note	Registered 2026-10-12 under register source state_duals_kb (W8) as the successor of the v4 object (same facts under neutral ids). Serving takes effect with the next MCP bridge release.

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