A crosswalk dataset matching US ZIP codes to corresponding census tracts
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.)
Census tract definition
A census tract, census area, census district or meshblock is a geographic region defined for the purpose of taking a census. Sometimes these coincide with the limits of cities, towns or other administrative areas and several tracts commonly exist within a county. In unincorporated areas of the United States these are often arbitrary, except for coinciding with political lines.
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
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
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.
A crosswalk matching US ZIP codes to corresponding CBSA (core-based statistical area)
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
CC0 1.0 Universal Public Domain Dedicationhttps://creativecommons.org/publicdomain/zero/1.0/
License information was derived automatically
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.
Our United States zip code Database offers comprehensive postal code data for spatial analysis, including postal and administrative areas. 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.
The TIGER/Line shapefiles and related database files (.dbf) are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line shapefile is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. 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. The Census Bureau uses tabulation blocks as the basis for defining each ZCTA. Tabulation blocks are assigned to a ZCTA based on the most frequently occurring ZIP Code for the addresses contained within that block. The most frequently occurring ZIP Code also becomes the five-digit numeric code of the ZCTA. These codes may contain leading zeros. Blocks that do not contain addresses but are surrounded by a single ZCTA (enclaves) are assigned to the surrounding ZCTA. Because the Census Bureau only uses the most frequently occurring ZIP Code to assign blocks, a ZCTA may not exist for every USPS ZIP Code. Some ZIP Codes may not have a matching ZCTA because too few addresses were associated with the specific ZIP Code or the ZIP Code was not the most frequently occurring ZIP Code within any of the blocks where it exists. The ZCTA boundaries in this release are those delineated following the 2020 Census.
https://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
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 dataset is organized as follows:
The data used to create this data set was taken from several recent government data sets.
These are:
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.
MIT Licensehttps://opensource.org/licenses/MIT
License information was derived automatically
AS OF APRIL 2021
Updates upon request. Does not include zip+4 code. Other data formats uppon request.
This layer represents ZIP Code outlines for the state of North Carolina. The counties are stored as polygons.
A ZIP Code is a five digit numeric code that identifies a collection of mailing addresses within the United States and its territories to simplify the distribution of mail by the United States Postal Service (USPS).
A ZIP Code is a delivery sort sequence and the USPS does not associate an area with each ZIP Code. Said another way, ZIP Codes are lists of addresses for delivering the mail. They are not areas. However, many ZIP Codes have delivery areas, and some ZIP Codes are for buildings or campuses that have defined borders. Boundaries can also be created by grouping small areas (defined by the U.S. Bureau of the Census for their nationwide street map) based on the dominant ZIP Code of the addresses in each small area, but this is an approximation because carrier routes may overlap and portions of the country have no deliverable addresses. The ZIP Code areas often do not adhere to boundaries of cities, towns, counties, or states.
CC0 1.0 Universal Public Domain Dedicationhttps://creativecommons.org/publicdomain/zero/1.0/
License information was derived automatically
Release Date: 2020-07-23.Release Schedule:.The data in this file were released on July 23, 2020....Key Table Information:.Beginning with reference year 2007, ZBP data are released using the Noise disclosure methodology to protect confidentiality. See Survey Methodology for complete information on the coverage and methodology of the ZIP Code Business Patterns data series..Includes only establishments with payroll..Data by employment size class, shown at the 2-6 digit NAICS code levels only contains data on the number of establishments..Data shown for NAICS code 00 (Total for all sectors) contains data on the number of establishments, total employment, first quarter payroll, and annual payroll...Data Items and Other Identifying Records: .This file contains data classified by employment size category of the establishment .Number of establishments.Annual payroll ($1,000).First-quarter payroll ($1,000).Number of employees ..Geography Coverage:.The data are shown at the 5-digit ZIP Code level only. ..Industry Coverage:.The data are shown at the 2- through 6- digit NAICS code levels for all sectors with published data, and for NAICS code 00 (Total for all sectors)..Footnotes:.Not applicable..FTP Download:.Download the entire table at: https://www2.census.gov/programs-surveys/cbp/data/2018/CB1800ZBP.zip ..API Information:.ZIP Codes Business Patterns (ZBP) data are housed in the ZIP Codes Business Patterns (ZBP) API. For more information, see Census.gov: Developers: Available APIs, County Business Patterns and Nonemployer Statistics (1986-2018): ZIP Codes Business Patterns (ZBP) APIs...Methodology:.To maintain confidentiality, the U.S. Census Bureau suppresses data to protect the identity of any business or individual. The census results in this file contain sampling and/or nonsampling error. Data users who create their own estimates using data from this file should cite the U.S. Census Bureau as the source of the original data only. ..To comply with disclosure avoidance guidelines, data rows with fewer than three contributing establishments are not presented. Additionally, establishment counts are suppressed when other select statistics in the same row are suppressed. For detailed information about the methods used to collect and produce statistics, see. County Business Patterns Methodology. ..Symbols:.D - Withheld to avoid disclosing data for individual companies; data are included in higher level totals (used prior to 2017).N - Not available or not comparable.S - Withheld because estimate did not meet publication standards. Employment or payroll field set to zero. .G - Low Noise.H - Moderate Noise.J - High Noise.For a complete list of symbols, see County Business Partterns Abbreviations and Symbols Glossary...Source:.U.S. Census Bureau, 2018 ZIP Business Patterns..Contact Information:.U.S. Census Bureau.Economy-Wide Statistics Division.Business Statistics Branch.Tel: (301) 763 - 2580 .Email: ewd.county.business.patterns@census.gov
US Postal Service ZIP Code boundaries. For more information, click here.ZIP is an acronym for Zone Improvement Plan.Legal vs. Postal CitiesMany users confuse the name the Post Office delivers main 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.
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.
MIT Licensehttps://opensource.org/licenses/MIT
License information was derived automatically
Count of live births represents births to Santa Clara County residents. The measure is summarized for total county population at zip code level. Data trends are from year 2004 to 2013.METADATA:Notes (String): Lists table title, notes, sourcesYear (Numeric): Year of birthZip code (Numeric): Lists zip codes. U.S. Census Bureau, 2000 ZCTA geographies are used.Count (Numeric): Number of live births in a year in the area. Birth count less than 6 in a year in the area are not presented.
US Postal Service Zone Improvement Plan (ZIP) Codes are used throughout the United States to improve mail delivery. There are 479 unique 5-digit ZIP Codes in Oregon all starting with 97. All ZIP Codes are assigned and managed exclusively by the US Postal Service. There are three main categories of ZIP Codes - 1) Standard, 2) PO Box Only, 3) Unique for large commercial and government customers.Each ZIP Code is assigned a preferred city name by the US Postal Service. NOTE - these city names may not correspond with the city limits or other jurisdiction boundaries of incorporated cities. There are other acceptable city names listed that may be used for mailing addresses for some ZIP Codes. There are also other city names to avoid using for mailing addresses. To verify the preferred, acceptable, or city names to avoid enter the ZIP Code in this tool from the US Postal Service - https://tools.usps.com/zip-code-lookup.htm?citybyzipcodeThis is not a product of the US Postal Service. It was compiled by checking all numbers from 97000 - 97999 with the ZIP Code Lookup tool.Most Standard and some PO Box Only ZIP Codes may also be listed as Census ZIP Code Tabulation Areas (ZTCA). NOTE - The ZTCA is only an approximation of a ZIP Code area based on the predominate ZIP Code of all housing units in each Census block. ZIP Codes actually follow lines of travel along letter carrier routes and are not polygons as shown by the ZTCA.
This layer provides zip code data for view and analysis in GIS and interactive web mapping applications.
MIT Licensehttps://opensource.org/licenses/MIT
License information was derived automatically
Table contains count and percentage of county residents living below the 200% of Federal Poverty Level (FPL). Data are presented at county, city, zip code and census tract level. Data are presented for zip codes (ZCTAs) fully within the county. Source: U.S. Census Bureau, 2016-2020 American Community Survey 5-year estimates, Table C17002; data accessed on April 11, 2022 from https://api.census.gov. The 2020 Decennial geographies are used for data summarization.METADATA:notes (String): Lists table title, notes, sourcesgeolevel (String): Level of geographyGEOID (Numeric): Geography IDNAME (String): Name of geographypop (Numeric): Population for whom poverty status was assessedfpl200 (Numeric): Number of people living below 200% of Federal Poverty Levelpct_200 (Numeric): Percent of people living below 200% of Federal Poverty Level
https://creativecommons.org/share-your-work/public-domain/pdmhttps://creativecommons.org/share-your-work/public-domain/pdm
The U.S. Census Bureau TIGER/Line® files in this data collection were originally distributed by the Inter-university Consortium for Political and Social Research (ICPSR) through its TIGER/Line file web site, which was decommissioned in 2018 (archived version: https://web.archive.org/web/20090924181858/http://www.icpsr.umich.edu/TIGER/index.html). There, users could download various versions of the U.S. Census Bureau's TIGER (Topologically Integrated Geographic Encoding and Referencing) database. The TIGER/Line files do not include demographic data, but they do contain geographic information that can be linked to the Census Bureau’s demographic data. Due to file number limitations in openICPSR, the original data collections have been bundled into single zip packages. A single TIGER_directory.txt file listing the original files and the original directory structure is included with the root directory. Documentation files are also included as standalone subdirectories in each collection so users do not need to download entire zip bundles to view documentation. The TIGER/Line data are stored in compressed format in subdirectories by state name. There is one TIGER/Line file (in a compressed format) for each county or county equivalent. The file names consist of TGR + the 2-digit state FIPS (Federal Information Processing Standards) code + the 3-digit county FIPS code (i.e. TGR01031.ZIP for Coffee County, Alabama). Each state folder contains individual county files.The individual county files include one file for each record type included for that county with the following name convention: tgr01031.rt1. The convention follows the order described above with each file having a suffix which includes 'rt' (record type) followed by its designation (in this case record type 1). Each county file also contains its own metadata record.If present, documentation files for the TIGER/Line data are stored in a directory named '0docs' which is located in the 'Parent Directory'. This directory appears at the top of the index of state subdirectories for each edition of the TIGER/Line files. The documentation includes a complete list of FIPS state and county codes.
This layer provides zip code data for view and analysis in GIS and interactive web mapping applications.
MIT Licensehttps://opensource.org/licenses/MIT
License information was derived automatically
Count and percentage of county residents by age groups. Data are summarized at county, city, zip code and census tract of residence. Data are presented for zip codes (ZCTAs) fully within the county. Source: U.S. Census Bureau, 2016-2020 American Community Survey 5-year estimates, Table B01001; data accessed on April 11, 2022 from https://api.census.gov. The 2020 Decennial geographies are used for data summarization.METADATA:notes (String): Lists table title, notes, sourcesgeolevel (String): Level of geographyGEOID (Numeric): Geography IDNAME (String): Name of geographyt_pop (Numeric): Total populationt0_4 (Numeric): Population count ages less than 5 yearst5_14 (Numeric): Population count ages 5 to 14 yearst15_24 (Numeric): Population count ages 15 to 24 yearst25_34 (Numeric): Population count ages 25 to 34 yearst35_44 (Numeric): Population count ages 35 to 44 yearst45_54 (Numeric): Population count ages 45 to 54 yearst55_64 (Numeric): Population count ages 55 to 64 yearst65over (Numeric): Population count ages 65 years and olderp_0_4 (Numeric): Percent of people ages less than 5 yearsp_5_14 (Numeric): Percent of people ages 5 to 14 yearsp_15_24 (Numeric): Percent of people ages 15 to 24 yearsp_25_34 (Numeric): Percent of people ages 25 to 34 yearsp_35_44 (Numeric): Percent of people ages 35 to 44 yearsp_45_54 (Numeric): Percent of people ages 45 to 54 yearsp_55_64 (Numeric): Percent of people ages 55 to 64 yearsp_65over (Numeric): Percent of people ages 65 years and older
A crosswalk dataset matching US ZIP codes to corresponding census tracts
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.)
Census tract definition
A census tract, census area, census district or meshblock is a geographic region defined for the purpose of taking a census. Sometimes these coincide with the limits of cities, towns or other administrative areas and several tracts commonly exist within a county. In unincorporated areas of the United States these are often arbitrary, except for coinciding with political lines.
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