# States M2 FFS rate book: vw_state_medicaid_rate_vs_medicare_v1

`vlada_curated.vw_state_medicaid_rate_vs_medicare_v1` · State programs · status partial

Medicaid product M2 (FFS rate book) of the States lane: Medicaid as a share of Medicare. medicare_rate is the Medicare Physician Fee Schedule non-facility amount, no modifier, the unweighted mean of the state's localities for the latest PFS year held (medicare_year, medicare_localities); medicaid_pct_of_medicare = medicaid_rate / medicare_rate. Only Medicaid rows with a per-service / unit / visit / 15_min unit and a 5-character CPT / HCPCS code join. Filter state (and code) before reading.

**Grain.** One row per state x schedule x program x provider_type x setting x geography x population x code (no modifier, one printed rate): the Medicaid rate in force beside the Medicare PFS non-facility rate for the same code in the same state. 145,476 rows, 36 states (Athena, 2026-11-02).

| column | type | meaning |
|---|---|---|
| state | string |  |
| schedule_id | string |  |
| program | string |  |
| provider_type | string |  |
| setting | string |  |
| geography | string |  |
| population | string |  |
| code | string |  |
| service_line | string |  |
| rate_unit | string |  |
| medicaid_rate | double |  |
| effective_from | date |  |
| edition_effective_date | date |  |
| description | string |  |
| source_sha256 | string |  |
| source_ref | string |  |
| medicare_year | int |  |
| medicare_localities | bigint |  |
| medicare_rate | double |  |
| medicare_basis | varchar(81) |  |
| medicaid_pct_of_medicare | double |  |

Tools that read it: get_medicaid_rate

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