US Zip code database with state, city, latitude and longitude geolocation in SQL or CSV format.
SQL format Download link
CSV format Download link
Updated Apr 24 2010
The data is collected from google maps so it should be very accurate.
SELECT * FROM `zipcodes` where `zipcode` like 94043 order by zipcode desc limit 1;