United States 5-Digit ZIP Codes - Lite Edition

United States 5-Digit ZIP Codes The Lite Edition contains a complete listing of all United States ZIP Codes, their corresponding USPS preferred city or organization name, state, and ZIP Code type.

This is a very basic ZIP Code data product. The data is well suited for simple ZIP Code validation, city-state lookup or similar application.

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
AbbreviationVARCHAR (13)USPS abbreviation for the City name
StateCHAR (2)USPS state or territory abbreviation
ZipTypeCHAR (1)General classification or type for the ZIP code

SQL Table Definitions

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

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