Cable Data Fields

Cable TV Database Set. Product 401

Cable TV Product 402 ships with a complete set of pre-defined Digital TV Market Area map shape files for BusinessMap and MS MapPoint covering all 224 DTVMA's. In addition a complete set of Excel (.xls), dBase III (.dbf), Tab Dellimited (.txt) and Comma Delimited (.txt) files are provided for each DTVMA.

Product 401 includes:

Cable community and demographics files by zip code. (cablecomzip2010)
Cable contact database. (cable2010)
DTVMA pre-defined map files.
Cable MSO's (Multi-System Operators). (mso2010)
Complete set of Excel, dBase III and Tab Delimited files for import into MapInfo, ArcView, Maptitude and any other GIS mapping program.

       CABLE2010.DBF
       Number of data records 2011
       Field            Name           Type        Width

1	COMZIP	Character	10	Community Zip Code
2	AREACODE	Character	3	Area Code
3	COMCODE	Character	10	Community Code assigned by FCC
4	SYSTEMID	Character	10	System Identification Number
5	COUNTY	Character	35	County
6	SYSTEMNAME	Character	50	System Assumed Name
7	ADDRESS	Character	35	Mailing Address
8	CITY	Character	35	Mailing City (Office)
9	STATE	Character	15	Mailing State
10	ZIPCODE	Character	5	Mailing Zip Code
11	GM	Character	75	General Manager Name
12	GMEMAIL	Character	75	General Manager Email Address
13	ENGMGR	Character	45	Engineering Manager Name
14	ENGEMAIL	Character	75	Engineering Manager Email Address
15	ENGPHONE	Character	15	Engineers Direct Line
16	AREAMGR	Character	75	Area/Region Manager
17	AMPHONE	Character	15	Area/Regional Manager Telephone
18	AMEMAIL	Character	75	Area/Region Manager Email Address
19	TELEPHONE	Character	15	Office Telephone
20	ALTPHONE	Character	15	Alternate Telephone Number
21	FAX	Character	15	Office Fax
22	TOTALPOP	Character	10	Total Franchise Population
23	TOTALHH	Character	10	Total House Holds for this system
24	TOTALSUBS	Numeric	10	Total Subscribers for this system
25	SYSMILES	Numeric	10	Total Miles of Plant for this system
26	ANALOGDIG	Numeric	10	Provides analog or digital service
27	MODEMMFG	Character	25	Modem Manufacturer
28	MARKETNAME	Character	45	Market Name
29	MARKETRANK	Character	10	Ranking of Market Area

      CableComZip2010.DBF
     Number of data records: 54200
     Field      Field Name         Type                 Width

1	COMZIP	Character	10	Community/Zip Code
2	COMMUNITY	Character	40	Community Name
3	COUNTY	Character	35	Service County
4	COMSTATE	Character	2	Community/State
5	SYSTEMNAME	Character	50	System Assumed Name
6	ALTCABLE	Character	45	2nd Cable Operator
7	ALTCABLE2	Character	45	3^rd Cable Operator
8	SYSTEMID	Character	15	System Identification Number
9	UVERSECBL	Character	30	AT&T Uverse Cable Service
10	FIOSCBL	Character	30	Verizon FiOS Cable Service
11	AREACODE	Character	3	NPA (AreaCode)
12	FIPS CODE	Character	9	FIPS Code
13	SYSTEMID	Character	10	Unique system identifier
14	LATITUDE	Character	25	Community Latitude Centroid
15	LONGITUDE	Character	25	Community Longitude Centroid
16	BUS_POBOX	Character	1	Zip Code located in business area
17	CONSUMER	Character	1	Zip Code located in residential area
18	TOTALPOP	Numeric	10	Total Population for Community/Zip Code
19	WHITEPOP	Numeric	10	Total White Pop in Community/Zip Code
20	BLACKPOP	Numeric	10	Total Black Pop in Community/Zip Code
21	HISPPOP	Numeric	10	Total Hispanic Pop in Community/Zip
22	COUNTYPOP	Numeric	10	Total county population
23	TOTALHH	Numeric	10	Total Households for Community/Zip
24	HHINCOME	Numeric	10	Household Income in Community/Zip
25	HHVALUE	Numeric	10	Average HH Value
26	COUNTYHH	Numeric	10	Total County house holds
27	BASICSUBS	Numeric	10	Total Subscribers within community
28	SYSSUBS	Numeric	10	Total Subscribers for Franchise
29	TOTALSYS	Numeric	10	Total systems for MSO (Nation Wide)
30	PLANTMILES	Numeric	10	Total Plant Miles for Community/Zip Code
31	TOTALANASUBS	Numeric	10	Total analog subscribers
32	TOTALDIGSUBS	Numeric	10	Total Digital Subscribers
33	TOTALOPSUBS	Numeric	10	Total subscribers for Franchise
34	DIGITAL	Character	10	Digital or Analog Service
35	Service	Character	25	Type Service
36	MARKETNAME	Character	45	Market Name
37	MARKETRANK	Character	10	Market Rank
38	HEADEND	Character	1	Denotes location is a Cable Headend
39	PLACECODE	Character	15	Stater,County,City FIPS Code

       MSO2010.DBF
      Number of data records: 173
      Field      Name            Type                 Width

1	OWNERMSO	Character	50	Corporate Owner
2	ADDRESS	Character	30	Address
3	CITY	Character	25	Mail City
4	STATE	Character	2	Mail State
5	ZIPCODE	Character	10	Zip Code
6	TELEPHONE	Character	15	Telephone
7	FAX	Character	15	Fax
8	ENGMANAGER	Character	25	Engineering Manager
9	CHIEFEXOFF	Character	25	Chief Executive Officer
10	CHIEFOPOFF	Character	25	Executive VP
11	MCSZ	Character	35	Mail/City/State/Zip (For mailing labels)
12	TOTALANASUBS	Numeric	10	Total analog subs for system operator
13	TOTALDIGSUBS	Numeric	10	Total digital subs for system operator
14	TOTALOPSUBS	Numeric	10	Total analog and digital subs
15	WEBSITE	Character	50	URL