Blog

Free Zip Code, City, County, State, CSV

Banner will redirect to landing page with Certification Track courses.

Free Download of the zip code CSV file available at the bottom of this post.

Why this is so hard to track down I don't know.  We were looking for a comma
delimited list which would map zip code to county since county is the lowest
grain available in the out of the box SQL Server Reporting Services (SSRS) maps.  There are plenty of vendors offering this data for a fee, but who wants to pay a fee for a proof of concept project?  Not I. As an added bonus this free list has latitude and longitude coordinates as well.

The attached file contains the following fields:

Zip Code

Latitude

Longitude

City

State

County

Zip Class

 

Sample Data Format:

"91941","+32.761050","-116.998102","LA MESA","CA","SAN DIEGO","STANDARD"

 

Of note: We have not used the data in this file yet so I'm not sure if
there are any issues with it.

 

The original source of the file was the site below.  In addition to providing this file they also have a Canadian Postal Code CSV and a few files mapping IP addresses to city or country.

http://www.populardata.com/

Without further ado, here is the link to the compressed zip code file:

zipcodes.zip

Tags:

28 Responses to “Free Zip Code, City, County, State, CSV”

  1. Steve January 16, 2012 at 8:50 pm #

    Hi there,

    Do you by any chance have a link to the Canadian Postal Codes database? I can't seem to access populardata.com.

    Cheers,

    Steve

  2. dbo January 18, 2012 at 12:18 pm #

    Hey Steve,

    Sorry, I don't have a Canadian postal code file. Also, it looks like the populardata.com site is down.

    Good luck!

    Phil

  3. Joe January 22, 2012 at 10:22 am #

    Thanks so much saved a ton of time and most of all seems to be really accurate thus far

  4. Bill February 23, 2012 at 9:49 am #

    Thanks guys. This has been very helpful.I have used this for DC, Baltimore, Atlanta, Cincinnati, NY, and Philly. All have been accurate.

  5. dbo February 24, 2012 at 2:36 pm #

    Good to hear!

  6. dbo February 24, 2012 at 2:36 pm #

    Happy to help!

  7. kathy July 25, 2012 at 1:23 pm #

    I need several zip codes, hope this will help.

  8. dbo August 1, 2012 at 10:35 am #

    Good luck. Let me know how it works!

  9. Jami August 28, 2012 at 7:30 am #

    This is exactly what I needed. Thanks!

  10. Howard Renollet August 29, 2012 at 11:35 am #

    Huge help!! Thank you so much for posting this!!!

  11. Jeff November 12, 2012 at 9:30 am #

    you rock! been looking for this for 15 years.

  12. Phil Steffek November 12, 2012 at 10:00 am #

    Well shoot! I should have posted it a long time ago!

  13. Jason February 10, 2013 at 10:22 am #

    Thanks for posting this! Very helpful.
    I noticed that there are 155 regular zipcodes with blank lat/lon and another 537 military zipcodes with blank lat/lon.

    I don't know what to do with the militarly zips, so I have just removed them from my DB, however I did geocode the remaining 155 zipcodes.

    I uploaded a CSV file of just the corrected zipcodes here:
    http://rapidshare.com/files/518676851/missing_zips_geocoded.csv

    Hopefully that will help someone, or help you update the original CSV.

  14. Ben March 19, 2013 at 7:08 am #

    Awesome, thanks bro.

    @ Jason your download link is dead.

  15. Phil Steffek March 20, 2013 at 1:08 pm #

    Glad it worked for you Ben. Best of luck!

  16. Jason March 20, 2013 at 1:18 pm #

    @Ben - thanks for letting me know. Looks like RapidShare changed their file access rules since I uploaded.

    Should be working now.
    http://rapidshare.com/files/518676851/missing_zips_geocoded.csv

  17. Kris April 8, 2013 at 1:02 pm #

    Much appreciated for the share. Really helped to map zips to counties.

    Thanks a lot!

  18. Phil Steffek April 9, 2013 at 10:20 am #

    Sure thing Kris! Best of luck!

  19. beka April 16, 2013 at 11:01 am #

    You rock. Thank you so much.

  20. Phil Steffek April 17, 2013 at 3:36 pm #

    No. You rock!

  21. Kay Heckroth March 7, 2014 at 7:57 am #

    How often do you refresh the Zip Code file?

  22. Aaliyah March 10, 2014 at 3:59 am #

    Hi, all is going well here and ofcourse every one is sharing information, that's really
    good, keep up writing.

  23. Andrew March 11, 2014 at 7:46 pm #

    I noticed the City of Bloomington in Minnesota is missing data. Any ideas why? Thanks.

  24. war thunder aimbot March 21, 2014 at 12:45 pm #

    I've been browsing on-line greater than three hours as of late, yet I by no means discovered any fascinating article like yours.
    It is pretty worth enough for me. In my view, if all web owners and bloggers made excellent content material as
    you probably did, the internet can be much more helpful than
    ever before.

  25. dragon story hack tool March 21, 2014 at 12:45 pm #

    Spot on with this write-up, I honestly think this website needs
    far more attention. I'll probably be back again to read more, thanks for the
    advice!

  26. how to hack zombie lane April 2, 2014 at 7:10 am #

    I love your blog.. very nice colors & theme. Did you create this website yourself or did you
    hire someone to do it for you? Plz answer back as I'm looking to design my own
    blog and would like to know where u got this from. kudos

  27. learn to plaster courses April 18, 2014 at 11:45 am #

    I will leave you with this thought: In order for the "clocks" on our several global positioning
    satellites to keep our location on the planet accurate enough to be useful, did you know they must be adjusted
    everyday. This means that OSHA has reviewed the material and has accepted it for online distribution.
    Fire protection was not specified in the policy and the peril, in
    this case lightening, did not occur to the specified dwelling.

  28. John December 19, 2014 at 1:19 pm #

    Thanks for making this available. Our company is currently re-organizing sales territories by county and we needed to be able to quickly pull a list of accounts and the only way to do it was by zip code. This list made me look like a hero!

Leave a Reply