Combined United States/Canadian Postal Codes

Premium Edition

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.

Combined Postal Codes Assignments File data sample
Field	Data Type	Field Description
POSTCODE	VARCHAR(7)	The five or six character post code.
CITY	VARCHAR(28)	Name of city or location.
REGION	VARCHAR(28)	Full name of the state or province.
REGIONCODE	CHAR(2)	Official abbreviation of the state or province.
CITYTYPE	CHAR(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
AREACODE	CHAR(3)	Primary area code associated with the post code.
GMT	CHAR(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)
DST	CHAR(1)	Daylight savings time recognized, (Y)es or (N)o.
COUNTRY	CHAR(2)	Name of the country.
LATITUDE	DOUBLE	Latitude in decimal degrees to the center of the postal code.
LONGITUDE	DOUBLE	Longitude in decimal degrees to the center of the postal code.