Zip code (zcta) To County Crosswalk

Maps Cenus zip-code tabulation areas to Counties Modified 2022-04-25T18:11:42

Resources | Packages | Documentation| Contacts| References| Data Dictionary



This file links Ztca regions — the Census version of ZIP codes, to counties, by associating a Zcta with the county that contains the Zctas centroid.

There are only about 1/2 the number of Zctas in this file ( 33K ) as there are ZIP codes ( about 77K )


Note that the ZCTA regions are joined to counties after converting the geometries to EPSG 4326 (WGS84), from the original 4269 (NAD 83). The discrepancy between these CRS is only a few meters, so this should not make a difference.


Data Dictionary



Column NameData TypeDescription
statestringState FIPS code
countystringCounty FIPS code
zctastringZcta (zip) code
zcta_geoidstringZcta geoid
county_geoidstringCounty geoid


Urls used in the creation of this data package.

  • censusgeo://2018/5/CA/zcta/. ZCTA Geography file
  • censusgeo://2018/5/US/county/. Counties geography file


Accessing Data in Vanilla Pandas

import pandas as pd

county_zcta_df =  pd.read_csv('')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('')

# Create Dataframes
county_zcta_df = pkg.resource('county_zcta').dataframe()