ZIPList5 Medical MSA (May 2012 data)
Zipcode and MSA database designed for health care organizations which must meet the reporting requirements of the Health Care Financing Administration (HCFA) for Medicare and Medicaid claims!
The ZIPList5 Medical MSA database is a special 5-digit zipcode and MSA database for use by health care organizations which must meet the reporting requirements of the Health Care Financing Administration (HCFA) for Medicare and Medicaid claims. This database includes the HCFA-approved 4-digit or 5-digit Metropolitan Statistical Area (MSA) codes, including the latest Goldsmith Modification, and rural county codes for all fifty states.
Note: You should use this database ONLY for those applications where the HCFA-approved MSA codes are appropriate. For all other applications requiring MSA codes, you should use a different database product, ZIPList5 Gold, which contains the Census Bureau/OMB-approved MSA codes. The HCFA MSA codes do not exactly match the Census Bureau/OMB MSA codes.
This database contains the preferred city name, state abbreviation, county name and county FIPS code, primary telephone areacode, and HCFA MSA code for nearly 42,700 zipcodes. Additionally, the database also includes approximately 28,800 "alias" city name records, for a total of 71,500 records. Records in this database cover all fifty states, plus the District of Columbia, Puerto Rico, and the US Virgin Islands. Military zipcodes plus zipcodes for the outlying Pacific islands are excluded from this database.
The ZIPList5 Medical MSA database is formatted as a comma-delimited ASCII text file, making it easy to import the data into most database programs such as MS Access, dBase, Paradox, FoxPro, etc. The text file can also be searched by most text editors and word processors, although the size of the file (about 4.3MB) can be a problem for some text editors. The database is also available in native MS Access, dBase, and Paradox formats. Other file formats are available upon request. You can also incorporate this data into your own applications to look up such information as the city and state based on zipcode, or find the MSA based on zipcode.
The data in this database was compiled by CD Light, LLC from a variety of sources, including the US Postal Service, the Census Bureau, Health Care Financing Administration, maps, published telephone books, direct communication with various telephone companies, and Bellcore. The most up-to-date 5-digit zipcode - MSA database available, this file includes all recent areacode changes. We have invested considerable effort in making this list as accurate as possible.
"City Name","State Code","Zipcode","Areacode","County FIPS code","County Name","Preferred flag","MSA"CRLF
The fields are defined as follows:
Record Layout:
The data records of the ZIPList5 Medical MSA database consist of eight quote-delimited, comma-separated, ASCII text fields, arranged 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 | ||
| Areacode | Fixed length ASCII | 3 numeric characters | ||
| County FIPS | Fixed length ASCII | 5 numeric characters | ||
| County Name | Variable length ASCII | 25 maximum | ||
| Preferred? | Fixed length ASCII | 1 ("P","A", or "N") | ||
| MSA | Variable length ASCII | 4 or 5 characters |
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 Preferred? flag can have one of three states, which indicate how that name can be used for delivery of mail to the associated zipcode. The three states are:
- P - This is the preferred city name for this zipcode
- A - This city name is approved (but NOT preferred) for this zipcode
- N - The city name is NOT approved for mail delivery to this zipcode
The one preferred name record has the preferred field set to "P", while all alias name records have the preferred field set to "A" or "N". Note that in some cases a particular name may be preferred for some zipcodes but an alias name for other zipcodes. This frequently occurs when the exact political boundary between adjacent cities is obscure, leading people to use the two city names interchangeably within the boundary area.
The MSA (Metropolitan Statistical Area) code is based on the HCFA MSA definition, which differs from the Census Bureau/OMB MSA definition in some significant areas. For that reason, this database should be used only for those applications where the HCFA definition is appropriate, such as medical claim forms to be submitted to the HCFA. The MSA code used here includes the so-called Goldsmith Modification, which identifies rural areas of metropolitan counties. Special MSA codes are also included for all rural counties, as shown in the following sample records.
Sample Records:
"Key West","FL","33040","305","12087","Monroe","P","9910"
"Stock Island","FL","33040","305","12087","Monroe","A","9910"
"Raccoon Key","FL","33040","305","12087","Monroe","N","9910"
Click here to download a self-extracting file containing sample records in Access 2003 format (about 26 KB).
Click here to download a self-extracting file containing sample records in comma-delimited ASCII format (about 17 KB).
Available File Formats:
| Format | Compression | Download Size | ||
|---|---|---|---|---|
| Comma-delimited ASCII | self-extracting | 1.0 MB | ||
| Microsoft Access 2.0 | self-extracting | 1.4 MB | ||
| Microsoft Access 2003 | self-extracting | 1.2 MB | ||
| Paradox 9.0 | self-extracting | 1.1 MB | ||
| dBase | self-extracting | 1.0 MB | ||
| Comma-delimited ASCII | WinZip | 1.0 MB | ||
| Comma-delimited ASCII | uncompressed | 4.3 MB |
Licenses:
We offer the following licenses for ZIPList5 Medical 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 Medical MSA outside your company.
| May 2012 data | Quarterly* Subscription save up to 62% |
Monthly** Subscription save up to 68% |
|
|---|---|---|---|
| Workstation License: | $299.00 | $499.00 | $1249.00 |
| Enterprise License: | $399.00 | $599.00 | $1499.00 |
| Duplication Addendum: up to 100 copies more than 100 copies |
$799.00 $1599.00 |
$1199.00 $2399.00 |
$2999.00 $5999.00 |
* Quarterly subscription: You'll receive the latest ZIPList5 Medical MSA data every three months for a full year, starting with May 2012.
** Monthly subscription: You'll receive the latest ZIPList5 Medical MSA data every month for a full year, starting with May 2012.
Prices subject to change without notice.
| Internet: | Download ZIPList5 Medical 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 Medical MSA with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList5 Medical MSA we will cheerfully refund the purchase price of the product.
What our Customers say about our Database Products and about
us
Order Information - Product Catalog - Product Search - About Us - Contact Us - Home