United States 5-Digit ZIP Codes - Standard Edition

United States 5-Digit ZIP Codes

The Standard Edition contains a complete listing of all United States ZIP Codes and their corresponding geographic latitude and longitude coordinates. It also contains the USPS preferred and alternate city or organization name for each ZIP Code.

This data is well suited for basic ZIP Code validation, city-state lookup, and nearest dealer type applications.

Produced: on or before 5th calendar day quarterly
Current Release: January 4, 2017
Distribution Frequency: quarterly (issue date: January, April, July, October)
Distribution Format: Internet download

Portions of data provided by and Copyright United States Postal Service 2017. Quentin Sager Consulting is a non-exclusive licensee of the United States Postal Service.


ZIP Code Assignments File

FieldData TypeField Description
ZIPCHAR (5)The United States 5-digit ZIP code
CityVARCHAR (64)City, organization, or entity name associated with the ZIP Code
StateCHAR (2)USPS state or territory abbreviation
CityTypeCHAR (1)USPS recognition of the CITY name when used with this ZIP code
ZipTypeCHAR (1)General classification or type for the ZIP code
LatitudeDOUBLELatitude in decimal degrees of the geographic centroid of the ZIP code
LongitudeDOUBLELongitude in decimal degrees of the geographic centroid of the ZIP code
FieldData TypeField Description
ZipCodeCHAR (5)The United States 5-digit ZIP code
ZipTypeCHAR (1)General classification or type for the ZIP code
CityTypeCHAR (1)USPS recognition of the CITY name when used with this ZIP code
CityVARCHAR (64)City, organization, or entity name associated with the ZIP Code
StateCHAR (2)USPS state or territory abbreviation

SQL Table Definitions

CREATE DATABASE IF NOT EXISTS `zipstandard`;
USE `zipstandard`;

DROP TABLE IF EXISTS `zipcodes`;
CREATE TABLE `zipcodes` (
	`ZIP` CHAR(5) NOT NULL,
	`City` VARCHAR(64) DEFAULT NULL,
	`State` CHAR(2) DEFAULT NULL,
	`CityType` CHAR(1) DEFAULT NULL,
	`ZipType` CHAR(1) DEFAULT NULL,
	`Latitude` DOUBLE DEFAULT 0,
	`Longitude` DOUBLE DEFAULT 0,
	PRIMARY KEY (`ZIP`));

DROP TABLE IF EXISTS `us_alternate`;
CREATE TABLE `us_alternate` (
	`ZipCode` CHAR(5) NOT NULL,
	`ZipType` CHAR(1) DEFAULT NULL,
	`CityType` CHAR(1) DEFAULT NULL,
	`City` VARCHAR(64) DEFAULT NULL,
	`State` CHAR(2) DEFAULT NULL,
	KEY (`ZipCode`));