Free IP address geolocation tools

Zip code database

Introduction

Free US zipcode database with state, city, latitude and longitude geolocation in SQL or CSV format. Will be updated every months.

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.

The database

SQL format Download link
CSV format Download link
Updated Sept 8 2009

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` <= 94043 order by zipcode desc limit 1;
and the result would be :
state|city|zipcode|latitude|longitude

CA|Mountain View|94043|37.4219|-122.078