Public Dataset

US ZIP Code Geographic Reference

A comprehensive geographic reference for 33,791 U.S. ZIP codes (ZCTAs) combining Census Bureau Gazetteer coordinates with ZCTA-to-county relationship data. Each ZIP code includes state, primary county (based on largest land area overlap), latitude/longitude centroid, and land/water area. Ideal as a join table to enrich any ZIP code-based dataset with geographic context.

grid_on
33.8K rows9 columns2.1 MB

Try asking

Data Preview

zip_codestate_fipsstatecounty_fipscounty_namelatitudelongitudeland_area_sq_miwater_area_sq_mi
60172PR72001Adjuntas Municipio18.180555-66.74996164.4160.308
60272PR72003Aguada Municipio18.361945-67.17559730.3271.71
60372PR72005Aguadilla Municipio18.457399-67.12486734.3562.414
60672PR72093Maricao Municipio18.158327-66.93292844.3340.005
61072PR72011Añasco Municipio18.295304-67.1251837.1241.656
61172PR72141Utuado Municipio18.276316-66.80716510.6490.001
61272PR72013Arecibo Municipio18.416727-66.7000976.2545.797
61672PR72013Arecibo Municipio18.420408-66.67198610.8790.07
61772PR72017Barceloneta Municipio18.446889-66.56115418.3430.654
62272PR72023Cabo Rojo Municipio17.988103-67.16035731.1687.561
62372PR72023Cabo Rojo Municipio18.084371-67.15876539.1985.48
62472PR72111Peñuelas Municipio18.051808-66.72171146.9975.909
62772PR72027Camuy Municipio18.412423-66.86370846.4471.306
63172PR72001Adjuntas Municipio18.184294-66.8307953.1260.274
63672PR72125San Germán Municipio18.1636-67.0800970.3670
63772PR72121Sabana Grande Municipio18.080103-66.94797535.1610.01
63872PR72039Ciales Municipio18.280188-66.51311171.4010.185
64172PR72141Utuado Municipio18.268074-66.70178584.1061.332
64672PR72051Dorado Municipio18.432897-66.28649921.0521.257
64772PR72055Guánica Municipio17.963613-66.94712715.7993.079
65072PR72054Florida Municipio18.349209-66.57811231.740.213
65272PR72013Arecibo Municipio18.448446-66.5941116.440.02
65372PR72055Guánica Municipio17.988642-66.9016922.1122.024
65672PR72059Guayanilla Municipio18.040467-66.7896842.1444.049
65972PR72065Hatillo Municipio18.407304-66.80899541.0211.169
66072PR72067Hormigueros Municipio18.134695-67.11619911.3180
66272PR72071Isabela Municipio18.468301-67.01574941.2712.054
66472PR72073Jayuya Municipio18.21033-66.59161646.9060.001
66772PR72079Lajas Municipio18.003422-67.0358160.20710.907
66972PR72081Lares Municipio18.276925-66.86958764.1180.034
67072PR72083Las Marías Municipio18.233585-66.98758546.5080.145
67472PR72091Manatí Municipio18.424145-66.48789543.4532.657
67672PR72099Moca Municipio18.381597-67.08088448.8530.022
67772PR72117Rincón Municipio18.332568-67.22702214.5691.388
67872PR72115Quebradillas Municipio18.430503-66.93047929.1261.815
68072PR72097Mayagüez Municipio18.183493-67.13305464.3057.653
68272PR72097Mayagüez Municipio18.224864-67.15389116.313.112
68372PR72125San Germán Municipio18.1078-67.03726349.2890.011
68572PR72131San Sebastián Municipio18.336887-66.97292978.6940.438
68772PR72101Morovis Municipio18.318017-66.42039238.8710.054
68872PR72013Arecibo Municipio18.382305-66.62639332.5030.027
69072PR72005Aguadilla Municipio18.493543-67.0969152.2620.003
69272PR72143Vega Alta Municipio18.410652-66.33620226.5260.771
69372PR72145Vega Baja Municipio18.425961-66.39809844.4092.061
69472PR72145Vega Baja Municipio18.483127-66.392360.7990.756
69872PR72153Yauco Municipio18.072916-66.8511962.6590.629
70372PR72007Aguas Buenas Municipio18.248401-66.13066231.0220.011
70472PR72123Salinas Municipio17.973168-66.2290118.9960.78
70572PR72009Aibonito Municipio18.12896-66.26669130.4060.026
70772PR72095Maunabo Municipio18.014055-65.92075120.9251.474

Showing 50 of 33,791 rows

What You Can Do

Joining ZIP code-based datasets with county or state information
Adding latitude/longitude coordinates to address data
Mapping ZIP codes to their primary county and state
Calculating distances between ZIP codes
Enriching customer or business data with geographic context
Cross-referencing ZIP codes with county-level datasets

Data Dictionary

ColumnTypeDescription
zip_codetext5-digit ZIP Code (ZCTA)
state_fipstext2-digit state FIPS code
statetext2-letter state abbreviation
county_fipstext5-digit county FIPS code (state + county)
county_nametextCounty name (primary county by land area overlap)
latitudedecimalLatitude of ZIP code centroid
longitudedecimalLongitude of ZIP code centroid
land_area_sq_midecimalLand area in square miles
water_area_sq_midecimalWater area in square miles

Explore More Datasets

Discover other public datasets and live API connections you can chat with.

Federal Reserve Bank of St. Louis
Live API

FRED (Federal Reserve Economic Data) API

Access 800,000+ economic time series from the Federal Reserve — GDP, unemployment, inflation, interest rates, and more.

Federal Reserve Bank of St. Louis

U.S. Department of Labor
Live API

Bureau of Labor Statistics

U.S. employment, unemployment, inflation (CPI), wages, and productivity data from the Bureau of Labor Statistics.

U.S. Department of Labor

U.S. Securities and Exchange Commission
Live API

SEC EDGAR

10-K, 10-Q, 8-K, proxy statements, insider trades, and XBRL financial data from all SEC corporate filings.

U.S. Securities and Exchange Commission

The World Bank Group
Live API

World Bank Development Indicators

Nearly 16,000 development indicators covering GDP, population, health, education, and trade for 200+ countries.

The World Bank Group

U.S. Department of the Treasury
Live API

USA Spending Federal Government Spending

Free, comprehensive U.S. federal spending data covering contracts, grants, loans, and financial assistance across all government agencies.

U.S. Department of the Treasury

Frankfurter / European Central Bank
Live API

Frankfurter Currency Exchange Rates

Free currency exchange rates and conversion data from the European Central Bank, updated daily with 30+ currencies and historical data back to 1999.

Frankfurter / European Central Bank

U.S. Census Bureau
Live API

U.S. Census Bureau API

Over 1,700 Census datasets covering demographics, housing, income, employment, and business data at all geographic levels.

U.S. Census Bureau

Census Demographics by ZIP Code & DMA
File

Census Demographics by ZIP Code & DMA

ZIP-level population, age, race, and ethnicity data from the 2024 ACS with DMA market area mappings.

U.S. Census Bureau

IRS Income Statistics by ZIP Code (2022)
File

IRS Income Statistics by ZIP Code (2022)

ZIP-level income tax data with AGI brackets, income sources, deductions, and credits for 27,590 ZIP codes.

IRS Statistics of Income (SOI)

National Weather Service (NOAA)
Live API

National Weather Service

Current conditions, forecasts, and severe weather alerts for U.S. locations via the National Weather Service.

National Weather Service (NOAA)

NOAA National Centers for Environmental Information
Live API

NOAA Climate Data Online

Historical weather observations, climate normals, and records from global stations (some dating back to 1763).

NOAA National Centers for Environmental Information

EPA AirNow Program
Live API

EPA AirNow Air Quality

Real-time and forecast Air Quality Index (AQI) data for PM2.5, PM10, and ozone across the US, Canada, and Mexico.

EPA AirNow Program

Centers for Medicare & Medicaid Services
Live API

CMS Medicare Provider Data

U.S. Medicare provider quality ratings, hospital comparisons, nursing home inspections, physician data, and healthcare spending from CMS.gov.

Centers for Medicare & Medicaid Services

USGS Earthquake Hazards Program
Live API

USGS Earthquake Catalog

Real-time and historical earthquake data worldwide including magnitude, location, depth, and tsunami alerts from the USGS.

USGS Earthquake Hazards Program

U.S. Geological Survey
Live API

USGS Water Data

Real-time and historical U.S. water data including streamflow, water levels, water quality, and groundwater measurements from USGS monitoring stations nationwide.

U.S. Geological Survey

U.S. Department of Education
Live API

College Scorecard

Institution-level and field-of-study data for 6,500+ colleges including costs, earnings, graduation rates, and admissions.

U.S. Department of Education

County Health Rankings (2025)
File

County Health Rankings (2025)

County-level health outcomes, behaviors, clinical care, and socioeconomic factors for 3,200+ U.S. counties.

Robert Wood Johnson Foundation / University of Wisconsin

Medicaid Provider Spending
Database

Medicaid Provider Spending

Explore 26.8M+ Medicaid provider spending records from CMS — analyze claims, procedures, and payments by provider, state, ZIP code, and monthly trends from 2018–2024.

CMS (Centers for Medicare & Medicaid Services)

U.S. Food and Drug Administration
Live API

OpenFDA

FDA public data on drug adverse events, recalls, medical devices, food enforcement, and product labeling.

U.S. Food and Drug Administration

USDA Agricultural Research Service
Live API

USDA FoodData Central

Nutrient profiles for 300,000+ foods including branded products, foundation foods, and survey data from the USDA.

USDA Agricultural Research Service

HUD User
Live API

HUD User Housing Data

Fair Market Rents, income limits, USPS vacancy data, and geographic crosswalks from the U.S. Department of Housing and Urban Development.

HUD User

TrustMRR
Live API

TrustMRR

Verified startup revenue, MRR, growth rates, and acquisition data for hundreds startups backed by real payment provider integrations.

TrustMRR

NASA
Live API

NASA APIs

Access NASA space and Earth science data including astronomy images, asteroid tracking, Mars rover photos, and space weather.

NASA

MLB Advanced Media
Live API

MLB Statcast (Baseball Savant)

Comprehensive MLB batting and pitching data — exit velocity, launch angle, pitch velocity, spin rate, expected stats, and advanced analytics for every play since 2015 via Baseball Savant.

MLB Advanced Media

NAICS Industry Classification Codes (2022)
File

NAICS Industry Classification Codes (2022)

Complete 2022 NAICS code hierarchy with all 2,122 industry classifications across 5 levels.

U.S. Census Bureau