Data Last Updated: December 1, 2024

U.S. ZIP +4 Database

What is a ZIP+4 Historical Database?

ZIP Code 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.

Compare ZIP+4 Historical Database Versions

$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
Immediate Download :: As soon as your purchase of is complete and payment received, you will be able to download the ZIP Code Database immediately.IncludedIncludedIncluded
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.IncludedIncludedIncluded
Comma-Delimited (.CSV) :: All database versions can be downloaded in Comma Separated Values .CSV format for immediate use.IncludedIncludedIncluded
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.IncludedIncludedIncluded
100% Money Back Guarantee :: Our ZIP+4 Database is the most accurate available and we back this up with our 100% Money Back Guarantee.IncludedIncludedIncluded
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!IncludedIncludedIncluded
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 now2018-12 to now2007-09 to now
ZipCode :: 00000-99999 Five digit numeric ZIP Code of the area. 1 IncludedIncludedIncluded
UpdateKey :: A unique key number identifying this record for updates. 1 IncludedIncludedIncluded
ActionType :: A or D, meaning add or delete this record. 1 IncludedIncludedIncluded
RecordType :: A flag indicating which type of record this is. Ex: Firm, General Delivery, High Rise, PO Box, Rural Route, or Street. 1 IncludedIncludedIncluded
CarrierRouteID :: Carrier identification code or number for a given delivery route or PO box presentation. 1 IncludedIncludedIncluded
StreetPreDirAbbr :: The directional abbreviation that comes before an address: Ex: The N meaning North in 'N 123 MAIN ST' 1 IncludedIncludedIncluded
StreetName :: The official name of the street as assigned by a local governing authority for this record. 1 IncludedIncludedIncluded
StreetSuffixAbbr :: Code that is the standard USPS abbreviation for the trailing designator in a street address. 1 IncludedIncludedIncluded
StreetPostDirAbbr :: A geographic direction that follows the street name. Ex: The N meaning North in '123 MAIN ST N' 1 IncludedIncludedIncluded
AddressPrimaryLowNumber :: The low number in a range of numeric or alphanumeric components to an address preceding the street name. 1 IncludedIncludedIncluded
AddressPrimaryHighNumber :: The high number in a range of numeric or alphanumeric components to an address preceding the street name. 1 IncludedIncludedIncluded
AddressPrimaryOddEven :: Code that identifies the side or sides of a street for which a given address range is applicable. 1 IncludedIncludedIncluded
BuildingFirmName :: The name of a company, building, apartment complex, shopping center, or other distinguishing secondary address information. 1 IncludedIncludedIncluded
AddressSecondaryAbbr :: Only Applicable to Record Types F and H. 1 IncludedIncludedIncluded
AddressSecondaryLowNumber :: The low-end secondary address component in a range of secondary addresses. 1 IncludedIncludedIncluded
AddressSecondaryHighNumber :: The high-end secondary address component in a range of secondary addresses. 1 IncludedIncludedIncluded
AddressSecondaryOddEven :: Code that identifies the side or sides of a street for which a given address range is applicable. 1 IncludedIncludedIncluded
Plus4Low :: ZIP Add-On Low Number in the range. Also known as the +4. 1 IncludedIncludedIncluded
Plus4High :: ZIP Add-On High Number in the range. Also known as the +4. 1 IncludedIncludedIncluded
BaseAlternateCode :: Code that specifies whether a record is a base (preferred) or alternate record. 1 IncludedIncludedIncluded
LACSStatus :: L = LACS Converted, Blank = Not Applicable 1 IncludedIncludedIncluded
GovernmentBuilding :: This indicates what type of Government building this is if applicable. 1 IncludedIncludedIncluded
FinanceNumber :: A code assigned to Postal Service facilities (primarily post offices) to collect cost and statistical data and compile revenue and expense data. 1 IncludedIncludedIncluded
State :: A 2-character abbreviation for the name of a state, U.S. territory, or armed forces ZIP Code designation. 1 IncludedIncludedIncluded
CountyFIPS :: The 3-digit (FIPS) code assigned to counties in sequence within each state. 1 IncludedIncludedIncluded
CongressionalDistrict :: The current Congressional District this ZIP+4 record is assigned to. 1 IncludedIncludedIncluded
UrbanizationCityStateKey :: An index to the USPS City State file that provides the urbanization name for this delivery range. 1 IncludedIncludedIncluded
PreferredLastLineCityStateKey :: Match this field to our ZIP Code Database for City name, City alias, Area Code, TimeZone, and more. 1 IncludedIncludedIncluded
ToLatitude :: The north/south measurement indicating the beginning for this record.* 2 IncludedIncludedIncluded
FromLatitude :: The north/south measurement indicating the beginning for this record.* 2 IncludedIncludedIncluded
ToLongitude :: The east/west measurement indicating the beginning for this record.* 2 IncludedIncludedIncluded
FromLongitude :: The east/west measurement indicating the beginning for this record.* 2 IncludedIncludedIncluded
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 IncludedIncludedIncluded
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 IncludedIncludedIncluded
TLID :: Tiger Line Identification (TLID) is a universal number associated with Census Bureau products.* 2 IncludedIncludedIncluded
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
Breakdown: 48 113 008900 6

  • 2 digit state
  • 3 digit county
  • 6 digit tract
  • 1 digit block group
  • 4
    IncludedIncluded
    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?

    100% Money Back Guarantee

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

    1. [123]: The first 3 digits of the ZIP Code are for a Sectional Center (in rural areas) or Large City.
    2. [45]: The last 2 digits of the ZIP Code are for the Post Office Facility or Delivery Area.
    3. [ - ]: The dash/hyphen is always required and separates the 5 digit ZIP Code from the +4.
    4. [67]: First 2 digits of the ZIP+4 are the Sector or Several Blocks.
    5. [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

    1. U.S. Postal Service [Last Updated: 12/1/2024], https://www.usps.com
    2. U.S. Census, https://www.census.gov
    3. ZIP-Codes.com Internal Data Creation [Last Updated: 12/1/2024], https://www.zip-codes.com
    4. 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.

    SecurityMetrics card safe certification logo
    Official PayPal Seal