Spatial filtering
Filter any dataset by city, county, metro area, or Census region instantly — without any GIS software. Use the included lat/lng coordinates to calculate distances or cluster ZIP codes geographically.
City, county, state, metro area, latitude/longitude, land area, time zone, Census region, and population density for every US ZIP code — pre-joined and ready to use.
How to use this data
Spatial filtering
Filter any dataset by city, county, metro area, or Census region instantly — without any GIS software. Use the included lat/lng coordinates to calculate distances or cluster ZIP codes geographically.
AI-powered analysis
Ask Claude or ChatGPT questions like "Which ZIP codes are in the Nashville metro?" or "Show me all ZIPs within 50 miles of Denver" — the geographic reference columns make location queries natural and fast.
Enriching your own data
Join your customer or transaction data to the EnrichZip file by ZIP code and immediately add metro area, county, timezone, and population density to every record — no lookup tables needed.
Market segmentation
Segment your analysis by Census region (Northeast, Midwest, South, West), urban vs. rural density, or metro vs. non-metro classification — groupings that are pre-computed and immediately available.
Columns Included
Source: GeoNames database and US Census Bureau. All columns are pre-joined with no additional API access or geocoding required.
| Column Name | Description |
|---|---|
city | Primary city name for the ZIP code |
county | County name |
state | State abbreviation (e.g. TX, CA) |
state_name | Full state name |
cbsa_name | Core Based Statistical Area (metro/micro area) |
cbsa_type | Metropolitan or Micropolitan |
census_region | Census Bureau region (Northeast, Midwest, South, West) |
census_division | Census Bureau division (9 divisions within 4 regions) |
latitude | ZIP code centroid latitude |
longitude | ZIP code centroid longitude |
land_area_sq_miles | Land area in square miles |
timezone | Timezone (e.g. America/Chicago) |
population_density | Population per square mile |
urban_rural_classification | Urban, suburban, or rural designation |
About This Data
Geographic reference data is the scaffolding that makes all other ZIP code data more useful. Knowing that ZIP code 60614 is in Cook County, in the Chicago metro area, in the Midwest Census division, at latitude 41.92° and longitude -87.64° — this context turns a row of numbers into a place you can reason about.
EnrichZip assembles geographic reference data from two primary sources. The GeoNames database provides city names, counties, and geographic coordinates for each ZIP code. The US Census Bureau provides CBSA (Core Based Statistical Area) designations, Census regions and divisions, and land area measurements from their TIGER/Line shapefiles.
These columns are particularly valuable for AI analysis. Language models reason well about place names but struggle with raw FIPS codes and coordinate pairs. By including city, county, metro area name, and region as text columns, EnrichZip makes geographic queries natural: "Show me all ZIP codes in the Dallas–Fort Worth metro" or "Filter to just Midwest ZIPs with income above $70k" work directly without any joins or lookups.
Population density — calculated from Census population divided by land area — adds a crucial urban/rural dimension that's not captured in raw population counts. A ZIP code with 10,000 people in 2 square miles (Brooklyn) is fundamentally different from one with 10,000 people in 800 square miles (rural Montana).