ZIP code database with 5-digit ZIP code, city, state, area code, county name, county FIPS code, ZIP code type and HCFA-approved Metropolitan Statistical Area (MSA) code. Contains the latest Goldsmith Modification and rural county codes for all fifty states. 88

ZIPList5 Medical MSA TM (October 2024 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!

Download ZIP code and MSA database with city, state, area code, county name and FIPS code information immediately!

Description
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.

We update every record in ZIPList5 Medical MSA monthly, so you always receive the latest and most up-to-date data. You can't get more accurate and timely ZIP code data from any other source! We include the most recent area code changes in every update. We license our ZIP code data directly from the US Postal Service, and collect and cross-check all the other data continuously from a variety of sources, including the Census Bureau, the Office of Management and Budget, the Health Care Financing Administration, NANPA, the telephone companies, and maps.

Record Layout
The fields are defined as follows:

Field Type Length
City Name Variable length 28 maximum
State Code Fixed length 2
ZIP code Fixed length 5 numeric characters
Area code Fixed length 3 numeric characters
County FIPS Fixed length 5 numeric characters
County Name Variable length 25 maximum
Preferred? Fixed length 1 ("P","A", or "N")
MedMSA Fixed length 4 digits
ZIP code type Fixed length 1 character (P, U, M, or blank)

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:

  • P - This is the preferred city name for this ZIP code
  • A - This city name is approved (but NOT preferred) for this ZIP code
  • N - The city name is NOT approved for mail delivery to this ZIP code
Some people object to using the "preferred" name specified by the US Postal Service; these people may instead use some other, locally preferred name. This can be quite confusing. Accordingly, we have included in the database these "alias" city names, along with the ZIP codes to which they apply. This means that a particular ZIP code may exist in a "preferred name" record and again in one or more "alias name" records.

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.

Sample Records
City Name
Aurora
Denver
Austin
Sandy
Baileys Crossroads
ST Code
CO
CO
TX
UT
VA
ZIP Code
80010
80203
78701
84070
22041
Area Code
303
303
512
801
703
Cnty FIPS
08005
08031
48453
49035
51059
County Name
Arapahoe
Denver
Travis
Salt Lake
Fairfax
Pref Code
P
P
P
P
A
Medical MSA
2080
2080
0640
7160
8840
ZIP Type
 
 
 
 
 

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)
Comma-delimited ASCII (CSV) compressed and uncompressed
Microsoft Excel 2007, 2010, 2013
Microsoft Access 2007, 2010, 2013
dBase IV, Visual FoxPro

Licenses
We offer the following licenses for ZIPList5 Medical MSA:

Please read our License Overview to determine which license you need.


Prices
October 2024
data
Quarterly*
Subscription

save up to 62%
Monthly**
Subscription

save up to 68%
Workstation License: $313.95 $523.95 $1,311.45
Enterprise License: $418.95 $628.95 $1,573.95
Duplication Addendum:
up to 100 copies
unlimited copies

$838.95
$1,678.95

$1,258.95
$2,518.95

$3,148.95
$6,298.95

* Quarterly subscription: Annual fee. You'll receive the latest ZIPList5 Medical MSA data every three months for a full year, starting with October 2024.
** Monthly subscription: Annual fee. You'll receive the latest ZIPList5 Medical MSA data every month for a full year, starting with October 2024.
Prices subject to change without notice.

Delivery:
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.


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

Yes, I want to order ZIP code and MSA database with city, state, area code, county name and FIPS code



ZIP code and MSA database with city, state, area code, county name and FIPS code


Other ZIP code Products - ZIP code Product Comparison - About Us - Contact Us - Home


ZIP code and MSA database with city, state, area code, county name and FIPS code

Copyright © 2024 Melissa Data Corporation