FIPS and County Code Lookup

magic_dreamer

于 2015-10-13 05:19:29 发布

阅读量672

点赞数

CC 4.0 BY-SA版权

分类专栏： Database Scripts

本文链接：https://blog.csdn.net/magic_dreamer/article/details/84744552

Scripts 同时被 2 个专栏收录

299 篇文章

订阅专栏

Database

53 篇文章

订阅专栏

本文提供了从ZIP码到FIPS县代码的映射资源及步骤。通过HUD官方网站上的Excel文件可以实现ZIP码与县的对应关系转换。此外，还提供了一个FIPS县代码的Excel对照表。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

FIPS and County Code Lookup

There is a mapping EXCEL from here http://www.schooldata.com/pdfs/US_FIPS_Codes.xls

I found the content from here http://www.huduser.gov/portal/datasets/usps_crosswalk.html

I select “ZIP-COUNTY” and “2nd Quarter 2015” I download the EXCEL file with this format.
http://www.huduser.gov/portal/datasets/usps/ZIP_COUNTY_062015.xlsx

References:
http://stackoverflow.com/questions/10081203/fips-county-code-lookup

https://github.com/bgruber/zip2fips
http://stackoverflow.com/questions/13316185/r-convert-zipcode-or-lat-long-to-county
https://www.zipinfo.com/products/cz/cz.htm
http://opendata.stackexchange.com/questions/4335/mapping-counties-to-zip-codes
http://www.huduser.gov/portal/datasets/usps_crosswalk.html