# States M2 FFS rate book: vw_state_medicaid_rate_compare_v1

`vlada_curated.vw_state_medicaid_rate_compare_v1` · State programs · status partial

Medicaid product M2 (FFS rate book) of the States lane: one code across states on ONE basis. basis is per_hour when the unit is a time unit (rate x 60 / unit_minutes), else the printed unit; a state on another basis is a different row, never converted. Five-character CPT / HCPCS codes are mapped to code_system HCPCS so cpt and CPT compare together. Keys with more than one rate for the same date are left out (1 on 2026-11-02). Filter code (and modifiers, basis) before reading; state_rate is the median across the state's unambiguous keys.

**Grain.** One row per state x code_system x code x modifiers x basis: the rate in force today (the latest dated rate on or before today for a key the current edition still prints), with the national median / p25 / p75 across states on the same basis, the state''s ratio and rank. 128,547 rows, 48 states (Athena, 2026-11-02).

| column | type | meaning |
|---|---|---|
| state | string |  |
| code_system | string |  |
| code | string |  |
| modifiers | string |  |
| basis | string |  |
| service_line | string |  |
| state_rate | double |  |
| state_min | double |  |
| state_max | double |  |
| n_rows | bigint |  |
| effective_from | date |  |
| edition_effective_date | date |  |
| description | string |  |
| source_sha256 | string |  |
| source_ref | string |  |
| n_states | bigint |  |
| national_median | double |  |
| national_p25 | double |  |
| national_p75 | double |  |
| ratio_to_national_median | double |  |
| rank_high_to_low | bigint |  |
| unit_minutes_source | varchar(14) |  |
| hcpcs_dosage | string |  |
| setting_basis | varchar(12) |  |
| figure_basis | varchar(8) |  |
| n_rates_printed | bigint |  |
| tie_on | string |  |

Tools that read it: get_medicaid_rate

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