World zip code database free download

Zipcode data is free from the various governments around the world. Yet so many organizations, reputable or not, want to charge money for it. This project is an automated solution for retrieving and collating US and worldwide zipcode data.

In , we originally pulled down all the US census data we could find, parsed it and exported it into 3. Later, we wrote 3 rake tasks to automate this process.

In we began using GeoNames data, which is licensed under Creative Commons. We are grateful to GeoNames for sharing, and urge you to visit their site and support their work. In we refactored the project and made it into a Ruby gem with a command-line executable for automating this process. The Census assigns an area to a ZCTA according to census blocks the smallest geographic unit used by the census.

Imagine a city block that makes up a typical census block as pictured to the right. It is bounded on all 4 sides by portions of city streets that each have their own name and addresses. The issue is that census blocks almost always split down the middle of the street.

ZIP codes rarely do because that would require two postal workers delivering mail to that street - one for each side of the street. In the example, one mail carrier may deliver to 3 sides of the block via one ZIP code while another mail carrier delivers mail on the other street in a different ZIP code.

When this happens, the Census Bureau will assign the entire block to a single ZCTA in this case, because the census block is the area that is precisely measured. If you are getting very precise usually a matter of meters, not miles , census block boundaries near the edge of a ZIP code almost always split ZIP codes. The statistics provided by the Census Bureau can give insight into the demographics within the ZIP code.

For instance, see our ZIP code rankings. Remember that ZIP codes were made to make mail delivery easier. GeoNames is an excellent site, and Marc is incredibly helpful if you can't quite find what you want. I've just emailed him about some geodata I need and he replied quickly with exactly what I needed. You can download postal code to name,lat,lng from their site here: download.

The downside is that they are missing for alot of countries. Zon Zon Thanks for the efforts you made. You could also zip this MB file that makes it just Get the same file here You can open it using HeidiSQL in a safe testing environment inside a testing database. Use VirtualBox or Docker to create an environment you're not feared to damage. How do I calculate the distance between two zip codes? We've published free formulas in popular programming languages.

Check them out. How come some demographic variables are blank empty strings for some zip codes? For privacy reasons, the Census Bureau and IRS will only provide zip code level data if the zip code is large enough to protect resident privacy. So, for smaller zip codes some variables may not be available.

Toggle navigation. Contact Us All Products. Up-to-date: Data updated as of August 10, Useful fields : From latitude and longitude to household income. Accurate : Aggregated from official sources and precisely geocoded to latitude and longitude. Simple: A single CSV file, concise field names, only one entry per zip code.

Yours is great. Clean and well organized! This is a comprehensive database with data about the post office codes for all countries in the world. Each dataset represents a country and has the following information available. Let's consider a Zip Code from Australia as an example. The data provided will look like this:.