Download our US ZIP Code Database with geographical Coordinates (lat/lon) to calculate distances between ZIP Codes or to determine all ZIP Codes within a given radius.
- 9 Digit Zip Code Database Free Download
- Usps Zip Code Database Free Download
- Us Zip Code Database Free Download
Details (Last update: 1. March 2020)
Mar 29, 2019 Demographic Statistics By Zip Code Metadata Updated: January 15, 2020. Demographic statistics broken down by zip code Access & Use Information. Public: This dataset is intended for public access and use. Non-Federal: This. XML File XML 3127 views Link is ok Openness score.
The USA ZIP Code Database contains all 5 digit US ZIP Codes, the default city for each ZIP Code, County, State, and manually verified latitude & longitude coordinates.
Unlike other ZIP code data suppliers, our data is optimized for the purpose of 'ZIP codes within a radius' calculation.This means that all ZIP Codes are 100% geocoded.City aliases are not occupying their own distinct records but are listed in an extra datafield for faster calculation.
Unlike other ZIP code data suppliers, our data is optimized for the purpose of 'ZIP codes within a radius' calculation.This means that all ZIP Codes are 100% geocoded.City aliases are not occupying their own distinct records but are listed in an extra datafield for faster calculation.
Datatable Structure
Fieldname | Datatype |
---|---|
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) |
Database Content
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) |
ZIP Codes within a Radius
Having a database of ZIP codes with their latitudes and longitudes enables you to locate the closest ZIP codes to a set point or specified radius.
To help you implement a ZIP 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.
In addition, you'll receive our complimentary ZIP Code in a Radius application that's executable in Microsoft Access. For your convenience, we left all source code open for further development.
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
To help you implement a ZIP 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.
In addition, you'll receive our complimentary ZIP Code in a Radius application that's executable in Microsoft Access. For your convenience, we left all source code open for further development.
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
9 Digit Zip Code Database Free Download
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
Shopping cart
Other Products
Free Tools
ZIP Codes in a Radius
Distance between ZIP Codes
When you download our U.S. or Canadian Postal CodeOM databases, you can choose between 4 separate formats for download, saving on conversion time and effort. Our zip codes database has the most comprehensive and precise data that you will find. You can perform free database lookups on our website with our software or you can download our ZIP codes database for data manipulation. Our free ZIP codes finder helps you find the ZIP codes and related demographic information for any U.S. or Canadian Postal CodeOM.
ZIP Code & Postal Code Facts
Zip Codes are largely responsible for the automation of the United States Post Office’s mail handling. Today, over 600,000,000 pieces of mail are delivered each business day, and our mail can take as little as one day to reach its destination. Back in 1799, it could take three weeks for a letter to travel from Lexington, Massachusetts to Philadelphia, Pennsylvania. The cost of mail was relatively much higher back then. It cost twenty-five cents to send a letter 450 miles – not much less than it costs today to send a letter anywhere in the country, and in considerably less time!
Today, many of us in the United States expect to have our mail delivered to our homes and offices at no extra charge. Before July 1, 1863, city residents had to pay to have a postal worker bring their mail to them; rural customers had to travel to pick up their own mail for another 30 years. Zip codes wouldn't have helped much in those days.
Many famous Americans have been postal workers. Benjamin Franklin is known as “The Father of the United States Postal Service.” Abraham Lincoln was postmaster of New Salem, Illinois in the 1830’s, and it is rumored that he personally delivered mail by carrying it in his hat along with a list of delivery places. Harry S. Truman was postmaster of Grandview, Missouri for a time. William Faulkner was postmaster of the University of Mississippi Post Office.
Perhaps the most romantic era in our United States postal history is that of the Pony Express. Before then, stagecoaches took more than 20 days to deliver mail from coast to coast. In 1860, William H. Russell bought strong horses and put a listing for good horseback riders in newspaper ads that read: “Wanted: Young, skinny, wiry fellows not over 18. Must be expert riders willing to risk death daily. Orphans preferred.” Russell’s Pony Express was in service for 18 months, cutting the time it took for mail delivery coast to coast in half. The service closed in 1861 when telegraph lines connecting the coasts were finished being laid, allowing people to send information much faster and cheaper than they could by Pony Express.
The history of the United States Post Office is filled with fascinating data and amusing facts. Did you know the first Post Office in the United States was actually a tavern? Or that the United States employed camels to deliver mail over deserts in the Southwest? Or that one of the first airmail deliveries involved a three mile flight, and that the pilot dropped the bag of mail from the flying plane to a postmaster waiting below?
Usps Zip Code Database Free Download
Zip Codes didn’t come into use until 1963. Their inventor, Robert Aurand Moon, is known as the “Father of ZIP Codes” and was nicknamed “Mr. ZIP Code.” Another character also went by this name: the lovable cartoon ambassador, Mr. Zip or Mr. Zippy, who some think was largely responsible for the success of United States ZIP code compliance.
Us Zip Code Database Free Download
And just what are ZIP Codes? And how does the United States Post Office use them? What do the numbers stand for? Where does the ZIP code data come from? How about the ZIP + 4 Codes? There’s plenty to learn about the Zoning Improvement Plan Codes!
To learn more about our ZIP Code finder - US ZIP Code Database Lists with Demographics Information, please view our FAQ's.