Complete Zip Code list* in the United States

Click here for a Sample of the actual zip code

  All this for only $30.00   (sent as a Download)
A download link sent by email within 24 hours or less**

Zipped File Size:  4,315 KB WinZip file.   Unzipped will create two Microsoft Excel files:
File #1)  37,962 records.  File Name:  ZipCodes_00501_To_49971.xls   Size: 9,972 KB
File #2)  32,491 records.  File Name:  ZipCodes_50001_To_99950.xls   Size: 8,522 KB
You will receive one .zip file emailed to you. You will need to unzip it to create these two Excel files.

ZIPCode char(5)


ZIP stands for "Zoning Information Plan". It is used to signify a delivery route in the United States as designated by the USPS. In most cases a ZIP Code is a geographic region with a center point.

ZIPType char(1)


The USPS has assigned each ZIP Code a "type". Why? It helps them sort mail more quickly.

  • S - Standard - A "standard" ZIP Code is what most people think of when they talk about ZIP Codes - essentially a town, city, or a division of a city that has mail service.

  • P - PO Box Only - Rural towns, groups of towns, or even high-growth areas of cities are given a "PO Box Only" ZIP Code type.

  • U - Unique - Companies, organizations, and institutions that receive large quantities of mail are given a "unique" ZIP Code type.

  • M - Military - Military bases overseas - and often vessels and ships - are given a "military" ZIP Code type.

City varchar(64)

The name of the city (and in some cases, organization) designated by that ZIP Code or postal code.

City Type char(1)

In many cases, a ZIP Code can have multiple "names", meaning cities, towns, or subdivisions, in its boundaries. However, it will ALWAYS have exactly 1 "default" name.

  • D - Default - This is the "preferred" name - by the USPS - for a city. Each ZIP Code has one - and only one - "default" name. In most cases, this is what people who live in that area call the city as well.

  • A - Acceptable - This name can be used for mailing purposes. Often times alternative names are large neighborhoods or sections of the city/town. In some cases a ZIP Code may have several "acceptable" names which is used to group towns under one ZIP Code.

  • N - Not Acceptable - A "not acceptable" name is, in many cases, a nickname that residents give that location. According to the USPS, you should NOT send mail to that ZIP Code using the "not acceptable" name when mailing.

County varchar(64)

A county is the largest administrative division in most states. Each ZIP Code in our database is assigned to one county. If a ZIP Code covers two counties, the "primary" county is used.

County FIPS char(5)

Each county in the United States is assigned a unique number for identification purposes - a "Federal Information Processing Standards" or FIPS code. The County FIPS code is a combination of a 2-digit state FIPS code as well as a 3-digit county code as designated by the National Institute of Standards and Technology (NIST).

State varchar(64)

A state in our database is a state, territory, province, or region as designated by the USPS. The database includes all United States territories and possessions that have been assigned ZIP Codes.

State Code char(2)

A state code or abbreviation is a two character designation for that state - for example, Minnesota is MN;  California is CA; Texas is TX; etc...

State FIPS char(2)

A state FIPS is a two-digit code used to uniquely define each state as designated by the National Institute of Standards and Technology (NIST).

MSA char(4)

MSAs or Metropolitan Statistical Areas, are 4-digit codes assigned to the roughly 340 metropolitan areas as designated by the Office of Management and Budget (OMB). They are primarily used to group cities together for statistical purposes or types of analysis. Latitude and longitude are a much more efficient way of accomplishing the same task.

Note that MSAs are now obsolete and have been replaced by CBSA codes.

But some people still use MSA in their older database.

Area Code char(3)

The area code listed in our database is the primary or foremost area code for each ZIP Code. If multiple area codes belong to one ZIP Code, only the primary is listed.

Time Zode varchar(16)

The time zone to which that ZIP Code belongs.
NOTE:  Only the primary time zone is listed for each ZIP Code.

GMT Offset decimal(3,1)

Hours before or after Grenitch Mean Time

DST char(1)

The daylight savings time flag indicates if a particular ZIP Code "obeys", or, in other words adjusts their clocks forward and back with the seasons. This information is particularly useful to determine time in other time zones with areas that may or may not use daylight savings time - for example, Arizona, Hawaii, and, of all places - Indiana.

Latitude decimal(9, 6)

The latitude coordinate listed is an exact north/south point (to 6 decimal places) on the globe of the centroid or "middle" of the ZIP Code.

Longitude decimal(9, 6)

The longitude coordinate listed is an exact east/west point (to 6 decimal places) on the globe of the centroid or "middle" of the ZIP Code.

Fun to see longitude and latitude for different cities, fun to work with portable GPS systems.
 

 

   

**You will get a thank you page after payment.   Then within the same or the next day I will send you the link to the download via email, make sure your PayPal Email address is good, or contact me after your order.

Need Zip Software? click here

Zipped File Size:  4,315 KB WinZip file.   Unzipped will create two Microsoft Excel files:
File #1)  37,962 records.  File Name:  ZipCodes_00501_To_49971.xls   Size: 9,972 KB
File #2)  32,491 records.  File Name:  ZipCodes_50001_To_99950.xls   Size: 8,522 KB

 

 

 

 

   
* This list was current at the time we created it for sale on the web.