United States 5-Digit ZIP Codes - Gold Edition

United States 5-Digit ZIP Codes

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: 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
CountyNameVARCHAR (64)Name of primary county, parish, or borough for the ZIP Code location
StateNameVARCHAR (64)Full name of the state or territory
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
CSACHAR (3)3-digit OMB code of the CSA the ZIP code is located in
CBSACHAR (5)5-digit OMB code of the CBSA the ZIP code is located in
CBSA_DIVISIONCHAR (5)5-digit OMB code of the CBSA Division the ZIP code is located in
CBSA_STATUSCHAR (1)Specifies whether the CBSA is a Metropolitan or Micropolitan area
NECMACHAR (4)Historical OMB 4-digit code of the New England County Metropolitan Area the ZIP Code is located in
Combined NectaCHAR (3)OMB 3-digit code of the Combined New England City and Towns Area the ZIP Code is located in
NECTACHAR (5)OMB 5-digit code of the New England City and Towns Area the ZIP Code is located in
NECTA DivisionCHAR (5)OMB 5-digit code of the New England City and Towns Area division the ZIP Code is located in
MSACHAR (4)4-digit OMB code of the MSA the ZIP code is located in
PMSACHAR (4)4-digit OMB code of the PMSA the ZIP code is located in
FIPSCHAR (5)FIPS 5-digit county number
AreaCodeCHAR (3)Predominate 3-digit telephone area code
OverlayVARCHAR (28)Additional telephone area codes in use when the predominate telephone area code is an overlayed area code.
TimeZoneCHAR (2)Primary time zone the ZIP code is located within
DSTCHAR (1)Daylight savings time is recognized within the area cover by this ZIP code
UTCVARCHAR (28)Time zone the ZIP Code is located in specified as a Universal Time Coordinate offset.
LatitudeDOUBLELatitude in decimal degrees of the geographic centroid of the ZIP code
LongitudeDOUBLELongitude in decimal degrees of the geographic centroid of the ZIP code
CustomerServiceAreaCHAR (1)United States Postal Service Customer Service Area code for this ZIP Code
CustomerServiceAreaNameVARCHAR (64)Name of the USPS Customer Service Area for this ZIP Code
CustomerServiceDistrictCHAR (3)United States Postal Service Customer Service Area District code for this ZIP Code
CustomerServiceDistrictNameVARCHAR (64)Name of the USPS Customer Service Area District for this ZIP Code

Alternate City Names File

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

FIPS County Codes File

FieldData TypeField Description
FIPSCHAR (5)FIPS county code
CountyNameVARCHAR (64)Name of the county, parish, or borough
StateCHAR (2)USPS state or territory abbreviation
Pop2000DOUBLEUnited States Census 2000 population
Pop2009DOUBLEUnited States Census 2009 population
Pop2010DOUBLEUnited States Census 2010 population
LandAreaSquareMilesDOUBLECounty land area in square miles
WaterAreaSquareMileDOUBLE DEFAULTCounty water area in square miles
CountyTypeVARCHAR (128)County or entity type described by county name
County_SeatVARCHAR (64)County seat or center of county government

CBSA Codes File

FieldData TypeField Description
CSACHAR (3)3-digit OMB Combined Statistical Area code
CBSACHAR (5)5-digit OMB Core Based Statistical Area code
CBSA_DivisionCHAR (5)5-digit OMB Core Based Statistical Division Area code
CSA_TitleVARCHAR (128)OMB Combined Statistical Area name
CBSA_TitleVARCHAR (128)OMB Core Based Statistical Area name
CBSA_Division_TitleVARCHAR (128)OMB Core Based Statistical Division Area name
CBSA_LevelVARCHAR (128)CBSA type (micropolitan or metropolitan)

Historical MSA Codes File

FieldData TypeField Description
MSACHAR (4)4-digit OMB Metropolitan Statistical Area code
PMSACHAR (4)4-digit OMB Primary Metropolitan Statistical Area code
ALT_CMSACHAR (2)2-digit OMB Alternate Consolidated Metropolitan Statistical Area code
AREA_NAMEVARCHAR (128)The OMB name for the Metropolitan Statistical Area
STATEVARCHAR (28)State (or multi-state definition) the statistical area covers
AREA_TYPEVARCHAR (10)The MSA area type

SQL Table Definitions

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`));