Medicare Advantage, Part D, Medicaid

Vlada Landscape disposition, every September member placed against next year's Landscape file, 2023 to 2027

medicare_semantic.fact_landscape_disposition_v1·live·mart

Rows

419,954

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The served grain of the defined Landscape analysis (Ben 2026-09-25, tools/ma_brain/landscape_analysis.py): every September-Y member (H/R contracts, plans 001-799) matched to the Y Landscape by plan and county, then placed against the Y+1 file: continues, or departing in five Day-One buckets (D1 same-named plan in the county, D2 plan sold elsewhere, D3 contract in the county, D4 parent in the county, D5 parent gone).
2Where the Y+1 crosswalk is held (2024 to 2026) truth_class says what really happened (moved, split, stranded_sar, terminated).
3Every cell of 2026 to 2027 was recomputed from the raw CMS zips with 0 differences (landscape_table_audit.py, 2026-09-28) and every partition checked 0-diff against the lane's CSVs.
4Tool: get_landscape_exits, which since 2026-09-30 also groups by county (state required) and filters to one county; the industry scope is product_type_y NOT IN ('non-SNP Cost', 'non-SNP MMP'), with which the four bases tie to 25,970,589 / 27,665,108 / 28,931,650 / 29,855,373 members (measured 2026-09-30).

Grain

Key	Grain
N/A	1One row per transition_year (2023 to 2026, partition) x parent x state x county x product_type_y x product_type_y1 x dayone_bucket x truth_class, with cells (plan-county cells) and members (September-Y enrollment). 2419,954 rows over four transitions (measured 2026-09-29).

Columns (15)

Column	Type	Meaning
`parent`	string
`state`	string
`county`	string
`product_type_y`	string
`product_type_y1`	string
`dayone_bucket`	string
`truth_class`	string
`cells`	bigint
`members`	bigint
`next_year`	int
`enrollment_month`	date
`l0_edition`	string
`l1_edition`	string
`crosswalk_held`	boolean
`built_at`	string

Query it

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

Item	Value
Typed tools that read it	get_county_view, get_landscape_exits
Identity key	`transition_year,parent,state,county,product_type_y,product_type_y1,dayone_bucket,truth_class`
Join	`how_to_join(source_fqn="medicare_semantic.fact_landscape_disposition_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.fact_landscape_disposition_v1

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