# States M2 FFS rate book: vw_state_medicaid_rate_v2

`vlada_curated.vw_state_medicaid_rate_v2` · State programs · status partial · 294,254 rows

Medicaid product M2 (FFS rate book) of the States lane: the state's Medicaid fee-for-service fee schedules, one row per published rate. Filter state and is_current = true, then code (and modifiers, provider_type, setting) before reading rate; rate_type and rate_unit say what the number is (a fee, a percent of Medicare, a per-diem). These are the state's FFS maximums, never managed care negotiated rates. 46 state(s): AK AL AR AZ CA CO CT DC DE FL GA HI IA ID IL IN KY LA MD ME MN MO MS MT NC ND NE NH NJ NM NV NY OH OK OR PA RI SC SD TX UT VA WA WI WV WY.

**Grain.** The state's Medicaid fee-for-service fee schedules, one row per published rate. 294,254 rows (Athena, 2026-10-29). Period 2006-04-03 to 2027-01-01 (edition_effective_date).

| column | type | meaning |
|---|---|---|
| schedule_id | string |  |
| program | string |  |
| provider_type | string |  |
| setting | string |  |
| geography | string |  |
| population | string |  |
| code_system | string |  |
| code | string |  |
| modifiers | string |  |
| description | string |  |
| rate | double |  |
| rate_type | string |  |
| rate_unit | string |  |
| unit_minutes | int |  |
| effective_from | date |  |
| source_end_date | date |  |
| edition_effective_date | date |  |
| source_s3_uri | string |  |
| source_sha256 | string |  |
| source_ref | string |  |
| reader_id | string |  |
| reader_version | string |  |
| extracted_at_utc | string |  |
| notes | string |  |
| state | string |  |
| service_line | string |  |
| effective_to | date |  |
| is_current | boolean |  |
| printed_effective_from | date |  |

Tools that read it: get_medicaid_rate

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