Medicare Advantage, Part D, Medicaid

Vlada benefit reading, allowance dollars like for like (edition v20261018b), same members base -> next year

medicare_semantic.vw_benefit_reading_cells_sd·live·mart

Rows

691,438

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Allowance dollars on paired members (book followed <-> next), like for like: level = sd_<k>_l0 / w and sd_<k>_l1 / w; sd_<k>_sw = members whose design changed form (a design change, never a raise or a cut).
2Pointer -> medicare_semantic.benefit_company_cells_sd_v20261018b.
3Owner: the Benefits lane.

Grain

Key	Grain
N/A	1One row per base_year x lvl x state x county_ssa x bucket x plan_type x parent.

Columns (30)

Column	Type	Meaning
`base_year`	int
`value_year`	int
`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.vw_benefit_reading_cells_sd")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_benefit_reading_cells_sd WHERE <filter> LIMIT 100")

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

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