# States W4 Medicare in the state: vw_state_medicare_ny_v1

`medicare_semantic.vw_state_medicare_ny_v1` · Medicare Advantage, Part D, Medicaid · status partial · 438,270 rows

State 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. One view per state (vw_state_medicare_<st>_v1). Filter 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). 1 state(s): NY.

**Grain.** Medicare in the state: MA enrollment, plans and parents by county and year, Original Medicare, and the plan-county rows. 438,270 rows (Athena, 2026-10-29). Period 2019 to 2027 (period_year).

| 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: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_state_medicare_ny_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_state_medicare_ny_v1")` first.