Telecom 2012:
The Telecom Database covers telephone operators and
independents. The NPA NXX database allows mapping of Telco
and Cable operators and includes management, emails,
addresses, phone/fax and service type; CLEC’s, ILEC’s,
CAP’s, RBOC’s , LATA’s and all by State, county,
City, Place Code, Zip Code and Census Block/Tract. The
Telco International database covers 124 countries and
Includes Management and Emails.
|
Structure
for table: Telco2012.dbf
Product Code 112
Number of data records: 1,850
Field
Field Name
Type
Width
|
1
|
Company Name
|
Character
|
45
|
Legal Name of
Telco
|
|
2
|
Address
|
Character
|
35
|
Physical
Address
|
|
3
|
City
|
Character
|
35
|
City
|
|
4
|
State
|
Character
|
15
|
State
|
|
5
|
City/State/Zipcode
|
Character
|
45
|
City/State/Zip
Code for labeling
|
|
6
|
Zipcode
|
Character
|
25
|
Zip Code
|
|
7
|
Fax Number
|
Character
|
34
|
Office Fax
Number
|
|
8
|
Telephone
|
|
34
|
Main
Telephone Number
|
|
9
|
General Manager
|
Character
|
45
|
General
Manager
|
|
10
|
Fname
|
Character
|
35
|
General
Manager First Namte
|
|
11
|
Lname
|
Character
|
35
|
General
Manager Last Name
|
|
12
|
Web Site
|
Character
|
44
|
URL
|
|
13
|
Email
|
Character
|
55
|
GM Email
|
|
14
|
Service
Type
|
Character
|
45
|
RBOC,
ILEC, CLEC, etc...
|
|
15
|
Corporate
Owners
|
Character
|
45
|
Corporate
Owner
|
Structure
for table: InternationalTelco2012.dbf Product Code 118
Number of data records: 1,883
Field Field Name
Type
Width
|
1
|
Company Name
|
Character
|
45
|
Legal Name of
Telco
|
|
2
|
Address
|
Character
|
35
|
Physical
Address
|
|
3
|
City
|
Character
|
35
|
City
|
|
4
|
Country
|
Character
|
35
|
Country of
Business
|
|
5
|
State
|
Character
|
15
|
State
|
|
6
|
City/State/Zipcode
|
Character
|
45
|
City/State/Zip
Code for labeling
|
|
7
|
Zipcode
|
Character
|
25
|
Zip Code
|
|
8
|
Fax Number
|
Character
|
34
|
Office Fax
Number
|
|
9
|
Telephone
|
Character
|
34
|
Main
Telephone Number
|
|
10
|
Manager
|
Character
|
45
|
General
Manager
|
|
11
|
FName
|
Character
|
35
|
Managers
First Name
|
|
12
|
LName
|
Character
|
35
|
Managers Last
Name
|
|
13
|
Web Site
|
Character
|
44
|
URL
|
|
14
|
Email
|
Character
|
55
|
Managers
Email
|
|
15
|
Service
Type
|
Character
|
45
|
RBOC,
ILEC, CLEC, etc...
|
TelcoCable2012
Product
Code 113
Number of data
records: 193,939
Field Field Name
Type
Width
|
1
|
Dupe Zip
|
Character
|
10
|
Duplicate
Zip Code used for sorting
|
|
2
|
AreaCode (NPA)
|
Character
|
10
|
3-Digit
Area Code
|
|
3
|
Prefix
(NXX)
|
Character
|
10
|
The area
designated as the area within which a LEC or CLC may provide
local exchange services.
|
|
4
|
ComZIP
|
Character
|
10
|
5-Digit Zip
Code associated with the State and City
|
|
5
|
PlaceCode
|
Character
|
15
|
State,County,
City FIPS Place
Code
|
|
6
|
Bus_POBox
|
Character
|
10
|
ID’s Zip
as Business Zip Code, not consumer
|
|
7
|
Consumer
|
Character
|
10
|
ID’s Zip
as Consumer, not business
|
|
8
|
City
|
Character
|
25
|
City of
Service
Area.
|
|
9
|
CityAlias
|
Character
|
75
|
Alias Name
for City in Service Area
|
|
10
|
County
|
Character
|
25
|
County
of
City
within Service Area.
|
|
11
|
State
|
Character
|
3
|
State by
5-Digit Zip Code for Service Area
|
|
12
|
MarketName
|
Character
|
45
|
Name of
Designated Market area
|
|
13
|
DTVMARank
|
Character
|
3
|
Rank of
Market Area
|
|
14
|
Region
|
Character
|
15
|
Name of
Geographical Region in the
US
.
|
|
15
|
Division
|
Character
|
15
|
Name of
Division of Regions.
|
|
16
|
Latitude
|
Character
|
15
|
Latitude of
Centroid of Zip Code in Service Area
|
|
17
|
Longitude
|
Character
|
15
|
Longitude of Centroid of Zip Code in Service Area
|
|
18
|
TelcoOper
|
Character
|
45
|
Name of Telephone Company serving the area.
|
|
19
|
CableOper
|
Character
|
55
|
Name of Primary Cable Operator serving the area.
|
|
20
|
UverseCBL
|
Character
|
15
|
AT&T U-Verse Cable Service
|
|
21
|
FiOSCBL
|
Character
|
15
|
Verizon FiOS Cable Service
|
|
22
|
POPbyZip
|
Character
|
15
|
Total Population within the Service Area Zip Code.
|
|
23
|
HHbyZip
|
Character
|
15
|
Total House Holds within the Service Area Zip Code.
|
|
24
|
CableSUBS
|
Character
|
15
|
Total Cable Subscribers within the Service Area Zip
Code
|
|
25
|
OCN
|
Character
|
45
|
Unique Operating Company Number
|
|
26
|
RateCenter
|
Character
|
45
|
A geographically specified area used for determining
mileage and/or usage dependent rates in the Public Switched
Telephone Network. A rate center is not always the exact
equivalent of an Exchange Area, but can be.
|
|
27
|
CLLI
|
Character
|
20
|
Common Language Location Identifier.
|
|
28
|
Type
|
Character
|
10
|
Codes to Identify various service types; CLC
(Competitive Local Carrier), CLEC (Competitive Local
Exchange Carrier), IEC (InterExchange Carrier) see the list
of acronyms for details.
|
|
29
|
SWName
|
Character
|
35
|
Manufacturer/Suppier of Switch Equipment
|
|
30
|
SWType
|
Character
|
35
|
Model/Type of Switch Equipemnet
|
|
3 31
|
LATA
|
Character
|
55
|
3 Digit
Code for each Local Access Transport Area.
|
|
32
|
Broadband
|
Character
|
15
|
Identification as
Broadband System
|
|
Structure for table: LATA2012.DBF
Product Code 114
Number of data records: 126,904
Field Field Name
Type Width
|
1
|
AREACODE (NPA)
|
Character
|
10
|
3-Digit Area
Code
|
|
2
|
PREFIX
(NXX)
|
Character
|
10
|
The area
designated as the area within which a LEC or CLC may provide local
exchange services.
|
|
3
|
COMZIP
|
Character
|
10
|
5-Digit Zip
Code associated with the State and City
|
|
4
|
COUNTY
|
Character
|
25
|
County
of
City
within Service Area.
|
|
5
|
STATE
|
Character
|
3
|
State by
5-Digit Zip Code for Service Area
|
|
6
|
CITY
|
Character
|
25
|
City of
Service
Area.
|
|
7
|
CITYALIAS
|
Character
|
75
|
Alias Name for City in Service Area
|
|
8
|
CLLI
|
Character
|
20
|
Common
Language Location Identifier.
|
|
9
|
TYPE
|
Character
|
10
|
Codes to
Identify various service types; CLC (Competitive Local Carrier),
CLEC (Competitive Local Exchange Carrier), IEC (InterExchange
Carrier) see the list of acronyms for details.
|
|
10
|
LATA
|
Character
|
55
|
3 Digit Code
for each Local Access Transport
|
|
CanadianTelecom2012.dbf
Product Code 118
(as
of 1/1/2011) Canada Telco's are included in Product 118)
International Telco Providers)
|
1
|
Company Name
|
Character
|
45
|
Legal Name of
Telco
|
|
2
|
Address
|
Character
|
35
|
Physical
Address
|
|
3
|
City
|
Character
|
35
|
City
|
|
4
|
State
|
Character
|
15
|
State
|
|
5
|
City/State/Zipcode
|
Character
|
55
|
Mailing
City/State/Zip Code for labeling
|
|
6
|
Zipcode
|
Character
|
25
|
Zip Code
|
|
7
|
Fax Number
|
Character
|
35
|
Office Fax
Number
|
|
8
|
Telephone
|
|
35
|
Main
Telephone Number
|
|
9
|
General Manager
|
Character
|
45
|
General
Manager
|
|
10
|
Web Site
|
Character
|
55
|
URL
|
|
11
|
Email
|
Character
|
75
|
GM Email
|
|
12
|
Service
Type
|
Character
|
35
|
iLEC,
CLEC, , DSL, etc...
|
Telco Tract &
Block Group2012
Product Code 115
Number of data
records: 318370
Field Field Name
Type
Width
|
1
|
State
|
Character
|
4
|
Location
State
|
|
2
|
Comzip
|
Character
|
10
|
Community
Zip Code
|
|
3
|
City
|
Character
|
10
|
City
|
|
4
|
Community
|
Character
|
35
|
Name of Community
|
|
5
|
County
|
Character
|
35
|
Name of County
|
|
6
|
Commalias
|
Character
|
35
|
Alias Name for Community
|
|
7
|
Centract
|
Character
|
35
|
Number for Census Tract
|
|
8
|
Blockgroup
|
Character
|
35
|
Number for Block Group
|
|
9
|
Totalpop
|
Character
|
15
|
Total
Population for Census Tract
|
|
10
|
County
fips
|
Character
|
15
|
FIPS Number for County
|
|
|
Click
Image to enlarge
Click browser back Button to return
Download
Excel Sample Telco2011
Download Excel Sample IntlTelco 2011
Telco operators
Victoria, TX
Time Warner Cable/Telephone
with ICO overlay
Charlotte, NC |
