zip code DB?

[farkedup]

anybody have a DB of zip codes? I need something that has the city and state for me so instead of filling in those 2 fields I'll only have to put in the zip code.

[AlienQ - BANNED FOR LIFE]

Lee Noga!

[farkedup]

http://www.micahcarrick.com/04-19-20...lculation.html

ended up importing that DB and yanking out the shit I didn't need so many places trying to charge for this LOL

[brandonstills]

google is your friend. I remember it took me a while to find one but you can find freely available ones that are a few years old.

[GrouchyAdmin]

This is the best one I've found.

[GrouchyAdmin]

They updated in Jan '08. I figured I might as well get a new import. This is a really bad DB schema, but it was mostly just to get it out of CSV. Enjoy.

CREATE TABLE `zipCityData` (
  `localid` int(10) NOT NULL auto_increment,
  `zip` varchar(5) NOT NULL,
  `city` varchar(64) NOT NULL,
  `state` varchar(2) NOT NULL,
  PRIMARY KEY  (`localid`),
  KEY `zip` (`zip`)
) TYPE=INNODB  AUTO_INCREMENT=41755;

localid is just for a numeric index so you have a non-zipcode key. Since this is probably going into MySQL of an unknown version (3.2.23 to 5.x), I decided to ensure it wouldn't corrupt the numbers by making them varchar. Whatever you wanna do with it, it's yours.