Combined United States and Canada Postal Codes Database

What's in the Premium Edition?

The Premium Edition contains a complete listing of all Canadian Postal Codes and United States 5-digit ZIP codes, associated geographic coordinates, time zone with daylight savings time indicator, and primary area code.

For Canadian postal codes the geographic latitude and longitude coordinates are to the center of the postal code FSA. This product does not provide Canadian LDU or street level coordinate granularity.

Combined Postal Codes Database Fields 

Postal Codes master file		Combined Postal Codes data samples
Field Name	Data Type	Description
POSTCODE	VARCHAR (7)	The five or six character post code.
CITY	VARCHAR (28)	Name of city.
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
AREACODE	CHAR (3)	Primary area code associated with the postal code.
GMT	CHAR (2)	Primary time zone the postal code is located within
DST	CHAR (1)	Daylight savings time is recognized within the area cover by this postal code
COUNTRY	CHAR (2)	ISO 3166 two character country code.
LATITUDE	DOUBLE	Latitude in decimal degrees of the geographic centroid of the ZIP code or Postal Code FSA
LONGITUDE	DOUBLE	Longitude in decimal degrees of the geographic centroid of the ZIP code or Postal Code FSA