art photo

DSDR KB

Q:  

Do you know where I can get a zipcode-to-county crosswalk online database? I have it for the state of Michigan but now I'd like one for the entire U.S. if possible. There are certain sites that have all states, but I would not want to download the files one state at a time.

A:  

There is a correspondence database:

http://mcdc.missouri.edu/websas/geocorr12.html.

It is also available for 2000 FIPS codes:

http://mcdc2.missouri.edu/websas/geocorr2k.html.

and for 1990 FIPS codes:

http://mcdc2.missouri.edu/websas/geocorr90.shtml.

On occasion, a zip code will cross county boundaries. The results from this utility, will provide a weight that shows what proportion of the population of that zip code is in one county and what proportion is in the other(s). For the most part, zip codes map to single counties, but you'll be able to tell where it doesn't.

If you have trouble figuring out what to do, I'll walk you through one state. You can do all states at once. You just have to highlight them all.

Annotated Resources:

Direct Links:

Related Question Groups:


W A R N I N G

If you are reading this, it may be that you are using rather old web browsing software that does not support modern international Web technology standards. For a better experience of the Web and this site in particular, please upgrade your web browser software. The following are good choices:

Firefox
Opera
Safari