State programs

States M2 FFS rate book: vw_state_medicaid_rate_vs_medicare_v1

vlada_curated.vw_state_medicaid_rate_vs_medicare_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: 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.
2Only Medicaid rows with a per-service / unit / visit / 15_min unit and a 5-character CPT / HCPCS code join.
3Filter state (and code) before reading.

Grain

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

Columns (21)

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

Query it

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

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