Home
Name Modified Size Downloads / Week Status
Totals: 3 Items   477.3 kB 15
googleea7bc01c45621ec9.html 2012-04-25 53 Bytes 44 weekly downloads
README 2012-04-24 2.3 kB 22 weekly downloads
timezonebyzipcode_20120424.sql.gz 2012-04-24 475.0 kB 99 weekly downloads
This is a MySQL dump of a database table named "timezonebyzipcode". It is compiled from 4 sources: * Yahoo PlaceFinder API (Primary source - 40,833 records) * www.zipdatamaps.com (Secondary source - 1,035 records) * lookupzipcodes.info (Tertiary source - 39 records) * alaska.hometownlocator.com/zip-codes/ (Final source - 1 record) It contains the following fields: * idtimezonebyzipcode (arbitrary primary key - generated by autoincrement at time of record insertion) * zip (US 5-digit zip code) * city (city where zip is located) * state (US 2 letter state code - state where zip is located) * country (Always 'United States') * timezone (tz database compatible time zone name) as received from source with the following alterations (for consistency between sources): * Eastern Standard Time;Y or EST;Yes changed to America/New_York * Central Standard Time;Y or CST;Yes changed to America/Chicago * Mountain Standard Time;Y or MST;Yes changed to America/Denver * Pacific Standard Time;Y or PST;Yes changed to America/Los_Angeles * Mountain Standard Time;N or MST;No changed to America/Phoenix * Alaska Standard Time (AKST);Y or Aleutian Standard Time (ASKT);Y or PST-1;Yes changed to America/Anchorage * addressquality - always 60 if zip code was queried from Yahoo PlaceFinder API * source (the source website where the timezone information was found for the zip code) * sourcedate (the date on which the timezone information was queried for the zip code) Some of the fields are likely unneccessary for your use. Feel free to delete them. The source and sourcedate fields were included so that future versions of the database table can indicate replacement records more easily, record verification purposes, and to indicate the age of the records. To use: * uncompress the .gz file to a .sql file * start your mysql client (usually "mysql -u <username> -p") * select a database where you want to import this table (usually "USE <databasename>") * make sure you don't already have a timezonebyzipcode table in your selected database (usually "SHOW TABLES LIKE 'timezonebyzipcode';" - don't forget the semi-colon (;)) * import the dump file (usually "\. timezonebyzipcode_20120424.sql") * exit your mysql client (usually "\q")
Source: README, updated 2012-04-24