Medicare Advantage, Part D, Medicaid

States W4 Medicare in the state: vw_state_medicare_sc_v1

medicare_semantic.vw_state_medicare_sc_v1·partial·semantic_view

Rows

325,937

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1State product W4 (Medicare in the state) of the States lane: Medicare in the state: MA enrollment, plans and parents by county and year, Original Medicare, and the plan-county rows.
2One view per state (vw_state_medicare_<st>_v1).
3Filter row_kind first (e.g. plan_county_year), then measure; value is one measure per row, so never sum across measures. canonical_parent_id is dated (parent_as_of).
41 state(s): SC.

Grain

Key	Grain
N/A	1Medicare in the state: MA enrollment, plans and parents by county and year, Original Medicare, and the plan-county rows. 2325,937 rows (Athena, 2026-10-29). 3Period 2019 to 2027 (period_year).

Columns (26)

Column	Type	Meaning
`row_kind`	varchar(16)
`state_code`	varchar(2)
`county_fips`	string
`county_name`	string
`period_year`	bigint
`period_month`	date
`period_grain`	varchar(13)
`measure`	varchar(23)
`value`	double
`value_lower`	double
`value_upper`	double
`contract_id`	string
`plan_id`	string
`canonical_parent_id`	string
`canonical_parent_name`	string
`parent_as_of`	date
`parent_method_tier`	string
`parent_changed_in_year`	boolean
`integration_status`	string
`plan_type`	string
`source_table`	varchar(54)
`source_url`	string
`source_sha256`	string
`locator`	string
`line`	varchar(8)
`row_key`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="medicare_semantic.vw_state_medicare_sc_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_state_medicare_sc_v1 (filter state_code)
Company names	`canonical_parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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