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: July 5, 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.
|Field||Data Type||Field Description|
|ZIP||CHAR (5)||The United States 5-digit ZIP code|
|City||VARCHAR (64)||City, organization, or entity name associated with the ZIP Code|
|Abbreviation||VARCHAR (13)||USPS abbreviation for the City name|
|State||CHAR (2)||USPS state or territory abbreviation|
|ZipType||CHAR (1)||General classification or type for the ZIP code|
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`));