Medicare Advantage, Part D, Medicaid

CMS Medicare Ambulance Fee Schedule (AFS) Public Use File

medicare_silver.fact_ambulance_fee_schedule·live·silver·CMS Medicare Ambulance Fee Schedule (AFS) Public Use File

Rows

29,160

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The standalone CMS Medicare Ambulance Fee Schedule (AFS PUF) — per HCPCS (A0425-A0436 + mileage) × carrier × locality: RVU, GPCI, base rate, and urban/rural base + mileage rates.
2NOT inside PFS/OPPS/CLFS/DMEPOS/ASC; the reference benchmark for repricing ambulance claims (a top balance-billing / overpayment category). ~1.3k rows/year, CY2004-CY2026, partition by year;
3CY2004 is represented by two effective-period half-year vintages.

Grain

Key	Grain
N/A	1One row per (year, effective_period_start, effective_period_end, HCPCS × carrier × locality) — ambulance fee-schedule rates.

Columns (27)

Column	Type	Meaning
`year`	int
`row_seq`	bigint
`hcpcs`	string
`contractor_carrier`	string
`locality`	string
`rvu`	double
`gpci`	double
`base_rate`	double
`urban_base_or_mileage`	double
`rural_base_or_mileage`	double
`rural_base_lowest_quartile`	double
`rural_ground_miles_1_17`	double
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`hcpcs`
Join	`how_to_join(source_fqn="medicare_silver.fact_ambulance_fee_schedule")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_ambulance_fee_schedule
Note	Iceberg medicare_silver.fact_ambulance_fee_schedule, partition by year, replace. Source = cms.gov AFS PUF annual/semiannual zip. Current proof: 29,160 rows, CY2004-CY2026, 24 source hashes, zero lineage-null rows, zero duplicate effective-period keys.

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