Cable Information

SoftMedia’s Cable System Database Group is comprised of (4) individual databases

1. Cablesys2008- 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. Cable2008- Database Included in Product Code 100
For the convenience of our customers, SoftMedia provides a second database identical
to the cablesys2008 file with the duplicates removed. This database contains over 2700
listings and should be used for Mailing, Emailing, Faxing etc…

3. MSO2008- Database Included in Product Code 100
The 3rd database in our cable group, mso2008, 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 cable2008 database. By using a “Relational”
database software program, you can connect the databases allowing you to view the
cable2008 data and the comzip2008 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: CABLE2008.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	MARKETRANK	Character	5	Market Rank
29	SYSTEMID	Character	10	System (Franchise ID Number)

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