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: December 3, 2024
Distribution Frequency: quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
United States ZIP Codes Database Standard Edition Reference Manual
United States ZIP Codes Database Standard Edition Sample Data
Portions of data provided by and Copyright United States Postal Service 2023. Quentin Sager Consulting is a non-exclusive licensee of the United States Postal Service.
ZIP Code Assignments File
| 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 |
| State | CHAR (2) | USPS state or territory abbreviation |
| CityType | CHAR (1) | USPS recognition of the CITY name when used with this ZIP code |
| ZipType | CHAR (1) | General classification or type for the ZIP code |
| Latitude | DOUBLE | Latitude in decimal degrees of the geographic centroid of the ZIP code |
| Longitude | DOUBLE | Longitude in decimal degrees of the geographic centroid of the ZIP code |
Alternate City Names File
| Field | Data Type | Field Description |
|---|---|---|
| ZipCode | CHAR (5) | The United States 5-digit ZIP code |
| ZipType | CHAR (1) | General classification or type for the ZIP code |
| CityType | CHAR (1) | USPS recognition of the CITY name when used with this ZIP code |
| City | VARCHAR (64) | City, organization, or entity name associated with the ZIP Code |
| State | CHAR (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`));