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

`vlada_curated.vw_state_medicaid_jcode_basis_v1` · State programs · status partial

The 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). Read 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). Example 2026-11-05: KS base fee ASP + 6.0% on 590 codes, 532 within one point; CA PAD schedule ASP + 6.0%.

**Grain.** One 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. 271 rows, 44 states (Athena, 2026-11-05).

| 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: `query_substrate` with `SELECT ... FROM vlada_curated.vw_state_medicaid_jcode_basis_v1 WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.vw_state_medicaid_jcode_basis_v1")` first.