Combined United States, Canada, Mexico Postal Codes - Premium Edition

Combined Postal Codes

Complete listing of all United States, Canadian, and Mexican postal codes in a single package. Full state, province, and territory names and abbreviations; postal code types; latitude and longitude coordinates. This package also includes full time zone information and primary telephone area code associated with each postal code.

Produced: on or before 5th calendar day quarterly
Current Release: October 3, 2017
Distribution Frequency: quarterly (issue date: January, April, July, October)
Distribution Format: Internet download


Postal Codes Assignments File

FieldData TypeField Description
PostalCodeCHAR(7)United States, Canada or Mexico ZIP or postal code.
  • 5-digit United States Postal Service ZIP Code
  • 5-digit SEPOMEX postal code
  • 7-character Canada Post postal code; formatted 3-character Forward Sortation Area (FSA), space, 3-character Local Delivery Unit (LDU)
PlaceVARCHAR(64)Settlement, town, community, colony, or locale name.

Mexico entries only
CityVARCHAR(64)The city, community, station or other name for the postal code area.
CountyNameVARCHAR(64)Name of the Mexico municipality or predominate United States county, parish, or borough the postal code is located in.
StateProvinceNameVARCHAR(64)The full name for the state, province or territory the postal code is located in.
StateProvinceVARCHAR(5)ISO 3166-2 country subdivision code.
  • US - 2 character USPS state or territory abbreviation
  • CA - 2 character Canada Post province or territory abbreviation
  • MX - 2-4 character SEPOMEX state abbreviation
CountryCHAR(2)ISO 3166-1 two character country code
  • US - United States
  • CA - Canada
  • MX - Mexico
CityTypeCHAR(1)USPS or Canada Post recognition of the City name when used with this postal code.
  • P - the specified city name is the official city name for this postal code.
  • A - the city name is an acceptable alternate for use with this postal code.
  • N - the specified city name is not acceptable for use with this postal code.
PostalCodeTypeCHAR(1)The postal code definition or type for delivery purposes.

United States entries
  • S - A standard ZIP Code
  • P - A ZIP Code used only for Post Office Boxes
  • U - A ZIP Code used for a unique organization
  • M - An APO/FPO (Military) ZIP Code
Mexico and Canada entries
  • U - urban
  • R - rural
FIPSCHAR(5)County or county equivalent code.
  • US - 5-digit FIPS county code
  • MX - 5-digit INEGI municipality code
AreaCodeCHAR(3)Predominate 3-digit telephone area code.
  • United States or Canadian 3-digit Numbering Plan Area (NPA)
  • Mexican Region 3-digit Identification Number (NIR).
OverlayVARCHAR(128)Additional telephone area codes in use when the predominate telephone area code is an overlayed area code. Multiple entries are separated by an ASCII forward slash "/" character.
TimeZoneCHAR(2)North American Time Zone the post code is located in.
  • AK - Alaska
  • AS - (American) Samoa
  • AT - Atlantic
  • CA - Caroline
  • CH - Chamorro
  • CT - Central
  • ET - Eastern
  • HT - Hawaii-Aleutian
  • MA - Marshall
  • MT - Mountain
  • NT - Newfoundland
  • PA - Palau
  • PT - Pacific
DSTCHAR(1)Y/N indicator specifying whether daylight savings time is recognized
UTCCHAR(6)Time zone the postal code is located in specified as a Universal Time Coordinate offset
LatitudeDOUBLELatitude in decimal degrees to the approximate geographic center of the postal code service area.
LongitudeDOUBLELongitude in decimal degrees to the approximate geographic center of the postal code service area.

SQL Table Definitions

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

DROP TABLE IF EXISTS `uscamx`;
CREATE TABLE `uscamx` (
  `PostalCode` char(7) NOT NULL,
  `Place` varchar(64) DEFAULT NULL,
  `City` varchar(64) DEFAULT NULL,
  `CountyName` varchar(64) DEFAULT NULL,
  `StateProvinceName` varchar(64) NOT NULL,
  `StateProvince` varchar(5) NOT NULL,
  `Country` char(2) NOT NULL,
  `CityType` char(1) DEFAULT NULL,
  `PostalCodeType` char(1) DEFAULT NULL,
  `FIPS` char(5) DEFAULT NULL,
  `AreaCode` char(3) DEFAULT NULL,
  `Overlay` varchar(128) DEFAULT NULL,
  `TimeZone` char(2) DEFAULT NULL,
  `DST` char(1) DEFAULT NULL,
  `UTC` char(6) DEFAULT NULL,
  `Latitude` double DEFAULT NULL,
  `Longitude` double DEFAULT NULL,
  KEY `postal` (`PostalCode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;