federalgovernmentzipcodes.us

A Free Zipcode Database

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.

contact

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

zip code latitude longitude database

 zip code lookup database

mysql zip code database

census zip code database

free zip code software

free zip code table

zip code data base

free zip code radius search