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.
|
Details (Last update: 1. October 2024)
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:
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
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
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
Shopping cart
| Item | Price |
|---|---|
| ---- | ---- |
| Total | 0 US$ |
Other Products
Free Tools
ZIP Codes in a Radius
Distance between ZIP Codes
