State programs

Medicaid managed-care plan quality (HEDIS) by plan, 15 states, the newest three measurement years each publishes

medicare_semantic.vw_medicaid_plan_quality_measure_v1·partial·semantic_view

Rows

5,696

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Ten fixed HEDIS measures (W30, WCV, CIS10, PPC_PRE, PPC_POST, CBP, HBA1C_LT8, BCS, FUH7, FUM7) by Medicaid managed-care plan for 15 states (TX NY CA FL PA OH IL MI NC GA WA NJ AZ VA KY), as each state and its EQRO publish them: the fact (medicare_silver.medicaid_plan_quality_measure_v1) LEFT JOIN the plan crosswalk, so every row carries the canonical medicaid_plan_id, plan_product, plan_display_name, program_class and parent_name.
2Plan names stay as printed. rate is 0-1; a cell the publisher prints without a rate (NA, N/A, NR, a dash, See footnote, blank) is a row with NULL rate and the marker in rate_raw, never a zero.

Grain

Key	Grain
N/A	1One row per state x program x publisher plan name x measure x sub-measure x measurement year; 2(medicaid_plan_id, plan_product, indicator_code, measurement_year) is unique: 5,696 rows = 5,696 keys (Athena 0e9266f8, 3f142481).

Columns (28)

Column	Type	Meaning
`state_code`	string
`program_name_raw`	string
`plan_name_raw`	string
`measure_code`	string
`indicator_code`	string
`measure_label_raw`	string
`sub_measure_raw`	string
`measurement_year`	int
`rate`	double
`rate_raw`	string
`rate_flags`	string
`denominator`	bigint
`low_denominator`	boolean
`data_source_raw`	string
`audited_flag`	boolean
`medicaid_plan_id`	string
`plan_product`	string
`plan_display_name`	string
`program_class`	string
`parent_name`	string
`plan_id_match_method`	string
`document_url`	string
`sha256_content_hash`	string
`evidence_locator`	string
`parse_revision`	string
`semantic_row_sha256`	string
`bronze_object_key`	string
`s3_version_id`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`medicaid_plan_id,plan_product,indicator_code,measurement_year`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_plan_quality_measure_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_plan_quality_measure_v1 (pin state_code and measurement_year)
Company names	`parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Registered 2026-10-05 (MCP product lane) from the coordinator register card in the record (Data Tracker program, PR 3111). Door RAW. status partial: 15 states, three measurement years each at most. Versioned, never overwritten.

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