# Clinical Laboratory Fee Schedule, local amounts by carrier locality

`medicare_silver.medicare_clfs_locality_rates` · Medicare Advantage, Part D, Medicaid · status live · 1,051,939 rows

The CLFS by carrier locality: base fee, national limitation amount, median and pricing amount at the 60% and 62% levels, with the gap-fill indicator, per release. The national table (fact_clfs_national_rate) holds the limit only; this holds the local amounts.

**Grain.** One row per (release_label, hcpcs_code, modifier, carrier, locality): the local fee amounts and national limit for a lab code.

| column | type | meaning |
|---|---|---|
| release_label | string |  |
| calendar_year | int |  |
| effective_date | date |  |
| hcpcs_code | string |  |
| modifier | string |  |
| carrier | string |  |
| locality | string |  |
| carrier_locality | string |  |
| base_fee_amount_60_pct | double |  |
| base_fee_amount_62_pct | double |  |
| national_limit_amount_60_pct | double |  |
| national_limit_amount_62_pct | double |  |
| median_amount_60_pct | double |  |
| pricing_amount_60_pct | double |  |
| pricing_amount_62_pct | double |  |
| gap_fill_indicator | string |  |
| short_descriptor | string |  |
| floor_amount_60_pct | double |  |
| source_zip_url | string |  |
| source_zip_sha256 | string |  |
| source_member | string |  |
| source_member_sha256 | string |  |
| asserted_at | date |  |
| created_at | timestamp |  |
| source_id | string |  |
| is_current | boolean |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.medicare_clfs_locality_rates WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.medicare_clfs_locality_rates")` first.