ZIPList5 MSA TM (September 2024 data)

Up-to-date ZIP code database with 5-digit ZIP code, MSA, PMSA, city, state, area code, county and FIPS code, time zone, daylight saving time flag, and ZIP code type.

Please note: This database uses the old MSA definition from the 1990's using 4-digit MSA codes. If you need a database based on the newly revised 5-digit MSA definitions issued by the Federal Government in February 2013 click here.

Download ZIP code, MSA, PMSA, area code, county and county FIPS code, time zone, daylight saving time, city and state information immediately!

Description
ZIPList5 MSA is a ZIP code database file listing every active ZIP code currently defined by the US Postal Service. 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. MSAs and PMSAs are four-digit numeric codes assigned to the 337 metropolitan geographic areas defined by the Office of Management and Budget (OMB), a part of the administrative branch of the Federal Government. Each record of ZIPList5 MSA 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. We update all the data in this database every month.

Please note: This database includes all active ZIP codes defined by the US Postal Service, even though some ZIP codes may not have an MSA nor a PMSA code. Rural ZIP codes, which are not part of any defined metropolitan area, are included in this database. But rural ZIP codes have neither an MSA nor a PMSA code. Those ZIP codes which do lie within a defined metropolitan area have only an MSA code or a PMSA code. No ZIP code has both.

ZIPList5 MSA is an excellent tool for defining sales territories, distribution systems, or franchise territories, etc. ZIPList5 MSA divides the country into 337 geographic areas based primarily on population. However, there are rural portions of nearly every state which are not included in any of the 337 defined metropolitan areas. If you need a geopraphic coding scheme which covers the entire country, we suggest that you consider using our Market Area (MA) database, ZIPList5 Market Area. Market Areas have distinct advantages over MSA/PMSAs in some applications. For example, MSA/PMSAs cover only the 337 metropolitan areas defined by OMB, while the market areas cover both rural and metropolitan areas of the entire country. These two products cost the same.

ZIPList5 MSA is formatted as a comma-delimited ASCII text file, making it easy to import the data into most database programs.

We verify and update every record of ZIPList5 MSA every month, 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 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 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
Time zone Variable length 5 maximum
DST Fixed length 1 ("Y" or "N")
MSA Fixed length 4 numeric characters or blank
PMSA Fixed length 4 numeric characters or blank
ZIP code type Fixed length 1 character (P, U, M, or blank)

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 MSA field contains the Metropolitan Statistical Area code, if any, 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. 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 ZIP code 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 ZIP Code type field identifies special ZIP codes used for PO Boxes, companies, or the military.

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

Sample Records
City Name
Aurora
Denver
Austin
Sandy
ST Code
CO
CO
TX
UT
ZIP Code
80010
80203
78701
84070
Area Code
303
303
512
801
Cnty FIPS
08005
08031
48453
49035
County Name
Arapahoe
Denver
Travis
Salt Lake
Time Zone
MST
MST
CST
MST
Daylight Saving
Y
Y
Y
Y
MSA Code
 
 
0640
7160
PMSA Code
2080
2080
 
 
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 MSA:

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


Prices
September 2024
data
Quarterly*
Subscription

save up to 59%
Monthly**
Subscription

save up to 66%
Workstation License: $41.95 $125.95 $313.95
Enterprise License: $104.95 $251.95 $628.95
Duplication Addendum:
up to 100 copies
unlimited copies

$208.95
$418.95

$502.95
$1,006.95

$1,258.95
$2,518.95

* Quarterly subscription: Annual fee. You'll receive the latest ZIPList5 MSA data every three months for a full year, starting with September 2024.
** Monthly subscription: Annual fee. You'll receive the latest ZIPList5 MSA data every month for a full year, starting with September 2024.
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.


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

Yes, I want to order...


ZIP code database file with MSA, PMSA, city, state, area code, county and FIPS code, time zone, and daylight saving time for every ZIP code


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


ZIP code database with MSA, PMSA, city, state, area code, county and FIPS code, time zone, and daylight saving time for every ZIP code

Copyright © 2024 Melissa Data Corporation