|
U.S. ZIP +4 Database
Questions? 1-800-425-1169
ZIP +4 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
- IMMEDIATE download upon purchase & DVD mailed promptly
* The Standard database Lat/Lon & Census Tract/Block coverage is approximately 60%.
† The Deluxe database Centroid Lat/Lon & Census Tract/Block coverage is approximately 90+%.
Redistribution
There are different license's and license types for the Standard and Deluxe ZIP+4 ZIP Code Databases.
- Immediate Download after purchase
- 1 Year Subscription with Monthly Updates
- All subscriptions are not automatically renewed.
- Visa, Mastercard, American Express, or Mail In Check/Purchase Order accepted
Standard ZIP+4 ZIP Code Database
Standard Database License Agreement
Designed for use within your organization.
Standard Database Redistributable License Agreement
Designed for use in a distributed product or service outside your organization.
Deluxe ZIP+4 ZIP Code Database
Deluxe Database License Agreement
Designed for all types of use.
ZIP+4 Database Documentation
Standard ZIP+4 Database
Deluxe ZIP+4 Database
ZIP+4 Database Specifications & Data Fields
Complete technical specifications including field data types and length can be found in our ZIP+4 Database Documentation
Our ZIP+4 ZIP Code Databse is approximately 1,000 Mb in size and contains over 45 million records.
ZIP+4 STANDARD Database Fields
| Field |
Description |
| ZipCode |
00000-99999 Five digit numeric ZIP Code of the area. |
| UniqueKey |
A unique key number identifying this record for updates. |
| ActionType |
A or D, meaning add or delete this record. |
| RecordType |
A flag indicating which type of record this is. Ex: Firm, General Delivery, High Rise, PO Box, Rural Route, or Street. |
| CarrierRouteID |
Carrier identification code or number for a given delivery route or PO box presentation. |
| StreetPreDirAbbr |
The directional abbreviation that comes before an address: Ex: The N meaning North in "N 123 MAIN ST" |
| StreetName |
The official name of the street as assigned by a local governing authority for this record. |
| StreetSuffixAbbr |
Code that is the standard USPS abbreviation for the trailing designator in a street address. |
| StreetPostDirAbbr |
A geographic direction that follows the street name. Ex: The N meaning North in "123 MAIN ST N" |
| AddressPrimaryLowNumber |
The low number in a range of numeric or alphanumeric components to an address preceding the street name. |
| AddressPrimaryHighNumber |
The high number in a range of numeric or alphanumeric components to an address preceding the street name. |
| AddressPrimaryOddEven |
Code that identifies the side or sides of a street for which a given address range is applicable. |
| BuildingFirmName |
The name of a company, building, apartment complex, shopping center, or other distinguishing secondary address information. |
| AddressSecondaryAbbr |
Only Applicable to Record Types F and H. |
| AddressSecondaryLowNumber |
The low-end secondary address component in a range of secondary addresses. |
| AddressSecondaryHighNumber |
The high-end secondary address component in a range of secondary addresses. |
| AddressSecondaryOddEven |
Code that identifies the side or sides of a street for which a given address range is applicable. |
| Plus4Low |
ZIP Add-On Low Number in the range. Also known as the +4. |
| Plus4High |
ZIP Add-On High Number in the range. Also known as the +4. |
| BaseAlternateCode |
Code that specifies whether a record is a base (preferred) or alternate record. |
| LACSStatus |
L = LACS Converted, Blank = Not Applicable |
| GovernmentBuilding |
This indicates what type of Government building this is if applicable. |
| FinanceNumber |
A code assigned to Postal Service facilities (primarily post offices) to collect cost and statistical data and compile revenue and expense data. |
| State |
A 2-character abbreviation for the name of a state, U.S. territory, or armed forces ZIP Code designation. |
| CountyFIPSCode |
The 3-digit (FIPS) code assigned to counties in sequence within each state. |
| CongressionalDistrict |
The 115th Congressional District this ZIP+4 record is assigned to. |
| UrbanizationCityStateKey |
An index to the USPS City State file that provides the urbanization name for this delivery range. |
| PreferredLastLineCityStateKey |
Match this field to our ZIP Code Database for City name, City alias, Area Code, TimeZone, and more. |
| FromLatitude |
The north/south measurement indicating the beginning for this record. |
| FromLongitude |
The east/west measurement indicating the beginning for this record. |
| ToLatitude |
The north/south measurement indicating the beginning for this record. |
| ToLongitude |
The east/west measurement indicating the beginning for this record. |
| 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. |
| 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. |
| TLID |
Tiger Line Identification (TLID) is a universal number associated with Census Bureau products. |
Note: Approximately 40-50% of records in the STANDARD Database do not contain Latitude/Longitude data; This is
partly due to the fact that many are "point" ZIP Codes which have no geographical boundaries. Examples include:
P.O. Box Only, Military, Single Business, and Government ZIP Codes. Any remaining missing Lat/Lon data is a function
of the Tiger data always trying to play "catch up" with the U.S. Postal Service changes. For more complete coverage, please see the DELUXE Database.
ZIP+4 DELUXE Database Fields
| Field |
Description |
| ZipCode |
00000-99999 Five digit numeric ZIP Code of the area. |
| UniqueKey |
A unique key number identifying this record for updates. |
| ActionType |
A or D, meaning add or delete this record. |
| RecordType |
A flag indicating which type of record this is. Ex: Firm, General Delivery, High Rise, PO Box, Rural Route, or Street. |
| CarrierRouteID |
Carrier identification code or number for a given delivery route or PO box presentation. |
| StreetPreDirAbbr |
The directional abbreviation that comes before an address: Ex: The N meaning North in "N 123 MAIN ST" |
| StreetName |
The official name of the street as assigned by a local governing authority for this record. |
| StreetSuffixAbbr |
Code that is the standard USPS abbreviation for the trailing designator in a street address. |
| StreetPostDirAbbr |
A geographic direction that follows the street name. Ex: The N meaning North in "123 MAIN ST N" |
| AddressPrimaryLowNumber |
The low number in a range of numeric or alphanumeric components to an address preceding the street name. |
| AddressPrimaryHighNumber |
The high number in a range of numeric or alphanumeric components to an address preceding the street name. |
| AddressPrimaryOddEven |
Code that identifies the side or sides of a street for which a given address range is applicable. |
| BuildingFirmName |
The name of a company, building, apartment complex, shopping center, or other distinguishing secondary address information. |
| AddressSecondaryAbbr |
Only Applicable to Record Types F and H. |
| AddressSecondaryLowNumber |
The low-end secondary address component in a range of secondary addresses. |
| AddressSecondaryHighNumber |
The high-end secondary address component in a range of secondary addresses. |
| AddressSecondaryOddEven |
Code that identifies the side or sides of a street for which a given address range is applicable. |
| Plus4Low |
ZIP Add-On Low Number in the range. Also known as the +4. |
| Plus4High |
ZIP Add-On High Number in the range. Also known as the +4. |
| BaseAlternateCode |
Code that specifies whether a record is a base (preferred) or alternate record. |
| LACSStatus |
L = LACS Converted, Blank = Not Applicable |
| GovernmentBuilding |
This indicates what type of Government building this is if applicable. |
| FinanceNumber |
A code assigned to Postal Service facilities (primarily post offices) to collect cost and statistical data and compile revenue and expense data. |
| State |
A 2-character abbreviation for the name of a state, U.S. territory, or armed forces ZIP Code designation. |
| CountyFIPSCode |
The 3-digit (FIPS) code assigned to counties in sequence within each state. |
| CongressionalDistrict |
The 115th Congressional District this ZIP+4 record is assigned to. |
| UrbanizationCityStateKey |
An index to the USPS City State file that provides the urbanization name for this delivery range. |
| PreferredLastLineCityStateKey |
Match this field to our ZIP Code Database for City name, City alias, Area Code, TimeZone, and more. |
| FromLatitude |
The north/south measurement indicating the beginning for this record. |
| FromLongitude |
The east/west measurement indicating the beginning for this record. |
| ToLatitude |
The north/south measurement indicating the beginning for this record. |
| ToLongitude |
The east/west measurement indicating the beginning for this record. |
| 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. |
| 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. |
| TLID |
Tiger Line Identification (TLID) is a universal number associated with Census Bureau products. |
| CenLat |
Latitude of the ZIP+4 Centroid. |
| CenLon |
Longitude of the ZIP+4 Centroid. |
| CensusBlockGroup |
Census block group code (state, county, tract and block group codes). |
Note: The Latitude/Longitude coverage is much more complete and accurate than our Standard ZIP+4 Database
5 Digit Standard ZIP Code Database Fields
[This database is included with the ZIP+4 Standard Database] For City and other information on each record, a copy of the 5 digit Standard ZIP Code database is included with your purchase:
| Field
| Description
|
| Zip Code |
5 digit zip code as designated by the United States Postal Service. |
| City |
City name as designated by the United States Postal Service. |
| State |
A 2-character abbreviation for the name of a state, U.S. territory, or armed forces ZIP Code designation. |
| County |
County or parish name where the ZIP Code resides. |
| Area Code |
Telephone area code(s) of the particular postal zone (ZIP Code). |
| City Type |
Describes the type of postal station in the "City Alias" field. |
| City Alias Abbr. |
Abbreviation of city alias where applicable. |
| City Alias Name |
The alias name for the ZIP Code. This may be a city name, postal entity, community or a municipality name. |
| Latitude |
The geographic coordinate of a point measured in degrees north or south of the equator. |
| Longitude |
The geographic coordinate of a point measured in degrees east or west of the Greenwich (prime) meridian. |
| Time Zone |
Time zone designation within the U.S. - the numbers 4-11 are assigned to the time zones. |
| Elevation |
The county's average elevation. |
| County FIPS |
The 3-digit (FIPS) code assigned to counties in sequence within each state. |
| Daylight Savings |
Flag indicating whether a zip code is on daylight savings. |
| PreferredLastLineKey |
Matches this record to our other products for designated city name, city type, area code, time zone, and more. |
5 Digit Deluxe ZIP Code Database Fields
[This database is included with the ZIP+4 Deluxe Database] For City and other information on each record, a copy of the 5 digit Deluxe ZIP Code database is included with your purchase:
| Field
| Description
|
| ZipCode | 00000-99999 Five digit numeric ZIP Code of the area. |
| State | 2 letter state name abbreviation. |
| StateFullName | The full US State Name. |
| City | Name of the city as designated by the USPS. |
| CityAliasName | Alias name of the city if it exists. |
| County | Name of County or Parish this ZIP Code resides in. |
| AreaCode | The telephone area codes available in this ZIP Code. |
| Latitude | Geographic coordinate as a point measured in degrees north or south of the equator. |
| Longitude | Geographic coordinate as a point measured in degrees east or west of the Greenwich Meridian. |
| Elevation | The average elevation of the county. |
| CityType | Indicates the type of locale such as Post Office, Stations, or Branch. |
| CityAliasAbbreviation | 13 Character abbreviation for the city alias name. |
| CountyFIPS | FIPS code for the County this ZIP Code resides in. |
| StateFIPS | FIPS code for the State this ZIP Code resides in. |
| TimeZone | Hours past Greenwich Time Zone this ZIP Code belongs to. |
| DayLightSaving | Flag indicating whether this ZIP Code observes daylight savings. |
| ClassificationCode | The classification type of this ZIP Code. |
| MultiCounty | Flag indicating whether this ZIP Code crosses county lines. |
| CityAliasCode | Code indication the type of the city alias name for this record. Record can be Abbreviations, Universities, Government, and more. |
| PrimaryRecord | Character 'P' denoting if this row is a Primary Record or not. Absence of character denotes a non-primary record. |
| HouseholdsPerZipcode | The estimated number of households of the ZIP Code based on 2010 Census data. |
| PersonsPerHousehold | The estimated average number of persons per household of the ZIP Code based on 2010 Census data. |
| AverageHouseValue | The average house value in County based on 2010 Census data. |
| IncomePerHousehold | The average household per ZIP Code based on 2010 Census data. |
| Population | The population of the ZIP Code based on 2010 Census data. |
| WhitePopulation | The estimated White/Caucasian Population of the ZIP Code based on 2010 Census data. |
| BlackPopulation | The estimated Black/African American Population of the ZIP Code based on 2010 Census data. |
| HispanicPopulation | The estimated Hispanic Population of the ZIP Code based on 2010 Census data. |
| AsianPopulation | The estimated Asian Population of the ZIP Code based on 2010 Census data. |
| HawaiianPopulation | The estimated Hawaiian or Pacific Islander Population of the ZIP Code based on 2010 Census data. |
| IndianPopulation | The estimated American Indian and Alaska Native Population of the ZIP Code based on 2010 Census data. |
| OtherPopulation | The estimated Population of all other races for the ZIP Code based on 2010 Census data. |
| MalePopulation | The estimated Male Population of the ZIP Code based on 2010 Census data. |
| FemalePopulation | The estimated Female Population of the ZIP Code based on 2010 Census data. |
| MSA | Metropolitan Statistical Area number assigned by Census 2010. |
| MSA_Name | Primary Metropolitan Statistical Area name or Title. |
| PMSA | Primary Metropolitan Statistical Area Number. |
| PMSA_Name | Primary Metropolitan Statistical Area name or Title. |
| CSA | Core Statistical Area. This area is a group of MSA's combined into a population core area. |
| CBSA | Core Based Statistical Area Number. |
| CBSA_DIV | Core Based Statistical Area Division. |
| CBSA_Type | Core Based Statistical Area Type (Metro or Micro). |
| CBSA_Name | Core Based Statistical Area Name or Title. |
| Region | 4 geographically grouped areas consisting of several States |
| Division | 9 geographically grouped areas consisting of several States |
| MailingName | Yes or No (Y/N) flag indicating whether or not the USPS accepts this City Alias Name for mailing purposes. |
| PreferredLastLineKey | Links this record with other products ZIP-Codes.com offers. |
| CityStateKey | Links this record with other products ZIP-Codes.com offers such as the ZIP+4. |
| CityAliasCode | Code indication the type of the city alias name for this record. Record can be Abbreviations, Universities, Government, and more. |
| CityMixedCase | The city name in mixed case (i.e. Not in all uppercase letters). |
| CityAliasMixedCase | The city alias name in mixed case (i.e. Not in all uppercase letters). |
| StateANSI | ANSI code for the State this ZIP Code resides in. |
| CountyANSI | ANSI code for the County/Parish this ZIP Code resides in.. |
| FacilityCode | The type of locale identified in the city/state name. |
| CityDeliveryIndicator | Specifies whether or not a post office has city-delivery carrier routes. |
| CarrierRouteRateSortation | Identifies where automation Carrier Route rates are available. |
| FinanceNumber | A code assigned to Postal Service facilities. |
| UniqueZIPName | Field that specifies whether the City State Record contains the organization name for a unique ZIP Code. |
ZIP+4 Database Files & Sizes
The ZIP+4 database is a large dataset (over 1 GB compressed). Because of this large size, the data is broken down into 62 individual files (one for each state/territory). Each file contains the full data for the given state. Below are the State files available as well as their current Compressed and Uncompressed File Sizes. All files are delivered in compressed .ZIP format.
| State |
Standard Database |
Deluxe Database |
| Compressed |
Uncompressed |
Compressed |
Uncompressed |
| AA |
120.5 KB |
1.6 MB |
126.8 KB |
2 MB |
| AE |
637.6 KB |
8.2 MB |
653.7 KB |
10.3 MB |
| AK |
2.2 MB |
15.5 MB |
2.9 MB |
19.2 MB |
| AL |
24.5 MB |
167.3 MB |
33.8 MB |
209.1 MB |
| AP |
221.6 KB |
2.6 MB |
225.1 KB |
3.4 MB |
| AR |
14.1 MB |
93.9 MB |
19 MB |
117 MB |
| AS |
3.1 KB |
20.6 KB |
3.1 KB |
21.1 KB |
| AZ |
15.7 MB |
134 MB |
20.7 MB |
166.8 MB |
| CA |
80.5 MB |
686.5 MB |
102.8 MB |
846 MB |
| CO |
16 MB |
117.2 MB |
20.9 MB |
144.8 MB |
| CT |
10.1 MB |
71.5 MB |
13 MB |
88.2 MB |
| DC |
2 MB |
18.6 MB |
2.5 MB |
22.7 MB |
| DE |
3.1 MB |
21.7 MB |
4.1 MB |
27 MB |
| FL |
60.9 MB |
497.2 MB |
80.5 MB |
611.8 MB |
| FM |
4.8 KB |
45.2 KB |
4.9 KB |
46.1 KB |
| GA |
36.9 MB |
295.6 MB |
49.6 MB |
367.8 MB |
| GU |
125.9 KB |
1.1 MB |
126.3 KB |
1.1 MB |
| HI |
3.1 MB |
27 MB |
3.9 MB |
33.6 MB |
| IA |
13.7 MB |
90.3 MB |
18.1 MB |
112 MB |
| ID |
5.5 MB |
36.4 MB |
7.3 MB |
45.3 MB |
| IL |
42 MB |
323.2 MB |
54.4 MB |
398.9 MB |
| IN |
24.3 MB |
179.9 MB |
32.9 MB |
224.2 MB |
| KS |
11.6 MB |
78.3 MB |
15.2 MB |
96.7 MB |
| KY |
17 MB |
118.1 MB |
22.8 MB |
146.3 MB |
| LA |
16.8 MB |
119.7 MB |
22.2 MB |
147.8 MB |
| MA |
19.5 MB |
142.1 MB |
24.9 MB |
174.6 MB |
| MD |
15.6 MB |
110.2 MB |
19.8 MB |
135.4 MB |
| ME |
6.2 MB |
43.9 MB |
8.2 MB |
55 MB |
| MH |
2.1 KB |
12.2 KB |
2.1 KB |
12.5 KB |
| MI |
33.4 MB |
239.5 MB |
43.5 MB |
297 MB |
| MN |
20.6 MB |
136 MB |
27 MB |
168.6 MB |
| MO |
23.7 MB |
161.1 MB |
31.5 MB |
199.1 MB |
| MP |
3.7 KB |
23.3 KB |
3.7 KB |
23.9 KB |
| MS |
13.4 MB |
89.2 MB |
18.1 MB |
110.7 MB |
| MT |
4.3 MB |
27.2 MB |
5.7 MB |
33.9 MB |
| NC |
37.5 MB |
256.8 MB |
50.4 MB |
318.6 MB |
| ND |
3.6 MB |
24.3 MB |
4.7 MB |
29.9 MB |
| NE |
8.3 MB |
55.3 MB |
11 MB |
68.3 MB |
| NH |
4.7 MB |
30.7 MB |
6.2 MB |
38 MB |
| NJ |
23.5 MB |
167 MB |
30.3 MB |
205.9 MB |
| NM |
6.4 MB |
44.6 MB |
8.2 MB |
55.1 MB |
| NV |
6.4 MB |
49.7 MB |
8.2 MB |
61.5 MB |
| NY |
51.9 MB |
460.2 MB |
66.6 MB |
569 MB |
| OH |
37 MB |
271.7 MB |
48.3 MB |
336 MB |
| OK |
16.8 MB |
117.6 MB |
22.8 MB |
146.4 MB |
| OR |
14 MB |
101.8 MB |
18.3 MB |
126.8 MB |
| PA |
42.7 MB |
307.1 MB |
56.2 MB |
381.2 MB |
| PR |
4 MB |
32.1 MB |
4.7 MB |
37.6 MB |
| PW |
2.5 KB |
17.4 KB |
2.5 KB |
17.8 KB |
| RI |
3.7 MB |
24.6 MB |
4.8 MB |
30.3 MB |
| SC |
18.4 MB |
126.2 MB |
24.5 MB |
156.4 MB |
| SD |
3.9 MB |
25 MB |
5.1 MB |
30.9 MB |
| TN |
26.2 MB |
178.7 MB |
34.9 MB |
221.1 MB |
| TX |
80.2 MB |
606.4 MB |
106.9 MB |
751.4 MB |
| UT |
6.2 MB |
51.2 MB |
8.4 MB |
64.1 MB |
| VA |
28.5 MB |
194.4 MB |
37.6 MB |
239.9 MB |
| VI |
119.7 KB |
997.5 KB |
120.4 KB |
1019.5 KB |
| VT |
3.8 MB |
24.3 MB |
5 MB |
30.4 MB |
| WA |
22.1 MB |
164.9 MB |
28.6 MB |
204 MB |
| WI |
21.6 MB |
141.5 MB |
28.5 MB |
175.5 MB |
| WV |
8.8 MB |
64 MB |
11.8 MB |
78.1 MB |
| WY |
2.2 MB |
14.9 MB |
2.9 MB |
18.5 MB |
Portions of data provided by and © United States Postal Service 2017. Zip-Codes.com is a non-exclusive licensee of the United States Postal Service.
|
ZIP Code Database