Description
Details
Structure
Details
Column Name | Description | Data Type | Column Length | Percentage of Rows Populated |
---|---|---|---|---|
ZIPCode | US ZIP Code | Text | 5 | 100% |
Latitude | Latitude in Degrees | Text | 15 | 98% |
Longitude | Longitude in Degrees | Text | 15 | 98% |
Elevation | Elevation in ft | Number | Integer | 98% |
City | City | Text | 50 | 100% |
StateCode | US State Code | Text | 2 | 100% |
County | US County | Text | 50 | 98% |
CountyFIPS | US County FIPS | Text | 5 | 98% |
AreaCode | Area Code | Text | 3 | 98% |
Type | Area Type | Text | 50 | 98% |
GMT | Time difference with GMT | Number | Integer | 98% |
TimeZone | Time Zone | Text | 10 | 98% |
DST | Daylight Saving Time | Number | Byte | 98% |
Others
Additional Information
File Format | MS Excel 2003 Spread Sheet, MS Access 2003 Database |
---|---|
Format Details |
Data is available in two formats - MS Excel 2003 spreadsheet and MS Access 2003 Database. You can of course easily convert the data to CSV or TAB delimited text file from the spreadsheet itself. If you want this data in any other format please send your request to us (sales@ebusinessgems.com). Please note that a small fee for data conversion (10% to 30% of the purchase price depending on the data type) may be applicable. |
Total Records |
42,000+ Active US ZIP Codes. (A separate table in the MS access version lists down some equivalent numbers of bad US zip codes.) |
File Size | 5 MB zip file. Around 24 MB when unzipped. |
Additional Info | US Zip Code database |
Keywords | usa, zipcode |
Key Phrases | us zipcodes |
Specific Terms and Condition |
You must understand the following before you download and use this database. eBuisnessGems.com has compiled this database to be used as a repository of relevant information for those who are interested to know but is not responsible for the validity of the content. We can not guarantee our information is accurate or up to date or suitable for any particular purpose. Unauthorized copying, distribution and use of this product is strictly prohibited. You can purchase and download this product only from www.eBusinessGems.com. You can use this product for your own purpose such as research, personal use, as read only content of your website and other similar usage. You are not entitled to resell or redistribute it in its original form and content. By downloading and using this product it will be deemed confirmed that you have read this specific terms and conditions, understood and fully agreed to it. |
Sample
Details
ZIPCode | Latitude | Longitude | Elevation | City | StateCode | County | CountyFIPS | AreaCode | Type | GMT | TimeZone | DST | VCode |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
00501 | 40.922326 | -72.637078 | 25 | HOLTSVILLE | NY | SUFFOLK | 36103 | 631 | UNIQUE | -5 | EST | 1 | D |
00544 | 40.922326 | -72.637078 | 25 | HOLTSVILLE | NY | SUFFOLK | 36103 | 631 | UNIQUE | -5 | EST | 1 | D |
00601 | 18.165273 | -66.722583 | 0 | ADJUNTAS | PR | ADJUNTAS | 72001 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00602 | 18.393103 | -67.180953 | 0 | AGUADA | PR | AGUADA | 72003 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00603 | 18.455913 | -67.145780 | 0 | AGUADILLA | PR | AGUADILLA | 72005 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00604 | 18.493520 | -67.135883 | 0 | AGUADILLA | PR | AGUADILLA | 72005 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00605 | 18.465162 | -67.141486 | 0 | AGUADILLA | PR | AGUADILLA | 72005 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00606 | 18.172947 | -66.944111 | 0 | MARICAO | PR | MARICAO | 72093 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00607 | 18.256995 | -66.104657 | AGUAS BUENAS | PR | -4 | EST +1 | 0 | B | |||||
00609 | 18.142002 | -66.273278 | AIBONITO | PR | -4 | EST +1 | 0 | B | |||||
00610 | 18.288685 | -67.139696 | 0 | ANASCO | PR | ANASCO | 72011 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00611 | 18.279531 | -66.802170 | 0 | ANGELES | PR | UTUADO | 72141 | 787 | PO BOX ONLY | -4 | EST +1 | 0 | D |
00612 | 18.450674 | -66.698262 | 0 | ARECIBO | PR | ARECIBO | 72013 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00613 | 18.458093 | -66.732732 | 0 | ARECIBO | PR | ARECIBO | 72013 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00614 | 18.429675 | -66.674506 | 0 | ARECIBO | PR | ARECIBO | 72013 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00615 | 17.96977 | -66.061459 | ARROYO | PR | -4 | EST +1 | 0 | B | |||||
00616 | 18.444792 | -66.640678 | 0 | BAJADERO | PR | ARECIBO | 72013 | 787 | STANDARD | -4 | EST +1 | 0 | D |
00617 | 18.447092 | -66.544255 | 0 | BARCELONETA | PR | BARCELONETA | 72017 | 787 | STANDARD | -4 | EST +1 | 0 | D |