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.
