State programs

States M2 FFS rate book: vw_state_medicaid_rate_change_v1

vlada_curated.vw_state_medicaid_rate_change_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: what moved.
2Each 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.
3Filter state (and service_line, effective_from window) before reading.

Grain

Key	Grain
N/A	1One 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). 2423,962 rows, 46 states (Athena, 2026-11-02 15:37Z serve; re-keyed by effective date 16:07Z).

Columns (27)

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

Query it

describe_data_source(source_fqn="vlada_curated.vw_state_medicaid_rate_change_v1")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.vw_state_medicaid_rate_change_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_change_v1")`
Raw door	Athena (read-only via query_substrate): vlada_curated.vw_state_medicaid_rate_change_v1 (filter state or code)

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