Complete Zip Code list* in the United States
|
|
Click here for
a Sample of the actual zip
code
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.
|
|
|