State programs

State duals knowledge base v5: plan effective benefit

medicare_silver.state_duals_kb_plan_effective_benefit_v5·live·silver

Rows

540

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Cited, curated state-by-state knowledge of what Medicaid gives each dual category and who pays (current version v5: v1 seeds + CA/FL/TX/PA/NJ depth + wave-3 and wave-4 demand-driven depth, under neutral source and rule ids).
2Every row carries source_id, a verbatim quote + locator on exact rows, confidence (exact / rule / judged), effective dates and spine_ref.
3Seeds pipelines/medicare/data/state_duals_kb/v1..v4 through v5/neutralise_v5.yaml; row contract pipelines/medicare/dsnp_wrap/kb.py.

Grain

Key	Grain
N/A	1Key effective_benefit_id. 2Spine: 9 coverage x 3 population x 1 organization (contract-plan) x D-SNP integration.

Columns (25)

Column	Type	Meaning
`effective_benefit_id`	string
`state_code`	string
`plan_year`	int
`contract_id`	string
`plan_id`	string
`segment_id`	string
`plan_label_raw`	string
`integration_type`	string
`dual_category`	string
`dual_category_raw`	string
`medicaid_arrangement`	string
`medicaid_arrangement_note`	string
`benefit_raw`	string
`dsnp_layer`	string
`medicaid_layer`	string
`effective_benefit`	string
`rule_ids`	string
`external_rule_ids`	string
`external_confidence`	string
`confidence`	string
`source_id`	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_plan_effective_benefit_v5")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.state_duals_kb_plan_effective_benefit_v5 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`effective_benefit_id`
Join	`how_to_join(source_fqn="medicare_silver.state_duals_kb_plan_effective_benefit_v5")`
Raw door	Athena (read-only via query_substrate): medicare_silver.state_duals_kb_plan_effective_benefit_v5
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_plan_effective_benefit_v5.md · every page in one file: /llms-full.txt