Combined United States/Canadian Postal Codes - Premium Edition

Combine Postal Codes

Advanced geocoded United States 5-digit ZIP and Canadian Postal Code data. This product contains all United States ZIP codes and Canadian postal codes in a single package.

Contains over 800,000 records. Each record contains the ZIP or postal code, the preferred city or location name with state or province abbreviation and associated 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: April 5, 2017
Distribution Frequency: quarterly (issue date: January, April, July, October)
Distribution Format: Internet download


Postal Code Assignments File

FieldData TypeField Description
PostalCodeVARCHAR(7)The five or six character post code.
CityVARCHAR(64)Name of city or location.
AbbreviationVARCHAR(13)Standard USPS or Canada Post 13 character city name abbreviation.
CountyNameVARCHAR (64)Name of primary county, parish, or borough for the ZIP Code location
StateProvinceNameVARCHAR(64)Full name of the state or province.
StateProvinceCHAR(2)Official abbreviation of the state or province.
CountryCHAR(2)ISO 3166 country code.
CityTypeCHAR(1)Postal Service recognition of the CITY field name
  • D - Default (preferred) city name
  • A - Alternate city name accepted
  • N - Not-recommended, used or accepted
PostalCodeTypeCHAR(1)The postal code definition or type for delivery purposes.
FIPSCHAR (5)FIPS 5-digit county number
AreaCodeCHAR(3)Primary area code associated with the post code.
OverlayVARCHAR (28)Additional telephone area codes in use when the predominate telephone area code is an overlayed area code.
TimeZoneCHAR(2)

North American Time Zone the post code is located in. Determined using Coordinated Universal Time (UTC) offset also referred to as hours relative to GMT.

  • NT - Newfoundland UTC -3:30 hours
  • AT - Atlantic UTC -4 hours
  • ET - Eastern UTC -5 hours
  • CT - Central UTC -6 hours
  • MT - Mountain UTC -7 hours
  • PT - Pacific UTC -8 hours
  • AK - Alaskan UTC -9 hours
  • HT - Hawaiian-Aleutian UTC -10 hours
  • AS - Samoa UTC -11 (American Samoa)
  • CH - Chamorro UTC +10 (Guam and Northern Mariana Islands)
DSTCHAR(1)Daylight savings time recognized, (Y)es or (N)o.
UTCVARCHAR (28)Time zone the ZIP Code is located in specified as a Universal Time Coordinate offset.
LatitudeDOUBLELatitude in decimal degrees to the center of the postal code.
LongitudeDOUBLELongitude in decimal degrees to the center of the postal code.

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

SQL Table Definitions

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

DROP TABLE IF EXISTS `postalcodes`;
CREATE TABLE `postalcodes` (
	`PostalCode` CHAR(7) NOT NULL,
	`City` VARCHAR(64) DEFAULT NULL,
	`Abbreviation` VARCHAR(13) DEFAULT NULL,
	`CountyName` VARCHAR(64) DEFAULT NULL,
	`StateProvinceName` VARCHAR(64) DEFAULT NULL,
	`StateProvince` CHAR(2) DEFAULT NULL,
	`Country` CHAR(2) DEFAULT NULL,
	`CityType` CHAR(1) DEFAULT NULL,
	`PostalCodeType` CHAR(1) 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,
	PRIMARY KEY (`PostalCode`));
	
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`));