This database file lists every active ZIP Code currently defined by the United States Postal Service for the entire USA. You can easily incorporate this data into your own applications to look up the city and state based on ZIP Code. ZIPList5 Max contains the following data for each active ZIP Code:
- Latitude and longitude
- CBSA/Division code, if any
- MSA/PMSA code, if any
- Population (Census 2012)
- Market Area
- City name (and abbreviation, if over 13 characters)
- Alternate city names, if any
- State abbreviation
- County name
- County FIPS code
- Primary area code
- Time zone
- Daylight Saving Time flag
- ZIP Code type
Included with the ZIPList5 Max data files are these support files:
- CBSA/Division codes: list of all valid CBSA codes with the associated area name
- MSA/PMSA codes: list of all valid MSA/PMSA/CMSA codes with the associated area name
- Market area codes: list of active market area codes with the associated area name and population
- State FIPS codes: list of all state FIPS codes, including the territories
- Area code list: complete list of all area codes for North America, including overlay area codes
ZIPList5 Max contains about 71,000 records (42,300 "preferred city name" records plus 28,700 "alternate city name" records). Covers all 50 states, plus Puerto Rico, US Virgin Islands, and the Pacific territories.
We update every record in ZIPList5 Max monthly, so you always receive the latest and most up-to-date data. We license our ZIP Code data directly from the United States Postal Service, and collect and cross-check all the other data continuously from a variety of sources, including the Census Bureau, the US Geological Survey, the Office of Management and Budget, NANPA, the telephone companies, and maps.
ZIPList5 Max is a data file, not a program. ZIPList5 Max works well with almost any commercial database program.Request Info Now
Each data record of the ZIPList5 Max file consist of nineteen fields, arranged as follows:
|City Name||Variable Length||28 Maximum, Mixed Case|
|State Code||Fixed Length||2 Alpha Characters (CA, UT, etc.)|
|ZIP Code||Fixed Length||5 Numeric Characters|
|Area Code||Fixed Length||3 Numeric Characters|
|County FIPS||Fixed Length||5 Numeric Characters|
|County Name||Variable Length||25 Maximum, Mixed Case|
|Preferred?||Fixed Length||1 ("P","A", or "N")|
|Time Zone||Variable Length||5 Maximum (EST, CST, MST, etc.)|
|DST?||Fixed Length||1 ("Y" or "N")|
|Latitude||Fixed Length||7 Characters: nn.nnnn, in degrees|
|Longitude||Variable Length||8 or 9 Characters: nnn.nnnn, in degrees|
|MSA||Fixed Length||4 Numeric Characters or Blank|
|PMSA||Fixed Length||4 Numeric Characters or Blank|
|City Name Abbreviation||Variable Length||13 Maximum, Mixed Case or Blank|
|Market Area||Fixed Length||3 Numeric Characters or Blank|
|ZIP Code Type||Fixed Length||1 Character (P, U, M, or Blank)|
|CBSA||Fixed length||5 Numeric Characters or Blank|
|Division||Fixed Length||5 Numeric Characters or Blank|
|Population||Variable Length||12 Numeric Characters Max|
The City Name field identifies a city name associated with the ZIP Code by the USPS. There may be several different city names associated with a particular ZIP Code. If so, the ZIP Code will appear in several different records, each with a different city name.
The ZIP Code field lists only valid 5-digit ZIP Codes currently defined by the USPS. Obsolete ZIP Codes which have been retired from service by the USPS are not included in this database. A particular ZIP Code may appear in more than one record if the USPS has defined more than one city name for that ZIP Code.
The area code is the "most prevalent" area code for that one ZIP Code. If multiple area codes apply to that one ZIP Code, only the primary area code is listed. Overlay area codes are not listed.
The County FIPS code is a 5-digit numeric field containing a unique numeric identification assigned to that county by the US government. The County FIPS code field and the County Name field identify the "most prevalent" county for the 5-digit ZIP Code listed in a given record.
The Preferred? flag can have one of three states, which indicate how that name can be used for delivery of mail to the associated ZIP Code. The three states are:
- P - This is the preferred city name for this ZIP Code
- A - This city name is approved (but NOT preferred) for this ZIP Code
- N - The city name is NOT approved for mail delivery to this ZIP Code
A particular ZIP Code always has exactly one "preferred name" record but also may have additional "alternate name" records.
The one preferred name record has the preferred field set to "P", while all alternate city name records have the preferred field set to "A" or "N". Note that in some cases a particular city name may be preferred for some ZIP Codes but an alternate city name for other ZIP Codes.
The time zone field always contains the standard time zone designation for a particular ZIP Code. If that ZIP Code falls within a political entity which participates in Daylight Saving Time (DST) during the summer months, the DST field is set to "Y". Otherwise the DST field is set to "N".
The latitude and longitude fields contain the geographic coordinates in degrees of the geographic centroid of the ZIP Code area. ZIPList5 Max documentation includes a tutorial and equations for calculating the distance in miles between ZIP Codes using latitude and longitude.
The MSA field contains the Metropolitan Statistical Area code, if any, in which the ZIP Code lies. The MSA is assigned by the US Government.
The PMSA field contains the Primary Metropolitan Statistical Area code, if any, in which the ZIP Code lies. The PMSA is assigned by the US Government.
The City Name Abbreviation field contains the United States Postal Service "official" abbreviation for the city name in those cases where the city name exceeds 13 characters. For those cities where the name is 13 or fewer characters this field is blank.
The Market Area field contains the three-digit Market Area code in which the ZIP Code lies.
The ZIP Code type field identifies special ZIP Codes used for PO Boxes, companies, or the military.
The CBSA field contains Core Based Statistical Area code, if any, in which the ZIP Code lies.
The Division field contains the CBSA division code, if any, in which the ZIP Code lies.
The Population field contains the Census 2012 population for the ZIP Code.Request Info Now
|City Name||ST Code||ZIP Code||Area Code||Cnty FIPS||County Name||Pref Code||Time Zone||Daylight Saving||Latitude Degrees||Longitude Degrees|
|MSA Code||PMSA Code||City Name Abbreviation||Market Area||ZIP Type||CBSA Code||Division Code||2012 Population|
Download ZIPList5 Max sample records: Comma-delimited ASCII (CSV) format | Comma-delimited ASCII (CSV), compressed with WinZip
Available File Formats
Selected at time of download:
- Comma-delimited ASCII (CSV) compressed and uncompressed
- Microsoft Excel 2007, 2010, 2013
- Microsoft Access 2007, 2010, 2013
- dBase IV, Visual FoxPro
We offer the following licenses for ZIPList5 Max:
- Workstation License - single-user, single workstation
- Enterprise License - unlimited users on unlimited sites within one company
- Duplication Addendum - Addendum to Enterprise or Workstation License for redistributing the data of ZIPList5 Max outside your company.
Please read our License Overview to determine which license you need.
|March 2023 Data||Quarterly * Subscription
save up to 62%
|Monthly ** Subscription
save up to 68%
up to 100 copies
* Quarterly subscription: Annual fee. You'll receive the latest ZIPList5 Max data every three months for a full year, starting with March 2023.
** Monthly subscription: Annual fee. You'll receive the latest ZIPList5 Max data every month for a full year, starting with March 2023.
Prices subject to change without notice.
Internet: Download ZIPList5 Max immediately after you place your order online via our secure server. We'll include an invoice which states what you ordered and paid.Request Info Now