ZIPList5 MSA TM (May 2012 data)
Up-to-date zipcode database with 5-digit zipcode, MSA, PMSA, city, state, area code, county and FIPS code, time zone, daylight saving time flag, and ZIP code type for the entire USA.
Description
ZIPList5 MSA is a zipcode database file containing the Metropolitan Statistical Area FIPS code or Primary Metropolitan Statistical Area FIPS code (if any), as defined by the White House's Office of Management and Budget (OMB), for each of the nearly 42,700 5-digit zipcodes defined by the US Postal Service. 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 ZIP code type for each zipcode. Updated monthly.
Please note: many zipcodes are not part of any metropolitan area, as defined by OMB. For that reason many zipcodes have neither an MSA nor a PMSA code. Those zipcodes which do fall within a metropolitan area have only an MSA code or a PMSA code. No zipcode has both.
This zipcode database file 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. Other file formats are available upon request.
We update every record in ZIPList5 MSA 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 sources, including the Census Bureau, Office of Management and Budget, NANPA, the telephone companies, and maps.
Record Layout
The data records of the ZIPList5 MSA file consist of eleven quote-delimited, comma-separated, ASCII text fields, arranged as follows:
"City Name","State Code","Zipcode","Area code","County FIPS code","County Name","Time zone","DST","MSA","PMSA","Zipcode Type"CRLF
The fields are defined as follows:
| Field | Type | Length | ||
|---|---|---|---|---|
| City Name | Variable length ASCII | 28 maximum | ||
| State Code | Fixed length ASCII | 2 | ||
| Zipcode | 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") | ||
| MSA | Fixed length ASCII | 4 numeric characters or blank | ||
| PMSA | Fixed length ASCII | 4 numeric characters or blank | ||
| Zipcode 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 zipcode 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 MSA field contains the Metropolitan Statistical Area code, if any, in which some or all of the zipcode lies. The MSA is a 4-digit FIPS code assigned by the White House's Office of Management and Budget. ZIPList5 MSA includes a cross-reference file listing all valid metropolitan statistical areas and their MSA codes.
The PMSA field contains the Primary Metropolitan Statistical Area code, if any, in which some or all of the zipcode lies. The PMSA is a 4-digit FIPS code assigned by the White House's Office of Management and Budget. ZIPList5 MSA includes a cross-reference file listing all valid primary metropolitan statistical areas and their PMSA codes.
The zipcode type field identifies special zipcodes used for PO Boxes, companies, or the military.
County, zipcode, and area code boundaries
County boundaries, state boundaries, zipcode 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 zipcode area may actually cross one or more county, area code, and/or time zone boundaries. But each zipcode record in ZIPList5 MSA 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 have attempted to provide the most accurate information for each zipcode by selecting the most prevalent county, area code, and time zone for each zipcode 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 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",,"1120",
"Newton","MA","02495","617","25017","Middlesex","EST","Y",,"1120",
"East Falmouth","MA","02536","508","25001","Barnstable","EST","Y",,,
"East Sandwich","MA","02537","508","25001","Barnstable","EST","Y","0740",,
"East Wareham","MA","02538","508","25023","Plymouth","EST","Y",,,
"Agoura","CA","91376","818","06037","Los Angeles","PST","Y",,"4480","P"
Click here to download a self-extracting file containing sample records in Access 2003 format (about 25 KB).
Click here to download a self-extracting file containing sample records in comma-delimited ASCII format (about 16 KB).
Available File Formats
| Format | Compression | Download Size | ||
|---|---|---|---|---|
| Comma-delimited ASCII | self-extracting | 439 KB | ||
| Microsoft Access 2.0 | self-extracting | 690 KB | ||
| Microsoft Access 2003 | self-extracting | 593 KB | ||
| Paradox 9.0 | self-extracting | 444 KB | ||
| dBase | self-extracting | 433 KB | ||
| Comma-delimited ASCII | WinZip | 423 KB | ||
| Comma-delimited ASCII | uncompressed | 2.7 MB |
Licenses
We offer the following licenses for ZIPList5 MSA:
- 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 MSA 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 MSA data every three months for a full year, starting with May 2012.
** Monthly subscription: Annual fee. You'll receive the latest ZIPList5 MSA data every month for a full year, starting with May 2012.
Prices subject to change without notice.
Delivery
| Internet: | Download ZIPList5 MSA 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 MSA with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList5 MSA 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
Sales: sales@zipinfo.com
Support: support@zipinfo.com
Mail: CD Light, LLC, 230 N Tranquil Path Dr, The Woodlands TX 77380-2758
Voice: 866-256-2042 or 281-292-3270