State programs

Washington Medicaid provider payments, actual: DSH, HSNA, SDP managed-care / DPH and trauma payments by provider and period (HCA)

medicare_semantic.vw_medicaid_wa_provider_actual_payments_v1·partial·semantic_view

Rows

8,702

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1What Washington Medicaid (HCA) paid hospitals and providers in DSH, hospital safety-net (HSNA CAH grants and FFS), state directed payments through managed care and DPH, and trauma payments, by the publisher's own period, from HCA PDFs and workbooks.
2Re-audited scope only; interim rows are labelled.
3Actual payments, not ceilings.

Grain

Key	Grain
N/A	1One row per provider x program x period_key x metric (source_sha256 + source_locator unique); 28,702 rows, 10 programs, 124 periods (Athena 87ed7b91, 2026-10-19).

Columns (26)

Column	Type	Meaning
`state`	varchar(2)
`program`	string
`program_component`	string
`period_key`	string
`period`	string
`period_note`	string
`from_date`	string
`to_date`	string
`basis`	string
`metric`	string
`payment_kind`	varchar(30)
`paid_usd`	decimal(38,13)
`amount_text`	string
`raw_value`	string
`provider_name`	string
`ccn`	string
`match_method`	string
`match_confidence`	string
`native_ccn`	string
`native_npi`	string
`native_providerone`	string
`source_id`	string
`source_url`	string
`source_sha256`	string
`source_locator`	string
`raw_line`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_sha256,source_locator`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_wa_provider_actual_payments_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_wa_provider_actual_payments_v1 (program = <one> AND period_key = <one>)
Note	Registered 2026-10-19 under register w8 (wa_medicaid_provider_actual_payments) as the only read surface (registration branch codex/medicaid-fedreports). Door RAW, World W8, status partial, class unversioned. The base table medicare_silver.medicaid_wa_provider_actual_payments_v1 is internal: no card, no World, refused NO_COVERAGE. Ships with the MCP lane's next main-based release.

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