USA ZIP Codes and Canadian Postal Codes Database, Combined Edition - The database includes all valid US and Canadian Postal Codes, cities, states/provinces, time zones, area codes, and individually certified latitude and longitude coordinates and much more in one database. The ZIP Code & Postal Code Database is available in the following formats: Microsoft Access 97 & 2000 (or later), comma-separated values, fixed-width format, and tab-delimited format. All formats are included with your purchase, and they can be imported into most databases.
When raw power and capability for the US and Canada are required for your information, the USA and Canada Combined Edition database is the top candidate for the job. Able to make quick work of even the most complex information, the Combined Edition will keep the correct information you need for the US and Canada at your fingertips.
Enjoy the simplicity of this pure, refined, and intensively-verified data. We know the difference correct results produce. We spend countless hours processing each piece of information to ensure our list is simply, the best available. We guarantee it or your money back.
With about 900,000 records – just under 42,000 US ZIP Codes and about 800,000 Canadian Postal Codes - you'll be glad you have the most accurate ZIP Code database on the internet at the best price – the difference your business needs.
Remember, we guarantee our product so you can guarantee yours.
Note: This product is available for download only. This allows us to keep prices low and pass the savings along to you. Plus, you receive your purchase immediately- so there's no waiting involved.Product Features & Benefits
Uncompressed Disk Space
Microsoft Access Version - 175 MB
Comma-separated Version - 100 MB
Fixed-width Version - 310 MB
Tab-delimited Version - 100 MB
WinZip or another similar PKzip archive extraction utility.
Microsoft Access, notepad, or another similar text-editing utility
|Country||varchar(12)||In our combined databases, the country column designates whether a postal code is located in the United States or Canada.|
|PostalCode||varchar(7)||A 5-digit numeric code representing a geographic delivery route.|
|PostalType||char(1)||The Canada Post has assigned each Postal 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.|
|CityName||varchar(64)||The name of the city (and in some cases, organization) designated by that ZIP Code or postal code.|
|CityType||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.|
|CountyName||varchar(64)||A county is the largest administrative division in most states. In our 5-digit USA Commercial Edition database, if a ZIP Code covers two counties, the primary county is used. In the Multi-county databases, all possible counties are listed with each county as a separate record.|
|CountyFIPS||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).|
|ProvinceName||varchar(64)||The value in the ProvinceName field in our combined database is a state, territory, province, or region as designated by the USPS or Canada Post. The database includes all United States territories and possessions that have been assigned ZIP Codes and all Canadian Provinces that have been assigned Postal Codes.|
|ProvinceAbbr||char(2)||A state or province abbreviation is a two character designation for that US state or Canadian province - for example, California is CA and Texas is TX, etc.|
|StateFIPS||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).|
|MSACode||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.|
|AreaCode||varchar(16)||In our USA 5-digit Premium Edition database, the area code listed is the primary or foremost area code for each ZIP Code.In our Commercial Edition databases (both the USA and Canada), if multiple area codes belong to one postal code, all area codes are listed and delimited by a slash / character.|
|TimeZone||varchar(16)||The time zone to which that ZIP Code belongs. Only the primary time zone is listed for each ZIP Code.|
|UTC||decimal(3,1)||The UTC offset is the number of hours the particular ZIP Code is from Universal Time Co-ordinated (UTC), the international time standard, also known as Greenwich Meridian Time (GMT).|
|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.|
ZIPCODE DATA SINCE 2002