ZIPList5 Market Area TM (May 2012 data)
Up-to-date Zipcode database with 5-digit Zipcode, market area, city, state, area code, county and FIPS code, time zone, daylight saving time flag, and Zipcode type for the entire USA.
Description
ZIPList5 Market Area is a Zipcode database file defining a market area for every 5-digit Zipcode which lies within the 50 states. The file also includes the city name, state abbreviation, county name and county FIPS code, primary telephone area code, time zone, daylight saving time flag and Zipcode type for each Zipcode. ZIPList5 Market Area also includes a separate cross-reference file defining the market areas by primary city name and their associated market area codes. Zipcodes are updated monthly. Market area definitions and codes stable.
This market area scheme divides the 50 states into approximately 200 unique geographic market areas. Each Zipcode in the 50 states is assigned to the appropriate market area. A particular market area may consist of Zipcodes in one, two, or more contiguous states.
This market area geographic system has gained general acceptance within the business community as a basic approach to structuring advertising and promotion as well as setting up distribution systems, sales territories, and franchise territories, etc. The market area scheme is superior to a scheme based on MSA/PMSA because a market area generally covers an area considerably larger than the corresponding MSA/PMSA, there are fewer market areas than MSA/PMSAs, and market areas cover the entire country, while MSA/PMSAs omit the rural areas of most states.
This market area definition scheme is superior to market area definitions based on broadcast television viewing patterns. TV coverage areas are significatly distorted, especially in the western states, by cable and satellite usage, leading to non-contiguous geographic areas being combined into a single market area. Our market area scheme avoids this problem because the market area definitions are based strictly on geography instead of television viewing patterns.
This Zipcode database file is formatted as a comma-delimited ASCII text file, making it easy to import the data into most database programs. It is also available in native MS Access, dBase, and Paradox formats.
We update every record in ZIPList5 Market Area monthly, so you always receive the latest and most up-to-date data. You can't get more accurate and timely Zipcode data from any other source! We include the most recent area code changes in every update. We license our Zipcode data directly from the US Postal Service, and collect all the other data continuously from a variety of other sources.
Record Layout
The data records of the ZIPList5 Market Area file consist of ten quote-delimited, comma-separated, ASCII text fields, arranged as follows:
"City Name","State Code","ZIP code","Area code","County FIPS code","County Name","Time zone","DST","Market Area","ZIP Code Type"CRLF
The fields are defined as follows:
| Field | Type | Length | ||
|---|---|---|---|---|
| City Name | Variable length ASCII | 28 maximum | ||
| State Code | Fixed length ASCII | 2 | ||
| ZIP code | Fixed length ASCII | 5 numeric characters | ||
| Area code | Fixed length ASCII | 3 numeric characters | ||
| County FIPS | Fixed length ASCII | 5 numeric characters | ||
| County Name | Variable length ASCII | 25 maximum | ||
| Time zone | Variable length ASCII | 5 maximum | ||
| DST | Fixed length ASCII | 1 ("Y" or "N") | ||
| Market Area | Fixed length ASCII | 3 numeric characters or blank | ||
| ZIP code type | Fixed length ASCII | 1 character (P, U, M, or blank) |
The city name field contains the one "preferred" city name for this particular Zipcode as defined by the US Postal Service. This database contains only one record for each active Zipcode, and does NOT list any possible "alias" city names for any Zipcode.
The ZIP code field lists only valid 5-digit Zipcodes currently defined by the USPS. Obsolete Zipcodes 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 Zipcode. If multiple area codes apply to that one Zipcode, 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 Zipcode listed in a given record.
The time zone field always contains the standard time zone designation for a particular Zipcode. If that Zipcode 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 market area field contains the 3-digit Market Area code, if any, in which some or all of the Zipcode lies. A cross-reference file defining all market area codes and their geographic name (usually one or more city names) is included with the database.
The ZIP Code type field identifies special Zipcodes used for PO Boxes, companies, or the military.
Market area, county, Zipcode, and area code boundaries
Market area boundaries, county boundaries, state boundaries, Zipcode boundaries, area code boundaries, and time zone boundaries are all administered by different federal, state, local, and private agencies. As you probably already know, cooperation between these various agencies is virtually nonexistent. As a result, the various boundaries do not necessarily align. This means that a given Zipcode area may actually cross more than one market area, county, area code, and/or time zone boundary. But each Zipcode record in ZIPList5 Market Area has only a single field each for market area, 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 have attempted to provide the most accurate information for each Zipcode by selecting the most prevalent county, area code, and time zone, and market area code for each Zipcode in the database. However, you should be aware that because of this boundary alignment problem, the market area code, county name and FIPS code, area code, and time zone provided for each Zipcode in the database may not apply to every address which lies within the boundaries of that Zipcode.
Sample Records
"Needham","MA","02494","617","25021","Norfolk","EST","Y","106",
"Newton","MA","02495","617","25017","Middlesex","EST","Y","106",
"East Falmouth","MA","02536","508","25001","Barnstable","EST","Y","106",
"East Sandwich","MA","02537","508","25001","Barnstable","EST","Y","106",
"East Wareham","MA","02538","508","25023","Plymouth","EST","Y","106",
"Agoura","CA","91376","818","06037","Los Angeles","PST","Y","403","P"
Click here to download a self-extracting file containing sample records in Access 2003 format (about 37 KB).
Click here to download a self-extracting file containing sample records in comma-delimited ASCII format (about 31 KB).
Available File Formats
| Format | Compression | Download Size | ||
|---|---|---|---|---|
| Comma-delimited ASCII | self-extracting | 450 KB | ||
| Microsoft Access 2.0 | self-extracting | 710 KB | ||
| Microsoft Access 2003 | self-extracting | 600 KB | ||
| Paradox 9.0 | self-extracting | 449 KB | ||
| dBase | self-extracting | 441 KB | ||
| Comma-delimited ASCII | WinZip | 435 KB | ||
| Comma-delimited ASCII | uncompressed | 2.75 MB |
Licenses
We offer the following licenses for ZIPList5 Market Area:
- 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 Market Area outside your company.
Prices
| May 2012 data | Quarterly* Subscription save up to 59% |
Monthly** Subscription save up to 66% |
|
|---|---|---|---|
| Workstation License: | $149.95 | $299.00 | $749.00 |
| Enterprise License: | $249.00 | $399.00 | $999.00 |
| Duplication Addendum: up to 100 copies unlimited copies |
$499.00 $999.00 |
$799.00 $1,599.00 |
$1,999.00 $3,999.00 |
* Quarterly subscription: Annual fee. You'll receive the latest ZIPList5 Market Area data every three months for a full year, starting with May 2012.
** Monthly subscription: Annual fee. You'll receive the latest ZIPList5 Market Area data every month for a full year, starting with May 2012.
Prices subject to change without notice.
Delivery
| Internet: | Download ZIPList5 Market Area 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, fax 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: |
Normally we process and ship all orders within 1 business day using the shipping method you chose. The following shipping and handling charges apply: |
||||||||||||||||||
|
Payment
All orders must be prepaid. We accept Visa, MasterCard, Discover Card and American Express. We also accept checks and money orders in US funds drawn on a US bank. The payment must include sales tax for Texas residents and shipping and handling charges if applicable.
30-Day Money-Back Guarantee
We back ZIPList5 Market Area with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList5 Market Area we will cheerfully refund the purchase price of the product.
What our Customers say about our Database Products and about us
Order Information - Other Zipcode Products - Zipcode Product Search - About Us - Contact Us - Home