ZIPList5 Medical MSA TM (November 2017 data)
ZIP code 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 ZIP code 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/PMSA codes, you should use a different database product, ZIPList5 MSA, which contains the Census Bureau/OMB-approved MSA/PMSA 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 area code, and HCFA MSA code for nearly 42,700 ZIP codes. 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 ZIP codes plus ZIP codes 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 ZIP code, or find the MSA based on ZIP code.
The City Name field identifies a city name associated with the ZIP code by the USPS. There may be several different city names associated with a particular ZIP code. If so, the ZIP code will appear in several different records, each with a different city name.
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. A particular ZIP code may appear in more than one record if the USPS has defined more than one city name for that ZIP code.
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 Preferred? flag can have one of three states, which indicate how that name can be used for delivery of mail to the associated ZIP code. The three states are:
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 ZIP codes but an alias name for other ZIP codes. 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 MedMSA (Medical 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.
The ZIP Code type field identifies special ZIP codes used for PO Boxes, companies, or the military.
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)
* Quarterly subscription: Annual fee. You'll receive the latest ZIPList5 Medical MSA data every three months for a full year, starting with November 2017.
** Monthly subscription: Annual fee. You'll receive the latest ZIPList5 Medical MSA data every month for a full year, starting with November 2017.
Prices subject to change without notice.
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 866-256-2042 or 281-292-3270 to place your order. We will prepare a pro forma invoice and send it to you via email 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 8.25% on the total amount of the order, including shipping and handling, if any. A sales tax of 8.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 send a tax exemption certificate to firstname.lastname@example.org and should contact us at 866-256-2042 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
Other ZIP code Products - ZIP code Product Comparison - About Us - Contact Us - Home
| Copyright © 2017 CD Light, LLC|