Medicare Advantage, Part D, Medicaid

Vlada locked 2027 allowance dollars like for like by company (v20261007a), same members 2026 vs 2027, dental / hearing / OTC / eyewear / flex card

medicare_semantic.benefit_company_cells_sd_v20261007a·live·mart

Rows

138,014

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Allowance dollars like for like (REPORT-FAMILY-PLAN.md section 0; rule in benefits_same_design.py): each 2026 continuing member (atoms kind = book, followed) paired 1:1 with their 2027 plan (kind = next, same county_ssa + base_key, same weight).
2For each allowance k in dental, hearing, OTC, eyewear and card: sd_<k>_l0 / sd_<k>_l1 = SUM(w x PMPM dollars) in 2026 / 2027 over the comparable pairs (same form both years, or offered without a stated amount both years), so the 2026 and 2027 levels are sd_<k>_l0 / w and sd_<k>_l1 / w and the like-for-like change is (sd_<k>_l1 - sd_<k>_l0) / w; sd_<k>_sw = members whose design changed form (a form switch is a design change, never a raise or a cut) and sd_<k>_kn = members with the design known both years.
3Tie-out: 7,250 values against same_design.json, 0 mismatches.
4Versioned, never replaced.
5Owner: the Benefits lane.

Grain

Key	Grain
N/A	1One row per lvl x state x county_ssa x bucket x plan_type x parent, the same keys and 'ALL' rollups as benefit_company_cells_v20261007a without per (every row is the paired 2026 -> 2027 members). 2138,014 rows (county 133,094, state 4,035, national 885; 3CELLS-MANIFEST.md 2026-10-07).

Columns (28)

Column	Type	Meaning
`lvl`	varchar(8)
`state`	string
`county_ssa`	string
`county_name`	string
`bucket`	string
`plan_type`	string
`parent`	string
`w`	double
`sd_dental_l0`	double
`sd_dental_l1`	double
`sd_dental_sw`	double
`sd_dental_kn`	double
`sd_hearing_l0`	double
`sd_hearing_l1`	double
`sd_hearing_sw`	double
`sd_hearing_kn`	double
`sd_otc_l0`	double
`sd_otc_l1`	double
`sd_otc_sw`	double
`sd_otc_kn`	double
`sd_eyewear_l0`	double
`sd_eyewear_l1`	double
`sd_eyewear_sw`	double
`sd_eyewear_kn`	double
`sd_card_l0`	double
`sd_card_l1`	double
`sd_card_sw`	double
`sd_card_kn`	double

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`lvl,state,county_ssa,bucket,plan_type,parent`
Join	`how_to_join(source_fqn="medicare_semantic.benefit_company_cells_sd_v20261007a")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.benefit_company_cells_sd_v20261007a

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