# Louisiana Medicaid hospital payments, actual: DSH and supplemental payments by hospital, year-to-date snapshots (LDH legislative report item F, SFY2023-2026)

`medicare_semantic.vw_medicaid_la_hospital_actual_payments_v1` · State programs · status partial · 119 rows

What Louisiana Medicaid reported paying each hospital in disproportionate share (DSH) and other supplemental payments, from the Louisiana Department of Health's legislative hospital reports (item F, 'other supplemental'), as year-to-date snapshots for SFY2023-2026. DSH and supplemental are separate rows; the report's per-hospital total is a control, not served. Each row carries its coverage months and period, the Medicaid provider ID, a CCN only where CMS POS proves it active and unique, and the PDF (source_url, source_sha256), page and line. Actual reported payments, not ceilings and not modeled allocations.

**Grain.** One row per Medicaid provider ID x snapshot x program_component (DSH or SUPPLEMENTAL); row_key unique. 119 rows, 42 providers, four year-to-date snapshots SFY2023_Q3, SFY2024_Q4, SFY2025_Q2, SFY2026_Q3 (Athena 7a3481e4, ac94dc27, 2026-10-19).

| column | type | meaning |
|---|---|---|
| state | varchar(2) |  |
| program_component | string |  |
| sfy | bigint |  |
| report_quarter | bigint |  |
| snapshot | string |  |
| coverage_months | bigint |  |
| period_start | string |  |
| period_end | string |  |
| period_coverage | varchar(20) |  |
| payment_kind | varchar(30) |  |
| amount_usd | decimal(38,2) |  |
| amount_status | string |  |
| money_direction | string |  |
| medicaid_provider_id | string |  |
| provider_name | string |  |
| ccn | string |  |
| identity_null_reason | string |  |
| identity_candidates | string |  |
| match_method | string |  |
| match_confidence | string |  |
| identity_temporal_limit | string |  |
| mapped_npi | string |  |
| native_period | string |  |
| period_rule | string |  |
| program_family | string |  |
| source_id | string |  |
| source_url | string |  |
| source_sha256 | string |  |
| page | string |  |
| line | string |  |
| locator | string |  |
| raw_line | string |  |
| row_key | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_medicaid_la_hospital_actual_payments_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_medicaid_la_hospital_actual_payments_v1")` first.