|
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
|
20
|
Total
Subscribers for Franchise
|
|
17
|
PLANTMILES
|
Character
|
20
|
Total Cable
Plant Miles for Community/Zip Code
|
|
18
|
TOTALPOP
|
Character
|
20
|
Total
Population for Community/Zip Code
|
|
19
|
TOTALHH
|
Character
|
20
|
Total
Households for Community/Zip Code
|
|
20
|
WHITEPOP
|
Character
|
20
|
Total White
Population in Community/Zip Code
|
|
21
|
BLACKPOP
|
Character
|
20
|
Total Black
Population in Community/Zip Code
|
|
22
|
HISPPOP
|
Character
|
20
|
Total
Hispanic Population in Community/Zip Code
|
|
23
|
HHINCOME
|
Character
|
20
|
Household
Income in Community/Zip Code
|
|
24
|
HHVALUE
|
Character
|
20
|
Average HH
Value
|
|
25
|
TOTALSYS
|
Character
|
20
|
Total
subscriber for the Franchise (Nation Wide)
|
|
26
|
DIGITAL
|
Character
|
10
|
Digital
or Analog Service
|
|
27
|
MODEM
|
Character
|
11
|
Manufacturer
of Internet/Modems
|
|
28
|
Service
|
Character
|
11
|
Name/Type of
Internet Service
|