VladaOmega
Sign inStart free
State programs

Medicaid plan quality plan-ID crosswalk v1 (publisher plan name to canonical Medicaid plan id)

medicare_silver.medicaid_plan_quality_plan_xwalk_v1·partial·reference
Rows
372
Columns
12
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1Maps each plan name as a state printed it, per program and measurement year, to the canonical medicaid_plan_id + plan_product, with plan_display_name, program_class, parent_name, match_method (Q1_exact 212, Q2_reviewed 160) and basis (the publisher evidence for a reviewed decision).
  2. 2157 printed plans resolve to 127 canonical plans;
  3. 3372 of 372 plan-years resolved.

Grain

KeyGrain
N/A
  1. 1One row per (state_code, program_name_raw, plan_name_raw, measurement_year);
  2. 2372 rows = 372 keys (Athena 6be006f0).

Columns (12)

ColumnTypeMeaning
state_codestring
program_name_rawstring
plan_name_rawstring
measurement_yearint
medicaid_plan_idstring
plan_productstring
plan_display_namestring
program_classstring
parent_namestring
match_methodstring
basisstring
quality_rowsint

Query it

describe_data_source(source_fqn="medicare_silver.medicaid_plan_quality_plan_xwalk_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.medicaid_plan_quality_plan_xwalk_v1 WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keystate_code,program_name_raw,plan_name_raw,measurement_year
Joinhow_to_join(source_fqn="medicare_silver.medicaid_plan_quality_plan_xwalk_v1")
Raw doorAthena (read-only via query_substrate): medicare_silver.medicaid_plan_quality_plan_xwalk_v1
Company namesparent_name resolve to a permanent Vlada ID: resolve_entity(text=<name>); the company pages hold owners and holdings
NoteRegistered 2026-10-05 with the view as a derived reference source; the view is the customer surface.

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