Combined Postal Codes - Standard Edition Home > Combined Postal Codes > Lite Edition

Combined United States/Canadian Postal Codes

Lite Edition

Combine Postal Codes

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

Basic 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.

It is the perfect choice when all you need is city, state or province to postal code cross reference.

  • Data Field Definitions
  • SQL Table Definitions
  • Postal Code Assignments
FieldData TypeField Description
PostalCodeVARCHAR(7)The five or six character post code.
CityVARCHAR(64)Name of city or location.
ProvinceCHAR(2)Official abbreviation of the state or province.
CountryCHAR(2)ISO 3166 country code.
PostalCodeTypeCHAR(1)The postal code definition or type for delivery purposes.
USE `postalcodelite`;

DROP TABLE IF EXISTS `postalcodes`;
CREATE TABLE `postalcodes` (
	`PostalCode` CHAR(7) NOT NULL,
	`StateProvince` CHAR(2) DEFAULT NULL,
	`Country` CHAR(2) DEFAULT NULL,
	`PostalCodeType` CHAR(1) DEFAULT NULL,
	PRIMARY KEY (`PostalCode`));

Corporate License

Single release

Annual subscription - quarterly updates

Distribution License

Annual subscription - quarterly updates

pdf file Reference Manual
zipped file Sample Data