State programs

State Medicaid Fee Schedule (rate per CPT/HCPCS)

vlada_curated.fact_state_medicaid_rate·live·silver·State Medicaid Fee Schedule (rate per CPT/HCPCS)

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Per-state Medicaid rate per code (the Medicaid floor).
2MD professional ingested (9,152).
3Tool ingest_state_medicaid.py;
4M-2 temporal.

Grain

Key	Grain
N/A	1One row per (state, procedure/HCPCS) — Medicaid allowed rate.

Columns (9)

Column	Type	Meaning
`billing_code`	string
`code_description`	string
`non_facility_rate`	double
`facility_rate`	double
`technical_component`	double
`source_url`	string
`content_sha256`	string
`asserted_at`	string
`is_current`	boolean

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="vlada_curated.fact_state_medicaid_rate")`
Raw door	query_substrate

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