State programs

States M2 home care: reviewed home health and private duty nursing rates (vw_state_medicaid_homecare_v1)

vlada_curated.vw_state_medicaid_homecare_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Home health and private duty nursing rates as each state prints them, classified by a person who read each schedule (docs/research/states/<ST>/HOMECARE-SCHEDULES.csv, evidence per row), not by code: hospice, supplies, waiver, school and facility nursing are left out.
2Final independent check 2026-11-06: 96% of sampled rows correctly classed, dollars 40 of 40 match the state files.
3States that publish no FFS rate (paid through MCOs, cost-based, or case by case) have no rows here; the proof is in each state's ledger.

Grain

Key	Grain
N/A	1One row per rate-book row a reviewed per-state schedule registry names as home health (agency visit rates) or private duty nursing (RN / LPN home nursing), homecare_line in front; a row may appear under both lines when one printed rate is both (IN, AL). 22,500 current home health rows in 46 states, 455 current PDN rows in 47 states (Athena, 2026-11-06).

Columns (33)

Column	Type	Meaning
`homecare_line`	varchar(20)
`comparable_basis`	varchar(14)
`comparable_rate`	double
`rate_variant`	varchar(18)
`schedule_id`	string
`program`	string
`provider_type`	string
`setting`	string
`geography`	string
`population`	string
`code_system`	string
`code`	string
`modifiers`	string
`description`	string
`rate`	double
`rate_type`	string
`rate_unit`	string
`unit_minutes`	int
`effective_from`	date
`source_end_date`	date
`edition_effective_date`	date
`source_s3_uri`	string
`source_sha256`	string
`source_ref`	string
`reader_id`	string
`reader_version`	string
`extracted_at_utc`	string
`notes`	string
`state`	string
`service_line`	string
`effective_to`	date
`is_current`	boolean
`printed_effective_from`	date

Query it

describe_data_source(source_fqn="vlada_curated.vw_state_medicaid_homecare_v1")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.vw_state_medicaid_homecare_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_homecare_v1")`
Raw door	Athena (read-only via query_substrate): vlada_curated.vw_state_medicaid_homecare_v1 (filter homecare_line, state and is_current; read rate_unit on every row; never compare across units)

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