Zip Code Database List
January 13th, 2006
Need a database full with zip codes/cities/area codes/population/counties, and much more? Me too. I’ve found a great one, with more information than you’ll ever need. Just $79.95 and you’re set. Download database as CSV/Access/Excel.
Check it out: Zip Code Database List
It took me a few hours to figure out how to import those two big ass CSV files, I tried using a PHP import script, but when I almost lost my mind, I tried SQLyog, and after a few trial & errors, managed to make the table schema perfect and import all the data. Here is my table, if anyone sees errors, please tell.
CREATE TABLE `frg_li_zip_ext` (
`ZipCode` char(5) default NULL,
`PrimaryRecord` char(1) default NULL,
`Population` decimal(10,0) default NULL,
`HouseholdsPerZipcode` decimal(10,0) default NULL,
`WhitePopulation` decimal(10,0) default NULL,
`BlackPopulation` decimal(10,0) default NULL,
`HispanicPopulation` decimal(10,0) default NULL,
`PersonsPerHousehold` float default NULL,
`AverageHouseValue` decimal(10,0) default NULL,
`IncomePerHousehold` decimal(10,0) default NULL,
`Latitude` float default NULL,
`Longitude` float default NULL,
`Elevation` decimal(10,0) default NULL,
`State` char(2) default NULL,
`StateFullName` varchar(35) default NULL,
`CityType` char(1) default NULL,
`CityAliasAbbreviation` varchar(13) default NULL,
`AreaCode` varchar(55) default NULL,
`City` varchar(35) default NULL,
`CityAliasName` varchar(35) default NULL,
`CountyName` varchar(45) default NULL,
`CountyFIPS` char(5) default NULL,
`StateFIPS` char(2) default NULL,
`TimeZone` char(2) default NULL,
`DayLightSaving` char(1) default NULL,
`MSA` varchar(35) default NULL,
`PMSA` char(4) default NULL,
`CSA` char(3) default NULL,
`CBSA` char(5) default NULL,
`CBSA_Div` char(5) default NULL,
`CBSAType` char(5) default NULL,
`CBSAName` varchar(150) default NULL,
`MSAName` varchar(150) default NULL
);
