State programs

Medicaid managed-care plan quality (HEDIS) by plan, the parsed fact without the plan crosswalk

medicare_silver.medicaid_plan_quality_measure_v1·partial·silver

Rows

5,696

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The parsed rates exactly as each state's report prints them (plan_name_raw, program_name_raw, measure_label_raw, sub_measure_raw, rate, rate_raw, rate_flags, denominator, data_source_raw, audited_flag) with lineage on every row.
2It carries no canonical plan id: read medicare_semantic.vw_medicaid_plan_quality_measure_v1, which joins the crosswalk.

Grain

Key	Grain
N/A	1One row per state x program x publisher plan name x measure x sub-measure x measurement year (5,696 rows, Athena a749fcd4).

Columns (22)

Column	Type	Meaning
`state_code`	string
`plan_name_raw`	string
`program_name_raw`	string
`measure_code`	string
`measure_label_raw`	string
`sub_measure_raw`	string
`indicator_code`	string
`measurement_year`	int
`rate`	double
`rate_raw`	string
`rate_flags`	string
`denominator`	bigint
`low_denominator`	boolean
`data_source_raw`	string
`audited_flag`	boolean
`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_silver.medicaid_plan_quality_measure_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.medicaid_plan_quality_measure_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`state_code,program_name_raw,plan_name_raw,indicator_code,measurement_year`
Join	`how_to_join(source_fqn="medicare_silver.medicaid_plan_quality_measure_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.medicaid_plan_quality_measure_v1 (pin state_code and measurement_year)
Note	Registered 2026-10-05 with the view; the view is the customer surface, this table is its evidence.

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