|
Download United States ZIP Code Database Products Enterprise Edition
* Payment will be required for 1-year of updates Description
The ZIPCodeDepot™ USA, Enterprise Edition is designed for the needs of advanced USA zip code users. The database fields include
ZIP code, ZIP code type, city name, abbreviated city name, city type, state code, state name, area code, latitude, longitude, time zone, GMT offset, Daylight Saving Time flag, county, county FIPS, state FIPS, MSA code, PMSA code, and Market Area.
The latest data has over 71,000 records with almost 43,000 ZIP codes and available in MS Access, industry-standard quote-delimited, comma-separated ASCII format, and any other format as you request!
What We Offer
- Download as you pay, no waiting time
- Unlimited download times
- Lowest price (for details, please see our Lowest Price Guarantee)
- 30-day Money-back Guarantee!
- Monthly update
- Different license for different needs
- Half-yearly, quarterly and monthly subscription available
- About 43,000 primary ZIP Code Records
- Over 27,000 alternate ZIP Code Records
- Free database creation script when you buy our product
- Guaranteed customer satisfied service!
File Size
Uncompressed Disk space
- Microsoft Access Version - 16 MB
- Comma-separated Version - 9 MB
Sample ZIP Code Data for DownloadNote: all files are in zip format, please use WinZip or other unzip tool to uncompress it. Each file contains 50 sample records.
Sample Records for Your Reference
"59001", "", "Absarokee", "", "P", "MT", "Montana", "406", "45.5102", "109.6167", "MST", "-7", "Y", "Stillwater", "30095", "30", "","", "088"
"89502", "", "Reno", "", "P", "NV", "Nevada", "775", "39.4944", "119.7469", "PST", "-8", "Washoe", "32031", "32", "6720", "", "672"
"76539", "", "Rumley", "", "N", "TX", "Texas", "512", "31.0791", "98.0007", "CST", "-6", "Lampasas", "48281", "48", "", "", "381"
"41222", "", "Mendola Village", "Mendola Vlg", "N", "KY", "Kentucky", "606", "37.7639","82.7875", "EST", "-5", "Y", "Johnson", "21115", "21", "", "", "340"
Database Fields
| Field Name | Data Type | Field Description |
| ZIPCode | char(5) | 5-digit ZIP Code |
| ZIPType | char(1) | The type of ZIP Code, defined as below:
- "" - Standard ZIP Code
- P - Used for PO Boxes
- U - Used for companies
- M - Used for militaries
|
| City | varchar(30) | The corresponding name of the city |
| CityAbbrev | varchar(13) | City Name Abbreviation |
| CityType | char(1) | Tells if the city name is recommended by the USPS.
- P - Default City Name - recommended by the USPS
- A - Alternate City Name, also used by the USPS, but not the preferred name of that ZIP Code.
- N - Not approved for mail delivery, not accepted by the USPS.
|
| StateCode | char(2) | The two-letter abbreviation of the state name |
| State | varchar(25) | The full name of the state (or territory) |
| AreaCode | char(3) | Corresponding area code for that zip code |
| Latitude | numeric (double) | The Latitude of the geographic center of the ZIP Code. For military ZIP Codes the Latitude will be 0.0 |
| Longitude | numeric (double) | The Longitude of the geographic center of the ZIP Code. For military ZIP Codes the Longitude will be 0.0 |
| TimeZone | varchar(5) | The standard time zone designation for the particular postal code |
| GMTOffset | int | The GMT offset indicates the difference in hours between GMT and the time zone for that particular ZIP Code. |
| DST | char(1) | DST stands for "Day light saving time". DST fields is set to "Y" if the particular ZIP Code obeys the Daylight Savings change, otherwise it is set to "N". |
| County | varchar(30) | The name of the county of the ZIP Code. |
| CountyFIPS | char(5) | FIPS stands for "Federal Information Processing Standard". It is a unique numeric identification assigned to that county by the US government. This field will be blank when the City is APO or FPO. |
| StateFIPS | char(2) | A unique two-digit FIPS number for a state or territory. |
| MSA | char(4) | MSA stands for "Metro Service Area". The MSA code groups ZIP Codes in a geographic region together by a common population center. Not all ZIP Codes have an MSA code. |
| PMSA | char(2) | The PMSA field contains the Primary Metropolitan Statistical Area code, which is assigned by US government. Not all ZIP Codes have a PMSA code. |
| MA | char(3) | The MA field contains the 3-digit Market Area code, which is assigned by US government. Each ZIP code is assigned to the appropriate market area. A particular market area may consist of ZIP codes in one, two, or more contiguous states. |
|
|
Shopping Cart
Login
Products
USA - Basic
Canada - Basic