ZIPList5 Geocode TM (April 2024 data)

You can incorporate this data into your own dealer/store locator applications to find all stores within a radius or to find the closest store. (We include the distance calculation equations.) Or use this data file with popular commercial database programs such as MS Access, dBase, Paradox, FoxPro, etc.

Included with ZIPList5 Geocode documentation is a brief tutorial explaining how to use latitude and longitude to calculate the distance in miles between two ZIP codes.

We update every record in ZIPList5 Geocode monthly, so you always receive the latest and most up-to-date data. You can't get more accurate and timely ZIP code data from any other source! 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 US Geological Survey, NANPA, the telephone companies, and maps.

The ZIPList5 Geocode is formatted as a comma-delimited ASCII text file, making it easy to import the data into most database programs. Also available in native MS Access, dBase, and Paradox formats.

Record Layout
The records of the ZIPList5 Geocode file consist of eleven fields fields, arranged as follows:

Field		Type		Length
City Name		Variable length		28 maximum
State Code		Fixed length		2
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
Time zone		Variable length		5 maximum
DST		Fixed length		1 ("Y" or "N")
Latitude		Fixed length		7 characters: nn.nnnn
Longitude		Variable length		8 or 9 characters: nnn.nnnn, in degrees
ZIP code type		Fixed length		1 character (P, U, M, or blank)

The city name field contains the one "preferred" city name for this particular ZIP code as defined by the US Postal Service. This database contains only one record for each active ZIP code, and does NOT list any possible "alias" city names for any ZIP code.

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.

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

The ZIP Code type field identifies special ZIP codes used for PO Boxes, companies, or the military.

County, ZIP code, and area code boundaries
County boundaries, state boundaries, ZIP code boundaries, area code boundaries, and time zone boundaries are all administered by different federal, state, and local government and private agencies. As you probably already know, cooperation between these various agencies is virtually nonexistent. As a result, these various boundaries do not necessarily align. This means that a given ZIP code area may actually cross one or more county, area code, and/or time zone boundaries. But each ZIP code record in ZIPList5 Geocode has only a single field each for county name, area code, or time zone. An attempt to add additional records to document all the variations which can occur would make the product too complex and difficult to use, and is beyond the scope of this inexpensive database.

We selected the most prevalent county, area code, and time zone for each ZIP code in the database. However, you should be aware that because of this boundary alignment problem, the county name and FIPS code, area code, and time zone provided for each ZIP code in the database may not apply to every address which lies within the boundaries of that ZIP code.

Sample Records

City Name
Aurora
Denver
Austin
Sandy

ST Code
CO
CO
TX
UT

ZIP Code
80010
80203
78701
84070

Area Code
303
303
512
801

Cnty FIPS
08005
08031
48453
49035

County Name
Arapahoe
Denver
Travis
Salt Lake

Time Zone
MST
MST
CST
MST

Daylight Saving
Y
Y
Y
Y

Latitude Degrees
39.7403
39.7318
30.2721
40.5769

Longitude Degrees
-104.8598
-104.9825
-97.7424
-111.8884

ZIP Type

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

Click here to download 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 Geocode:

• 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 Geocode outside your company.

Prices

	April 2024 data	Annual Subscription Quarterly* updates save up to 59%	Annual Subscription Monthly** updates save up to 66%
Workstation License:	$39.95	$119.95	$299.00
Enterprise License:	$99.95	$239.95	$599.00
Duplication Addendum: up to 100 copies unlimited copies	$199.00 $399.00	$479.00 $959.00	$1,199.00 $2,399.00

*Quarterly updates: Pay this fee one time. You'll receive the latest ZIPList5 Geocode data every three months for a full year (a total of four versions), starting with April 2024.
**Monthly updates: Pay this fee one time. You'll receive the latest ZIPList5 Geocode data every month for a full year (a total of 12 versions), starting with April 2024.
Prices subject to change without notice.

Delivery

Internet:	Download ZIPList5 Geocode 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

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

What our Customers say about our Database Products and about us