ZIPList5 MSA TM (November 2024 data)

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:

• 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 MSA outside your company.

Prices

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