US Zip Code Crosswalk (HUD-USPS)

This dataset includes crosswalks to lookup the US city, state, county, census tract, or core-based statistical areas associated with a given zip code. This includes reverse lookups to identify the zip codes associated with each of these entities. This data is sourced from the Office of Policy Development and Research within the United States Department of Housing and Urban Development. This data share includes 8 lookup tables: zip code to census tract; zip code to county; zip code to CBSA; census tract to zip code; county to zip code; CBSA to zip code, county names from the 2010 census, and CBSA names as defined in February 2013. It also includes a table with demo customer data. This secondary data can be used to practice joining the lookup table with the demo customer data.

The Snowflake Marketplace allows you to access live, ready-to-query data and data services. This lookup table is available for all Snowflake customers and can be used to experiment with accessing data from the Marketplace.

<p><br/></p>

Tables included:

- Zip Code to Census Tract
- Zip Code to County ID
- Zip Code to Core-Based Statistical Area (CBSA)
- Census Tract to Zip Code
- Zip Code to County ID
- Core-Based Statistical Area (CBSA) to Zip Code
- Counties
- Core-Based Statistical Areas

Fields Included:

- Zip Code
- Tract / County / CBSA
- USPS Preferred City Name
- USPS Preferred State Name
- Residential Address Ratio
- Business Address Ratio
- Other Address Ratio
- Total Address Ratio<br/>

Source: This data is sourced from the United States Department of Housing and Urban Development (https://www.huduser.gov/portal/datasets/usps_crosswalk.html) and the United States Census Bureau (https://www.census.gov/geographies/reference-files/time-series/geo/gazetteer-files.2010.html & https://www.census.gov/geographies/reference-files/time-series/demo/metro-micro/delineation-files.html). Lookups last updated in the 4th Quarter 2021.

搜集汇总

背景与挑战

背景概述

该数据集提供美国邮政编码与人口普查区、县、核心统计区等地理信息的双向映射表，包含8个查找表和地址比例等字段，数据源自美国住房和城市发展部，最后更新于2021年第四季度。