Data Last Updated: November 1, 2024

U.S. ZIP +4 Database

ZIP plus four 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 Database?

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. 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.
Comes with Complimentary 5 digit database for more powerful analysis
All purchases come with MONTHLY updates
IMMEDIATE download upon purchase & FTP Access Available

	$2,500/Yr. Deluxe	$799.95/Yr. Premium	$399.95/Yr. Standard
	Buy Now	Buy Now	Buy Now
	Terms of Service	Terms of Service	Terms of Service
	Download Sample	Download Sample	Download Sample
Only the Best For You:
Immediate Download	Included	Included	Included
1 Year Subscription with Monthly Updates	Included	Included	Included
Comma-Delimited (.CSV)	Included	Included	Included
Free FTP Access	Included	Included	Included
100% Money Back Guarantee	Included	Included	Included
Free Technical Support	Included	Included	Included

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

Includes 5 digit ZIP Code Database:	Deluxe	Deluxe	Standard
ZIP Code :: 5 digit ZIP Code as designated by the United States Postal Service. U.S. Territories are also included in our data. (Puerto Rico, Guam, American Samoa, Federated States of Micronesia, etc.) ¹	Included	Included	Included
City :: The official city name as designated by the United States Postal Service. ¹	Included	Included	Included
State :: U.S. two digit state code and State Full Name in separate columns. Sort on this field to get all your data grouped by state. ¹	Included	Included	Included
County :: County or parish where the ZIP Code resides. As with any of our data fields, you can sort the data by this field and the result will be data grouped by county. ¹	Included	Included	Included
Area Code :: Telephone Area Code(s) of the particular postal zone (ZIP Code). Sorting by this field will give you all the data grouped by area code. ³	Included	Included	Included
City Type :: Describes the type of postal station in the 'City Alias' field: CODE DESCRIPTION B Branch C Community Post Office (CPO) N Non Postal Community Name P Post Office S Station U Urbanization X APO/FPO MIlitary Z P.O. Box ¹	Included	Included	Included
City Alias Abbr. :: Abbreviation of city alias where applicable. ¹	Included	Included	Included
City Alias Name :: The alias name for the ZIP Code. This may be a city name, town name, village name, postal entity, community or a municipality name. The city alias names are the reason why our database has approximately 78,0sU00+ records. There are only about 43,000 U.S. ZIP Codes, but since we list each city alias within a ZIP Code, we end up with almost double the number of records. ¹	Included	Included	Included
Latitude :: The geographic coordinate of a point measured in degrees north or south of the equator. ³	Included	Included	Included
Longitude :: The geographic coordinate of a point measured in degrees east or west of the Greenwich (prime) meridian. ³	Included	Included	Included
Time Zone :: Time zone designation within the U.S. - the numbers 4-15 are assigned to the time zones. CODE DESCRIPTION 4 Atlantic (GMT -04:00) 5 Eastern (GMT -05:00) 6 Central (GMT -06:00) 7 Mountain (GMT -07:00) 8 Pacific (GMT -08:00) 9 Alaska (GMT -09:00) 10 Hawaii-Aleutian Islands (GMT -10:00) 11 American Samoa (GMT -11:00) 14 Guam (GMT +10:00) 15 Palau (GMT +9:00) ³	Included	Included	Included
Elevation :: The county's average elevation. ⁵	Included	Included	Included
State FIPS :: Federal Information Processing Standards code given to each state or US territory. This code simply identifies each U.S. state or territory by its unique 2 digit code. ¹	Included	Included	Included
County FIPS :: Federal Information Processing Standards code given to counties or parishes. This code simply identifies each U.S. county by its unique 3 digit code. ¹	Included	Included	Included
Daylight Savings :: Flag indicating whether the ZIP Code observes daylight savings. ³	Included	Included	Included
Preferred Last Line Key :: Links this record with other products ZIP-Codes.com offers such as the ZIP+4. ¹	Included	Included	Included
Classification Code :: The classification type of this ZIP Code. CODE DESCRIPTION 'Blank' = Non-Unique ZIP Code M = APO/FPO Military ZIP Code P = PO Box ZIP Code U = Unique ZIP Code (includes businesses and government buildings that have their own unique ZIP Code) ¹	Included	Included	Included
Multi County Flag :: Flag indicating whether this ZIP Code crosses county lines. IMPORTANT: This does not show which counties this ZIP Code covers, it is simply a flag that indicates whether the ZIP Code falls into more than one county. If you need the actual counties that a particular ZIP Code falls into, you need to purchase the Business version of our database. ³	Included	Included	Included
City Alias Code :: Code indicating the type of the city alias name for this record. Record can be Abbreviations, Universities, Government, and more. A = Abbreviation B = Business G = Government M1 = Military Base M1P = Military Base - Primary M2 = Military Non-Base M2P = Military Non-Base - Primary U = University UP = University - Primary Blank = Regular Non Abbreviated ZIP Code ³	Included	Included	Included
Primary Record :: This column indicates the 'primary' city name within a given ZIP Code, as designated by the U.S. Postal Service. If you want to get only the 'unique' U.S. ZIP Codes, sort the data by this field. Your results will be all (approx.) 43,000 unique ZIP Codes and all will be designated with a 'P'. ³	Included	Included	Included
Mixed Case City :: The city name of the ZIP Code in proper case. The USPS designates cities in all uppercase (i.e. NEW YORK). The Mixed case fields turns this into proper upper and lower case letters (i.e. New York). ³	Included	Included	Included
Mixed Case City Alias :: The city alias name of the ZIP Code in proper case. The USPS designates cities in all uppercase (i.e. NEW YORK). The Mixed case fields turns this into proper upper and lower case letters (i.e. New York). ³	Included	Included	Included
State ANSI Code :: ANSI code for the State this ZIP Code resides in. ANSI is the system that is replacing the FIPS system. ⁶	Included	Included	Included
County ANSI Code :: The type of locale identified in the city/state name. ANSI is the system that is replacing the FIPS system. ⁶	Included	Included	Included
Facility Code :: The type of locale identified in the city/state name. ¹	Included	Included	Included
Unique ZIP Name :: Field that specifies whether the City State Record contains the organization name for a unique ZIP Code. ¹	Included	Included	Included
City Delivery Indicator :: Specifies whether or not a post office has city-delivery carrier routes. ¹	Included	Included	Included
Carrier Route Sortation :: Identifies where automation Carrier Route rates are available. ¹	Included	Included	Included
Finance Number :: A code assigned to Postal Service facilities. ¹	Included	Included	Included
Population :: The population of the ZIP Code based on Census 2020. The population numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Househlds / Zip :: Total estimated amount of households per ZIP Code based on Census 2020. The households per zip numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
White Population :: The estimate of White population per ZIP Code based on Census 2020. The white population numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Black Population :: The estimate of Black population per ZIP Code based on Census 2020. The black population numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Hispanic Pop. :: The estimate of Hispanic population per ZIP Code based on Census 2020. The Hispanic population numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Asian Pop. :: The estimate of Asian population per ZIP Code based on Census 2020. The Asian population numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Hawaiian Pop. :: The estimate of Hawaiian or Pacific Islander population per ZIP Code based on Census 2020. The Hawaiian or Pacific Islander population numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Indian Pop. :: The estimate of American Indian and Alaska Native population per ZIP Code based on Census 2020. The American Indian and Alaska Native population numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Other Pop. :: The estimate population for all other races per ZIP Code based on Census 2020. The other race population numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Male Pop. :: The estimate of Male population per ZIP Code based on Census 2020. The Male population numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Female Pop. :: The estimate of Female population per ZIP Code based on Census 2020. The Female population numbers are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Persons / House :: Average number of individuals per household. The average number of individuals per household are not projected to the future, they are actual Census 2020 numbers. ⁷	Included	Included
Avg. House Value :: The Median average house value per ZIP Code based on Census American Community Survey. Sort by this field to get the top house values by ZIP Code. The Median average house value numbers are from the Census American Community Survey 2017-2021. ⁸	Included	Included
Income / House :: The Median average household income per ZIP Code based on Census American Community Survey. Sort by this field to get all the top household incomes by ZIP Code. The Median average household income numbers are from the Census American Community Survey 2017-2021. ⁸	Included	Included
MSA Code & Name :: Metropolitan Statistical Area. (no longer used by government - CBSA is the new standard) MSA's were replaced by CBSA's in the 90's. We keep the old MSA's in our database because some of our older customers have mapped their data by this information and it makes it easier for them if we leave the data in the database. ⁸	Included	Included
PMSA Code :: Primary Metropolitan Statistical Area. This is the area that the Census Bureau designates as the "primary" area within a given MSA. ⁸	Included	Included
CSA Code :: Core Statistical Area. This area is a group of MSA's combined into a population core area. ⁸	Included	Included
CBSA Code & Name :: Core Based Statistical Area (replaces old MSA's). A Core Based Statistical Area is the official term for a functional region based around an urban center of at least 10,000 people, based on standards published by the Office of Management and Budget (OMB) in 2000. These standards are used to replace the definitions of metropolitan areas that were defined in 1990. A CBSA is broken into two sub categories, Metro and Micro, and are detailed in the CBSA Type Field. These are defined by their population densities. To be considered a Micro area, population must be between 10,000 and 50,000. To be considered a Metro area, population must exceed 50,000. ⁸	Included	Included
CBSA Type :: Indication of whether a CBSA is Metro (over 50,000 population) or Micro (10,000 - 50,000 population). ⁸	Included	Included
CBSA Division Code & Name :: Core Based Statistical Area Division name and number. A metropolitan statistical area containing an urbanized area of at least 2.5 million people can be subdivided into two or more 'metropolitan divisions', provided specified criteria are met. Metropolitan divisions are conceptually similar the primary metropolitan statistical areas (PMSAs) defined under previous standards. These two fields field gives the sub-divided region name and number. ⁸	Included	Included
Region :: Census Division: A geographic area consisting of several States defined by the U.S. Department of Commerce, Bureau of the Census. The States are grouped into four regions and nine divisions. See also: Division ³	Included	Included
Division :: Census Division: A geographic area consisting of several States defined by the U.S. Department of Commerce, Bureau of the Census. The States are grouped into four regions and nine divisions. See also: Region ³	Included	Included
Mailing Name :: Yes or No (Y/N) flag indicating whether or not the USPS accepts this City Alias Name for mailing purposes. ¹	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.

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
U.S. Geological Survey [Updated as needed], https://www.usgs.gov
U.S. Census American National Standards Institute (ANSI) [Last Updated: 11/1/2024], https://www.census.gov
U.S. Census 2020 [Decennial] [Last Updated: 5/25/2023], https://www.census.gov
U.S. Census [Updated Yearly], https://www.census.gov

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.