100 Largest MSAs (Apri 2004 data)
We've done all the work for you!
This ZIP code list includes only the ZIP codes of the 100 largest Metropolitan Statistical Areas, as defined by the Federal Communications Commission to meet the requirements of Wireless Local Number Portability
Description
100 Largest MSAs is a ZIP code database file listing only the ZIP codes of the 100 largest MSAs, as defined by the Federal Communications Commission in its order for local number portability between wireline and wireless carriers.
For each ZIP code this database identifies the Metropolitan Statistical Area (MSA) code or Primary Metropolitan Statistical Area (PMSA) code in which the ZIP code lies. Each record 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 the ZIP code. The ZIP codes in this database come from the US Postal Service, and are accurate as of Apri 2004.
This database is formatted as a comma-delimited ASCII text file, making it easy to import the data into most database programs.
Record Layout
The data records of this database consist of eleven 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","ZIP Code Type","DST","MSA","MSA Name"
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") | ||
| ZIP code type | Fixed length ASCII | 1 character (P, U, M, or blank) | ||
| MSA | Fixed length ASCII | 4 numeric characters or blank | ||
| MSA Name | Variable length ASCII | 45 maximum |
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 ZIP Code type field identifies special ZIP codes used for PO Boxes, companies, or the military.
The MSA field contains the Metropolitan Statistical Area code in which some or all of the ZIP code lies. The MSA is a 4-digit FIPS code assigned by the White House's Office of Management and Budget.
The MSA Name field contains the "official" name for the Metropolitan Statistical Area as defined by the White House's Office of Management and Budget.
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 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 ZIP code by selecting 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.
Available File Formats
| Format | Compression | Download Size | ||
|---|---|---|---|---|
| Comma-delimited ASCII | WinZip | 124 KB |
Licenses
We offer the following license for 100 Largest MSAs:
- Enterprise License - unlimited users on unlimited sites within one company
Prices
| Apri 2004 data | Quarterly* Subscription save up to 59% |
Monthly** Subscription save up to 66% |
|
|---|---|---|---|
| Enterprise License: | $249.00 | $399.00 | $999.00 |
* Quarterly subscription: Annual fee. You'll receive the latest data every three months for a full year, starting with Apri 2004.
** Monthly subscription: Annual fee. You'll receive the latest data every month for a full year, starting with Apri 2004.
Prices subject to change without notice.
Delivery
| Internet: | Download in just minutes after you place your order via telephone. Sorry, we don't accept online orders for this product. 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 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 800-571-3914 or 281-292-3270 to place your order. We will prepare a pro forma invoice and send it to you via email, fax, 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 6.25% on the total amount of the order, including shipping and handling, if any. A sales tax of 6.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 fax a tax exemption certificate to us at 281-292-3608 and should contact us at 800-571-3914 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 this database with our 30-Day Money-Back Guarantee. If you are not satisfied with our product we will cheerfully refund the purchase price of the product.
What our Customers say about our Database Products and about us
Please call us at 800-571-3914 to place your order for the Top 100 MSAs ZIP code list
Other ZIP code Products - ZIP code Product Search - About 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: 800-571-3914 or 281-292-3270
Fax: 281-292-3608