Telco System Database Structure & Background
Information
Sample
Boundary Map for Torrance CA. Telco and Cable Service Area
SoftMedia’s
Telco System Database
Group is comprised of (5) individual database group;
1.
TeleCom2009 - Database - 5,804 Records Product
Code 201
The Telecom 2009 database is a
detailed database of Telephone Companies and includes complete
contact data with management, telephone, addresses and emails. Each
record provides data on
service type including those providing cable television
service.
2.
Lata2009- Database
- 124,169 Records
Product Code 202
A LATA is a geographical area in which the
local telephone company is allowed to carry local and long distance toll calls. The
LATA boundary is the point where your call is handed off from your local carrier
to your long-distance company. These areas were defined at Divestiture, when
Judge Greene broke up the AT&T monopoly in 1984. The companies LATA database
goes far beyond data provided by others and
includes NPA (Area Code), NXX (Prefix), Zip Code, City, State, and LATA
Number.
SoftMedia's LATA2009 database can be imported into most mapping software
programs so that you can create your own unique LATA Maps.
3.
Telephone2009- Database
- 193,938 Records
Product Code 203
The Telco2009 is the most complete set of data currently available for the
Industry. With over 193,000 records the Telco2009 database list 25 datafields
for all combinations of NPA/NXX/Zip Codes. Each 5 digit zip code covers all NXX
codes for Wireless, PCS and Wireline operators.
4.
TelephoneCable2009- Database -
193,938
Records
Product Code 204
The TelephoneCable database includes all
of the data available in Telephone2009, Plus it includes
the
Systemname of the Cable Operator
and the number of Subscribers, House-Hold by 5 digit zip code.
You can view Telephone Cable data by area code, prefix, house-holds, cable franchise,
digital service,
Internet, Telco service providers or hundreds of combinations.
This new version of has an additional data field called ‘COMMALIAS’.
This datafield is the
community alias name As an example; Most of the Primary zip codes have the same name in large
cities such as Los Angeles or New York. The
community alias is the alias name given to small
communities within the large
city areas. (Example: Los Angeles = Whittier)
SoftMedia’s cablecomzip files can be imported into most
mapping software programs.
(Sample
Map)
Structure
for table: Telecom2009.DBF/Telco2009.dbf
Product Code 201
Number of data records: 5,804
Field
Field
Name
Type
Width
|
1 |
Company Name |
Character |
35 |
Legal Name of Telco |
|
2 |
Address |
Character |
10 |
Physical Address |
|
3 |
City |
Character |
10 |
City |
|
4 |
State |
Character |
25 |
State |
|
5 |
City/State/Zipcode |
Character |
3 |
Mailing City/State/Zip Code for labeling convenience |
|
6 |
Zipcode |
Character |
25 |
Zip Code |
|
7 |
Fax Number |
Character |
75 |
Office Fax Number |
| 8 | Telephone | 15 | Main Telephone Number | |
|
9 |
General Manager |
Character |
45 |
General Manager |
|
10 |
Web Site |
Character |
15 |
URL |
|
11 |
|
Character |
15 |
GM Email |
| 12 | Service Type |
Character |
10 | RBOC, ILEC, CLEC, etc... |
| 13 | Corporate Owners |
Character |
45 | Corporate Owner |
Structure
for table: Telephone2009.DBF
Product Code 203
Number of data records: 193,939
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 |
REGION
|
Character |
15 |
Name of Geographical Region in the US. |
|
8 |
DIVISION
|
Character |
15 |
Name of Division within Regions. |
|
9 |
LATITUDE
|
Character |
15 |
Latitude of Centroid of Zip Code in Service Area |
|
10 |
LONGITUDE |
Character |
15 |
Longitude of Centroid of Zip Code in Service Area |
|
11 |
TELCOOPER |
Character |
45 |
Name of Telephone Company serving the area. |
|
12 |
TOTALPOP |
Character |
|
Total
Population within the Service Area Zip Code. |
|
13 |
TOTALHH |
Character |
15
|
Total
House Holds within the Service Area Zip Code. |
|
14 |
OCN |
Character |
45 |
Unique
Operating Company Number |
|
15
|
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. |
|
16 |
CLLI
|
Character |
20 |
Common Language Location Identifier. |
|
17 |
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. |
|
18 |
SWNAME |
Character |
35 |
Manufacturer/Suppier
of Switch Equipment |
|
19 |
SWTYPE |
Character |
35 |
Model/Type of Switch Equipemnet |
|
20 |
LATA |
Character |
55 |
3 Digit Code
for each Local Access Transport Area. |
Structure
for table: Telephonecable.DBF
Product Code 204
Number of data records: 193,939
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 |
DMANAME
& Rank |
Character |
45 |
Name
of Designated Market area |
|
9 |
REGION
|
Character |
15 |
Name of Geographical Region in the US. |
|
10 |
DIVISION
|
Character |
15 |
Name of Division of Regions. |
|
11 |
LATITUDE
|
Character |
15 |
Latitude of Centroid of Zip Code in Service Area |
|
12 |
LONGITUDE |
Character |
15 |
Longitude of Centroid of Zip Code in Service Area |
|
13 |
TELCOOPER |
Character |
45 |
Name of Telephone Company serving the area. |
|
14 |
CABLEOPER
|
Character |
55 |
Name of Cable Operator serving the area. |
|
15 |
TOTALPOP |
Character |
|
Total
Population within the Service Area Zip Code. |
|
16 |
TOTALHH |
Character |
15
|
Total
House Holds within the Service Area Zip Code. |
|
17 |
CABLESUBS
|
Character |
15 |
Total
Cable Subscribers within the Service Area Zip Code |
|
18 |
OCN |
Character |
45 |
Unique
Operating Company Number |
|
19
|
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. |
|
20 |
CLLI
|
Character |
20 |
Common Language Location Identifier. |
|
21 |
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. |
|
22 |
SWNAME |
Character |
35 |
Manufacturer/Suppier
of Switch Equipment |
|
23 |
SWTYPE |
Character |
35 |
Model/Type of Switch Equipemnet |
|
24 |
LATA |
Character |
55 |
3 Digit Code
for each Local Access Transport Area. |
Structure
for table: LATA2009.DBF
Product Code 202
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 Area. |
5. Complete
Telco/Cable Group 2009- Database
Product Code 205
The
CompleteTelcoCableGroup2009 Includes all of the following databases. This group
enables you to analyze every aspect of the Telephone and Cable industry.
| Lata2009 Telephone2009 Telco2009 CableSys2009 MSO2009 CableComZip2009 Telcotractblkgrp |
Local
Transport Area. Complete Telephone & Cable Service Area Database Complete Telephone Contact Database, Including Management, Email, etc.. Detailed research database of nearly 11,000 Cable System Franchises. Multiple System Operator Database (Corporate Database) Cable Community/Zip Code research and boundary mapping database. Telephone Track, Block, Census Group database |
For details of datafields in the Complete Telco/Cable Group 2009, scroll
down;
TelcoCableGroup2009
(All Databases below are included
in the Telco/Cable Group Product Code 205)
TelephoneCable2009
|
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 |
DMANAME
|
Character |
45 |
Name
of Designated Market area |
|
9 |
REGION
|
Character |
15 |
Name of Geographical Region in the US. |
|
10 |
DIVISION
|
Character |
15 |
Name of Division of Regions. |
|
11 |
LATITUDE
|
Character |
15 |
Latitude of Centroid of Zip Code in Service Area |
|
12 |
LONGITUDE |
Character |
15 |
Longitude of Centroid of Zip Code in Service Area |
|
13 |
TELCOOPER |
Character |
45 |
Name of Telephone Company serving the area. |
|
14 |
CABLEOPER
|
Character |
55 |
Name of Cable Operator serving the area. |
|
15 |
TOTALPOP |
Character |
|
Total
Population within the Service Area Zip Code. |
|
16 |
TOTALHH |
Character |
15
|
Total
House Holds within the Service Area Zip Code. |
|
17 |
CABLESUBS
|
Character |
15 |
Total
Cable Subscribers within the Service Area Zip Code |
|
18 |
OCN |
Character |
45 |
Unique
Operating Company Number |
|
19
|
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. |
|
20 |
CLLI
|
Character |
20 |
Common Language Location Identifier. |
|
21 |
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. |
|
22 |
SWNAME |
Character |
35 |
Manufacturer/Suppier
of Switch Equipment |
|
23 |
SWTYPE |
Character |
35 |
Model/Type of Switch Equipemnet |
|
24 |
LATA |
Character |
55 |
3 Digit Code
for each Local Access Transport Area. |
Telco2009
|
1 |
Company Name |
Character |
35 |
3-Digit Area Code |
|
2 |
Address |
Character |
10 |
The area designated as the area within which a LEC or CLC may provide local exchange services. |
|
3 |
City |
Character |
10 |
5-Digit Zip Code associated with the State and City |
|
4 |
State |
Character |
25 |
County
of City within Service Area. |
|
5 |
City/State/Zipcode |
Character |
3 |
State by 5-Digit Zip Code for Service Area |
|
6 |
Zipcode |
Character |
25 |
City of Service Area. |
|
7 |
Fax Number |
Character |
75 |
Alias
Name for City in Service Area |
| 8 | Telephone | 15 | Main Telephone Number | |
|
9 |
General Manager |
Character |
45 |
Name
of Designated Market area |
|
10 |
Web Site |
Character |
15 |
Name of Geographical Region in the US. |
|
11 |
|
Character |
15 |
Name of Division within Regions. |
| 12 | Service Type |
Character |
10 | RBOC, ILEC, CLEC, etc... |
| 13 | Corporate Owners |
Character |
45 | Corporate Owner |
CableSys2009/Cable2009
|
1 |
COMSTATE
|
Character |
10 |
State
System located in |
|
2 |
COMMUNITY
|
Character |
35 |
Community
System located in |
|
3 |
COMZIP
|
Character |
10 |
Zip
Code covered by System |
|
4 |
COUNTY
|
Character |
45 |
County
of Office |
|
5 |
SYSTEMNAME
|
Character |
50
|
System
Assumed Name |
|
6 |
ADDRESS
|
Character |
35 |
Mailing
Address |
|
7 |
MAILCITY
|
Character |
35 |
Mailing
City (Office) |
|
8 |
STATE
|
Character |
15 |
Mailing
State |
|
9 |
ZIPCODE
|
Character |
5 |
Mailing
Zip Code |
|
10 |
GM
|
Character |
75 |
General
Manager Name |
|
11 |
GMEMAIL
|
Character |
75 |
General
Manager Email Address |
|
12 |
AREAMGR
|
Character |
75 |
Area/Region
Manager |
|
13 |
AMPHONE
|
Character |
15 |
Telephone
of Area/Region Manager |
|
14 |
AMEMAIL
|
Character |
75 |
Area/Region
Manager Email Address |
|
15 |
ENGMGR
|
Character |
45 |
Engineering
Manager Name |
|
16 |
ENGEMAIL
|
Character |
75 |
Engineering
Manager Email Address |
|
17 |
TELEPHONE
|
Character |
15 |
Office
Telephone |
|
18 |
FAX
|
Character |
15 |
Office
Fax |
|
19 |
SYSTEMSUBS
|
Numeric |
8 |
Total
Subscribers for system |
|
20 |
SYSMILES |
Numeric |
8 |
Total
Miles of cable plant for system |
|
22 |
SYSHH
|
Numeric |
8 |
Total
Households in franchise |
|
22 |
HHPASSED
|
Numeric |
8 |
Total
Households passed in the Franchise |
|
23 |
WEBSITE
|
Character |
45 |
Web
Site URL |
|
24 |
SERVICE
|
Character |
55 |
Type
of Service |
|
25 |
MODEM
|
Character |
55 |
Modem
Manufacturer |
|
26 |
DIGITAL
|
Character |
10 |
Digital
or Analog Service |
MSO2009
|
1 |
OWNERMSO
|
Character |
50
|
Corporate
Owner |
|
2 |
ADDRESS
|
Character |
30
|
Address |
|
3 |
MAILADDRES
|
Character |
13 |
Address
#2(PO Box) |
|
4 |
CITY
|
Character |
25 |
Mail
City |
|
5 |
STATE
|
Character |
2 |
Mail
State |
|
6 |
ZIPCODE
|
Character |
10 |
Zip
Code |
|
7 |
TELEPHONE
|
Character |
12 |
Telephone
|
|
8 |
FAX
|
Character |
12 |
Fax
|
|
9 |
BASICSUBS
|
Numeric |
9 |
Total
Basicsubs for Operator |
|
10 |
SYSOWNED
|
Numeric |
6 |
Total
Number of Systems Owned |
|
11 |
ENGMANAGER |
Character |
20 |
Engineering
Manager |
|
12 |
CHIEFEXOFF
|
Character |
20
|
CEO |
|
13 |
CHIEFOPOFF
|
Character |
20 |
Executive
VP |
|
14 |
CHIEFFIOFF
|
Character |
20 |
Financial
Officer |
|
15 |
PROGRAMMER |
Character |
20
|
Programming
Manager |
|
16 |
ADMANAGER
|
Character |
20
|
Advertising
Manager |
|
17 |
MCSZ
|
Character |
30
|
Mail, City,
State, Zip code (For mailing labels) |
|
18 |
WEBSITE
|
Character |
50
|
|
CableComZip2009
|
1 |
SYSTEMID
|
Character |
9 |
System
Identification number |
|
2 |
COMZIP
|
Character |
10 |
Community/Zip
Code |
|
3 |
COMMUNITY
|
Character |
40
|
Community
Name |
|
4 |
COMSTATE
|
Character |
2 |
Community/State
|
|
5 |
SYSTEMNAME
|
Character |
50
|
System
Assumed Name |
|
6 |
ADDRESS
|
Character |
30
|
System
Mailing Address |
|
7 |
CITY
|
Character |
24 |
System
Mailing City |
|
8 |
STATE
|
Character |
9 |
System
Mailing State |
|
9 |
ZIPCODE
|
Character |
9 |
System
Mailing Zip Code |
|
10 |
COMMALIAS
|
Character |
35 |
Alias
name for community (Example: Los Angeles = Whittier) |
|
11 |
COUNTY
|
Character |
34 |
County
community located in |
|
12 |
TELEPHONE
|
Character |
15 |
Local
Telephone |
|
13 |
GM
|
Character |
35 |
General
Manager |
|
14 |
GMEMAIL
|
Character |
65 |
General
Manager Email |
|
15 |
DIGANALOG
|
Character |
15 |
Digital
or Analog Service |
|
16 |
LATITUDE
|
Character |
25 |
Community
Latitude Centroid |
|
17 |
LONGITUDE
|
Character |
25 |
Community
Longitude Centroid |
|
18 |
BASICSUBS
|
Character |
20 |
Total
Subs within community |
|
19 |
SYSSUBS
|
Character |
20
|
Total
Subscribers for Franchise |
|
20 |
PLANTMILES |
Character |
20 |
Total
Cable Plant Miles for Community/Zip Code |
|
21 |
TOTALPOP
|
Character |
20
|
Total
Population for Community/Zip Code |
|
22 |
TOTALHH
|
Character |
20 |
Total
Households for Community/Zip Code |
|
23 |
WHITEPOP
|
Character |
20
|
Total
White Population in Community/Zip Code |
|
24 |
BLACKPOP
|
Character |
20
|
Total
Black Population in Community/Zip Code |
|
25 |
HISPPOP
|
Character |
20 |
Total
Hispanic Population in Community/Zip Code |
|
26 |
HHINCOME
|
Character |
20 |
Household
Income in Community/Zip Code |
|
27 |
HHVALUE
|
Character |
20 |
Average HH
Value |
|
28 |
TOTALSYS
|
Character |
20
|
Total
subscriber for the Franchise (Nation Wide) |
|
29 |
DIGITAL |
Character |
10 |
Digital
or Analog Service |
|
30 |
MODEM |
Character |
11 |
Manufacturer
of Internet/Modems |
|
31 |
Service |
Character |
11 |
Name/Type of
Internet Service |