The Area Code Database NPA NXX, Commercial Edition is a telco data product + zip codes which provides a list of all active area codes and prefixes - NPA/NXX. It includes accurate TimeZones and Daylight Saving Time information.
Users would include call centers, webmasters, fraud detection specialists looking to validate area code to zip code. Also great for data validation, rate center lookups, line type lookups
Our Area Code Database Commercial Edition is put into row and column format for easy use and manipulation. The area Code files are available in the following formats: 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 and spreadsheets.Available for Immediate Download
When you order online from ZIP Code Download there is no need to wait for the mail. You'll receive The Area Code Database NPA NXX, Commercial Edition immediately. Our products are available for download only, which allows usto keep our prices low and pass the savings on to you. The data will be available in your account for 30 days after your purchase (unless you purchase an annual subscription). They can be downloaded on any computer with internet access.Product Features & Benefits
Uncompressed Disk Space
Microsoft Access Version - 175 MB
Comma-separated Version - 170 MB
Tab-delimited Version - 120 MB
WinZip or another similar PKzip archive extraction utility.
Microsoft Excel, Access, notepad, or another similar text-editing utility
|ZIPCode||char(10)||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.|
|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.|
|DST||bit||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.|
|State||varchar(50)||A state code or abbreviation is a two character designation for that state - for example, California is CA and Texas is TX, etc.|
|NPA-NXX||varchar(50)||The Combination of NPA and NXX.|
|NPA||varchar(50)||Number plan area (Area Code)|
|NXX||varchar(50)||Three digit prefix or Exchange code|
|OCN||varchar(50)||Operating Company Number|
|Company||varchar(100)||Full Company Name NPA-NXX is assigned to.|
|RateCenter||varchar(100)||10 character abbreviation for the Rate Center in which the code is assigned|
|EffectiveDate||varchar(50)||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.|
|Use||varchar(50)||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...Click link for more details|
|AssignDate||varchar(50)||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_Growth||varchar(60)||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.|
|Pooled_Code_File||varchar(60)||A state code or abbreviation is a two character designation for that state - for example, California is CA and Texas is TX, etc.|
|NPA_NXX_Availability||varchar(20)||Weather NPA-NXX available for use or not. Y:Yes(Available for use) or N:No (Not Available for use)|
|LATA||varchar(60)||Local Access Transport Area|
This End User License Agreement (the "EULA") is a contract between you (the "Customer") and ZIP Code Download (the "Company"). This EULA applies to all data, code, and applications (the "Products") sold by the Company ��� which shall include any upgrades, modified versions or updates of the Products licensed to you by the Company. By purchasing and/or retrieving the Products sold by the Company, the Customer accepts all the terms and conditions of the EULA. Upon your acceptance of this Agreement, the Company grants to you a nonexclusive license to use the Products, provided that you agree to the following:Use of the Products
You may install the Products on a hard disk or other storage device; install and use the Products on a file server for use on a network for the purposes of (i) permanent installation onto hard disks or other storage devices or (ii) use of the Products over such network; and make backup copies of the Products.
You may make unlimited copies of the Products, as long as each copy that you make, 1.) is for internal company use, 2.) contains this Agreement and, 3.) contains the same copyright and other proprietary notices pertaining to this Products that appear in the Products.
You may not make the Products publicly available in easily downloadable format (i.e. PKZip files or static/dynamic web pages) on public network such as bulletin boards, online services, or the internet.
However, the Products may be used on public networks (i.e. the internet) if used within a "Lookup Application" such as a "Store Locator" or "Nearest Member Search" so long as the underlying data is not exposed to the internet.Copyright and Trademark Rights
The Products are owned by the Company, and its structure, organization and code are the valuable trade secrets of the Company. The Products also is protected by United States Copyright Law and International Treaty provisions. You may use trademarks only insofar as required to comply with Section 1 of this Agreement and to identify printed output produced by the Products, in accordance with accepted trademark practice, including identification of trademark owner's name. Such use of any trademark does not give you any rights of ownership in that trademark. Except as stated above, this Agreement does not grant you any intellectual property rights in the Products.Restrictions
You are free to modify and/or adapt any Products provided in non-compiled form for your own use, reproduction as well as unlimited use within your organization. The Products are licensed and distributed by the Company. Redistribution and reseller agreements can be obtained by contacting the Company.
The Products are being delivered to you AS IS and the Company makes no warranty as to its use or performance. The Company DOES NOT AND CANNOT WARRANT THE PERFORMANCE OR RESULTS YOU MAY OBTAIN BY USING THE DATA OR DOCUMENTATION. The Company MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AS TO NONINFRINGEMENT OF THIRD PARTY RIGHTS, MERCHANTABILITY, OR FITNESS FOR ANY PARTICULAR PURPOSE. IN NO EVENT WILL The Company BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, INCIDENTAL OR SPECIAL DAMAGES, INCLUDING ANY LOST PROFITS OR LOST SAVINGS, EVEN IF A REPRESENTATIVE OF THE COMPANY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, OR FOR ANY CLAIM BY ANY THIRD PARTY. Some states or jurisdictions do not allow the exclusion or limitation of incidental, consequential or special damages, or the exclusion of implied warranties or limitations on how long an implied warranty may last, so the above limitations may not apply to you.
Governing Law and General Provisions
This Agreement will be governed by the laws of the State of Utah, U.S.A., excluding the application of its conflicts of law rules. This Agreement will not be governed by the United Nations Convention on Contracts for the International Sale of Goods, the application of which is expressly excluded. If any part of this Agreement is found void and unenforceable, it will not affect the validity of the balance of the Agreement, which shall remain valid and enforceable according to its terms. You agree that the Software will not be shipped, transferred or exported into any country or used in any manner prohibited by the United States Export Administration Act or any other export laws, restrictions or regulations. This Agreement shall automatically terminate upon failure by you to comply with its terms. This Agreement may only be modified in writing signed by an authorized officer of the Company.This Agreement is binding except in the case where a signed, certified letter is issued by the Company amending the Agreement.Notice to Government End Users
The Software and Documentation are "Commercial Items," as that term is defined at 48 C.F.R. v�2.101, consisting of "Commercial Computer Software" and "Commercial Computer Software Documentation," as such terms are used in 48 C.F.R. v�12.212 or 48 C.F.R. v�227.7202, as applicable. Consistent with 48 C.F.R. v�12.212 or 48 C.F.R. v�v�227.7202-1 through 227.7202-4, as applicable, the Commercial Computer Software and Commercial Computer Software Documentation are being licensed to U.S. Government end users (A) only as Commercial Items and (B) with only those rights as are granted to all other end users pursuant to the terms and conditions herein.Other
Unpublished-rights reserved under the copyright laws of the United States.
ZIPCODE DATA SINCE 2002