Warning: site is in maintainance mode, data may not be accurate and some queries may not work!
If you have sufficient subscription access, these files will be available for download.If you do not see the "Download Name" text as a clickable URL, you either do not have a sufficient subscription level, your account has expired, or you are not logged in.
If you do not have an account, and want access to these files, you can Sign up here
If you do have an account, and it has expired, you can Renew it here after Logging in to the site.
If you have any problems, or questions, please don't hesitate to send me an email.
If you need help importing these files into Microsoft Access, check here for some documentation we have on the topic.
| Download Name | Access Level | Description |
|---|---|---|
| city-county-zip | TelcoData - Advanced Membership | Area code, exchange, State, City, County, Zip (Requires Advanced subscription) |
| city-county-zip-byratecenter | TelcoData - Advanced Membership | Area code, exchange, State, City, County, Zip - By Ratecenter (Requires Advanced Subscription) |
| clli-lat-lon | TelcoData - Advanced Membership | Tab separated file containing CLLI codes, Latitude, and Longitude. (Before you ask, no, I will not provide street addresses in downloadable format) |
| clli-npa-nxx | TelcoData - Standard Membership | This is all telephone exchanges in the US and surrounding areas, format is CLLI|NPA|NXX. Generated during major site updates automatically. |
| cnutlzd.txt | TelcoData - Standard Membership | Drop in replacement for pre-October 2007 NANPA download with the same name (In Oct 2007, NANPA redacted CLLI codes from their downloads. This is the same exact file format, but contains them) - IA, IL, IN, KY, MI, MN, OH, WI |
| csutlzd.txt | TelcoData - Standard Membership | Drop in replacement for pre-October 2007 NANPA download with the same name (In Oct 2007, NANPA redacted CLLI codes from their downloads. This is the same exact file format, but contains them) - AL, AR, LA, MO, MS, TN, TX |
| eautlzd.txt | TelcoData - Standard Membership | Drop in replacement for pre-October 2007 NANPA download with the same name (In Oct 2007, NANPA redacted CLLI codes from their downloads. This is the same exact file format, but contains them) - PR, VI |
| enutlzd.txt | TelcoData - Standard Membership | Drop in replacement for pre-October 2007 NANPA download with the same name (In Oct 2007, NANPA redacted CLLI codes from their downloads. This is the same exact file format, but contains them) - CT, MA, ME, NH, NJ, NY, PA, RI, VT |
| esutlzd.txt | TelcoData - Standard Membership | Drop in replacement for pre-October 2007 NANPA download with the same name (In Oct 2007, NANPA redacted CLLI codes from their downloads. This is the same exact file format, but contains them) - DC, DE, FL, GA, MD, NC, SC, VA, WV |
| first6-city.csv | TelcoData - Standard Membership | A download of the first 6 characters of all the CLLI codes, followed by city and state. Format: CLLI,City,State. Updated every major site update. |
| lata | TelcoData - Standard Membership | List of all LATA numbers and their respective LATAs. Format is LATANUM|LATA Description |
| lata-npa-nxx-state-city-zip.csv | TelcoData - Standard Membership | A download of all exchanges, ordered by LATA, NPA, NXX, State, City, and Zip |
| npa-exchange-state-ratecenter | TelcoData - Advanced Membership | NPA,Exchange,State,Ratecenter,OCN,Company,City,County,Zip,Lat,Lon by Ratecenter |
| npa-exchange-tz | TelcoData - Advanced Membership | Area Code, Exchange, POSIX Timezone (Beta, requires Advanced subscription) |
| npa-nxx-company-county-zip | TelcoData - Advanced Membership | Area code, exchange, Company, State, City, County, Zip, Ratecenter - By Wirecenter (CSV) (Requires Advanced Subscription) |
| npa-nxx-companytype-ocn.csv | TelcoData - Standard Membership | NPA,NXX,COMPANY TYPE,OCN,COMPANY NAME,LATA,RATECENTER,STATE |
| npa-nxx-state-company-etc-nothousan | TelcoData - Standard Membership | All NPA-NXX along with the following fields: State, Company, OCN, Ratecenter, CLLI, Assign Date, prefix type, Switch name, switch type and lata (Warning: 18MB+, automatically updated whenever a major site update occurs) This file will be truncated if loaded into Excel. Please use MS Access or something like it. |
| npa-nxx-state-company-etc-thousands | TelcoData - Standard Membership | All NPA-NXX and thousands blocks along with the following fields: State, Company, OCN, Ratecenter, CLLI, Assign Date, prefix type, Switch name, switch type and lata (Warning: 20MB+, automatically updated whenever a major site update occurs) This file will be truncated if loaded into Excel. Please use MS Access or something like it. |
| npa-nxx-state-nothousands-ilec | TelcoData - Advanced Membership | All NPA-NXX along with the following fields: State, Company, OCN, Ratecenter, CLLI, Assign Date, prefix type, Switch name, switch type, lata, ILEC Name and ILEC OCN (Warning: 18MB+, automatically updated whenever a major site update occurs) This file will be truncated if loaded into Excel. Please use MS Access or something like it. |
| npa-nxx-state-thousands-ilec | TelcoData - Advanced Membership | All NPA-NXX and thousands blocks along with the following fields: State, Company, OCN, Ratecenter, CLLI, Assign Date, prefix type, Switch name, switch type, lata, ILEC Name and ILEC OCN (Warning: 20MB+, automatically updated whenever a major site update occurs) This file will be truncated if loaded into Excel. Please use MS Access or something like it. |
| npastate | TelcoData - Standard Membership | States to areacode mapping (ex. MI,248) |
| ocn-npanxx | TelcoData - Standard Membership | This is a csv, it goes OCN,NPANXXThousands(newline). Good for billing where your charges are different depending on the OCN of the terminating company. |
| ocnlist.csv | TelcoData - Advanced Membership | OCN, Company Name, Parent Company (if known) |
| sms-email | TelcoData - Advanced Membership | Area code, exchange, Thousands digit, company, type,email domain (Requires Advanced subscription) |
| sms-email-ocn | TelcoData - Advanced Membership | Area code, exchange, Thousands digit, company, type,email domain, OCN (Advanced Subscription) |
| type-to-manuf | TelcoData - Standard Membership | Type to manufacturer CSV. Take the commonly used three letter abbreviation for a switch type, and find its manufacturer and model name. Format is ABBREV,Manufacturer,Model. Collected from various sources, not 100% complete, but contains 99% of all the common ones. |
| wnutlzd.txt | TelcoData - Standard Membership | Drop in replacement for pre-October 2007 NANPA download with the same name (In Oct 2007, NANPA redacted CLLI codes from their downloads. This is the same exact file format, but contains them) - CO, ID, KS, MT, ND, NE, NV, OR, SD, UT, WA, WY |
| wputlzd.txt | TelcoData - Standard Membership | Drop in replacement for pre-October 2007 NANPA download with the same name (In Oct 2007, NANPA redacted CLLI codes from their downloads. This is the same exact file format, but contains them) - AK, AS, GU, HI, NN |
| wsutlzd.txt | TelcoData - Standard Membership | Drop in replacement for pre-October 2007 NANPA download with the same name (In Oct 2007, NANPA redacted CLLI codes from their downloads. This is the same exact file format, but contains them) - AZ, CA, NM, OK |