Here’s a convenient file with all the US zip codes and their associated latitude, longitude, city, state, and county. Mapping modules in Drupal and WordPress may require this database which isn’t always included due to size.

Download:

Zip Code Database

21 Responses to “Download: Zip Code Latitude Longitude City State County CSV”

  1. Maria

    This is great, very useful. Can you tell me what the source of this data is or how you made it?

  2. Islam Sharabash

    Thai, you’re my hero.

  3. Tim Heider

    Thank you very much!

  4. Mary O'Shaughnessy

    Thank you! This is a godsend.

  5. Valerie

    I appreciate what you are trying to do, but some of those coordinates are way off. Look at zip code 85732, your coordinates are 20 miles away from the center of the actual zip code. This is not the only one, I found many in Arizona, not sure how wide spread it is. Please add a disclaimer because if someone needs accuracy, these are not going to work well.

  6. Don Wise

    I agree with Valerie, this is a great effort, however in checking Los Angeles County zip codes, the same Lat/Lon is used for each zip code; this would be incorrect if working with data associated to a particular address or within a zip code.

    • Alysa Ochoa

      I agree with Don and Valerie. The Los Angeles zip codes aren't accurate. Good effort but I wouldn't use these for geographic analysis.

  7. walter

    you can get one here that is pretty good and regularly maintained: http://greatdata.com from the menu choose ‘more’ > ‘free products’.

  8. http://perthseod.com

    However long term developing a very large theme blog with quality
    content can be lucrative and a good way to do Internet marketing.
    An Internet marketing company will provide detailed monthly reports on
    the performances of your various campaigns which will help you track
    your business’s performance and improve your ROI. Even if
    you’re working by yourself, being enthusiastic will
    make a major difference to your overall progress, and it will show in your work.

  9. Dheeraj Remella

    Thai, Thanks so much for this.

  10. Joe Santos

    Thank you very much Thai for collecting this data. I will reference your contribution in my work.

  11. Sami

    I have associate this file into MATLAB code to find the distance between two Zip Codes using your data of the Lat and lon data found in the cvs file.
    Please feel free to check it out and let me know if you have any concerns.

    http://www.mathworks.com/matlabcentral/fileexchange/45905-zip-code-latitude-longitude-city-state-county

  12. GN

    Thanks Thai!

  13. Paul Duggan

    Hi Thai,

    Disclaimer: I work for GreatData.com. We provide a commercial ZIP Code product and a free one.

    I appreciate that you’re trying to help people!

    We understand that most people can’t check lat/long data to see if it’s accurate, so I made a program to see how the data compared, since others said that it wasn’t always correct. We found 1,564 bad ZIP Codes. About half of the lat/long was at least 3 miles off and 2,266 were over 20 miles off. It’s not easy creating a ZIP Code lat/long database (we’ve been working on it for about 20 years and still have challenges keeping it current!)

    If you would like to link to our free product from this page, feel free. We maintain it quarterly and a lot of people use it. We know that not everyone can afford a commercial product, so our free product was created to ensure that people have reasonably accurate info.

    • Shan Gill

      Paul – UPDATE: now there isn't any 'free' database @ GreatData.com

      • Paul

        Hi Shan,

        That's correct. We no longer have the free data page, but have a low-cost site for a ZIP Code database with latitude and longitude at SoftwareTools.com.

  14. Joel

    I wanted to defend Thai so I did some R analysis to compare the two data sources. I had to end up agreeing with Paul though. I was able to merge 25k of the roughly 42k sites on each list.

    I converted each lat/long from here (gl) and the GreatData site (gd) and compared the difference in mileage calculated by conferting to radians and then using the linked paged to calculate distance.

    Degrees to radians: http://www.r-bloggers.com/r-function-to-convert-degrees-to-radians/
    Distance: http://andrew.hedges.name/experiments/haversine/
    I found the mean distance discrepancy was 6 miles, and the median was 2.7 miles. So most of the time it was pretty good. Hawaii was for some reason way off though and remote areas were also bad in CA. when I did a one for one on the bad locations GD data landed on the map and GL data dropped me in the ocean or a desert.

  15. Sanjay Sharma

    Very Useful, Thanks a lot.

Comments are closed.