The Gold Edition contains a complete listing of all United States ZIP Codes, associated geographic coordinates, population based Metropolitan Statistical Area codes, times zones, DST recognized, FIPS codes and county cross-reference data.
This data is well suited for many type applications. Typical uses include ZIP Code lookup, ecommerce, user input validation, customer support and marketing, nearest dealer location and so on.
Produced: on or before 5th calendar day quarterly
Current Release: October 4, 2024
Distribution Frequency: quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
United States ZIP Codes Database Gold Edition Reference Manual
United States ZIP Codes Database Gold 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.
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 |
CountyName | VARCHAR (64) | Name of primary county, parish, or borough for the ZIP Code location |
StateName | VARCHAR (64) | Full name of the state or territory |
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 |
CSA | CHAR (3) | 3-digit OMB code of the CSA the ZIP code is located in |
CBSA | CHAR (5) | 5-digit OMB code of the CBSA the ZIP code is located in |
CBSA_DIVISION | CHAR (5) | 5-digit OMB code of the CBSA Division the ZIP code is located in |
CBSA_STATUS | CHAR (1) | Specifies whether the CBSA is a Metropolitan or Micropolitan area |
NECMA | CHAR (4) | Historical OMB 4-digit code of the New England County Metropolitan Area the ZIP Code is located in |
Combined Necta | CHAR (3) | OMB 3-digit code of the Combined New England City and Towns Area the ZIP Code is located in |
NECTA | CHAR (5) | OMB 5-digit code of the New England City and Towns Area the ZIP Code is located in |
NECTA Division | CHAR (5) | OMB 5-digit code of the New England City and Towns Area division the ZIP Code is located in |
MSA | CHAR (4) | 4-digit OMB code of the MSA the ZIP code is located in |
PMSA | CHAR (4) | 4-digit OMB code of the PMSA the ZIP code is located in |
FIPS | CHAR (5) | FIPS 5-digit county number |
AreaCode | CHAR (3) | Predominate 3-digit telephone area code |
Overlay | VARCHAR (28) | Additional telephone area codes in use when the predominate telephone area code is an overlayed area code. |
TimeZone | CHAR (2) | Primary time zone the ZIP code is located within |
DST | CHAR (1) | Single character Y/N value indicating whether daylight saving time is observed at this location. |
UTC | VARCHAR (28) | The standard time Coordinated Universal Time (UTC) offset at this location. Format is +\-HH:MM. |
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 |
CustomerServiceArea | CHAR (1) | United States Postal Service Customer Service Area code for this ZIP Code |
CustomerServiceAreaName | VARCHAR (64) | Name of the USPS Customer Service Area for this ZIP Code |
CustomerServiceDistrict | CHAR (3) | United States Postal Service Customer Service Area District code for this ZIP Code |
CustomerServiceDistrictName | VARCHAR (64) | Name of the USPS Customer Service Area District for this ZIP Code |
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 |
Field | Data Type | Field Description |
---|---|---|
FIPS | CHAR (5) | FIPS county code |
CountyName | VARCHAR (64) | Name of the county, parish, or borough |
State | CHAR (2) | USPS state or territory abbreviation |
Pop2000 | DOUBLE | United States Census 2000 population |
Pop2009 | DOUBLE | United States Census 2009 population |
Pop2010 | DOUBLE | United States Census 2010 population |
LandAreaSquareMiles | DOUBLE | County land area in square miles |
WaterAreaSquareMile | DOUBLE DEFAULT | County water area in square miles |
CountyType | VARCHAR (128) | County or entity type described by county name |
County_Seat | VARCHAR (64) | County seat or center of county government |
Field | Data Type | Field Description |
---|---|---|
CSA | CHAR (3) | 3-digit OMB Combined Statistical Area code |
CBSA | CHAR (5) | 5-digit OMB Core Based Statistical Area code |
CBSA_Division | CHAR (5) | 5-digit OMB Core Based Statistical Division Area code |
CSA_Title | VARCHAR (128) | OMB Combined Statistical Area name |
CBSA_Title | VARCHAR (128) | OMB Core Based Statistical Area name |
CBSA_Division_Title | VARCHAR (128) | OMB Core Based Statistical Division Area name |
CBSA_Level | VARCHAR (128) | CBSA type (micropolitan or metropolitan) |
Field | Data Type | Field Description |
---|---|---|
MSA | CHAR (4) | 4-digit OMB Metropolitan Statistical Area code |
PMSA | CHAR (4) | 4-digit OMB Primary Metropolitan Statistical Area code |
ALT_CMSA | CHAR (2) | 2-digit OMB Alternate Consolidated Metropolitan Statistical Area code |
AREA_NAME | VARCHAR (128) | The OMB name for the Metropolitan Statistical Area |
STATE | VARCHAR (28) | State (or multi-state definition) the statistical area covers |
AREA_TYPE | VARCHAR (10) | The MSA area type |
CREATE DATABASE IF NOT EXISTS `zipgold`;
USE `zipgold`;
DROP TABLE IF EXISTS `zipcodes`;
CREATE TABLE `zipcodes` (
`ZIP` CHAR(5) NOT NULL,
`City` VARCHAR(64) DEFAULT NULL,
`Abbreviation` VARCHAR(13) DEFAULT NULL,
`CountyName` VARCHAR(64) DEFAULT NULL,
`StateName` VARCHAR(64) DEFAULT NULL,
`State` CHAR(2) DEFAULT NULL,
`CityType` CHAR(1) DEFAULT NULL,
`ZipType` CHAR(1) DEFAULT NULL,
`CSA` CHAR(3) DEFAULT NULL,
`CBSA` CHAR(5) DEFAULT NULL,
`CBSA_DIVISION` CHAR(5) DEFAULT NULL,
`CBSA_STATUS` CHAR(1) DEFAULT NULL,
`NECMA` CHAR(4) DEFAULT NULL,
`Combined Necta` CHAR(3) DEFAULT NULL,
`NECTA` CHAR(5) DEFAULT NULL,
`NECTA Division` CHAR(5) DEFAULT NULL,
`MSA` CHAR(4) DEFAULT NULL,
`PMSA` CHAR(4) DEFAULT NULL,
`FIPS` CHAR(5) DEFAULT NULL,
`AreaCode` CHAR(3) DEFAULT NULL,
`Overlay` VARCHAR(28) DEFAULT NULL,
`TimeZone` CHAR(2) DEFAULT NULL,
`DST` CHAR(1) DEFAULT NULL,
`UTC` VARCHAR(28) DEFAULT NULL,
`Latitude` DOUBLE DEFAULT 0,
`Longitude` DOUBLE DEFAULT 0,
`CustomerServiceArea` CHAR(1) DEFAULT NULL,
`CustomerServiceAreaName` VARCHAR(64) DEFAULT NULL,
`CustomerServiceDistrict` CHAR(3) DEFAULT NULL,
`CustomerServiceDistrictName` VARCHAR(64) DEFAULT NULL,
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`));
DROP TABLE IF EXISTS `counties`;
CREATE TABLE `counties` (
`FIPS` CHAR(5) NOT NULL,
`CountyName` VARCHAR(64) DEFAULT NULL,
`State` CHAR(2) DEFAULT NULL,
`Pop2000` DOUBLE DEFAULT 0,
`Pop2009` DOUBLE DEFAULT 0,
`Pop2010` DOUBLE DEFAULT 0,
`LandAreaSquareMiles` DOUBLE DEFAULT -1,
`WaterAreaSquareMile` DOUBLE DEFAULT -1,
`CountyType` VARCHAR(128) DEFAULT NULL,
`County_Seat` VARCHAR(64) DEFAULT NULL,
PRIMARY KEY (`FIPS`));
DROP TABLE IF EXISTS `cbsa`;
CREATE TABLE `cbsa` (
`CSA` CHAR(3) DEFAULT NULL,
`CBSA` CHAR(5) NOT NULL,
`CBSA_Division` CHAR(5) DEFAULT NULL,
`CSA_Title` VARCHAR(128) DEFAULT NULL,
`CBSA_Title` VARCHAR(128) DEFAULT NULL,
`CBSA_Division_Title` VARCHAR(128) DEFAULT NULL,
`CBSA_Level` VARCHAR(128) DEFAULT NULL,
KEY (`CBSA`));
DROP TABLE IF EXISTS `msa`;
CREATE TABLE `msa` (
`MSA` CHAR(4) NOT NULL,
`PMSA` CHAR(4) DEFAULT NULL,
`ALT_CMSA` CHAR(2) DEFAULT NULL,
`AREA_NAME` VARCHAR(128) DEFAULT NULL,
`STATE` VARCHAR(28) DEFAULT NULL,
`AREA_TYPE` VARCHAR(10) DEFAULT NULL,
PRIMARY KEY (`MSA`));