Data Last Updated: November 1, 2024

U.S. ZIP +4 Historical Database

ZIP plus four Historical Database (9 digit ZIP Codes)

Actual Customer Emails

I appreciate your great customer service and your fine product.
Best,

Alan Maitland

Online Yellow Pages

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

	$7,500/Yr. Deluxe	$2,499/Yr. Premium	$1,599/Yr. Standard
	Buy Now	Buy Now	Buy Now
	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. ¹	Included	Included	Included
UpdateKey :: A unique key number identifying this record for updates. ¹	Included	Included	Included
ActionType :: A or D, meaning add or delete this record. ¹	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. ¹	Included	Included	Included
CarrierRouteID :: Carrier identification code or number for a given delivery route or PO box presentation. ¹	Included	Included	Included
StreetPreDirAbbr :: The directional abbreviation that comes before an address: Ex: The N meaning North in 'N 123 MAIN ST' ¹	Included	Included	Included
StreetName :: The official name of the street as assigned by a local governing authority for this record. ¹	Included	Included	Included
StreetSuffixAbbr :: Code that is the standard USPS abbreviation for the trailing designator in a street address. ¹	Included	Included	Included
StreetPostDirAbbr :: A geographic direction that follows the street name. Ex: The N meaning North in '123 MAIN ST N' ¹	Included	Included	Included
AddressPrimaryLowNumber :: The low number in a range of numeric or alphanumeric components to an address preceding the street name. ¹	Included	Included	Included
AddressPrimaryHighNumber :: The high number in a range of numeric or alphanumeric components to an address preceding the street name. ¹	Included	Included	Included
AddressPrimaryOddEven :: Code that identifies the side or sides of a street for which a given address range is applicable. ¹	Included	Included	Included
BuildingFirmName :: The name of a company, building, apartment complex, shopping center, or other distinguishing secondary address information. ¹	Included	Included	Included
AddressSecondaryAbbr :: Only Applicable to Record Types F and H. ¹	Included	Included	Included
AddressSecondaryLowNumber :: The low-end secondary address component in a range of secondary addresses. ¹	Included	Included	Included
AddressSecondaryHighNumber :: The high-end secondary address component in a range of secondary addresses. ¹	Included	Included	Included
AddressSecondaryOddEven :: Code that identifies the side or sides of a street for which a given address range is applicable. ¹	Included	Included	Included
Plus4Low :: ZIP Add-On Low Number in the range. Also known as the +4. ¹	Included	Included	Included
Plus4High :: ZIP Add-On High Number in the range. Also known as the +4. ¹	Included	Included	Included
BaseAlternateCode :: Code that specifies whether a record is a base (preferred) or alternate record. ¹	Included	Included	Included
LACSStatus :: L = LACS Converted, Blank = Not Applicable ¹	Included	Included	Included
GovernmentBuilding :: This indicates what type of Government building this is if applicable. ¹	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. ¹	Included	Included	Included
State :: A 2-character abbreviation for the name of a state, U.S. territory, or armed forces ZIP Code designation. ¹	Included	Included	Included
CountyFIPS :: The 3-digit (FIPS) code assigned to counties in sequence within each state. ¹	Included	Included	Included
CongressionalDistrict :: The current Congressional District this ZIP+4 record is assigned to. ¹	Included	Included	Included
UrbanizationCityStateKey :: An index to the USPS City State file that provides the urbanization name for this delivery range. ¹	Included	Included	Included
PreferredLastLineCityStateKey :: Match this field to our ZIP Code Database for City name, City alias, Area Code, TimeZone, and more. ¹	Included	Included	Included
ToLatitude :: The north/south measurement indicating the beginning for this record.* ²	Included	Included	Included
FromLatitude :: The north/south measurement indicating the beginning for this record.* ²	Included	Included	Included
ToLongitude :: The east/west measurement indicating the beginning for this record.* ²	Included	Included	Included
FromLongitude :: The east/west measurement indicating the beginning for this record.* ²	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.* ²	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.* ²	Included	Included	Included
TLID :: Tiger Line Identification (TLID) is a universal number associated with Census Bureau products.* ²	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. † ³		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 † ³		Included
Building based Centroid Latitude :: Deluxe database includes virtually all centerpoint Latitudes for every ZIP +4 in U.S. and is extremely comprehensive. ‡ ⁴	Included
Building based Centroid Longitude :: Deluxe database includes virtually all centerpoint Longitudes for every ZIP +4 in U.S. and is extremely comprehensive. ‡ ⁴	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 Breakdown: 48 113 008900 6 2 digit state 3 digit county 6 digit tract 1 digit block group ‡ ⁴	Included	Included
	Download Sample	Download Sample	Download Sample
	Buy Now	Buy Now	Buy Now

* The Standard database Lat/Lon & Census Tract/Block coverage is approximately 60% of available coordinates.
† 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 choose 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.

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 be 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: 11/1/2024], https://www.usps.com
U.S. Census, https://www.census.gov
ZIP-Codes.com Internal Data Creation [Last Updated: 11/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.