Cable/Telephone Database Group

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

The TelcoCable database includes all of the data available in Telephone2009 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 2009- Database Product Code 205
The CompleteTelcoCableGroup2009 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 2009	Complete Telephone & Cable Service Area Database
Teleco2009	Telephone Contact Database, Including Management, and Emails
Lata2009	Local Transport Area.
TelcoTractBlock	Complete database for Telco Tract/Block’s
CableSys2009/Cable 2009	Detailed research database of nearly 11,000 Cable System Franchises.
CableComZip2009	Cable Community/Zip Code research and boundary-mapping database.
MSO2009	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. Telco2009 - 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. Telephone/Cable2009- Database - 193,938 Records Product Code 203
The Telephone/Cable2009 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, 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: 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

        Structure for table: 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
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	Email	Character	15	GM Email
12	Service Type	Character	10	RBOC, ILEC, CLEC, etc...
13	Corporate Owners	Character	45	Corporate Owner

        Structure for table: Telco Tract & Block Group                  Product Code 206
        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

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

1. Cablesys2009- Database Included in Product Code 100
The cable system database covers 11,000 franchises in the U.S. With the consolidation
of operations, a specific office and management group manages more than one
franchise, therefore there are duplicate addresses, management etc., in this database.

2. Cable2009- Database Included in Product Code 100
For the convenience of our customers, SoftMedia provides a second database identical
to the cablesys2009 file with the duplicates removed. This database contains over 2700
listings and should be used for Mailing, Emailing, Faxing etc…

3. MSO2009- Database Included in Product Code 100
The 3rd database in our cable group, mso2009, file is the MSO Database.(Multiple
System Operators) corporate owners database. This database covers the 307 corporate
owners.

4. CABLECOMZIP Database Product Code 101
The 4^th database cablecomzip, is a database of over 42,500 communities and five digit
zip codes. When the FCC authorizes a new Franchise they are issued a “SYSTEM
IDENTIFICATION NUMBER”, systemid. Each community and zip code within that
franchise has the same systemid number, therefore, by indexing/sorting by the systemid
number you can view all of the communities and zip codes within a franchise. The
systemid number is also present in the cable2009 database. By using a “Relational”
database software program, you can connect the databases allowing you to view the
cable2009 data and the comzip2009 data at the same time. The comzip database is ideal
for loading into a mapping program. If your mapping software contains 5 digit zip code
boundaries you can create coverage map’s of each franchise area and overlay
demographics or other data that you need. (Sample Map)

        Structure for table: CABLE2009.DBF        Included in Product Code 100
        Number of data records 2799
        Field          Field Name                   Type                    Width

	SYSTEMNAME	Character	50	System Assumed Name
2	ADDRESS	Character	35	Mailing Address
3	MAILCITY	Character	35	Mailing City (Office)
4	COUNTY	Character	45	County of Office
5	STATE	Character	15	Mailing State
6	ZIPCODE	Character	5	Mailing Zip Code
7	GM	Character	75	General Manager Name
8	GMEMAIL	Character	75	General Manager Email Address
9	ENGMGR	Character	45	Engineering Manager Name
10	ENGEMAIL	Character	75	Engineering Manager Email Address
11	AREAMGR	Character	75	Area/Region Manager
12	AMPHONE	Character	75	Area/Regional Manager Telephone
13	AMEMAIL	Character	75	Area/Region Manager Email Address
14	TELEPHONE	Character	15	Office Telephone
15	ALTPHONE	Character	15	Alternate Telephone Number
16	FAX	Character	15	Office Fax
17	MKTMGR	Character	40	Advertising Manager Name
18	MKTEMAIL	Character	75	Advertising Manager Email Address
19	WEBSITE	Character	45	Web Site URL
20	TOTALSUBS	Numeric	8	Total Subscribers for system
21	SYSMILES	Numeric	8	Total Miles of cable plant for system
22	HHPASSED	Numeric	8	Total Households passed in the Franchise
23	SYSTEMHH	Numeric	8	Total Households in Franchise
24	DIGITAL	Character	10	Digital or Analog Service
25	MODEM	Character	55	Modem Manufacturer
26	SERVICE	Character	55	Type of Service
27	MARKETNAME	Character	45	Market Name
28	SYSTEMID	Character	10	System (Franchise ID Number)

        Structure for table: CABLESYS2009.DBF            Included in Product Code 100
        Number of data records: 11174
        Field       Field Name                         Type                      Width

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
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
27	SYSTEMID	Character	10	System (Franchise ID Number)

        Structure for table: MSO2009.DBF            Included in Product Code 100
        Number of data records: 311
        Field      Field Name            Type                 Width

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

        Structure for table: CABLECOMZIP.DBF            Product Code 101
        Number of data records: 42542
        Field       Field Name                        T ype                      Width

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	DIGANALOG	Character	15	Digital or Analog Service
13	LATITUDE	Character	25	Community Latitude Centroid
14	LONGITUDE	Character	25	Community Longitude Centroid
15	BASICSUBS	Character	20	Total Subs within community
16	SYSSUBS	Character