Facebook
TwitterA crosswalk dataset matching US ZIP codes to corresponding county codes
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
Facebook
Twitterhttps://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
Dataset created to link between County - State Name, State-County FIPS, and ZIP Code.
https://www.huduser.gov/portal/datasets/usps.html
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.
Facebook
TwitterThe 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.
Facebook
TwitterA listing of NYS counties with accompanying Federal Information Processing System (FIPS) and US Postal Service ZIP codes sourced from the NYS GIS Clearinghouse.
Facebook
Twitterhttps://www.icpsr.umich.edu/web/ICPSR/studies/8051/termshttps://www.icpsr.umich.edu/web/ICPSR/studies/8051/terms
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.
Facebook
Twitter
Facebook
Twitterhttps://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
Easily lookup US historical demographics by county FIPS or zipcode in seconds with this file containing over 5,901 different columns including:
*Lat/Long *Boundaries *State FIPS *Population from 2010-2019 *Death Rate from 2010-2019 *Unemployment from 2001-2020 *Education from 1970-2019 *Gender and Age Population
Provided by bitrook.com to help Data Scientists clean data faster.
https://www.ers.usda.gov/data-products/county-level-data-sets/download-data/
https://www.ers.usda.gov/data-products/county-level-data-sets/download-data/
https://www.ers.usda.gov/data-products/county-level-data-sets/download-data/
https://data.world/niccolley/us-zipcode-to-county-state
https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/counties/asrh/cc-est2019-agesex-**.csv https://www2.census.gov/programs-surveys/popest/technical-documentation/file-layouts/2010-2019/cc-est2019-agesex.pdf
https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/counties/asrh/cc-est2019-alldata.csv https://www2.census.gov/programs-surveys/popest/technical-documentation/file-layouts/2010-2019/cc-est2019-alldata.pdf
Facebook
Twitterhttps://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.
Facebook
TwitterThe dataset represents approximate Zip code boundaries in Westchester County. Data was downloaded from the U.S. Census Bureau 2020. The cartographic boundary files are simplified representations of selected geographic areas from the Census Bureau’s MAF/TIGER geographic database. These boundary files are specifically designed for small-scale thematic mapping. Some of the boundaries near CT were edited to match the state line. This is NOT official Postal Service data. The data was updated in August 2025.
Facebook
TwitterMIT Licensehttps://opensource.org/licenses/MIT
License information was derived automatically
Table contains total population and population density summarized at county, city, zip code, and census tract level. Population density is defined as number of people residing per square mile of area. 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 (String): Geography IDNAME (String): Name of geographyt_pop (Numeric): Total populationpop_density (Numeric): Area in square milesarea (Numeric): Population density
Facebook
TwitterUS 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.
Facebook
TwitterCC0 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, including sampling, eligibility, questions, data collection and processing, data quality, review, weighting, estimation, coding operations, confidentiality protection, sampling error, nonsampling error, and more, see. Economic Census: Technical Documentation: Economic Census 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. .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 Division.Tel: (301) 763 - 2580 .Email: ewd.county.business.patterns@census.gov
Facebook
TwitterMIT 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
Facebook
TwitterThis 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.
Facebook
TwitterCC0 1.0 Universal Public Domain Dedicationhttps://creativecommons.org/publicdomain/zero/1.0/
License information was derived automatically
Release Date: 2019-12-12.Release Schedule:.The data in this file were released on December 12, 2019....Key Table Information:.Beginning with reference year 2007, CBP 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 and firms 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/2017/CB1700ZBP.zip ..API Information:.Economic census data are housed in the Census Bureau API. For more information, see Explore Data: Developers: Available APIs: County Business Patterns and Nonemplyer Statistics (1986-2017)...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, including sampling, eligibility, questions, data collection and processing, data quality, review, weighting, estimation, coding operations, confidentiality protection, sampling error, nonsampling error, and more, see. Economic Census: Technical Documentation: Economic Census Methodology. ..Symbols:.S - Withheld because estimate did not meet publication standards .N - Not available or not comparable.For a complete list of symbols, see County Business Partterns Abbreviations and Symbols Glossary...Source:.U.S. Census Bureau, 2017 ZIP Business Patterns..Contact Information:.U.S. Census Bureau.Economy-Wide Statistics Division.Business Statistics Division.Tel: (301) 763 - 2580 .Email: ewd.county.business.patterns@census.gov
Facebook
TwitterMIT Licensehttps://opensource.org/licenses/MIT
License information was derived automatically
Unlock the power of geographical precision with this comprehensive ZIP to FIPS dataset. Seamlessly map ZIP codes to Federal Information Processing Standards (FIPS) codes, enabling accurate location-based analyses. Ideal for geospatial applications, demographic research, and data integration. Explore the seamless fusion of ZIP and FIPS codes for enhanced spatial insights.
Facebook
Twitterhttps://www.usa.gov/government-works/https://www.usa.gov/government-works/
All data was collected from US Census official site: data.census.gov
The first row in all data files contains column descriptions. It should be ignored in the load, e.g.:
df = pd.read_csv('ACSST5Y2018.S0101-Data.csv', skiprows=[1], low_memory=False)
Next, if you need county CFIPS, it can be exctracted from the GEO_ID column:
df['CFIPS'] = df['GEO_ID'].apply(lambda x: int(x.split('US')[-1]))
American Community Survey (ACS) data derived from S0101 AGE AND SEX: - ACSST5Y2018.S0101-Data.csv - ACSST5Y2018.S0101-Column-Metadata.csv - ACSST5Y2019.S0101-Data.csv - ACSST5Y2019.S0101-Column-Metadata.csv - ACSST5Y2020.S0101-Data.csv - ACSST5Y2020.S0101-Column-Metadata.csv - ACSST5Y2021.S0101-Data.csv - ACSST5Y2021.S0101-Column-Metadata.csv
Includes basic info on population and age structure
American Community Survey (ACS) data derived from DP05ACS DEMOGRAPHIC AND HOUSING ESTIMATES: - ACSDP5Y2018.DP05-Data.csv - ACSDP5Y2018.DP05-Column-Metadata.csv - ACSDP5Y2019.DP05-Data.csv - ACSDP5Y2019.DP05-Column-Metadata.csv - ACSDP5Y2020.DP05-Data.csv - ACSDP5Y2020.DP05-Column-Metadata.csv - ACSDP5Y2021.DP05-Data.csv - ACSDP5Y2021.DP05-Column-Metadata.csv
Includes detailed info on demographic structure: age, race, sex, etc
County Business Patterns (CBP) data derived from: - CB1800CBP All Sectors: County Business Patterns, including ZIP Code Business Patterns, by Legal Form of Organization and Employment Size Class for the U.S., States, and Selected Geographies: 2018 - CBP2018.CB1800CBP-Data.csv - CBP2018.CB1800CBP-Column-Metadata.csv - CB1900CBP All Sectors: County Business Patterns, including ZIP Code Business Patterns, by Legal Form of Organization and Employment Size Class for the U.S., States, and Selected Geographies: 2019 - CBP2019.CB1900CBP-Data.csv - CBP2019.CB1900CBP-Column-Metadata.csv - CB2000CBP All Sectors: County Business Patterns, including ZIP Code Business Patterns, by Legal Form of Organization and Employment Size Class for the U.S., States, and Selected Geographies: 2020 - CBP2020.CB2000CBP-Data.csv - CBP2020.CB2000CBP-Column-Metadata.csv
Includes info on number of establishments, payroll, and other metrics by different business size (less than 5 employees, 5 to 9 employees, etc).
American Community Survey (ACS) data derived from B28003 PRESENCE OF A COMPUTER AND TYPE OF INTERNET SUBSCRIPTION IN HOUSEHOLD: - ACSDT5Y2018.B28003-Data.csv - ACSDT5Y2018.B28003-Column-Metadata.csv - ACSDT5Y2019.B28003-Data.csv - ACSDT5Y2019.B28003-Column-Metadata.csv - ACSDT5Y2020.B28003-Data.csv - ACSDT5Y2020.B28003-Column-Metadata.csv - ACSDT5Y2021.B28003-Data.csv - ACSDT5Y2021.B28003-Column-Metadata.csv
American Community Survey (ACS) data derived from S2801 TYPES OF COMPUTERS AND INTERNET SUBSCRIPTIONS: - ACSST5Y2018.S2801-Data.csv - ACSST5Y2018.S2801-Column-Metadata.csv - ACSST5Y2019.S2801-Data.csv - ACSST5Y2019.S2801-Column-Metadata.csv - ACSST5Y2020.S2801-Data.csv - ACSST5Y2020.S2801-Column-Metadata.csv - ACSST5Y2021.S2801-Data.csv - ACSST5Y2021.S2801-Column-Metadata.csv
Facebook
TwitterMIT Licensehttps://opensource.org/licenses/MIT
License information was derived automatically
Table contains county residents without health insurance. Data are summarized as people of all ages and those 19 to 64 years old. 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 B27001; data accessed on June 30, 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 health insurance coverage was assessedt_uninsured (Numeric): Number of people (all ages) who were without health insurancep_uninsured (Numeric): Percent of people (all ages) who were without health insurancet_19_64 (Numeric): Population ages 19 to 64 years for whom health insurance coverage was assessedt_unins_19_64 (Numeric): Number of people ages 19 to 64 years who were without health insurancep_unins_19_64 (Numeric): Percent of people ages 19 to 64 years who were without health insurance
Facebook
TwitterMIT 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
Facebook
TwitterCC0 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.
Facebook
TwitterA crosswalk dataset matching US ZIP codes to corresponding county codes
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