U.S. ZIP +4 Database
What is a ZIP+4 Historical Database?
Our Historical database contains every U.S. street and address range, with its related 9 digit ZIP Code, put into row and column CSV format for easy use and manipulation going back to September 2007. With over 50 unique fields of information and every 9 digit ZIP Code in the United States, it gives you an unlimited number of ways to analyze all the U.S. ZIP +4 information. Our ZIP plus 4 Database is a great tool for address verification, building websites, geotargeting, sales tax, and general analysis.
- Use our ZIP plus 4 data for easy lookups and data filling
- Target key locations and demographics using our data
- Comes with every U.S. address range and its related geolocation
- Has every street name and house number range in the U.S.
- Files are delivered via FTP Access only
Compare ZIP+4 Historical Database Versions
|
$7,500/Yr.
Deluxe
|
$2,499/Yr.
Premium
|
$1,599/Yr.
Standard
|
|
|---|---|---|---|
| Download Sample | Download Sample | Download Sample | |
| Terms of Service | Terms of Service | Terms of Service | |
| Redistribution TOS | Redistribution TOS | ||
| Only the Best For You: | |||
| Immediate Download :: As soon as your purchase of is complete and payment received, you will be able to download the ZIP Code Database immediately. | Included | Included | Included |
| 1 Year Subscription :: All purchases come with a 1 year subscription. You will get the ZIP+4 Databases immediately as well as new releases over the year. | Included | Included | Included |
| Comma-Delimited (.CSV) :: All database versions can be downloaded in Comma Separated Values .CSV format for immediate use. | Included | Included | Included |
| Free FTP Access :: The historical ZIP+4 data is quite large with multiple files over 1GB in size for each month. FTP is the only reliable means to transfer this much data. Just shoot us an email with your username and we will get it setup. FTP, SFTP, and FTPS available to meet your companies policies. | Included | Included | Included |
| 100% Money Back Guarantee :: Our ZIP+4 Database is the most accurate available and we back this up with our 100% Money Back Guarantee. | Included | Included | Included |
| Free Technical Support :: There is a LOT of data in our ZIP+4 Database, and it can be hard understanding some things at times. That's why we are always here and able to assist you in working with our databases, for free! | Included | Included | Included |
| Dates Available :: There is a LOT of data in our ZIP+4 Database, and it can be hard understanding some things at times. That's why we are always here and able to assist you in working with our databases, free! | 2010-12 to now | 2018-12 to now | 2007-09 to now |
| Data Fields & Columns: | |||
| ZipCode :: 00000-99999 Five digit numeric ZIP Code of the area. 1 | Included | Included | Included |
| UpdateKey :: A unique key number identifying this record for updates. 1 | Included | Included | Included |
| ActionType :: A or D, meaning add or delete this record. 1 | Included | Included | Included |
| RecordType :: A flag indicating which type of record this is. Ex: Firm, General Delivery, High Rise, PO Box, Rural Route, or Street. 1 | Included | Included | Included |
| CarrierRouteID :: Carrier identification code or number for a given delivery route or PO box presentation. 1 | Included | Included | Included |
| StreetPreDirAbbr :: The directional abbreviation that comes before an address: Ex: The N meaning North in 'N 123 MAIN ST' 1 | Included | Included | Included |
| StreetName :: The official name of the street as assigned by a local governing authority for this record. 1 | Included | Included | Included |
| StreetSuffixAbbr :: Code that is the standard USPS abbreviation for the trailing designator in a street address. 1 | Included | Included | Included |
| StreetPostDirAbbr :: A geographic direction that follows the street name. Ex: The N meaning North in '123 MAIN ST N' 1 | Included | Included | Included |
| AddressPrimaryLowNumber :: The low number in a range of numeric or alphanumeric components to an address preceding the street name. 1 | Included | Included | Included |
| AddressPrimaryHighNumber :: The high number in a range of numeric or alphanumeric components to an address preceding the street name. 1 | Included | Included | Included |
| AddressPrimaryOddEven :: Code that identifies the side or sides of a street for which a given address range is applicable. 1 | Included | Included | Included |
| BuildingFirmName :: The name of a company, building, apartment complex, shopping center, or other distinguishing secondary address information. 1 | Included | Included | Included |
| AddressSecondaryAbbr :: Only Applicable to Record Types F and H. 1 | Included | Included | Included |
| AddressSecondaryLowNumber :: The low-end secondary address component in a range of secondary addresses. 1 | Included | Included | Included |
| AddressSecondaryHighNumber :: The high-end secondary address component in a range of secondary addresses. 1 | Included | Included | Included |
| AddressSecondaryOddEven :: Code that identifies the side or sides of a street for which a given address range is applicable. 1 | Included | Included | Included |
| Plus4Low :: ZIP Add-On Low Number in the range. Also known as the +4. 1 | Included | Included | Included |
| Plus4High :: ZIP Add-On High Number in the range. Also known as the +4. 1 | Included | Included | Included |
| BaseAlternateCode :: Code that specifies whether a record is a base (preferred) or alternate record. 1 | Included | Included | Included |
| LACSStatus :: L = LACS Converted, Blank = Not Applicable 1 | Included | Included | Included |
| GovernmentBuilding :: This indicates what type of Government building this is if applicable. 1 | Included | Included | Included |
| FinanceNumber :: A code assigned to Postal Service facilities (primarily post offices) to collect cost and statistical data and compile revenue and expense data. 1 | Included | Included | Included |
| State :: A 2-character abbreviation for the name of a state, U.S. territory, or armed forces ZIP Code designation. 1 | Included | Included | Included |
| CountyFIPS :: The 3-digit (FIPS) code assigned to counties in sequence within each state. 1 | Included | Included | Included |
| CongressionalDistrict :: The current Congressional District this ZIP+4 record is assigned to. 1 | Included | Included | Included |
| UrbanizationCityStateKey :: An index to the USPS City State file that provides the urbanization name for this delivery range. 1 | Included | Included | Included |
| PreferredLastLineCityStateKey :: Match this field to our ZIP Code Database for City name, City alias, Area Code, TimeZone, and more. 1 | Included | Included | Included |
| ToLatitude :: The north/south measurement indicating the beginning for this record.* 2 | Included | Included | Included |
| FromLatitude :: The north/south measurement indicating the beginning for this record.* 2 | Included | Included | Included |
| ToLongitude :: The east/west measurement indicating the beginning for this record.* 2 | Included | Included | Included |
| FromLongitude :: The east/west measurement indicating the beginning for this record.* 2 | Included | Included | Included |
| CensusTract :: Small, locally delineated statistical areas within selected counties, generally having stable boundaries and, when first established by local communities, designed to have relatively homogeneous demographic characteristics.* 2 | Included | Included | Included |
| CensusBlock :: Blocks are numbered uniquely within each census tract with a 4-character number that identifies the collection block used in the census and a character block suffix. This character block suffix is often blank.* 2 | Included | Included | Included |
| TLID :: Tiger Line Identification (TLID) is a universal number associated with Census Bureau products.* 2 | Included | Included | Included |
| Street based Centroid Latitude :: The Premium database includes a street based centerpoint Latitude/Longitude for the ZIP+4. This will center point for the range, on the street itself. † 3 | Included | ||
| Street based Centroid Longitude :: The Premium database includes a street based centerpoint Latitude/Longitude for the ZIP+4. This will center point for the range, on the street itself † 3 | Included | ||
| Building based Centroid Latitude :: Deluxe database includes virtually all centerpoint Latitudes for every ZIP +4 in U.S. and is extremely comprehensive. ‡ 4 | Included | ||
| Building based Centroid Longitude :: Deluxe database includes virtually all centerpoint Longitudes for every ZIP +4 in U.S. and is extremely comprehensive. ‡ 4 | Included | ||
| Census Block Group :: Deluxe database includes virtually all Block Groups for the entire U.S.
A census block group is a cluster of census blocks represented by a code that includes state, county, and tract codes. Census Block Group Code Structure: Example Block Group: 481130089006
|
Included | Included | |
| Download Sample | Download Sample | Download Sample | |
† The Premium database Street based Centroid Lat/Lon & Census Tract/Block Group coverage is approximately 80+% of available coordinates.
‡ The Deluxe database Building based Centroid Lat/Lon & Census Tract/Block Group coverage is approximately 95+% of available coordinates.
Why trust our ZIP+4 Database?
A lot of companies make claims that they are the best but we truly feel no other Zip Code provider provides nearly the quality of data and support as we do. We've been in operation since 2003 and have an extensive customer list of fortune 500 companies, individuals and small businesses. We also answer our phones. Seriously, we do not hide. Call us at 1-800-425-1169. ZIP-Codes.com was the first to offer an unconditional money back guarantee because we know our ZIP Code Database quality is superior. We are not just licensees of the USPS, we work directly with them and they license data back from us. We also work directly with other data vendors such as Pitney Bowes. Quality and service are our #1 priorities. But do not just trust us. See why you should chose us.
Are there parts to a ZIP Code?
Yes, a full ZIP+4 is actually comprised of 5 parts. 12345-6789 for instance may be grouped as [123] [45] [ - ] [67] [89].
- [123]: The first 3 digits of the ZIP Code are for a Sectional Center (in rural areas) or Large City.
- [45]: The last 2 digits of the ZIP Code are for the Post Office Facility or Delivery Area.
- [ - ]: The dash/hyphen is always required and separates the 5 digit ZIP Code from the +4.
- [67]: First 2 digits of the ZIP+4 are the Sector or Several Blocks.
- [89]: Last 2 digits of the ZIP+4 are the Segment or One Side of a Street.
Why do ZIP+4 records come in low/high ranges instead of individually?
For most addresses, a single ZIP+4 is the norm. Just 1 ZIP+4 will cover several houses on a block or side of the street. However, large businesses or those receiving a large volume of mail may be given a range of ZIP+4 codes so that they can route mail to specific departments. A range of ZIP+4 codes may also be assigned to a corresponding range of PO Boxes (PO Box 1004 would have ZIP+4 1004), or a single PO Box could have a full range of ZIP+4 codes (PO Box 1004 would have ZIP+4 1000 through 1100).
Because the USPS allows some instances of ZIP+4 ranges, the requirement to display the data in ranges applies to even singular ZIP+4 codes.
Do you have every ZIP+4 in the U.S. listed separately?
Unfortunately, due to the reasons listed above, no. The ZIP+4 data is only available in ranges.
What does ND as the last two characters in a ZIP+4 mean?
ND as the last two characters in a ZIP+4 mean “Non Deliverable”. It simply means that the USPS has this in their system, but does not actively deliver the mail to that address. USPS documentation has this to say about non-deliverable addresses: “Non-deliverable areas are areas to which the USPS does not deliver mail, such as vacant lots and land that borders railroad tracks. Mailers should not match an address identified as a non-delivery area.”
How do you match data from 5-digit database to the ZIP+4 database?
The ZIP+4 database is very large and is missing certain pieces of information such as City. City information can retrieved from the included 5-digit ZIP Code database.
Most people match ZIP+4 to ZIP Code in the 5 digit ZIP Code Database using just the ZIP Code. While this method works, a more precise method of matching is using the Preferred Last Line City State key from the ZIP+4 database and matching this to the City State Key in the 5 digit ZIP Code Database. This will provide the city and state names which are available for this ZIP+4 record. From there, please use the MailingName field to determine if a City Alias is valid for mailing purposes or not.
Urbanization names only exist for records in Puerto Rico. For Puerto Rico ZIP+4 records only, you can obtain the Urbanization City State Key and match this to the City State Key in the 5 digit ZIP Code database. In the matching 5 digit ZIP Code database record, the City Name field will contain the urbanization name. The same process is used to obtain the municipality name.
The city name in the 5 digit ZIP Code Database can contain many types of names: preferred last-line, urbanization, municipality, and other names by which a given 5-digit ZIP Code is known.
Do you have any other formats for the data?
Unfortunately, no. CSV is the most concise and versatile format for transferring the ZIP+4 data from system to system. It is the only data format we provide this information in.
What is from/to latitude and longitude
ZIP+4 records for the most part represent a number of houses, apartments, or businesses along a street. They do not represent singular points. In an attempt to provide more useful information regarding location, a starting point (From Latitude and From Longitude) indicate where a ZIP+4 record begins while the ending point (To Latitude and To Longitude) indicates where it begins. All areas between those two points can be thought of as being part of that ZIP+4.
Unfortunately, not all ZIP+4 codes are straight lines. Many areas curve, bend, and follow streets that are not in a straight line, so some interpretation and understanding of what is physically in between those two points must be taken into account.
References
- U.S. Postal Service [Last Updated: 12/1/2024], https://www.usps.com
- U.S. Census, https://www.census.gov
- ZIP-Codes.com Internal Data Creation [Last Updated: 12/1/2024], https://www.zip-codes.com
- Precisely [Updated Quarterly], https://www.precisely.com
Portions of data provided by and © United States Postal Service 2024. Zip-Codes.com is a non-exclusive licensee of the United States Postal Service.
