ZIP Code Database USA + Canada

Download our USA + Canada ZIP/ Postal Code Database with geographical Coordinates (lat/lon) to calculate distances between ZIP Codes or to determine all ZIP Codes within a given radius.

ZIP Codes USA and Canada
Step1 Help?
Step2 Help?
Step3

$119 USD

Internet Download

Details (Last update: 1. August 2017)

The USA + Canadian ZIP Code Database contains all US ZIP Codes and all Canadian Postal Codesand the city for each ZIP /postal code, state / province, and manually verified latitude & longitude coordinates.

Datatable Structure

Fieldname Datatype
countrycode varchar(2)
zipcode/postalcode varchar(7)
city varchar(64)
state/province varchar(48)
statecode/provincecode varchar(2)
timezone varchar(10)
daylightsaving varchar(1)
latitude decimal(13, 9)
longitude decimal(13, 9)

Database Content USA

Data Amount
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

Data Amount
Provinces 13
Cities 7,292
Unique Postal Codes 851,425
Geocoded locations 100 %
Number of records 852,149

Available Database Formats:

  • CSV / Excel
  • MS Access
  • MS SQL Server
  • MySQL
  • Oracle
  • PostGreSQL

ZIP Codes and Postal Codes within a Radius

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

To help you implement a ZIP code/postal code radius or distance search, we offer free access to example codes in many scripting and programming languages like ASP (VBScript), ASP.NET (C#), PHP, Coldfusion and more.

Since we stand behind the accuracy of our product, the formulas in our example scripts take the earth's curvature into consideration. With this in play, the accuracy of our product is pinpoint.

Working examples

Sample Data

countrycode;zipcode;city;cityalias;county;county-fips;state;statecode;state-fips;timezone;daylightsaving;latitude;longitude
US;94301;Palo Alto;Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.44300418;-122.151342
US;94302;Palo Alto;Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.44184901;-122.142186
US;94303;Palo Alto;East Palo Alto/Palo Alto/E Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.45809827;-122.123543
US;94304;Palo Alto;Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.40446424;-122.167761
US;94305;Stanford;Stanford/Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.42403628;-122.167743
US;94306;Palo Alto;Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.41185385;-122.129525
US;94309;Palo Alto;Palo Alto/Stanford;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.44172883;-122.141794
US;94401;San Mateo;San Mateo;SAN MATEO;081;California;CA;06;GMT -08:00;Y;37.57431309;-122.319760
US;94402;San Mateo;San Mateo;SAN MATEO;081;California;CA;06;GMT -08:00;Y;37.54005540;-122.330554
US;94403;San Mateo;San Mateo;SAN MATEO;081;California;CA;06;GMT -08:00;Y;37.54076023;-122.304490
US;94404;San Mateo;San Mateo/Foster City;SAN MATEO;081;California;CA;06;GMT -08:00;Y;37.55468039;-122.269424
US;94497;San Mateo;San Mateo/Postal Data Center;SAN MATEO;081;California;CA;06;GMT -08:00;Y;37.56333681;-122.324719
US;94501;Alameda;Alameda Pt/Alameda;ALAMEDA;001;California;CA;06;GMT -08:00;Y;37.77358919;-122.278630
US;94502;Alameda;Alameda;ALAMEDA;001;California;CA;06;GMT -08:00;Y;37.73443455;-122.244457
US;94503;American Canyon;American Cyn/Vallejo/American Canyon;NAPA;055;California;CA;06;GMT -08:00;Y;38.20397306;-122.233153
US;94505;Discovery Bay;Byron/Discovery Bay;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.88902420;-121.602884
US;94506;Danville;Blackhawk/Danville;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.81024114;-121.911398
US;94507;Alamo;Alamo;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.85322261;-121.991061
US;94508;Angwin;Angwin;NAPA;055;California;CA;06;GMT -08:00;Y;38.58514151;-122.441484
US;94509;Antioch;Antioch;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.99013887;-121.808322
US;94510;Benicia;Benicia;SOLANO;095;California;CA;06;GMT -08:00;Y;38.09537842;-122.126919
US;94511;Bethel Island;Bethel Island;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;38.05373416;-121.628572
US;94512;Birds Landing;Birds Landing;SOLANO;095;California;CA;06;GMT -08:00;Y;38.12754463;-121.839100
US;94513;Brentwood;Brentwood;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.90000170;-121.735850
US;94514;Byron;Byron/Discovery Bay;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.81948219;-121.642957
US;94515;Calistoga;Calistoga;NAPA;055;California;CA;06;GMT -08:00;Y;38.61859880;-122.586085
US;94516;Canyon;Canyon;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.83292913;-122.189194
US;94517;Clayton;Clayton;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.89476070;-121.872360
US;94518;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.95367031;-122.022334
US;94519;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.99041933;-122.002070
US;94520;Concord;Clyde/Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;38.00493565;-122.036583
US;94521;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.96557417;-121.953044
US;94522;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.97849304;-122.030498
US;94523;Pleasant Hill;Concord/Pleasant Hill;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.95394152;-122.078409
US;94524;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.97877750;-122.031412
US;94525;Crockett;Crockett;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;38.04861495;-122.229860
US;94526;Danville;Danville;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.81399980;-121.998889
US;94527;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.97852760;-122.030610
US;94528;Diablo;Diablo;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.84140708;-121.962956
US;94529;Concord;Chevron/Chevron Usa Inc/Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.97845772;-122.030385

countrycode;postalcode;city;province;provincecode;timezone;daylightsaving;latitude;longitude
CA;M4J 4Z9;Toronto;Ontario;ON;GMT -05:00;Y;43.67661346;-79.3280197
CA;M4J 5A1;Toronto;Ontario;ON;GMT -05:00;Y;43.67593793;-79.3286134
CA;M4J 5A2;Toronto;Ontario;ON;GMT -05:00;Y;43.67623031;-79.3291471
CA;M4J 5A3;Toronto;Ontario;ON;GMT -05:00;Y;43.67567894;-79.3294478
CA;M4J 5A4;Toronto;Ontario;ON;GMT -05:00;Y;43.67618048;-79.3297304
CA;M4J 5A5;Toronto;Ontario;ON;GMT -05:00;Y;43.67657460;-79.3303585
CA;M4J 5A6;Toronto;Ontario;ON;GMT -05:00;Y;43.67733607;-79.3305363
CA;M4J 5A7;Toronto;Ontario;ON;GMT -05:00;Y;43.67747250;-79.3303820
CA;M4J 5A9;Toronto;Ontario;ON;GMT -05:00;Y;43.67770673;-79.3305091
CA;M4J 5B1;East York;Ontario;ON;GMT -05:00;Y;43.68977228;-79.3416175
CA;M4J 5B2;Toronto;Ontario;ON;GMT -05:00;Y;43.67711312;-79.3299036
CA;M4J 5B3;Toronto;Ontario;ON;GMT -05:00;Y;43.68134897;-79.3379472
CA;M4J 5B5;Toronto;Ontario;ON;GMT -05:00;Y;43.68189053;-79.3314979
CA;M4J 5B6;Toronto;Ontario;ON;GMT -05:00;Y;43.68221689;-79.3317368
CA;M4J 5B7;Toronto;Ontario;ON;GMT -05:00;Y;43.67825982;-79.3352564
CA;M4J 5B8;Toronto;Ontario;ON;GMT -05:00;Y;43.67905960;-79.3355132
CA;M4J 5B9;Toronto;Ontario;ON;GMT -05:00;Y;43.67919750;-79.3447097
CA;M4J 5C2;East York;Ontario;ON;GMT -05:00;Y;43.69067085;-79.3280439
CA;M4J 5C3;Toronto;Ontario;ON;GMT -05:00;Y;43.68352865;-79.3253955
CA;M4J 5C4;Toronto;Ontario;ON;GMT -05:00;Y;43.68315106;-79.3239657
CA;M4J 5C6;East York;Ontario;ON;GMT -05:00;Y;43.69551609;-79.3448094
CA;M4J 5C7;East York;Ontario;ON;GMT -05:00;Y;43.69629607;-79.3453371
CA;M4K 1A1;Toronto;Ontario;ON;GMT -05:00;Y;43.66622205;-79.3527685
CA;M4K 1A2;Toronto;Ontario;ON;GMT -05:00;Y;43.66643034;-79.3531440
CA;M4K 1A3;Toronto;Ontario;ON;GMT -05:00;Y;43.66766848;-79.3475204
CA;M4K 1A4;Toronto;Ontario;ON;GMT -05:00;Y;43.66778944;-79.3477422
CA;M4K 1A5;Toronto;Ontario;ON;GMT -05:00;Y;43.66821201;-79.3459004
CA;M4K 1A6;Toronto;Ontario;ON;GMT -05:00;Y;43.66812817;-79.3455120
CA;M4K 1A7;Toronto;Ontario;ON;GMT -05:00;Y;43.66734918;-79.3537498
CA;M4K 1A8;Toronto;Ontario;ON;GMT -05:00;Y;43.66860324;-79.3485686
CA;M4K 1A9;Toronto;Ontario;ON;GMT -05:00;Y;43.66861746;-79.3481962

Download Sample Data

Shopping cart

ItemPrice
--------
Total0 US$

2Checkout / Paypal


Other Products


ZIP Code Database USA Postal Code Database Canada



Free Tools


ZIP Codes in a Radius

ZIP Code Radius

Distance between ZIP Codes

Distance between 2 ZIP Codes