Zip code (zcta) To County Crosswalk – SDRDL Data Repository

Maps Cenus zip-code tabulation areas to Counties

census.gov-zcta_county-2.1.2. Modified 2022-04-25T18:11:42

Resources

county_zcta. County to Zcta Crosswalk

Documentation

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 )

Caveats

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.

Documentation Links

Documentation Page

Contacts

Wrangler
Eric Busboom, Civic Knowledge

Data Dictionary

county_zcta

Column Name	Data Type	Description
state	string	State FIPS code
county	string	County FIPS code
zcta	string	Zcta (zip) code
zcta_geoid	string	Zcta geoid
county_geoid	string	County geoid

References

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

Packages

zip http://library.metatab.org/census.gov-zcta_county-2.1.2.zip
s3 s3://library.metatab.org/census.gov-zcta_county-2.1.2.csv
csv http://library.metatab.org/census.gov-zcta_county-2.1.2.csv
source https://github.com/metatab-packages/census.gov-zcta_county.git

Accessing Data in Vanilla Pandas

import pandas as pd


county_zcta_df =  pd.read_csv('http://library.metatab.org/census.gov-zcta_county-2.1.2/data/county_zcta.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/census.gov-zcta_county-2.1.2.zip')

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