ZIP Codes of USA & Canada

Postcode Database USA & Canada

Details (Data of: 2024)

The USA & Canada postcode database includes all USA & Canada Postcodes plus city and region plus latitude/longitude. The USA & Canada postcode database includes all USA & Canada Postcodes plus location and region plus latitude/longitude.

Database content USA

States	50 (+ 12 Army / Overseas)
Cities	29,743
Unique ZIP Codes	42,037
Geocoded locations	100 % (except: Armed Forces in Overseas)
Number of records	42,122 83,102 (City Aliases counted)

Database content Canada

Provinces	13
Cities	7,507
Unique Postal Codes	869,130
Geocoded locations	100 %
Number of records	871,178

Available Formats:

Comma-separated values (CSV) ~2.5 MB ZIP compressed

Easy to import into all popular database management systems:

MySQL

MS SQL

Oracle

Postgre SQL

Microsoft Access

DB Structure USA

countrycode	varchar(2)
zipcode	varchar(5)
city	varchar(64)
city-aliases	varchar(MAX)
county	varchar(64)
county-fips	varchar(4)
state	varchar(48)
statecode	varchar(2)
state-fips	varchar(2)
timezone	varchar(10)
daylightsaving	varchar(1)
latitude	decimal(13, 9)
longitude	decimal(13, 9)

DB Structure Canada

countrycode	varchar(2)
postalcode	varchar(7)
city	varchar(64)
province	varchar(48)
provincecode	varchar(2)
timezone	varchar(10)
daylightsaving	varchar(1)
latitude	decimal(13, 9)
longitude	decimal(13, 9)

Delivery

Online Download

Programming

Having a database of localities with their latitudes and longitudes enables you to locate the closest locations to a set point (or within a radius of X).

To help you to implement a ZIP Code radius / distance search we offer free access to example codes in many scripting languages and programming languages like ASP, PHP, Coldfusion...

To achieve the highest accuracy the formulas in our example scripts take the earth's curvature into consideration.

Check out a working example.