Tuesday, July 3, 2007

ZIP Code to MSA name

This is an Excel file from the U.S. Department Of Labor, listing all of the ZIP codes and indicating what MSA, if any, it's located in. Quite good.


EDIT: Above is not working so well, but as of 8/7/09, this is.

9 comments:

Leonard Gaines said...

Do you know how they classify a ZIP code that crosses a county boundary, especially if it is means that part of the ZIP code is in one metropolitan area and another is either out totally or in a different one?

Roger Green said...

I'm sure that there are such ZIP codes, but I haven't hit on any examples yet. Unlike those lists that are carved up by county, I couldn't find an obvious one.

That said, I tried to call the federal DOL, but could find no one who could answer my question, though, to be fair, maybe he or she is at lunch.

charlie said...

I put this data into a simple website that maps ZIP to MSA and MSA to ZIP. www.msa-zip.com You can also download the data in a CSV file, as the link to the government website above is no longer working.

Chantel said...

You write very well.

Mia said...

This was usefull thanks! But I wanted to say THANK YOU to charlie for the website he put together, that is an awesome resource.

Anonymous said...

Thank you.

Jacen said...

Yeah, I agree with Mia. Charlie, your website saved me a lot of time. Thanks!

Roger Owen Green said...

See more up-to-date source here.

Matt said...

I have started a small project site that distributes licensed USPS zip code data. I started the site because I was frustrated by this exact question on how to link to MSAs!

I don't know how much you know this, but there are HUGE amounts of changes to Zip codes all the time based on changes to carrier postal routes. We receive monthly updates at a zip+4 level (which also allows you to link zip codes to census block, congressional district and the like - great fun.) Anyway, point being that links to MSA and zip codes rapidly go out of date. The ones from the census are quite old (based of 2000 data.)

I've put up a download here that links all the MSAs, CBSAs, Combined Statistical Areas, and Metropolitan Divisions that we update monthly with the most accurate zip codes. A sample file is up for download as well so you can get a feel for it...

http://www.zipcodeinsights.com/zip/zip-code-data-downloads/msa-cbsa-csa-division-to-zip-code.html

Zip codes to msa cbsa csa and division


Hope this is helpful and love your site - a great read for a data guy!!