Updated 10/12/2009
Software and database developers often need a list of US zip codes, unfortunately the official zip code database from the Postal Service costs hundreds of dollars a year and does not contain useful information such as latitude or longitude (one such website that requires zip code information is federalgovernmentjobs.us).
About the data:
The basic list is obtained directly from the postal service.
The list is updated often, but not regularly. Old zip codes are "decommissioned"
rather than removed from the list. Since the Post Office includes a number of different
city names for some zip codes, there is a record for each place name. The main unique
zip code record is indicated by the primary=Yes (about 42,456 of 80,164 )
All non-military zip codes are assigned latitude and longitude based on mapping APIs and have been checked for "reasonableness" by comparing to other zip codes in the same county. A continent code and the ISO 3166 country code are assigned when available.
All military zip codes (APO, FPO, and DPO) are included, but do not contain location or demographic information. Each does contain the current restriction codes.
Census ZCTA files from 2000 are used to include estimates for population, land and water area, and housing units.
Updates are based on the USPS Postal Bulletin Changes.
Zipcode
Latitude(Decimal)
Longitude(Decimal)
City
State
County
Zipcode Type
Primary
WorldRegion
Country
LocationText
Location
Population
HousingUnits
Income
LandArea
WaterArea
Decommisioned
MilitaryRestrictionCodes ( Definitions can be found in the Postal Bulletin)
A good resource for coding distance searches is located at http://msdn.microsoft.com/en-us/library/ms980211.aspx
| Quoted CSV | Excel | MySQL (From 2/15/2009 data) |
| free-zipcode-database.csv (12 MB) | free-zipcode-database.xlsx (10 MB) | zip_code_full.zip (.zip 2.5 MB) |
Links appreciated. and correction too.