Subscription
The 5-digit Premium Edition includes a complete list of US Zip Codes, the default city for each Zip Code, alternate cities and spellings, states, the primary Zip Code area code, andindividually certified latitude & longitude coordinates.
The database is available inthe following formats: Microsoft Excel 97 (or later), Microsoft Access 97 & 2000 (or later), comma-separated values, fixed-width format, and tab-delimited format. All formats are included with your purchase, and they can be imported into most databases and spreadsheets.
When you order online from ZIP Code Download there is no need to wait for the mail. You'll receive the 5-digit ZIP Code Database, Premium Edition immediately. Our products are available for download only, which allows us to keep our prices low and pass the savings on to you. The data will be available in your account for 30 days after your purchase (unless you purchase an annual subscription). They can be downloaded on any computer with internet access.
Product Features & BenefitsFormats Available
CSV (Comma Separated Values)
Fixed Width
Microsoft Access 2000 (or later)
Microsoft Access 97
Microsoft Excel 97 (or later)
Tab Delimited (MySQL compatible)
Uncompressed Disk Space
Microsoft Excel Version - 20 MB
Microsoft Access Version - 12 MB
Comma-separated Version - 10 MB
Tab-delimited Version - 10 MB
WinZip or another similar PKzip archive extraction utility
Microsoft Excel, Access, notepad, or another similar text-editing utility
Field | Data Type | Description |
ZIPCode | char(5) | ZIP stands for Zoning Improvement Plan. It is used to signify a delivery route in the United States as designated by the USPS. In most cases a ZIP Code is a geographic region with a center point. |
ZIPType | char(1) | The USPS has assigned each ZIP Code a type. Why? It helps them sort mail more quickly. |
CityName | varchar(64) | The name of the city (and in some cases, organization) designated by that ZIP Code or postal code. |
CityType | char(1) | In many cases, a ZIP Code can have multiple names, meaning cities, towns, or subdivisions, in its boundaries. However, it will ALWAYS have exactly 1 default name. |
StateName | varchar(64) | A state in our database is a state, territory, province, or region as designated by the USPS. The database includes all United States territories and possessions that have been assigned ZIP Codes. |
StateAbbr | char(2) | A state code or abbreviation is a two character designation for that state - for example, California is CA and Texas is TX, etc. |
AreaCode | varchar(20) | In our USA 5-digit Premium Edition database, the area code listed is the primary or foremost area code for each ZIP Code. In our Commercial Edition databases (both the USA and Canada), if multiple area codes belong to one postal code, all area codes are listed and delimited by a slash / character. |
Latitude | decimal(9,6) | The latitude coordinate listed is an exact north/south point (to 6 decimal places) on the globe of the centroid or middle of the ZIP Code. |
Longitude | decimal(9,6) | The longitude coordinate listed is an exact east/west point (to 6 decimal places) on the globe of the centroid or middle of the ZIP Code. |
Our Products
ZIPCODE DATA SINCE 2002