# States M2 FFS rate book: vw_state_medicaid_rate_change_v1

`vlada_curated.vw_state_medicaid_rate_change_v1` · State programs · status partial

Medicaid product M2 (FFS rate book) of the States lane: what moved. Each rate is dated by its own effective date (cumulative schedules reprint old rates in every edition; the latest edition printing a dated rate wins); a change is one key whose rate differs from its previous dated rate, with prev_effective_from, effective_from, prev_rate, rate, change_kind, pct_change. ambiguous_key marks a printing with more than one rate for the same date; never average one. Filter state (and service_line, effective_from window) before reading.

**Grain.** One row per rate key per dated rate that moved against the previous dated rate (increase / decrease), or a code that first appears after the schedule''s first dated rate (new_code). 423,962 rows, 46 states (Athena, 2026-11-02 15:37Z serve; re-keyed by effective date 16:07Z).

| column | type | meaning |
|---|---|---|
| state | string |  |
| schedule_id | string |  |
| service_line | string |  |
| code_system | string |  |
| code | string |  |
| modifiers | string |  |
| program | string |  |
| provider_type | string |  |
| setting | string |  |
| geography | string |  |
| population | string |  |
| rate_unit | string |  |
| rate_type | string |  |
| description | string |  |
| unit_minutes | int |  |
| prev_effective_from | date |  |
| effective_from | date |  |
| edition_effective_date | date |  |
| prev_rate | double |  |
| rate | double |  |
| change_kind | varchar(8) |  |
| pct_change | double |  |
| ambiguous_key | boolean |  |
| source_sha256 | string |  |
| source_ref | string |  |
| spans_missing_edition | boolean |  |
| prior_held_edition | date |  |

Tools that read it: get_medicaid_rate

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