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.

Try a real question

us-zip-code-reference.csv
33.8K rows9 columns2.1 MB

Download the full dataset

Create a free account to download us-zip-code-reference.csv (2.14 MB) and use it anywhere.

Get the full file

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.