State programs

States M2 J-code book: measured pricing basis per state (vw_state_medicaid_jcode_basis_v1)

vlada_curated.vw_state_medicaid_jcode_basis_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The measured J-code pricing basis: what each state actually pays relative to Medicare ASP, per schedule and provider type (one payment basis per median; provider types are never blended).
2Read beside the state's stated method in docs/research/medicaid-ffs/drug_pricing/DRUG-PRICING-METHODS.csv (51 of 51). flat_amount = one rate on half or more of >= 20 rows: an administration amount, not a drug basis (KS mid-level injection $1.73, injection admin $2.30).
3Example 2026-11-05: KS base fee ASP + 6.0% on 590 codes, 532 within one point;
4CA PAD schedule ASP + 6.0%.

Grain

Key	Grain
N/A	1One row per state x schedule x provider type: the median implied ASP+ at the effective quarter, p25 / p75, matched codes, codes within one point, modal_rate_share and flat_amount. 2271 rows, 44 states (Athena, 2026-11-05).

Columns (15)

Column	Type	Meaning
`state`	string
`schedule_id`	string
`provider_type`	string
`n_rates`	bigint
`n_codes`	bigint
`n_matched`	bigint
`median_asp_plus`	double
`p25_asp_plus`	double
`p75_asp_plus`	double
`first_eff`	date
`last_eff`	date
`edition`	date
`n_within_1pt`	bigint
`modal_rate_share`	double
`flat_amount`	boolean

Query it

describe_data_source(source_fqn="vlada_curated.vw_state_medicaid_jcode_basis_v1")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.vw_state_medicaid_jcode_basis_v1 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.vw_state_medicaid_jcode_basis_v1")`
Raw door	Athena (read-only via query_substrate): vlada_curated.vw_state_medicaid_jcode_basis_v1 (filter state; prefer n_matched >= 100 and flat_amount = false; never average across provider types)

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