Subscription
Do you need to turn 5-digit ZIP Codes into +4 Codes? Do you need to assign a 5-digit ZIP Code to a street address? If you are looking for the raw data to get this done, our ZIP+4 Premium Edition database is the data you need. It is our most comprehensive list of ZIP Codes and includes the information you will need to update your zip code table or database. Each record includes the ZIP Code, +4 Code, street, city, state, and plenty of other useful bits of information, such as the county and congressional district.
Product Summary:The ZIP Code list is available in the following formats: Comma-separated values and tab-delimited format. All formats are included with your purchase, and they can be imported into most databases (Note: This file is too large to import into Microsoft Access).
Important Information:This product is a database found in a raw text file. It is not a software program. We recommend that you have someone experienced with large text files work with this data. If you have any questions, please feel free to contact us.
Available for Immediate DownloadWhen you order online from ZIP Code Download there's no need to wait for the mail. You'll receive the USA ZIP+4 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 in any available format including excel and zip code table onto any computer with internet access.
Product Features & Benefits:Uncompressed Disk Space
Tab-delimited Version - 5500 MB
WinZip 9.0 or 10.0 Required to extract files
MySql, Oracle, Microsoft SQL Server
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. |
Plus4 | char(4) | 4-digits that are used to identify a geographic segment within the 5-digit delivery area, such as a city block or a group of apartments or an individual high-volume receiver of mail, or any other unit that could use an extra identifier to aid in efficient mail sorting and delivery. This code is the low end of the range of +4 Codes that pertain to this ZIP Code. |
Range | char(4) | The range of +4 codes. Summing the +4 Code and the +4 Range will give you the high end of the range of +4 Codes that pertain to this ZIP Code. |
CityName | varchar(64) | The name of the city (and in some cases, organization) designated by that ZIP Code or postal code. |
RecordType | char(1) | An alphabetic value that identifies the type of data in the record. |
CarrierRouteID | char(4) | A 4-digit code assigned to a mail delivery or collection route within a 5-digit ZIP Code. The first character of this identification is alphabetical, and the last three are numeric:Bnnn = PO box, Hnnn = Highway contract, Rnnn = Rural route, Cnnn = City delivery, Gnnn = General delivery |
StreetPredirectional | varchar(2) | A geographic direction that precedes the street name. |
StreetName | varchar(28) | The official name of a street as assigned by a local governing authority. The Street Name column contains only the street name and does not include directionals or suffixes. This element may also contain literals, such as PO BOX, GENERAL DELIVERY, USS, PSC, or UNIT |
StreetSuffix | varchar(4) | The street suffix. |
StreetPostdirectional | varchar(2) | A geographic direction that precedes the street name. |
AddressPrimaryLowNumber | char(10) | A house, rural route, highway contract box, or post office box number; the numeric or alphanumeric component of an address preceding the street name; the low-end address in a range of addresses. Often referred to as house number. |
AddressPrimaryHighNumber | char(10) | A house, rural route, highway contract box, or post office box number; the numeric or alphanumeric component of an address preceding the street name; the high-end address in a range of addresses. Often referred to as house number. |
AddressPrimaryOddEvenCode | char(1) | Code that identifies the side or sides of a street for which a given address range is applicable. For street, highrise, firm and multi-carrier records, B = Both sides of a street, E = Even side of a street (even-numbered addresses in the range); O = Odd side of a street (odd-numbered addresses in the range). For general delivery, post office box, and rural route/highway contract records, this code will always be B (both). |
BuildingOrFirmName | varchar(40) | The name of a company, building, apartment complex, shopping center, or other distinguishing secondary address information. This column is normally used with firm and highrise records but may also contain literals such as Postmaster or United States Postal Service. |
AddressSecondaryAbbreviation | varchar(4) | A descriptive code used to identify the type of address secondary range information in the Address Secondary Range column. This code may be useful in address matching, i.e., the secondary address numbers may indicate apartment, suite, or trailer numbers, etc. |
AddressSecondaryLowNumber | char(8) | Code that describes an apartment, room, suite, space, floor or other secondary addressing numeric or alphanumeric that follows a street address. The low-end secondary address component in a range of secondary addresses. |
AddressSecondaryHighNumber | char(8) | Code that describes an apartment, room, suite, space, floor, or other secondary addressing numeric or alphanumeric that follows a street address. The high-end secondary address component in a range of secondary addresses. |
AddressSecondaryOddEvenCode | char(1) | Code that identifies a secondary address within a range of secondary addresses as being odd (0), even (E), or both (B). |
ZIPAdd-OnLowSector | char(4) | The ZIP Add-On High Sector and the ZIP Add-On High Segment together form the ZIP Add-On High Number, which is the high-end ZIP add-on in a range of codes; the add-on of the last ZIP+4 code in a consecutive series of ZIP+4 codes assigned to the delivery address. Most delivery addresses are assigned a single ZIP+4 code; however, large companies may be given a range of ZIP+4 codes that can be used to route mail to specific departments. A range of ZIP+4 codes can also be assigned to a corresponding range of post office boxes, and each box is mapped, one-to-one, with a ZIP+4 code in the range. A single post office box can also be assigned a range of ZIP+4 codes. (See also ZIP Add-On Code.) |
ZIPAdd-OnLowSegment | char(4) | The ZIP Add-On Low Sector and the ZIP Add-On Low Segment together form the ZIP Add-On Low Number. The ZIP Add-On Low Number is the last four positions of a ZIP+4 code; the low-end ZIP add-on in a range of codes; the add-on of the first ZIP+4 code in a consecutive series of ZIP+4 codes assigned to the delivery address. For example, most delivery addresses are assigned a single ZIP+4 code. However, large companies may be given a range of ZIP+4 codes that can be used to route mail to specific departments. A range of ZIP+4 codes can also be assigned to a corresponding range of post office boxes, and each box is mapped, one-to-one, with a ZIP+4 code in the range. A single post office box can also be assigned a range of ZIP+4 codes. |
ZIPAdd-OnHighSector | char(4) | The ZIP Add-On High Sector and the ZIP Add-On High Segment together form the ZIP Add-On High Number, which is the high-end ZIP add-on in a range of codes; the add-on of the last ZIP+4 code in a consecutive series of ZIP+4 codes assigned to the delivery address. Most delivery addresses are assigned a single ZIP+4 code; however, large companies may be given a range of ZIP+4 codes that can be used to route mail to specific departments. A range of ZIP+4 codes can also be assigned to a corresponding range of post office boxes, and each box is mapped, one-to-one, with a ZIP+4 code in the range. A single post office box can also be assigned a range of ZIP+4 codes. (See also ZIP Add-On Code.) |
ZIPAdd-OnHighSegment | char(4) | The ZIP Add-On High Sector and the ZIP Add-On High Segment together form the ZIP Add-On High Number, which is the high-end ZIP add-on in a range of codes; the add-on of the last ZIP+4 code in a consecutive series of ZIP+4 codes assigned to the delivery address. Most delivery addresses are assigned a single ZIP+4 code; however, large companies may be given a range of ZIP+4 codes that can be used to route mail to specific departments. A range of ZIP+4 codes can also be assigned to a corresponding range of post office boxes, and each box is mapped, one-to-one, with a ZIP+4 code in the range. A single post office box can also be assigned a range of ZIP+4 codes. (See also ZIP Add-On Code.) |
BaseAlternateCode | char(1) | Code that specifies whether a record is a base (preferred) or alternate record. Base records (represented as B) can represent a range of addresses or an individual address, such as a firm record, while alternate records (represented as A) are individual delivery points. Government deliveries will only be listed on alternate records with the appropriate government building indicator (federal, state, or city) set. |
LACSStatusIndicator | varchar(1) | The Locatable Address Conversion Service (LACS) indicator describes records that have been converted to the LACS system. Rural route and some city addresses are being modified to city-style addresses so that emergency services can find these addresses more efficiently. |
GovernmentBuildingIndicator | varchar(1) | An alphabetic value that identifies the type of government agency at the delivery point and/or whether a firm is the only delivery at an address. |
FinanceNumber | char(6) | A code assigned to Postal Service facilities (primarily post offices) to collect cost and statistical data and compile revenue and expense data. The state number comprises the first two positions of the finance number. |
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. |
CountyFIPS | char(5) | Each county in the United States is assigned a unique number for identification purposes - a Federal Information Processing Standards or FIPS code. The County FIPS code is a combination of a 2-digit state FIPS code as well as a 3-digit county code as designated by the National Institute of Standards and Technology (NIST). |
CongressionalDistrictNumber | char(2) | A standard value identifying a geographic area within the United States served by a member of the US House of Representatives or Senate. If Army/Air Force (APO) or fleet post office (FPO), this column will be blank. If there is only one member of Congress within a state, the code will be AL (at large). |
MunicipalityCityStateKey | char(6) | This column will be blank until further notice. |
UrbanizationCityStateKey | char(6) | An index to the City State file that provides the urbanization name for this delivery range. |
PreferredLastLineCityStateKey | char(6) | An index to the City State file that provides the preferred last-line name for this address range. |
This End User License Agreement (the "EULA") is a contract between you (the "Customer") and ZIP Code Download (the "Company"). This EULA applies to all data, code, and applications (the "Products") sold by the Company � which shall include any upgrades, modified versions or updates of the Products licensed to you by the Company. By purchasing and/or retrieving the Products sold by the Company, the Customer accepts all the terms and conditions of the EULA. Upon your acceptance of this Agreement, the Company grants to you a nonexclusive license to use the Products, provided that you agree to the following:
You may install the Products on a hard disk or other storage device; install and use the Products on a file server for use on a network for the purposes of (i) permanent installation onto hard disks or other storage devices or (ii) use of the Products over such network; and make backup copies of the Products. You may make unlimited copies of the Products, as long as each copy that you make, 1.) is for internal company use, 2.) contains this Agreement and, 3.) contains the same copyright and other proprietary notices pertaining to this Products that appear in the Products. You may not make the Products publicly available in easily downloadable format (i.e. PKZip files or static/dynamic web pages) on public network such as bulletin boards, online services, or the internet. However, the Products may be used on public networks (i.e. the internet) if used within a "Lookup Application" such as a "Store Locator" or "Nearest Member Search" so long as the underlying data is not exposed to the internet.
Copyright and Trademark RightsThe Products are owned by the Company, and its structure, organization and code are the valuable trade secrets of the Company. The Products also is protected by United States Copyright Law and International Treaty provisions. You may use trademarks only insofar as required to comply with Section 1 of this Agreement and to identify printed output produced by the Products, in accordance with accepted trademark practice, including identification of trademark owner's name. Such use of any trademark does not give you any rights of ownership in that trademark. Except as stated above, this Agreement does not grant you any intellectual property rights in the Products.
RestrictionsYou are free to modify and/or adapt any Products provided in non-compiled form for your own use, reproduction as well as unlimited use within your organization. The Products are licensed and distributed by the Company. Redistribution and reseller agreements can be obtained by contacting the Company.
No WarrantyThe Products are being delivered to you AS IS and the Company makes no warranty as to its use or performance. The Company DOES NOT AND CANNOT WARRANT THE PERFORMANCE OR RESULTS YOU MAY OBTAIN BY USING THE DATA OR DOCUMENTATION. The Company MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AS TO NONINFRINGEMENT OF THIRD PARTY RIGHTS, MERCHANTABILITY, OR FITNESS FOR ANY PARTICULAR PURPOSE. IN NO EVENT WILL The Company BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, INCIDENTAL OR SPECIAL DAMAGES, INCLUDING ANY LOST PROFITS OR LOST SAVINGS, EVEN IF A REPRESENTATIVE OF THE COMPANY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, OR FOR ANY CLAIM BY ANY THIRD PARTY. Some states or jurisdictions do not allow the exclusion or limitation of incidental, consequential or special damages, or the exclusion of implied warranties or limitations on how long an implied warranty may last, so the above limitations may not apply to you.
Governing Law and General ProvisionsThis Agreement will be governed by the laws of the State of Utah, U.S.A., excluding the application of its conflicts of law rules. This Agreement will not be governed by the United Nations Convention on Contracts for the International Sale of Goods, the application of which is expressly excluded. If any part of this Agreement is found void and unenforceable, it will not affect the validity of the balance of the Agreement, which shall remain valid and enforceable according to its terms. You agree that the Software will not be shipped, transferred or exported into any country or used in any manner prohibited by the United States Export Administration Act or any other export laws, restrictions or regulations. This Agreement shall automatically terminate upon failure by you to comply with its terms. This Agreement may only be modified in writing signed by an authorized officer of the Company. This Agreement is binding except in the case where a signed, certified letter is issued by the Company amending the Agreement.
Notice to Government End UsersThe Software and Documentation are "Commercial Items," as that term is defined at 48 C.F.R. 2.101, consisting of "Commercial Computer Software" and "Commercial Computer Software Documentation," as such terms are used in 48 C.F.R. 12.212 or 48 C.F.R. 227.7202, as applicable. Consistent with 48 C.F.R. 12.212 or 48 C.F.R. 227.7202-1 through 227.7202-4, as applicable, the Commercial Computer Software and Commercial Computer Software Documentation are being licensed to U.S. Government end users (A) only as Commercial Items and (B) with only those rights as are granted to all other end users pursuant to the terms and conditions herein.
OtherUnpublished-rights reserved under the copyright laws of the United States.
Our Products
ZIPCODE DATA SINCE 2002