Microsoft access database mdb, comma separated values csv, and tab. North american area codes npa nxx database one month subscription service. Enter a specific npanxxx and this query returns tns within a pooled block that have been ported. Csv is the acronym for the commaseparated values file which allows saving the data in the table structured format. The data is available in both a friendly html format on the left and in csv. Area codes for north america with city, state, latitude and longitude in easy to read csv format. This data pairs up npa area codes with one or more cities, as well as a latitude longitude pair.
Microsoft access database mdb, comma separated values csv, and tab delimited tab. North american local exchange npa nxx database wire. Our sources for nonus npanxx data do not provide this information. Included in this database is npa area code, nxx exchange, country, state, county, population, fips code and zip code.
North american area code database premium edition download. The npa, combined with the central office code or nxx, is the destination code being reported. If you were a paid member, you could be loading this into any version of excel or access or any other software that understands csv right now for less than you paid for your breakfast or lunch today. It displays their location continent, iso 31661 alpha 23 codes and iso number as well as iddd code and flag, ndd code, country dialing code, fips pub 104 and tld top level domain code and the current time in the country, distinguishing sign, ioc code, iso currency code and language. Npa nxx search software free download npa nxx search. It includes highly accurate time zones and daylight saving time information in an area code database. Text fixed, comma csv, tab delimited and xml download sample download sample download sample. Download database database of 1,668,040 npa nxx codes. Canadian npanxx data is hosted by canadian number administrator including a csv file for canada. This takes a fair bit of work, and since this isnt my fulltime job, there is not really an incentive for me to provide extracts, at least not for free.
North american area codes database one month subscription service. Nalennd, the north american local exchange npa nxx database gold edition, record layouts, field. I appreciate your great customer service and your fine product. The area served by the nanp is divided into smaller numbering plan areas npas, each identified by a threedigit npa code, commonly called an area code. North american area codes database one month subscription service with thousand blocks information. Canadian npa nxx data is hosted by canadian number administrator including a csv file for canada. North american area codes npanxx database one month subscription service. Your new dial patterns will be added to your list in the dial patterns tab. Complete telecommunications database targeted specifically toward disseminating all valid npanxx combinations in the north american numbering plan. Reduces the stress of launching applications or checking websites in prescheduled manner.
Microsoft access, excel, sql server compact, text fixed, comma csv, tab delimited, xml wire center npa nxx database sample one record per clli layout left side. Nanpa also provides for download an area code database in a csv file that can be found under area code relief planning reports. Npa nxx databasenpanxx databaseoperating company number. Complete coverage of all active telephone area codes, exchanges, and central office prefixes within the united states, canada, and many caribbean countries. Enter into mysql mysql userroot passwordpassword connect free. Complete telecommunications database targeted specifically toward disseminating all valid npanxx together with block in the north american numbering plan. The database includes npa area code, nxx exchange, country, state, county, latitude, longitude, lata, timezone, day light saving, population. Npa nxx north american telephone database, area code,u. Search for area code listings provides information about an area code, to include whether it is assigned, the location and inservice date, time zone and basic dialing plan. Outbound routes module user guide pbx gui documentation. North american area code database premium edition north american area codes database one month subscription service.
Access the co code nxx status data for a specific npa by clicking on the links. This npa nxx database version adds unique, clean, manually verified rate center names and operating company number to our standard area code database. This intuitive element is incredibly helpful for reporting such as a call accounting software report or for it. The database includes npa area code, nxx exchange, country, state. Area code, exchange, posix timezone beta, requires advanced subscription npanxxcompanycountyzip. Npa nxx area code database list directory with exchanges. When this file is executed under windows, it upgrades protector plus antivirus software virus database. The format of the report is a commaseparated values csv file. Complete telecommunications database targeted specifically toward disseminating all valid npa nxx together with block in the north american numbering plan. Local calling information is from tariffs that i have translated. Csv s generally look like a gardenvariety spreadsheet data but they have an extension.
Effective date searches are available only for us area codes. Npanxx information comes from nanpa and cna plus various other regulatory entities. Centurylink local service providers by npanxx the following pages list centurylinks local npanxxs in ascending order. If you are a member please login to access this and other functionality. It covers all active north american npanxx assignments including the united states and canada. For quick information about a specific area code, use the area code search. Samples csv download free lifetime updates database. How to import csv files in mongodb database habilelabs. Complete telecommunications database targeted specifically toward disseminating all valid npa nxx combinations in the north american numbering plan. Do not select the download local patterns button it should be light blue in color then, select one or more pattern options.
Us area codes npa nxx database, time zones, rate centers, and carrier. Our npa nxx area code database has over 428,000 data records. Our database is updated 4 times a year to include the most current area code data. Telecom datatelco dataarea code dataarea code database. Compiled directly from united states and canadian ilec local exchange.
You can use this data to identify all active npa nxx combinations, what areas they serve, what lata are they in. Expump prices computation template effective 1st may, 2020 hsse manual for energy sector organizations. A download of all exchanges, ordered by lata, npa, nxx, state, city, and zip. Use your pdf viewer search functionality to locate your npanxx search without the hyphen. Our area code database is a telco data product which provides a list of all active area codes and prefixes npanxx. Our sources for nonus npa nxx data do not provide this information.
Enter the tn followed by a space or comma and then the ending four digits. And you will see that your document data will be imported. While we do not yet have a description of the npa file format and what it is normally used for, we do know which programs are known to open these files. Npa database csv file containing information about area codes. The numbering plan area code is the first three digits of a 10 digit nanp telephone number. You can also find the area code for a city or town with population greater than 20,000. The north american numbering plan nanp is a telephone numbering plan that encompasses twentyfive distinct regions in twenty countries primarily in north america, including the caribbean. You can use this data to identify all active npa nxx combinations, what areas they serve, what lata are they in, who is the carrier and more. The software includes postal code, city name, colony name, area abbreviation, latitude and longitude, time zone and area code in almeria. Country codes is a small database of country codes and additional information for more than 250 countries. North american numbering plan npa nxx databases and area code prefix lists. If you want to search an entire area code regardless of activity, leave both the next and past days fields set to zero.
We do not offer an extended download protection type plan. Click browse and find the file or if you prefer, type the path and file name directly in the box. Gold edition nalennd npa nxx area code exchange database. Area code, exchange, posix timezone beta, requires advanced subscription npa nxx companycountyzip. North american local exchange npa nxx database rate. Enter a phone number as dialed from the usa to see where it is located. We give you the choice of 3 separate formats to download your area code data. Port ps search and search results help numbering portal. Telecom npa nxx databases and neca meet point billing percent databases. Npanxx npa is a telecom data code which stands for numbering plan area. The data portion of the file will contain all npa nxxcarrier combinations, expanding other as appropriate based on the nonother branches, plus all npanxxannouncement pairs.
Clicking on a link will cause a compressed zipped file to be downloaded to your computer. The price includes an initial download and any updates made available. When you purchase our products and services we provide you an order number and password which you can use to log in to our web site through our customer login web page. You can use this data to identify all active npa nxx combinations, what areas they serve, where the service comes from, and who provides it. North american local exchange npa nxx database rate center edition rate center is the telecom industry term used to identify a telephone local exchange service area. Every day thousands of users submit information to us about which programs they use to open specific types of files. North american local exchange npa nxx database wire center. Expump prices computation template effective 1st may, 2020. Albany, valdosta, thomasville, bainbridge, tifton, americus.
Our npa nxx area code database is precise and comprehensive. North american local exchange npa nxx database rate center. Scanner frequencies and radio frequency reference database. See the list of programs recommended by our users below. If the wizard window does not automatically disappear, click close to. Thousands block report enter a specific npa nxx x and this query returns tns within a pooled block that have been ported.
1341 1277 600 1092 1147 1029 79 774 262 1121 141 17 701 1078 492 1457 1098 1330 829 272 118 903 1010 292 743 986 1019 1428 273 108 1155 863 288 381 942 712 1381