# 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` · State programs · status partial · 8,702 rows

What 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. Re-audited scope only; interim rows are labelled. Actual payments, not ceilings.

**Grain.** One row per provider x program x period_key x metric (source_sha256 + source_locator unique); 8,702 rows, 10 programs, 124 periods (Athena 87ed7b91, 2026-10-19).

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