State programs

States M2 FFS rate book: vw_state_medicaid_rate_compare_v1

vlada_curated.vw_state_medicaid_rate_compare_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicaid 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.
2Five-character CPT / HCPCS codes are mapped to code_system HCPCS so cpt and CPT compare together.
3Keys with more than one rate for the same date are left out (1 on 2026-11-02).
4Filter code (and modifiers, basis) before reading; state_rate is the median across the state's unambiguous keys.

Grain

Key	Grain
N/A	1One 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. 2128,547 rows, 48 states (Athena, 2026-11-02).

Columns (27)

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

Query it

describe_data_source(source_fqn="vlada_curated.vw_state_medicaid_rate_compare_v1")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.vw_state_medicaid_rate_compare_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	get_medicaid_rate
Identity key	N/A
Join	`how_to_join(source_fqn="vlada_curated.vw_state_medicaid_rate_compare_v1")`
Raw door	Athena (read-only via query_substrate): vlada_curated.vw_state_medicaid_rate_compare_v1 (filter state or code)

This page as markdown: /docs-md/data/vlada_curated_vw_state_medicaid_rate_compare_v1.md · every page in one file: /llms-full.txt