Zip code database
US Zip code database with state, city, latitude and longitude geolocation in SQL or CSV format.
Download
SQL format Download link
CSV format Download link
Updated Apr 24 2010
If you use the database on a regular basis, please consider making a donation. Everything on this site is totally free but we need donations in order to pay for hosting and dedicated servers.
Data accuracy
The data is collected from google maps so it should be very accurate.
Usage
Simply do a query like this :SELECT * FROM `zipcodes` where `zipcode` like 94043 order by zipcode desc limit 1;