# CMS ZIP5 → PFS Locality Crosswalk (authoritative)

`medicare_silver.medicare_zip5_locality` · Medicare Advantage, Part D, Medicaid · status live · 687,053 rows

The authoritative CMS Zip Code to Carrier Locality File (ZIP5) — maps every 5-digit ZIP to its Medicare PFS pricing locality (+ carrier/MAC, state, rural indicator). This is the routing table GPCI localization needs to price a professional claim to the provider's geography. It supersedes medicare_zip_to_locality, which collapsed big-metro ZIPs into rest-of-state. Annual end-of-year ZIP5 history is loaded for 2011-2025 plus the current 2026Q3 file; 94110 -> SF locality 05, 90001 -> LA 18, 10001 -> Manhattan 01.

**Grain.** One row per (loaded year, 5-digit ZIP) from the CMS Zip Code to Carrier Locality File (ZIP5) \u2014 state, carrier/MAC, PFS pricing locality, rural indicator, and CMS year-quarter.

| column | type | meaning |
|---|---|---|
| year | int |  |
| row_seq | bigint |  |
| zip_code | string |  |
| state | string |  |
| carrier | string |  |
| locality_number | string |  |
| rural_indicator | string |  |
| year_quarter | string |  |
| 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: `query_substrate` with `SELECT ... FROM medicare_silver.medicare_zip5_locality WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.medicare_zip5_locality")` first.