The Telco/Cable System Database Group is comprised
      of (7) individual databases

The TelcoCable database includes all of the data available in Telephone2008 and all of the data from SoftMedia's Cable Group. Using our System Identification Number you can index/sort the database and create maps of Telco and Cable boundaries. You can view Telco/Cable data by area code, prefix, house-holds, cable franchise, digital service, Internet, Telco service providers or hundreds of combinations. This new version has a number of new data fields:
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) (Sample Map)
CONSUMERS, you can now limit your queries for only those zip codes serving residential areas.
ACCESS LINES, number of Wired Access Lines by zip/operator/NPA-NXX or any other combination
of data fields.
BUS_POBOX, you can construct your query to eliminate AP0’s PO Boxes and zip codes assigned to specific 
companies or buildings.
DUPLICATEZIP, query and sum data while ignoring duplicate zip codes.
ALTSYSTEM, Cable Operator serving a specific zip code.
BROADBAND, identifies each cable operator by zip code and community that provides broadband digital service
and those operators that only provide analog service.

Complete Telco/Cable Group 2008- Database             Product Code 205
The CompleteTelcoCableGroup2008 Includes all of the databases in the Cable Group and the Telephone Group. Please refer to each database  to see the detailed data fields list.

TelephoneCable 2008

Complete Telephone & Cable Service Area Database

Teleco2008

Telephone Contact Database, Including Management, and Emails

Lata2008

Local Transport Area.

TelcoTractBlock

Complete database for Telco Tract/Block’s

CableSys2008/Cable 2008

Detailed research database of nearly 11,000 Cable System Franchises. 

CableComZip2008

Cable Community/Zip Code research and boundary-mapping database. 

MSO2008

Multiple System Operator Database (Corporate Database)

     The TelephoneCable database includes data fields for the Cable Operator and Cable Subscribers for 
     each geographic area.

Because of the large size of TelephoneCable databases, SoftMedia has created a set offiles by Region. The US is divided into four regions. The two digit number next to each state is the State FIPS Code. The file names use  _MIDWEST.XXX format.

The Telephone Section of the Telephone/Cable System Database Group is comprised
of (4) individual databases

1.    Telco2008 - Database - 5,804 Records      Product Code 201
The Telecom 2008 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.    Lata2008- 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 LATA2008 database can be imported into most mapping software
programs so that you can create your own unique LATA Maps. 

3.    Telephone/Cable2008- Database - 193,938 Records         Product Code 203
The Telephone/Cable2008 is the most complete set of data currently available for the Industry.
With over 193,000 records the Telco2008 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, Cable Operators, House-Holds, Population, and 
Cable Subscribers. 

4.    Telephone & Block Group Database – Records 318,370      Product Code 206.
       If you are looking for data regarding income, occupation or education etc.., then the
       smallest geographic unit for which you'll be able to get that data is the block group.
       The Tract/Block group database is quite large and is best used by applying the data in
       an overlay to your base map.  

Structure for table: Telephonecable.DBF                            Product Code 204
Number of data records: 316733
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 BUS_POBOX Character   5 "X" Designates business zipcode
5 CONSUMER Character   5 "X" Disignates consumer zipcdoe 

6

CITY

Character

25

City of Service Area.

7

CITYALIAS

Character

75

Alias Name for City in Service Area

8

COUNTY

Character

25

County of City within Service Area.

9

STATE

Character

3

State by 5-Digit Zip Code for Service Area

10

MARKETNAME

Character

45

Name of Designated Market area

11 MARKETRANK Character   5 Rank of Market (New York = 1)

12

REGION

Character

15

Name of Geographical Region in the US.

13

DIVISION

Character

15

Name of Division of Regions.

14

LATITUDE

Character

15

Latitude of Centroid of Zip Code in Service Area

15

LONGITUDE

Character

15

Longitude of Centroid of Zip Code in Service Area

16

TELCOOPER 

Character

45

Name of Telephone Company serving the area.

17

CABLEOPER

Character

55

Name of Cable Operator serving the area.

18

TOTALPOP

Character

15

Total Population within the Service Area Zip Code.

19

TOTALHH

Character

15

Total House Holds within the Service Area Zip Code.

20

CABLESUBS  

Character

15

Total Cable Subscribers within the Service Area Zip Code

21

OCN

Character

45

Unique Operating Company Number

22

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.

23

CLLI

Character

20

Common Language Location Identifier.

24

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.  

25

SWNAME

Character

35

Manufacturer/Suppier of Switch Equipment

26

SWTYPE

Character

35

Model/Type of Switch Equipemnet

27

LATA

Character

55

3 Digit Code for each Local Access Transport Area.

        Structure for table: LATA2008.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