Blog

Free Zip Code, City, County, State, CSV

You can write SQL which outperforms and is bug free.

Get your copy of my SQL Best Practices and start writing the SQL which sails through code reviews.

Cost? Pay what you want :)


Student or just starting your career? Give yourself a break and get it for free.

Database professional? Think about your hourly rate and how much time you'll save with crisp and clear best practices.
Contribute over $27 and I'll send you the Word version of the doc so you can easily customize it for yourself and your team.

Get SQL Best Practices

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:

No comments yet.

Leave a Reply