This tool--a simple csv or Stata file for merging--gives you a fast way to assign Census county FIPS codes to variously presented county names. This is useful for dealing with county names collected from official sources, such as election returns, which inconsistently present county names and often have misspellings. It will likely take less than ten minutes the first time, and about one minute thereafter--assuming all versions of your county names are in this file. There are about 3,142 counties in the U.S., and there are 77,613 different permutations of county names in this file (ave=25 per county, max=382). Counties with more likely permutations have more versions. Misspellings were added as I came across them over time. I DON'T expect people to cite the use of this tool. DO feel free to suggest the addition of other county name permutations.

A listing of NYS counties with accompanying Federal Information Processing System (FIPS) and US Postal Service ZIP codes sourced from the NYS GIS Clearinghouse.

Abstract

A crosswalk dataset matching US ZIP codes to corresponding county codes

Documentation

The denominators used to calculate the address ratios are the ZIP code totals. When a ZIP is split by any of the other geographies, that ZIP code is duplicated in the crosswalk file.

**Example: **ZIP code 03870 is split by two different Census tracts, 33015066000 and 33015071000, which appear in the tract column. The ratio of residential addresses in the first ZIP-Tract record to the total number of residential addresses in the ZIP code is .0042 (.42%). The remaining residential addresses in that ZIP (99.58%) fall into the second ZIP-Tract record.

So, for example, if one wanted to allocate data from ZIP code 03870 to each Census tract located in that ZIP code, one would multiply the number of observations in the ZIP code by the residential ratio for each tract associated with that ZIP code.

https://redivis.com/fileUploads/4ecb405e-f533-4a5b-8286-11e56bb93368%3E" alt="">(Note that the sum of each ratio column for each distinct ZIP code may not always equal 1.00 (or 100%) due to rounding issues.)

County definition

In the United States, a county is an administrative or political subdivision of a state that consists of a geographic region with specific boundaries and usually some level of governmental authority. The term "county" is used in 48 U.S. states, while Louisiana and Alaska have functionally equivalent subdivisions called parishes and boroughs, respectively.

Further reading

The following article demonstrates how to more effectively use the U.S. Department of Housing and Urban Development (HUD) United States Postal Service ZIP Code Crosswalk Files when working with disparate geographies.

Wilson, Ron and Din, Alexander, 2018. “Understanding and Enhancing the U.S. Department of Housing and Urban Development’s ZIP Code Crosswalk Files,” Cityscape: A Journal of Policy Development and Research, Volume 20 Number 2, 277 – 294. URL: https://www.huduser.gov/portal/periodicals/cityscpe/vol20num2/ch16.pdf

Contact information

Questions regarding these crosswalk files can be directed to Alex Din with the subject line HUD-Crosswalks.

Acknowledgement

This dataset is taken from the U.S. Department of Housing and Urban Development (HUD) office: https://www.huduser.gov/portal/datasets/usps_crosswalk.html#codebook

The following crosswalks are the result of a data pipeline that pulls crosswalks from the U.S. Department of Housing and Urban Development (HUD) database, compiling a comprehensive ZIP --> FIPS crosswalk from 2010 to 2023. The crosswalks are available in four different forms: "one2one": one row, per ZIP code, per year. Each ZIP is matched to its best matching FIPS code. "one2few": Potentially multiple rows, per ZIP code, per year. All FIPS codes with a non-zero number of addresses for a given ZIP code are returned. "one2one_summy" and "one2few_summy" return the same respective types of data as the above, but summarize across chunks of years. Further description of these datasets, as well as code to reproduce and adjust results according to certain parameters, is available at the Github repo.

This data collection relates ZIP codes to counties, to standard metropolitan statistical areas (SMSAs), and, in New England, to minor civil divisions (MCDs). The relationships between ZIP codes and other geographical units are based on 1979 boundaries, and changes since that time are not reflected. The Census Bureau used various sources to determine ZIP code-county or ZIP code-MCD relationships. In the cases where the sources were confusing or contradictory as to the geographical boundaries of a ZIP code, multiple ZIP-code records (each representing the territory contained in that ZIP-code area) were included in the data file. As a result, the file tends to overstate the ZIP code-county or ZIP code-MCD crossovers. The file is organized by ZIP code and is a byproduct of data used to administer the 1980 Census. Variables include ZIP codes, post office names, FIPS state and county codes, county or MCD names, and SMSA codes. (Source: downloaded from ICPSR 7/13/10)

Please Note: This dataset is part of the historical CISER Data Archive Collection and is also available at ICPSR at https://doi.org/10.3886/ICPSR08051.v1. We highly recommend using the ICPSR version as they may make this dataset available in multiple data formats in the future.

Edited by MetroSafe. Efforts were made to include/exclude specific Address points from ZIP code regions. As a result, boundary areas not conforming to coincident parcel boundary, road edge, or street centerline features should be seen as interpolated/extrapolated, and not geographically certain beyond a general measure. View detailed metadata.

One of the many challenges that social science researchers and practitioners face is the difficulty of relating data between census tracts which are re-delineated with each decennial census. While some methods of harmonizing or crosswalking data between census tracts exist, to provide additional avenues for merging these data, PD&R has released the HUD-USPS Census Tract Crosswalk Files. These unique files are derived from the USPS Vacancy Data which are regularly updated by the USPS which makes them uniquely positioned to describe human settlements patterns between census tract delineations. These data use the locations of ZIP+4 centroids, an extremely granular level of geography, the number of addresses of various types (residential, business, other, and total), and do not rely on ancillary data to map where population or households might be located.There are twelve types of crosswalk files available for download. The first six crosswalk files are used to allocate ZIP codes to Census Bureau geographies such as census tracts, counties, county subdivisions, Core Based Statistical Areas (CBSAs), CBSA Divisions, and Congressional Districts. The last six are used to allocate from those same Census Bureau geographies to ZIP Codes. It is important to note that the relationship between the two types of crosswalk files is not perfectly inverse. That is to say, the ZIP to Tract crosswalk file cannot be used to allocate data from census tract geographies to ZIP codes. Instead, the Tract to ZIP crosswalk file must be used in that specific scenario.In addition to the crosswalk files, this dataset also includes screenshots of HUDs documentation and FAQ pages.

Demographics, population, housing, income, education, schools, and geography for ZIP Code 46117 (Charlottesville, IN). Interactive charts load automatically as you scroll for improved performance.

GIS Feature class polygon of Zip codes in Jefferson County joined with Latest Confirmed Cases by Zip code without Long Term Care and Population of 2019 ACS Demographic Data by Zip code. This feature is used in the Covid-19 Jefferson County Public Hub Site https://covid-19-in-jefferson-county-ky-lojic.hub.arcgis.com/Note: This data is preliminary, routinely updated, and is subject to change.For questions about this data please contact Angela Graham (Angela.Graham@louisvilleky.gov) or YuTing Chen (YuTing.Chen@louisvilleky.gov) or call (502) 574-8279.

Map developed by Jefferson County ITS GIS. Using the 2020 Zip Codes from the US Census Web site. This map is made available to the public - there is a disclaimer statement in the marginalia.

Demographics, population, housing, income, education, schools, and geography for ZIP Code 68138 (Omaha, NE). Interactive charts load automatically as you scroll for improved performance.

Demographics, population, housing, income, education, schools, and geography for ZIP Code 97225 (Portland, OR). Interactive charts load automatically as you scroll for improved performance.

The City of Tempe ZIP Codes feature class is from Maricopa County GIS Open Data and is intended to show the USPS ZIP Code boundaries within Tempe, Arizona.

This layer was developed by the Research & Analytics Group of the Atlanta Regional Commission, using data from the U.S. Census Bureau’s American Community Survey 5-year estimates for 2013-2017, to show populations with computer and internet access by Zip Code Tabulation Area in the Atlanta region.

The user should note that American Community Survey data represent estimates derived from a surveyed sample of the population, which creates some level of uncertainty, as opposed to an exact measure of the entire population (the full census count is only conducted once every 10 years and does not cover as many detailed characteristics of the population). Therefore, any measure reported by ACS should not be taken as an exact number – this is why a corresponding margin of error (MOE) is also given for ACS measures. The size of the MOE relative to its corresponding estimate value provides an indication of confidence in the accuracy of each estimate. Each MOE is expressed in the same units as its corresponding measure; for example, if the estimate value is expressed as a number, then its MOE will also be a number; if the estimate value is expressed as a percent, then its MOE will also be a percent.

The user should also note that for relatively small geographic areas, such as census tracts shown here, ACS only releases combined 5-year estimates, meaning these estimates represent rolling averages of survey results that were collected over a 5-year span (in this case 2013-2017). Therefore, these data do not represent any one specific point in time or even one specific year. For geographic areas with larger populations, 3-year and 1-year estimates are also available.

For further explanation of ACS estimates and margin of error, visit Census ACS website.

Naming conventions:

Prefixes:

None

Count

p

Percent

r

Rate

m

Median

a

Mean (average)

t

Aggregate (total)

ch

Change in absolute terms (value in t2 - value in t1)

pch

Percent change ((value in t2 - value in t1) / value in t1)

chp

Change in percent (percent in t2 - percent in t1)

Suffixes:

None

Change over two periods

_e

Estimate from most recent ACS

_m

Margin of Error from most recent ACS

_00

Decennial 2000

Attributes:

SumLevel

Summary level of geographic unit (e.g., County, Tract, NSA, NPU, DSNI, SuperDistrict, etc)

GEOID

Census tract Federal Information Processing Series (FIPS) code

NAME

Name of geographic unit

Planning_Region

Planning region designation for ARC purposes

Acres

Total area within the tract (in acres)

SqMi

Total area within the tract (in square miles)

County

County identifier (combination of Federal Information Processing Series (FIPS) codes for state and county)

CountyName

County Name

TotalHH_e

# Total households, 2017

TotalHH_m

# Total households, 2017 (MOE)

WithAComputer_e

# Households with a computer, 2017

WithAComputer_m

# Households with a computer, 2017 (MOE)

pWithAComputer_e

% Households with a computer, 2017

pWithAComputer_m

% Households with a computer, 2017 (MOE)

WithBroadband_e

# Households with broadband Internet, 2017

WithBroadband_m

# Households with broadband Internet, 2017 (MOE)

pWithBroadband_e

% Households with broadband Internet, 2017

pWithBroadband_m

% Households with broadband Internet, 2017 (MOE)

last_edited_date

Last date the feature was edited by ARC

Source: U.S. Census Bureau, Atlanta Regional Commission

Date: 2013-2017

For additional information, please visit the Census ACS website.

US Postal Service ZIP Code boundaries. This layer was created by Los Angeles County eGIS to align with parcel boundaries.ZIP is an acronym for Zone Improvement Plan.Legal vs. Postal Cities: Many users confuse the name the Post Office delivers mail to (e.g. Van Nuys, Hollywood) as a legal city (in this case Los Angeles), when they are a postal city. The County contains 88 legal cities, and over 400 postal names that are tied to the ZIP Codes. To support usability and geocoding, we have attached the first 3 postal cities to each address, based upon its ZIP Code.The US Postal Service is the authoritative source for ZIP Code data. See their website for more information.

The document is a downloadable PDF GIS map document of Somerset County’s 2020 Census Zip Code Boundaries. The page size is set to Poster (24 X 36). The map was last updated on August 2023 by the Somerset County Office of GIS Services.

Shapefile of zip codes in Shelby County

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.

Zip code boundaries from Los Angeles County.

Demographics, population, housing, income, education, schools, and geography for ZIP Code 97527 (Grants Pass, OR). Interactive charts load automatically as you scroll for improved performance.