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

This dataset is part of the Geographical repository maintained by Opendatasoft. It's been built from the ground up using authoritative sources including the U.S. Postal Service™, U.S. Census Bureau, National Weather Service, American Community Survey, and the IRS.Contains most USPS zip codes (lat/long).

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

This dataset demarcates the zip code boundaries that lie within Allegheny County.If viewing this description on the Western Pennsylvania Regional Data Center’s open data portal (http://www.wprdc.org), this dataset is harvested on a weekly basis from Allegheny County’s GIS data portal (http://openac.alcogis.opendata.arcgis.com/). The full metadata record for this dataset can also be found on Allegheny County’s GIS portal. You can access the metadata record and other resources on the GIS portal by clicking on the “Explore” button (and choosing the “Go to resource” option) to the right of the “ArcGIS Open Dataset” text below.Category: Civic Vitality and GovernanceOrganization: Allegheny CountyDepartment: Geographic Information Systems Group; Department of Administrative ServicesTemporal Coverage: currentData Notes: Coordinate System: Pennsylvania State Plane South Zone 3702; U.S. Survey FootDevelopment Notes: noneOther: noneRelated Document(s): Data Dictionary (none)Frequency - Data Change: As neededFrequency - Publishing: As neededData Steward Name: Eli ThomasData Steward Email: gishelp@alleghenycounty.us

For many countries lat/lng are determined with an algorithm that searches the place names in the main geonames database using administrative divisions and numerical vicinity of the postal codes as factors in the disambiguation of place names. For postal codes and place name for which no corresponding toponym in the main geonames database could be found an average lat/lng of 'neighbouring' postal codes is calculated. Please let us know if you find any errors in the data set. ThanksFor Canada we have only the first letters of the full postal codes (for copyright reasons)For Ireland we have only the first letters of the full postal codes (for copyright reasons)For Malta we have only the first letters of the full postal codes (for copyright reasons)The Argentina data file contains 4-digit postal codes which were replaced with a new system in 1999.For Brazil only major postal codes are available (only the codes ending with -000 and the major code per municipality).For India the lat/lng accuracy is not yet comparable to other countries.Update frequency: 1 month

Context

Dataset created to link between County - State Name, State-County FIPS, and ZIP Code.

Acknowledgements

Data Sources

• US HUD

https://www.huduser.gov/portal/datasets/usps.html

• Census Bureau

https://www2.census.gov/geo/docs/reference/codes/files/national_county.txt https://www.census.gov/geo/reference/codes/cou.html

Data cleaned by Data4Democracy and hosted originally on Data.World: https://github.com/Data4Democracy/zip-code-to-county https://data.world/niccolley/us-zipcode-to-county-state

ZCTA data from USPS 6.2017 release.

Image from Reddit.

List of cities, zip codes and counties in Missouri

The 2020 Zip Code Boundaries dataset contains boundary information for Zip Code Tabulation Areas (ZCTAs) as of the 2020 Census, sourced from the United States Census Bureau. ZCTAs are statistical representations of USPS ZIP Code service areas and are used for demographic analysis, data aggregation, and geographic reference purposes. This dataset includes boundary polygons for each ZCTA, allowing users to visualize and analyze ZIP Code boundaries within Montgomery County, Texas.Data Fields Included:ZCTA CodeAreaThis dataset is sourced from the United States Census Bureau.Data source: United States Census Bureau TIGER Data

This dataset is part of the Geographical repository maintained by Opendatasoft.This dataset contains data for zip codes 5 digits in United States of America.ZIP Code Tabulation Areas (ZCTAs) are approximate area representations of U.S. Postal Service (USPS) ZIP Code service areas that the Census Bureau creates to present statistical data for each decennial census. The Census Bureau delineates ZCTA boundaries for the United States, Puerto Rico, American Samoa, Guam, the Commonwealth of the Northern Mariana Islands, and the U.S. Virgin Islands once each decade following the decennial census. Data users should not use ZCTAs to identify the official USPS ZIP Code for mail delivery. The USPS makes periodic changes to ZIP Codes to support more efficient mail delivery.Processors and tools are using this data.EnhancementsAdd ISO 3166-3 codes.Simplify geometries to provide better performance across the services.Add administrative hierarchy.

The H-GAC ZIP code coverage includes polygons and their attributes for Harris County. It was primarily created from the census 2002 ZIP code boundary data with secondary source data coming from Centerpoint ZIP code, Esri 2009 ZIP code, address point data from centerpoint and counties, CRIS ( Carrier Route Information System) data, US Postal Services Online site ( Look up a ZIP code) and parcels. Must Not Overlap and Must Not have Gaps topology rules have been used in order to create an accurate ZIP code layer. The layer represents physical ZIP codes and a few PO BOX ZIP codes are included rural areas . PO BOX ZIP codes can be identifying by "zip_type" field in the attribute table.

Our Europe Zip Code Database offers comprehensive postal code data for spatial analysis, including postal and administrative areas for numerous European countries. This dataset contains accurate and up-to-date information on all administrative divisions, cities, and zip codes, making it an invaluable resource for various applications such as address capture and validation, map and visualization, reporting and business intelligence (BI), master data management, logistics and supply chain management, and sales and marketing. Our location data packages are available in various formats, including CSV, optimized for seamless integration with popular systems like Esri ArcGIS, Snowflake, QGIS, and more. Product features include fully and accurately geocoded data, multi-language support with address names in local and foreign languages, comprehensive city definitions, and the option to combine map data with UNLOCODE and IATA codes, time zones, and daylight saving times. Companies choose our location databases for their enterprise-grade service, reduction in integration time and cost by 30%, and weekly updates to ensure the highest quality.

This dataset contains model-based ZIP Code Tabulation Area (ZCTA) level estimates. PLACES covers the entire United States—50 states and the District of Columbia—at county, place, census tract, and ZIP Code Tabulation Area levels. It provides information uniformly on this large scale for local areas at four geographic levels. Estimates were provided by the Centers for Disease Control and Prevention (CDC), Division of Population Health, Epidemiology and Surveillance Branch. PLACES was funded by the Robert Wood Johnson Foundation in conjunction with the CDC Foundation. The dataset includes estimates for 40 measures: 12 for health outcomes, 7 for preventive services use, 4 for chronic disease-related health risk behaviors, 7 for disabilities, 3 for health status, and 7 for health-related scocial needs. These estimates can be used to identify emerging health problems and to help develop and carry out effective, targeted public health prevention activities. Because the small area model cannot detect effects due to local interventions, users are cautioned against using these estimates for program or policy evaluations. Data sources used to generate these model-based estimates are Behavioral Risk Factor Surveillance System (BRFSS) 2022 or 2021 data, Census Bureau 2020 population data, and American Community Survey 2018–2022 estimates. The 2024 release uses 2022 BRFSS data for 36 measures and 2021 BRFSS data for 4 measures (high blood pressure, high cholesterol, cholesterol screening, and taking medicine for high blood pressure control among those with high blood pressure) that the survey collects data on every other year. More information about the methodology can be found at www.cdc.gov/places.

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.

Abstract

A crosswalk matching US ZIP codes to corresponding CBSA (core-based statistical area)

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.)

CBSA definition

A core-based statistical area (CBSA) is a U.S. geographic area defined by the Office of Management and Budget (OMB) that consists of one or more counties (or equivalents) anchored by an urban center of at least 10,000 people plus adjacent counties that are socioeconomically tied to the urban center by commuting. Areas defined on the basis of these standards applied to Census 2000 data were announced by OMB in June 2003. These standards are used to replace the definitions of metropolitan areas that were defined in 1990. The OMB released new standards based on the 2010 Census on July 15, 2015.

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 authors

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

Zip code data includes polygons and labels representing zipcode boundaries in Buncombe County as defined by the United States Postal Service. These boundaries represent the five-digit ZIP Code areas used by the U.S. Postal Service to deliver mail more effectively.

US Geographic Codes Dataset

This code is used to generate a combined data set of US ZIP, FIPS, and County data for most ZIP Codes in the U.S. (41,867 to be exact).

Code to generate the data set from the government files listed below can be found here.

The Data

The dataset is organized as follows:

• Zip Code: USPS ZIP code from here
• State Name: Full state name (E.g. Michigan)
• State Abrv: USPS abbreviated state name (E.g: MI)
• State Code: FIPS State Code from here
• County Name: County in which ZIP is located
• County Code: FIPS County Code
• FIPS Code: FIPS State Code + FIPS County Code from here
• ANSI Code: American National Standards Institute Code
• Centroid Lat: Latitude value of the county center
• Centroid Long: Longitude value of the county center

Sources

The data used to create this data set was taken from several recent government data sets.

These are:

• 2017 US Gazetteer FIPS Dataset
• 2017 US Census County Polygons Dataset
• 2015 Department of Labor GPCI Dataset
• General Census State Code Reference Document

Disclaimers

The final csv is in 'latin1' encoding to preserve the Spanish county names in Puerto Rico.

This data is from, and shall remain in the public domain, and the onus of responsibility lies with the user of this data.

This annual study provides selected income and tax items classified by State, ZIP Code, and the size of adjusted gross income. These data include the number of returns, which approximates the number of households; the number of personal exemptions, which approximates the population; adjusted gross income; wages and salaries; dividends before exclusion; and interest received. Data are based who reported on U.S. Individual Income Tax Returns (Forms 1040) filed with the IRS. SOI collects these data as part of its Individual Income Tax Return (Form 1040) Statistics program, Data by Geographic Areas, ZIP Code Data.

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.

A Listing of Oregon City-Zipcodes and the County

ZIP code areas within Fairfax County.