ZIP Code Database

Match ZIP Codes to City, State, Latitude and Longitude

Working on laptop
René Mansi/E+/Getty Images

This free Access database of ZIP codes provides database designers with a valuable tool to help map ZIP codes to a city/state pair. It also provides the latitude and longitude of each location. The database contains three tables: the ZIP Code table, the Class table and the States table.

Note: This database is in the MDB format used by Access prior to its 2007 release. Access 2007 and later versions use the ACCDB format. You can still import this database into later versions and save it in ACCDB format.

The ZIP Code Database Design 

The ZIP Code table contains six fields:

  • ZIP Code is the five-digit ZIP code and is the primary key of this table.
  • Latitude is the latitude of the location, to five decimal places.
  • Longitude is the longitude of the location, to five decimal places.
  • Class is the class of the ZIP code and is the foreign key to the Class table.
  • City is the name of the post office serving this ZIP code.
  • State Code is the two-digit state code, as defined by the Federal Information Processing Standards, and is the foreign key to the States table.

The States table contains three fields:

  • State Code is the two-digit state code, as defined by the Federal Information Processing Standards.
  • State Abbreviation is the commonly accepted postal abbreviation for the state.
  • State Name is the full name of the state.

The Class table contains two fields:

  • Class is the one character class code.
  • Description is a text field describing the class in further detail.

    I’ve added a query, “Show All ZIP Codes” that lists the city and state pair associated with each ZIP code for your reference. You may wish to build additional queries for your specific needs.

    Downloading the Database


    Download Link:You may download the database in Microsoft Access format.

    Terms of Use: This Access database is copyright 2006, Mike Chapple.

    You may use it for personal or business use, but you may not redistribute this file to others without written permission.

    Important Note: The ZIP code data in this database was obtained from the 1999 United States Census. As a product of the Census Bureau, it is in the public domain. You should understand that 1999 was the last year that the Census Bureau produced this data, so there are no more recent updates. The Census Bureau does produce a series of data files on what it called Zip Code Tabulation Areas (ZCTAs) that reflect statistical data about ZIP code areas. 

    To obtain a more current file, various vendors offer commercial products. The U.S. Postal Service used to provide a similar database, but now just lists suggested vendors for ZIP code and other data.  

    Format
    mla apa chicago
    Your Citation
    Chapple, Mike. "ZIP Code Database." ThoughtCo, Nov. 17, 2016, thoughtco.com/zip-code-database-1019509. Chapple, Mike. (2016, November 17). ZIP Code Database. Retrieved from https://www.thoughtco.com/zip-code-database-1019509 Chapple, Mike. "ZIP Code Database." ThoughtCo. https://www.thoughtco.com/zip-code-database-1019509 (accessed November 23, 2017).