ZIPList5 Max TM (October 2017 data)

Up-to-date ZIP code data file with latitude, longitude, CBSA, MSA, Census 2012 population, market area, city name and abbreviation, state, area code, county name and FIPS code, ZIP code type, time zone, and daylight saving time information for the entire USA!

Download ZIP code database with latitude, longitude, MSA, PMSA, market area area code, county name, county FIPS code, time zone, city and state information immediately!
Description
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 file 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 US 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, including MS Access, dBase, FoxPro, Paradox, etc. ZIPList5 Max is available in these native database formats: MS Access, dBase/FoxPro, and Paradox.

Record Layout
Each data record of the ZIPList5 Max file consist of nineteen fields, arranged as follows:

Field Type Length
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 US 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. For more information about market area click here.

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.

Sample Records
City Name
Aurora
Denver
Austin
Sandy
Baileys Crossroads
ST Code
CO
CO
TX
UT
VA
ZIP Code
80010
80203
78701
84070
22041
Area Code
303
303
512
801
703
Cnty FIPS
08005
08031
48453
49035
51059
County Name
Arapahoe
Denver
Travis
Salt Lake
Fairfax
Pref Code
P
P
P
P
A
Time Zone
MST
MST
CST
MST
EST
Daylight Saving
Y
Y
Y
Y
Y
Latitude Degrees
39.7403
39.7318
30.2721
40.5769
38.8465
Longitude Degrees
-104.8598
-104.9825
-97.7424
-111.8884
-77.1465
MSA Code
 
 
0640
7160
PMSA Code
2080
2080
 
 
8840
City Name Abbreviation
 
 
 
 
Baileys Xrds
Market Area
034
034
064
716
097
ZIP Type
 
 
 
 
 
CBSA Code
19740
19740
12420
41620
47900
Division Code
 
 
 
 
47894
2012 Population
39728
18839
6841
24861
27989

Click here to download ZIPList5 Max sample records in comma-delimited ASCII (CSV) format.

Click here to download ZIPList5 Max sample records in comma-delimited ASCII (CSV) format, 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
Microsoft Access 2003
Paradox 9.0
dBase IV, Visual FoxPro

Licenses
We offer the following licenses for ZIPlist5 Max:

Please read our License Overview to determine which license you need.


License Fees
October 2017
data
Quarterly*
Subscription

save up to 62%
Monthly**
Subscription

save up to 68%
Workstation License: $99.95 $199.95 $499.00
Enterprise License: $199.95 $299.95 $749.00
Duplication Addendum:
up to 100 copies
unlimited copies

$399.00
$799.00

$599.00
$1,199.00

$1,499.00
$2,999.00

* Quarterly subscription: Annual fee. You'll receive the latest ZIPList5 Max data every three months for a full year, starting with October 2017.
** Monthly subscription: Annual fee. You'll receive the latest ZIPList5 Max data every month for a full year, starting with October 2017.
Prices subject to change without notice.

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

If you place your order via phone or mail we will process your order usually within 1 business day. After we process your order we will send you an email message with the download information. We'll include an invoice which states what you ordered and paid.

No shipping and handling charges for Internet delivery.

CDROM: We'll process and ship your order within one business day. The following shipping and handling charges apply to delivery on CDROM:
Surface (USA, First Class) $8.00
International (Air Mail) $20.00

Payment
All orders must be prepaid. We do not accept Purchase Orders. We accept Visa, MasterCard, Discover Card and American Express for online or telephone orders.

We also accept checks and money orders in US funds drawn on a US bank. The payment must include shipping and handling charges, if applicable. Orders which do not include appropriate shipping and handling charges will be delayed. If you need an invoice to submit to your accounting department to have a check cut please contact us at 866-256-2042 or 281-292-3270 to place your order. We will prepare a pro forma invoice and send it to you via email or snail mail. However, your order will not be shipped until we receive payment in full.

Attention Texas residents: Orders for delivery to a Texas address, whether downloaded via the Internet or delivered on CDROM, must include sales tax of 8.25% on the total amount of the order, including shipping and handling, if any. A sales tax of 8.25% of the order total will automatically be added to all Texas orders processed through our online ordering system. Tax exempt organizations in Texas must send a tax exemption certificate to sales@zipinfo.com and should contact us at 866-256-2042 to place their orders. Orders which do not include appropriate sales tax or a valid tax exemption certificate will be delayed.

30-Day Money-Back Guarantee
We back ZIPList5 Max with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList5 Max we will cheerfully refund the purchase price of the product.

What our Customers say about
our Database Products and about us

Yes, I want to order ZIP code database with latitude, longitude, MSA, PMSA, market area, market area area code, county name, county FIPS code, time zone, city and state for every 5-digit ZIP code



ZIP code, geo code (latitude and longitude), MSA, and PMSA database with city, city abbreviation, state, area code, county name and FIPS code, time zone, and daylight saving time


Other ZIP code Products - ZIP code Product Comparison - About Us - Contact Us - Home


ZIP code, geo code (latitude and longitude), CBSA, MSA, PMSA, Census 2012 population, and market area database with  city, city abbreviation, state, area code, county name and FIPS code, time zone, and daylight saving time

Copyright © 2017 CD Light, LLC