Help Articles

The API subscription is a monthly subscription. You receive the specified number of requests per month and the subscription renews each month. The subscription will remain active until you choose to turn off the subscription in the My Subscriptions section of the website.

Distance Wizard Standard includes the basic source code (in 16 different programming and query languages) to calculate distances on the Earth's surface. It works great combined with a  ZIP/postal code database.

Distance Wizard Professional, however, incoorporates our smart boundary technology to make your database queries extremely fast and efficient. When used with a database, it will cut down the number of rows checked by your application from literally millions (of North American postal codes) to just dozens, exponentially decreasing your execution waiting time. Users won't be waiting for your website to finish their request and your other applications will remain speedy.

To update your credit card you will Login to your account then click on My Subscriptions and then on the Add/Edit Credit Card link. *All credit card information is stored with the merchant processor not with zipcodedownload.

You can update the password by logging in and clicking on Manage Account Settings. Then click on Change password.

The Distance and Radius Assistant Base Packages include DLLs for ASP, Java, C#, VB.net, Visual Basic, and C++. The Source Code Editions include source code for PHP, Perl, ASP, Java, C#, VB.net, Visual Basic, and C++. The SQL Server Stored Procedures packages include all the DLLs and Source Code along with the SQL Server Stored Procedures.

Most latitude and longitude coordinates are centroid based. In other words, they're in the exact "center" of the ZIP Code. In cases where the ZIP Code includes a large unpopulated area, the coordinates may be population based.

Yes, our ZIP Code Multi-County product contains ZIP Codes mapped to all the counties they lie in. The  USA 5-digit ZIP Code Database, Commercial Edition  includes the primary county, as determined by the USPS, for each ZIP Code. The  ZIP+4 Premium Edition  includes the county FIPS Code for each +4 Code. A database mapping the FIPS Code to the County Name can be obtained by contacting customer support.

Absolutely! Our programming APIs are fully Linux & UNIX compatible. All the example code as well as source code is included in the package that you purchase.

No, the geo-codes are completely separate. However, the US Census does do quite a bit of analysis with ZIP Codes as their building block - so you can never go wrong by having your own database.

The formula is available when you purchase the  Distance Assistant with source code .

Both the USA 5-digit and Canada 6-digit Premium & Commercial Editions, along with our USA & Canada Bundled database, have lat/long info. You can view these products on our product page.

The  USA 5-digit Commercial Edition  has the primary county for each ZIP Code and the  ZIP+4 Premium Edition  has the County FIPS Code for each ZIP+4. We also offer a Multi-County product that indicates whether or not ZIP Codes cross into multiple counties.

No, they don't. ZIP Codes were never meant to identify a geographic region, they're simply routes taken to deliver mail. We use the boundaries created by the mail routes to create a geographic region and assign the ZIP Code lat/long coordinates.

Yes, but you need to purchase a redistribution license. On each product page with redistribution licensing there is a link under the product prices and buy now buttons that states "Click here for volume or redistribution licensing."

Yes, since it's just raw data, you'll easily be able to search by any column, be it city, state, county, etc.

The problem you're seeing with the "4-digit or 3-digit ZIP Code" isn't really a problem with our data at all, in fact, it has to do with Microsoft Excel and other programs that read the Tab or CSV file. They're trying to read the first column as an integer. When they see zeros, they get rid of them. The ZIP Code you see 501 should be 00501. You may need to use a "text-import" feature in order to get the columns to render properly as "text" and not numbers.

ZIP Code Download is a non-exclusive licensee of the USPS and Canada data. We receive monthly updates of the USPS and Canada databases and then add our internally developed data, such as latitude/longitude coordinates, to their databases. We validate our data against several different sources to insure that you receive the most accurate data possible. Remember, we offer a 30-day money-back guarantee  on all our products. If you feel the data is incorrect, please let us know!

There is limitation of around 65,000 rows in most spreadsheet applications such as Excel. If you want to use the data in Excel, download the version specific to Excel. Our Excel version contains multiple sheets within the file that contain the data. Otherwise, you can use Access or another database program to view the data.

Yes. The USPS and Canada data is updated monthly and there are changes to the data every single month. We receive the updated zip code and postal code data directly from the providers and include the changes in our monthly update. This includes all added and removed ZIP Codes and Postal Codes. We recommend purchasing monthly or quarterly updates to our databases if you will be using the data in an application. That way, you'll always have the most accurate data available!

Yes and no. The postal code data itself come directly from the USPS - they are responsible for the addition, deletion, and modification of ZIP Codes. Data such as lat/long coordinates, area codes, time zones, etc. is developed internally and validated across multiple sources.

Our database uses the most current data available. The Canada Post and USPS do in fact add and remove postal codes from their lists. Freely available sources are rarely updated monthly due to the expenses involved in obtaining updated data. To verify that a postal code is currently valid, you can use the  USPS ZIP Code Lookup  or  Canada Post Postal Code Lookup .

We only offer our products via download from our website. This is for several reasons, the main one is price. We don't have to pay for CD duplication or distribution and we can then pass those savings along to you.

You are given 30 days to download the product. If you need more time, let us know.

To get the database files you simply follow the steps in the confirmation email you received.

If you've already purchased, your temporary password is the last four digits of the credit card you used for your purchase. If you have logged in and changed your password, you can use our password lookup tool found on the login page.

Each database comes in a variety of formats. You can view the available formats by clicking on "Tech Specs" or "Sample Data" on the product page. After purchasing you can choose which format you want the database files to come in.

We allow you to download the database for up to 30 days after your first download. If you need more time, contact us. Licensing restrictions from the USPS and Canada Post may prevent us from providing data that is more than 90 days old.

Once you purchase, you'll be able to download IMMEDIATELY - there's absolutely no waiting involved.

You will receive a receipt through email confirming your purchase. You will also receive a printable receipt on the website after you checkout.

We send you a complete refresh of the database each update. The database you receive is the most current database available.

No. The update price INCLUDES the base price - you simply pay the update price and that's it. For example, the monthly update package entitles you to receive the initial product download, as well as all the updates.

Every month/quarter, we send out an email notifying you that updates are ready to be downloaded. You'll then login to our website to download the files.

Every month/quarter, we send out an email notifying you that updates are ready to be downloaded. You'll then login to our website to download the files.

You'll be able to download our data on or about the 5th business day of every month until your subscription ends. If the 5th falls on a weekend, or holiday, you'll be able to download your data on the first business day following the 5th business day of the month.

The subscription is a one year subscription. There are 11 updates (for the monthly subscription) on top of the initial download, so in other words, you'll receive 12 total databases. For the quarterly subscription, there will be 3 updates + the initial download, or 4 total databases. An email will be sent on or about the 5th business day of the month containing download instructions.

That depends. Does your application depend on correct data over time? If so, you need a subscription, or in other words, updates to the ZIP Code data. Otherwise, you will begin to notice inaccurate data over time.

A subscription is a one-time fee charged at the time of purchase that entitles you to receive updates to our products on a monthly or quarterly basis for one year, which means you will receive a total of 12 or 4 product updates.

Please see our Money-back Guarantee for refund information. Refunds MUST be submitted in writing. Our support reps will refer you to the refund policy on the website if you call.

We primarily deal with credit cards because they allow us to keep prices low. However, if you prefer not to use a credit card, feel free to contact us and we'll make other arrangements.

Yes. Please contact sales or customer support for more information. Please include the name and email address for the user with the purchase order to enable delivery of the product.

No, but we have collected some sources (many of them free) for international data in our International ZIP Code Directory.

This function allows you to find the distance between two ZIP Codes. Simply enter two ZIP Codes and click "Calculate"...and wallah! Results.

Want to find all ZIP Codes within 500 miles of Beverly Hills, 90210? Punch in the ZIP Code & the number of miles and click "Search". Click on "Save" to save the search results. Then you can work with them into your favorite program.

What if you want to sort the results by distance? Simply - just click on column heading "Miles" and it will automatically sort the results for you.

What if you want all results within 500 miles - but only those in Los Angeles, CA? Punch in Los Angeles into the city column, click "Search", and you're all set.

This function allows you to lookup a ZIP Code with the information you have about that ZIP Code. Don't know the ZIP Code? Enter the info you do have and find it in seconds.

If you just want information about one ZIP Code, punch it in and click "Search". It couldn't be easier!

Simply pass in two latitude and longitude coordinates and the Distance Assistant will return the distance in miles. All calculations are completely database-independent.

For an illustration of how the Distance Assistant works, check out the Tutorial on our Combo Package page.

In it's most basic state - it's a trig formula that finds the lat/long lines running X miles north, south, east and west of a center point.

For an illustration of how the Radius Assistant works, check out the Tutorial on our Combo Package page.

Full source code as well as example scripts for the language indicated are included.

ZIP stands for "Zoning Improvement 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.

This database contains all US ZIP Codes and Canadian Postal Codes in the PostalCode column. 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. The US ZIP Code is 5 numbers. The Canadian Postal Code is a 6-digit (+1 space) code representing a geographic delivery route.

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.

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.

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

In our combined databases, the country column designates whether a postal code is located in the United States or Canada.

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.

There are three types of cities in our databases. They are indicated by the CityType column.

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

In many cases, a ZIP Code can have multiple "names", meaning cities, towns, or subdivisions, in its boundaries. Alternate names show additional names that are a part of that ZIP Code or postal code - but are not necessarily the "primary" or "default" name.

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.

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

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.

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

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

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.

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.

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.

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

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

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.

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. Please see our CBSA product under "USA Data" in the product section.

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.

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.

Combined Statistical Area. A combined statistical area may comprise two or more metropolitan statistical areas, a metropolitan statistical area and a micropolitan statistical area, two or more micropolitan statistical areas, or multiple metropolitan and micropolitan statistical areas.

The name of the CSA being identified by the CSACode column.

The term "Core Based Statistical Area" (CBSA) became effective in 2003 and refers collectively to metropolitan and micropolitan statistical areas. This standard supercedes "MSA Codes" which were used from about 1950-2000.

The name of the CBSA being identified by the CBSACode column.

The type of CBSA being identified. This column can have the following 4 values:

• met - Metropolitan Statistical Area
• mic - Micropolitan Statistical Area
• div - Division
• non - None

A metropolitan statistical area containing a single core with a population of 2.5 million or more may be subdivided to form smaller groupings of counties referred to as "Metropolitan Divisions".

The name of the division being identified by the DivCode column.

4-digits that are used to identify a geographic segment within the 5-digit delivery area, such as a city block or a group of apartments or an individual high-volume receiver of mail, or any other unit that could use an extra identifier to aid in efficient mail sorting and delivery. This code is the low end of the range of +4 Codes that pertain to this ZIP Code.

ZIP+4 Codes associated with nondelivery areas are composed of valid ZIP sector numbers and "ND" for the ZIP segment number, for example 12345-12ND. Non-deliverable areas are areas to which the USPS does not deliver mail, such as vacant lots and land that borders railroad tracks. Mailers should not match an address identified as a nondelivery area.

If you absolutely must have numeric characters in the Plus4Code column, you may treat "ND" values as "00" (zero zero).

The range of +4 codes. Summing the +4 Code and the +4 Range will give you the high end of the range of +4 Codes that pertain to this ZIP Code.

ZIP Code 00602 has a +4 Code of 0001, and a +4 Range of 119. This means that the ZIP+4 Codes that are covered by ZIP Code 00602 range from 0001 to 0001 plus 119 (0120). Thus, ZIP+4 Codes 00602-0001 through 00602-0120 all pertain to ZIP Code 00602.

An alphabetic value that identifies the type of data in the record. Record type codes include the following:

• G = General delivery
• H = Highrise
• F = Firm
• S = Street
• P = PO box
• R = Rural route/highway contract

A 4-digit code assigned to a mail delivery or collection route within a 5-digit ZIP Code. The first character of this identification is alphabetical, and the last three are numeric:

• Bnnn = PO box
• Hnnn = Highway contract
• Rnnn = Rural route
• Cnnn = City delivery
• Gnnn = General delivery

A geographic direction that precedes the street name.

For Example:

• 472 N MAIN ST Street Pre-Direction Abbreviation = N
• Spaces = No pre-direction
• N = North
• NE = Northeast
• E = East
• SE = Southeast
• S = South
• SW = Southwest
• W = West
• NW = Northwest

The official name of a street as assigned by a local governing authority. The Street Name column contains only the street name and does not include directionals (EAST, WEST, etc.) or suffixes (ST, DR, BLVD, etc.). This element may also contain literals, such as PO BOX, GENERAL DELIVERY, USS, PSC, or UNIT. Numeric street names that have numeric components that are four characters (or less) in length at are justified such that the low-order digit of the number is positioned in the fourth position of the street name column. This shift is made so that the numeric street names appear in numeric sequence.

The street suffix:

For Example:

• ST = Street
• RD = Road
• DR = Drive
• LN = Lane

A geographic direction that precedes the street name.

For Example:

• 472 MAIN ST N Street Pre-Direction Abbreviation = N
• Spaces = No pre-direction
• N = North
• NE = Northeast
• E = East
• SE = Southeast
• S = South
• SW = Southwest
• W = West
• NW = Northwest

A house, rural route, highway contract box, or post office box number; the numeric or alphanumeric component of an address preceding the street name; the low-end address in a range of addresses. Often referred to as house number.

For Example:

• {Address Range} {Address Primary Low Number}
• 100 – 198 Main Ave -> 100
• 101 – 199 Main Ave -> 101
• A200 – A298 Main Ave -> A200
• 124-45 – 124-88 Main Ave -> 124-45
• 101 – 120 PO Box -> 101
• 1A – 1G RR 2 -> 1A

In our database the low and high numbers are usually preceded by leading zeros, which are removed from the mailing address. If the leading zero is part of the address, the number will have a hyphen instead of the leading zeros.

For Example:

• {Address Range} {Address Primary Low Number}
• 0100 – 0198 Main Ave -> -100

A house, rural route, highway contract box, or post office box number; the numeric or alphanumeric component of an address preceding the street name; the high-end address in a range of addresses. Often referred to as house number.

For Example:

• {Address Range} {Address Primary High Number}
• 100 – 198 Main Ave -> 198
• 101 – 199 Main Ave -> 199
• A200 – A298 Main Ave -> A298
• 124-45 – 124-88 Main Ave -> 124-88
• 101 – 120 PO Box -> 121
• 22A – 22B RR 2 -> 22B

In our database the low and high numbers are usually preceded by leading zeros, which are removed from the mailing address. If the leading zero is part of the address, the number will have a hyphen instead of the leading zeros.

For Example:

• {Address Range} {Address Primary High Number}
• 0100 – 0198 Main Ave -> -198

Code that identifies the side or sides of a street for which a given address range is applicable. For street, highrise, firm and multi-carrier records, B = Both sides of a street, E = Even side of a street (even-numbered addresses in the range); O = Odd side of a street (odd-numbered addresses in the range). For general delivery, post office box, and rural route/highway contract records, this code will always be "B" (both).

For Example:

• {Address Range}
• 100 – 198 Main Ave E -> Even addresses in the range
• 101 – 199 Main Ave O -> Odd addresses in the range
• 100 – 199 Main Ave B -> Even and odd addresses in the range

The name of a company, building, apartment complex, shopping center, or other distinguishing secondary address information. This column is normally used with firm and highrise records but may also contain literals such as "Postmaster" or "United States Postal Service."

A descriptive code used to identify the type of address secondary range information in the Address Secondary Range column. This code may be useful in address matching, i.e., the secondary address numbers may indicate apartment, suite, or trailer numbers, etc.

Code that describes an apartment, room, suite, space, floor or other secondary addressing numeric or alphanumeric that follows a street address. The low-end secondary address component in a range of secondary addresses.

For Example:

• {Address Range} - {Address Secondary Low Number}
• 00000001 through 00000009 -> 00000001
• A through F -> A
• 55A through 55E -> 55A

Code that describes an apartment, room, suite, space, floor, or other secondary addressing numeric or alphanumeric that follows a street address. The high-end secondary address component in a range of secondary addresses.

For Example:

• {Address Range} {Address Secondary High Number}
• 00000001 through 00000009 -> 00000009
• A through F -> F
• 66A through 66E -> 66E

Code that identifies a secondary address within a range of secondary addresses as being odd (0), even (E), or both (B).

The ZIP Add-On Low Sector and the ZIP Add-On Low Segment together form the ZIP Add-On Low Number. The ZIP Add-On Low Number is the last four positions of a ZIP+4 code; the low-end ZIP add-on in a range of codes; the add-on of the first ZIP+4 code in a consecutive series of ZIP+4 codes assigned to the delivery address. For example, most delivery addresses are assigned a single ZIP+4 code. However, large companies may be given a range of ZIP+4 codes that can be used to route mail to specific departments. A range of ZIP+4 codes can also be assigned to a corresponding range of post office boxes, and each box is mapped, one-to-one, with a ZIP+4 code in the range. A single post office box can also be assigned a range of ZIP+4 codes.

For Example:

• 12345-0001 through 12345-0009 -> ZIP Add-On Low Number = 0001

The ZIP Add-On Low Sector and the ZIP Add-On Low Segment together form the ZIP Add-On Low Number. The ZIP Add-On Low Number is the last four positions of a ZIP+4 code; the low-end ZIP add-on in a range of codes; the add-on of the first ZIP+4 code in a consecutive series of ZIP+4 codes assigned to the delivery address. For example, most delivery addresses are assigned a single ZIP+4 code. However, large companies may be given a range of ZIP+4 codes that can be used to route mail to specific departments. A range of ZIP+4 codes can also be assigned to a corresponding range of post office boxes, and each box is mapped, one-to-one, with a ZIP+4 code in the range. A single post office box can also be assigned a range of ZIP+4 codes.

For Example:

• 12345-0001 through 12345-0009 -> ZIP Add-On Low Number = 0001

The ZIP Add-On High Sector and the ZIP Add-On High Segment together form the ZIP Add-On High Number, which is the high-end ZIP add-on in a range of codes; the add-on of the last ZIP+4 code in a consecutive series of ZIP+4 codes assigned to the delivery address. Most delivery addresses are assigned a single ZIP+4 code; however, large companies may be given a range of ZIP+4 codes that can be used to route mail to specific departments. A range of ZIP+4 codes can also be assigned to a corresponding range of post office boxes, and each box is mapped, one-to-one, with a ZIP+4 code in the range. A single post office box can also be assigned a range of ZIP+4 codes. (See also ZIP Add-On Code.)

For Example:

• 12345-0001 through 12345-0009 -> ZIP Add-On High Number = 0009

The ZIP Add-On High Sector and the ZIP Add-On High Segment together form the ZIP Add-On High Number, which is the high-end ZIP add-on in a range of codes; the add-on of the last ZIP+4 code in a consecutive series of ZIP+4 codes assigned to the delivery address. Most delivery addresses are assigned a single ZIP+4 code; however, large companies may be given a range of ZIP+4 codes that can be used to route mail to specific departments. A range of ZIP+4 codes can also be assigned to a corresponding range of post office boxes, and each box is mapped, one-to-one, with a ZIP+4 code in the range. A single post office box can also be assigned a range of ZIP+4 codes. (See also ZIP Add-On Code.)

For Example:

• 12345-0001 through 12345-0009 -> ZIP Add-On High Number = 0009

Code that specifies whether a record is a base (preferred) or alternate record. Base records (represented as "B") can represent a range of addresses or an individual address, such as a firm record, while alternate records (represented as "A") are individual delivery points. Government deliveries will only be listed on alternate records with the appropriate government building indicator (federal, state, or city) set.

The Locatable Address Conversion Service (LACS) indicator describes records that have been converted to the LACS system (a product/system that allows mailers to identify and convert a rural route address to a city-style address). Rural route and some city addresses are being modified to city-style addresses so that emergency services (i.e., ambulances, police, etc.) can find these addresses more efficiently.

For Example:

• L = LACS address: The old (usually rural-route) address that has been converted for the LACS system.
• Blank = Not applicable

An alphabetic value that identifies the type of government agency at the delivery point and/or whether a firm is the only delivery at an address. For this purpose, "address" is defined as the complete delivery line (e.g., complete street address and, if included as part of the firm record, the secondary abbreviation and/or address secondary number). This column may be blank or may contain one of the following values:

• A = City government building
• B = Federal government building
• C = State government building
• D = Firm only
• E = City government building and firm only
• F = Federal government building and firm only
• G = State government building and firm only

A code assigned to Postal Service facilities (primarily post offices) to collect cost and statistical data and compile revenue and expense data. The state number comprises the first two positions of the finance number.

A standard value identifying a geographic area within the United States served by a member of the US House of Representatives or Senate. If Army/Air Force (APO) or fleet post office (FPO), this column will be blank. If there is only one member of Congress within a state, the code will be "AL" (at large).

This column will be blank until further notice.

An index to the City State file that provides the urbanization name for this delivery range.

An index to the City State file that provides the preferred last-line name for this address range.

6-digit (+1 space) postal representing a geographic delivery route.

The two-letter abbreviation for the province name.

The full name of the province, i.e. Yukon, Quebec, etc. etc.

A 5-digit numeric code representing a geographic delivery route.

When used in a city setting, it represents a section or portion of a city that has its own non-political, non-administrative identity. In a rural setting, it represents a town or village that has not yet achieved city status through population growth.

Indicates the kind of division in the DivisionName colum. This helps determine the size of the division.

The full name of the Mexican province/state.

The abbreviation for the Mexican province/state.

This option allows you to purchase the most recent version of the data available. You pay the price listed one time during checkout and are not charged again.

As the data changes each month, you will not receive updates to the data and the data that you purchased will become outdated.

This option allows you to purchase the most recent version of the data available. You pay the price listed one time during checkout and are not charged again.

You will then be entitled to receive an update to your data every three months for a period of ONE YEAR.

When your subscription expires, you will have the option to renew it. We typically give a renewal discount to existing subscribers.

This option allows you to purchase the most recent version of the data available. You pay the price listed one time during checkout and are not charged again.

After purchasing, you will be entitled to receive an update to your data each month for a period of ONE YEAR. This means you will receive 12 versions of the file - one for each month.

When your subscription expires, you will have the option to renew it. We typically give a renewal discount to existing subscribers.

When you purchase this package you will receive the following programmer components:

• Compiled Windows COM Object (for use with ASP, C++, Windows environment)
• Compiled .NET Assemblies for use in your .NET project
• Compiled JAVA .class files for use in your Java project

When you purchase this package you will receive the following programmer components:

• Compiled Windows COM Object (for use with ASP, C++, Windows environment)
• The source code for the following languages:
  • PHP
  • Perl
  • Java
  • Generic C++
  • ASP
  • ASP.NET
  • C#
  • VB.NET

When you purchase this package you will receive the following programmer components:

• Compiled Windows COM Object (for use with ASP, C++, Windows environment)
• The source code for the following languages:
  • PHP
  • Perl
  • Java
  • Generic C++
  • ASP
  • ASP.NET
  • C#
  • VB.NET
• Microsoft SQL Server 2000 (or later) stored procedures and user-defined functions.

You will need the "+ Source Code" Edition. It is specifically designed for PHP/MySql Linux/UNIX environments.

Note that the "+ SQL Server Stored Procedures" are designed for Microsoft SQL Server 2000 only and will not work on MySql.

Once you purchase our product, you'll gain immediate access to download the product. This allows you to download immediately following purchase.

Because we offer monthly updates to our data, 'Current Version' displays the month of the current update.

We keep your information 100% private and secure.

We will NOT give, sell, rent or lease your data to anyone for any reason - period. We value your privacy and we want to make sure your personal information (such as email, name, or contact info) is kept private in our SSL encrypted database.

We will only use your email within our company to notify you of updates to your subscription (if you are purchasing a subscription), or to send you an email confirmation receipt. We may also send you special offers from time to time. If you forget your password, we will also use this email to send you your password.

For more information, please review our privacy policy.

We use more than two dozen different industry-standard practices and proprietary techniques to keep your credit card information private and secure. Here are just a few of the things we do to keep your information completely secure:

1. First and foremost, you should see a small "padlock" icon on the bottom right-hand side of your browser - indicating a secure connection.
2. Furthermore, the checkout page is located on a HTTPS: connection - which is another indication of a secure connection.
3. Then, our GeoTrust & VeriSign SSL certificates require your browser to initiate at least a 128-bit secure channel between your PC and our server - so that absolutely no one else can see your data.
4. Next, we transmit your credit card information in small chunks (never the whole thing at one time) across multiple internet paths to your credit card issuing bank using 256-bit encryption (128-bit encryption is considered totally secure).
5. Finally, we encrypt only the first and last 4-digits of your credit card for storage (to help us assist you should you have questions about your transaction) in our system using 1024-bit permanently irreversible encryption.

Rest assured, we are not declining your transaction. When you enter your credit card number, and click "Place Your Order", we submit that card number to your card issuing bank - meaning the bank that gives you a credit card. Along with that card number, we submit all of the information you enter. Based upon that information, they either accept or decline our request to charge your card.

There are a number of reasons why your card company may have declined us when we tried to charge your card:

1. Do you have the correct expiration date? Occasionally the expiration date will be different than the date listed on the card.
2. Do you have the billing address correct?

   The billing address is where the credit card statement is mailed every month. If you're using a business card - it's usually business address. If you're an authorized user of someone's card - ask them what the billing address of the credit card is.

3. Did you enter the "Verification Code" of the credit card correctly?

   If the verification code is wrong, you will usually get declined.

4. Do you have a "pre-set" spending limit for the card?

   Usually if there's more than one user on a credit card account, the total purchases of both cards count against the maximum amount you can spend in a day.

5. Does your credit card company know you make internet transactions?

   Often times credit card companies will reject internet transactions because of the potential for fraud - you simply have to notify your credit card company that you wish to make an internet purchase and they'll enable your account.

6. Is the amount of the transaction too much?

   Because we are an internet-based company and your credit/debit card is not "physically" present during the transaction, your credit card company may limit the amount that we can charge your card.

7. If you receive too many declines in a day, your card company may "lock" your card from being used - it's a preventative measure just in case your card is stolen.

What can I do now?

1. The easiest thing to do is to triple-check the information you entered in our form with the list above and see if any match your situation. If so, correct any mistakes and try again.
2. If that doesn't work you can CALL YOUR CREDIT CARD COMPANY and ask them why they declined us when we tried to charge your card. They have the ability to see everything that's going on with the transaction that are attempted using your card and they can tell you exactly why they declined us.

The "Verification Code" or CVV2 is an important new internet security feature that now appears on the back of most Visa and MasterCard credit cards and on the front of American Express cards. This new code is a three or four-digit number which validates that the customer placing the order online actually has the card in their possession, and that the card number given is legitimate.

Visa & MasterCard
	Flip your card over and look at the "signature panel" box. You should see the entire 16-digit credit card number (or just the last four digits) followed by a separate 3-digit code. This 3-digit is your "Verification Code".

American Express
	Look for the 4-digit code printed on the front of your card - just above the right of your main credit card number. This 4-digit code is your "Verification Code".
American Express Optima
	Look for the 4-digit code printed on the front of your card - just above the main credit card number. This 4-digit code is your "Verification Code".

Discover
	The "Verification Code" is the 3 digits that come after your credit card number on the back of your card.

Microsoft Internet Explorer 6

1. Select "Internet Options" from the Tools menu.
2. Click on the "Privacy" tab.
3. Click the "Default" button (or manually slide the bar down to "Medium") under "Settings".
4. Click "OK".

1. Select "Internet Options" from the Tools menu.
2. Click on the "Security" tab.
3. Click the "Custom Level" button.
4. Scroll down to the "Cookies" section.
5. Set "Allow cookies that are stored on your computer" to "Enable".
6. Set "Allow per-session cookies" to "Enable".
7. Click "OK".

1. Select "Internet Options" from the View menu.
2. Click on the "Advanced" tab.
3. Scroll down to find "Cookies" within the "Security" section.
4. Select "Always accept cookies".
5. Click "OK".

Netscape 7

1. Select "Preferences" from the Edit menu.
2. Click on the arrow next to "Privacy & Security" in the scrolling window to expand.
3. Under "Privacy & Security", select "Cookies."
4. Select "Enable all cookies".
5. Click "OK".

1. Select "Preferences" from the Edit menu.
2. Expand the Advanced selection in the left part of the window.
3. Click on the Cookies selection.
4. Check the Enable all cookies setting.
5. Click "OK".

1. Select "Preferences" from the Edit menu.
2. Find the "Cookies" section in the "Advanced" category.
3. Select "Accept all cookies" (or "Enable all cookies").
4. Click "OK".

Mozilla Firefox

1. Go to the "Tools" menu.
2. Select the "Privacy" icon in the left panel.
3. Check the box corresponding to "Allow sites to set cookies".
4. Click "OK" to save changes.

Opera 7

1. Click on the "Tools" menu.
2. Click on "Preferences"
3. Click on "Privacy" near the bottom-left size of the window.
4. The Enable cookies checkbox must be checked, and Accept all cookies should be selected in the "Normal coookies" drop-down.
5. Click "OK".

Absolutely! Cookies are completely safe. We use cookies to make your purchase process more secure.

No Updates: This option allows you to purchase the most recent version of the data available. You pay the price listed one time during checkout and are not charged again.

As the data changes each month, you will not receive updates to the data and the data that you purchased will become outdated.

Quarterly Updates: This option allows you to purchase the most recent version of the data available. You pay the price listed one time during checkout and are not charged again.

You will then be entitled to receive an update to your data every three months for a period of ONE YEAR.

When your subscription expires, you will have the option to renew it. We typically give a renewal discount to existing subscribers.

Monthly Updates: This option allows you to purchase the most recent version of the data available. You pay the price listed one time during checkout and are not charged again.

After purchasing, you will be entitled to receive an update to your data each month for a period of ONE YEAR. This means you will receive 12 versions of the file - one for each month.

When your subscription expires, you will have the option to renew it. We typically give a renewal discount to existing subscribers.

Standard License: For most of our customers the Standard License is adequate. It allows you, the licensee, to make unlimited copies of our products for all machines within your organization. Furthermore, this license covers any contractors or 3rd parties that are working on your behalf so long as the data is not being used for other clients. There are a few simple restrictions for this license. The biggest is that you are not allowed to bundle this data into a redistributable application--one that leaves machines under your control. Basically, the idea is that, as long as it's on your machines, you're okay.

Redistribution License: This expands upon the standard license agreement. The main difference is that you can now bundle our product with your application. In general, the data covered under this license should not be made available to download from your application in its entirety. The idea is that you're using our data and products to enhance your application.

General Restrictions: One of the main themes behind these licenses is that you don't post our data to the web such that it can be easily downloaded. For example, you are restricted from creating "lookup pages" that simply display the raw data for end users. As long as you are displaying only portions of our data in conjunction with your data, then you're okay. But if you make the raw data available for anyone to retrieve, then there's a problem.

Special Note--Developer Tools: Our developer tools such as the Distance Wizard include in their standard licensing the ability to be compiled (so far as the programming language allows for compilation) into a redistributable application that you are building. The idea is that your application depends upon geo-location capabilties. We just don't want you giving away the source code.

More Information: On each product page with redistribution licensing there is a link under the product prices and buy now buttons that states "Click here for volume or redistribution licensing."

For specific questions regarding License Agreements please consult the license agreement of the product in question. Each product page has a "License" tab allowing you to view the entire license agreement for a particular product.

The Combination of NPA and NXX.

Number plan area (Area Code)

Three digit prefix or Exchange code

Full Company Name NPA-NXX is assigned to.

Operating Company Number

10 character abbreviation for the Rate Center in which the code is assigned

The future date when a new code will be in service (for new codes only). Once the effective date is reached, this date will no longer appear

The future date when a new code will be in service (for new codes only). Once the effective date is reached, this date will no longer appear. *VC:VC indicates codes that are vacant; they are available for assignment to a service provider. AS:AS indicates codes that are assigned to a service provider. PR:PR indicates codes that are protected for a split; that is, these codes are assigned in the old or the new NPA and can not be assigned in the other NPA until after the end of permissive dialing. RV:RV indicates codes that have been reserved by a service provider. The identity of the service provider is considered proprietary information and will not be shown. UA:UA indicates codes that are unavailable for assignment. These codes include, but are not limited to, test and special use codes (e.g., 958, 959, 555, time), N11 and other unique codes (e.g., 976, 950), codes set aside for pooling, and codes with special dialing arrangements (e.g., 7-digit dialing cross NPA boundary). Blank indicate that NPA-NXX available

Date the code was assigned to the service provider by NANPA. This field is populated only for those codes assigned from January 2001 on.

Initial is the first geographic NXX code assigned at a unique switching entity or point of interconnection for a service provider. Growth is a code assigned to a switching entity or point of interconnection subsequent to the assignment of the first code, for the same purpose as a code that was previously assigned for a service provider to the same switching entity or point of interconnection.

Local Access Transport Area

Weather NPA-NXX available for use or not. Y:Yes(Available for use) or N:No (Not Available for use)

Operating Company Number