completemailingdatabase

Welcome to our COMPLETE MAILING DATABASES website!
Twitter Facebook Pinterest Instagram
Menu

Menu
Sale!

USA – ZIP+4 Database, Premium Edition

Last Update : August, 2023
Avaliability : Immediate Download
License : Standard

$299.95

Category:

Overview

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:

ZIP Code
+4 Code
+4 Range
City
Record Type
Carrier Route ID
Street Predirectional
Street Name
Street Suffix
Street Postdirectional
Add. Primary Low Num
Add. Primary High Num
Add. Primary Odd Even
Bldg. or Firm Name
Add. Secondary Abbrev.
Add. Secondary Low Num
Add. Secondary High Num
Add. Secondary Odd Even
ZIP Add-On Low Sector
ZIP Add-On Low Segment
ZIP Add-On High Sector
ZIP Add-On High Segment
Base Alternate Code
LACS Status Indicator
Gvt. Bldg. Indicator
Finance Number
State Abbreviation
County FIPS
Congressional District Num
Municipality City State Key
Urbanization Key
Preferred Last Line Key
View Complete Schema

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 Download

When 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:

  • Complete ZIP+4 Database
  • 30-Day Money Back Guarantee!
  • Updated Monthly
  • Award-Winning Customer Service
  • Site License – you may install this product on all computers within your organization
  • Available in Many Different Formats
  • Used by more Fortune 500 Companies – Google, Amazon.com, American Express, AOL Time Warner, Apple Computer, Inc., AT&T, Bank One, FedEx, Ford Motor Co., Kodak, Microsoft Corp., Walmart, Wells Fargo & Company and many more.

Compare this product to :

USA – ZIP+4 Database, Basic Edition

Technical Specifications

Uncompressed Disk Space

Tab-delimited Version – 5500 MB

WinZip 9.0 or 10.0 Required to extract files

MySql, Oracle, Microsoft SQL Server

Sample Data

Click on One of the following formats to download the Sample Data:
Comma-separated values
Tab-delimited format

Schema

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.

EULA/License

User Notice

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:

Use of the Products

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 Rights

The 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.

Restrictions

You 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 Warranty

The 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 Provisions

This 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 Users

The 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.

Other

Unpublished-rights reserved under the copyright laws of the United States.

Related products

Thanks for signing up. You must confirm your email address before we can send you. Please check your email and follow the instructions.
We respect your privacy. Your information is safe and will never be shared.
Don't miss out. Subscribe today.
×
×
WordPress Popup Plugin
Scroll to Top