federalgovernmentzipcodes.us

A Free Zip Code Database + Latitude and Longitude

Database Updated: 1/22//2012

Send feedback. How can we make this database more useful?
Sorry, No County information. Postal Service delivery areas are not designated by county.

Several people have requested greater precision in the Latitude and Longitude. The values are provided to two decimal places or more. Since a degree of latitude is about 62 miles, one one-hundredth is .62 miles, Similarlly, for the populated places in the US, a degree of latitudes is less than 65 miles. So the numeric values are a single point falls within a quite small area of about a mile for rounding errors. This is far more numerical precision than actual geograhic reality. Zip codes represent delivery routes for the post office. Occasionally as well defined as a single building, or several hundred miles of wilderness, or even a moving ship(no locations for these, of course), usually they are several square miles and the issue is not the number of decimal places. If you find that a zipcode is not at the location listed, please let me know so we can research it and find more accurate locations.

NEW Zipcode database based on suggestions of over 100 people.

• Format: CSV is popular and easiest use.
• Sources: Rebuilt using authoritative sources
• Census demographics are out. Census Zip Code Tabulations Areas (ZCTAs) just aren't compatible with Postal Service zip codes.
• Internal Revenue Service demographics are in. IRS Zip codes are compatible (The zip of the filers primary residence).

About the data:

• Updated often, but not regularly.
• 81,831 rows of data.
• All 41,891 active zipcodes + 634 decommisioned zipcodes from the recent past.
• All 80673 active Primary(41885), Acceptable(13988), and Not Acceptable(24800) placenames. Some additonal placenames for decommisioned codes.
• 29,971 Standard, 9465 PO BOX, 2437 Unique, and 649 Military codes.
• 50 States +
  361 AA Military - Americas
  38 AE Military - Europe
  164 AP Military - Pacific
  1 AS American Samoa
  290 DC Washinton DC
  4 FM Federated States Micronesia
  13 GU Guam
  2 MH Marshall Islands
  3 MP Northern Mariana Islands
  176 PR Puerto Rico
  2 PW Palau
  16 VI Virgin Islands
  

Sources:

• Current zipcodes, placenames, zipcode type(Standard, PO, Unique, Military), placename type (Primary, Acceptable, Not Acceptable): USPS
• Military placenames (base or ship name): MPSA 2008 Election Ballot information
• Tax returns filed, estimated population, total wages: IRS 2008
• Latitude and Longitude; National Weather Service supplemented by Google Earth and Maps and occasionally other sources
• Decommisioned zipcodes, Our old database--usually quality sources, but not verifiable.

Other Sources of zipcode information:

• Placenames (Cities, towns, geographic features) can be found at US Geological Survey GNIS Dataset
• The IRS has additional data fields for 2008 and is reviewing their publication procedures for later years. see http://www.irs.gov/taxstats/indtaxstats/article/0,,id=96947,00.html
• The Census publishes data, but they use Zipcode Tabulation Areas (ZCTAs) which 1) have changed areas between the 2000 census and the 2010 census 2) do not map well to USPS zipcodes well. If needed http://www.census.gov/geo/ZCTA/zcta.html
• Social Security recipients by zipcode http://www.ssa.gov/policy/docs/statcomps/oasdi_zip/
• For economic researchers and those who want tons of background on data sources by zipcode, University of Missouri OSEDA project

Free Zipcode Database (8.7 MB) Updated 1/22/2012 All Locations (Multiple locations for some zipcodes)

Free Zipcode Database (4.2 MB) Updated 1/22/2012  Primary location only ( Just one "Primary" location for each Zip code)

Document encoding: Plain Old ASCII

First Row: Field names in double quotes

Field Delimiter: Comma ","

Text Fields: Enclosed in double quotes "

Line Delimiter: CRLF

Name	Type	Description
Zipcode	Text	5 digit Zipcode or military postal code(FPO/APO)
ZipCodeType	Text	Standard, PO BOX Only, Unique, Military(implies APO or FPO)
City	Text	USPS offical city name(s)
State	Text	USPS offical state, territory, or quasi-state (AA, AE, AP) abbreviation code
LocationType	Text	Primary, Acceptable,Not Acceptable
Lat	Double	Decimal Latitude, if available
Long	Double	Decimal Longitude, if available
Location	Text	Standard Display  (eg Phoenix, AZ ; Pago Pago, AS ; Melbourne, AU )
Decommisioned	Text	If Primary location, Yes implies historical Zipcode, No Implies current Zipcode; If not Primary, Yes implies Historical Placename
TaxReturnsFiled	Long Integer	Number of Individual Tax Returns Filed in 2008
EstimatedPopulation	Long Integer	Tax returns filed + Married filing jointly + Dependents
TotalWages	Long Integer	Total of Wages Salaries and Tips