You are here

United States Zip Codes Database

$39.95

This is a well structured and well indexed database of the 33,181 zip codes or postal codes of United States cities across 51 states.

The database includes:
- zip code / postal code
- city
- state full name
- state abbreviation
- latitude
- longitude

The package is a zip file 1,8M that contains 3 file formats:
1. MySQL data dump (.sql)
2. Microsoft Access (.mdb)
3. CSV (.csv)

MySQL database details:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `zip_codes`
-- ----------------------------
DROP TABLE IF EXISTS `zip_codes`;
CREATE TABLE `zip_codes` (
`zip` varchar(5) NOT NULL DEFAULT '',
`state` char(2) NOT NULL DEFAULT '',
`latitude` varchar(10) NOT NULL DEFAULT '',
`longitude` varchar(10) NOT NULL DEFAULT '',
`city` varchar(50) DEFAULT NULL,
`full_state` varchar(50) DEFAULT NULL,
KEY `zip` (`zip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

SKU: us_zip_codes
List price: $0.00
Price: $39.95