|
1. Cable2010-
Database
Product Code 100
There
are currently over 7,700 cable systems/franchises in the U.S.
market
with over 2000
managing offices. The cable2010 database covers managing
offices including management, addresses, email, telephone, fax and
other contact and research data. This database can be merged with
the cablecomzip2010 database to provide the most complete tool
available for analysis of the cable industry.
2. CableComZip2010- Database
Product Code 102
The 2nd
database, cablecomzip, is a database of over 54,000 communities
and five digit
zip codes for detailed analysis of cable footprints.
As an example:
this database allows you to analyze a territory
by All communities, including ‘Also known as’, and
‘Unincorporated areas’.
The cablecomzip database provides the capability to analyze:
1. Total subscribers by zip code, county, state, or market area.
2. Households by zip code, county, state or market area.
3. Population by zip code, county, state, market area, and
includes key demographics such as
ethnic background,
income, HH value and many others.
4. A data field identifying the system as analog, digital and
broadband.
NEW! for 2010. The database has been updated to include
AT&T's UVerse and Verizon's FiOS
cable service, In addition it covers the primary cable provider,
alternate cable provider 2 and 3.
The database also includes a data field that identifies the 'Headend'
community for the system.
The database includes a SYSTEMID that identifies each
community and zip code within that franchise. By
sorting/indexing on the SYSTEMID number you can view all of the
communities and zip codes within a franchise. 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.
3. MSO2010-
Database
Included in Product Code 100
The
3rd database in our cable group; mso2010 file is the MSO Database.(Multiple System Operators) corporate owners database. This data file
includes contact data for the CEO, COO, and Engineering
VP as well as system statistics.
CABLE2010.DBF
Product Code 100
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
Product Code 101
Number of data records: 65200
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
|
3rd
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
|
Structure
for table: MSO2010.DBF
Included in Product Code 100
Number of data records: 65200
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
|
CABLEINTL2010
Product Code 109
Number of data records: 743
Field
Field Name
Type
Width
|
1
|
SYSTEMNAME
|
Character
|
44
|
System
Name/Call Sign
|
|
2
|
ADDRESS
|
Character
|
30
|
Address
|
|
3
|
CITY
|
Character
|
35
|
System
Location City/ Mailing
|
|
4
|
COUNTRY
|
Character
|
35
|
Country
location
|
|
5
|
ZIPCODE
|
Character
|
25
|
System
Mailing Zip Code
|
|
6
|
STATE
|
Character
|
25
|
State/Province
|
|
7
|
MANAGER
|
Character
|
35
|
Title
Addressing (Attn: Manager)
|
|
8
|
TYPE
|
Character
|
15
|
System Type,
Cable, Satellite etc
|
|
9
|
EMAIL
|
Character
|
75
|
Manager
Personal Email
|
|
10
|
TELEPHONE
|
Character
|
25
|
Manager Direct Telephone Number
|
|
11
|
URL
|
Character
|
55
|
System Web
Site
|
International
Cable Coverage
|
Albania
|
Argentina
|
Aruba
|
Australia
|
|
Australia
|
Austria
|
Bahamas
|
Barbados
|
|
Belarus
|
Belgium
|
BELIZE
|
Bermuda
|
|
Bolivia
|
Bonaire
N.A.
|
Bosnia/Herzegovina
|
Brazil
|
|
Bulgaria
|
BVI
|
BWI
|
Canada
|
|
Cayman
Islands
|
Chile
|
China
|
Colombia
|
|
Costa
Rica
|
Cyprus
|
Czechia
|
Denmark
|
|
Dominica
|
Dominican
Republic
|
Ecuador
|
El
Salvador
|
|
England
|
Finland
|
France
|
France
|
|
French
Guiana
|
Gambia
|
Germany
|
Germany
|
|
Greece
|
Greece
|
Grenada
|
Guadeloupe
|
|
Guatemala
|
Guyana
|
Honduras
|
Hong
Kong
|
|
Hungary
|
Iceland
|
India
|
India
|
|
Indonesia
|
Indonesia
|
Iraq
|
Israel
|
|
Italy
|
Ivory
Coast
|
Jamaica
WI
|
Japan
|
|
Jordan
|
Kenya
|
Kosova
|
Latvia
|
|
Macedonia
|
Malaysia
|
Martinique
|
Mexico
|
|
Netherlands
|
Netherlands
|
Netherlands
Antilles
|
New
Zeeland
|
|
Nicaragua
|
Nigeria
|
Norway
|
Pakistan
|
|
Panama
|
Peru
|
Philippines
|
Poland
|
|
Portugal
|
Puerto
Rico
|
Romania
|
Russia
|
|
San
Marino
|
Saudi
Arabia
|
Serbia
|
Singapore
|
|
Slovakia
|
South
Africa
|
South
Korea
|
Spain
|
|
SPAIN
|
Sri
Lanka
|
St.
Croix VI
|
St.
Kitts
|
|
St.
Lucia
|
St.
Marten
|
St.
Marten N.A
|
St.
Thomas VI
|
|
Sweden
|
Switzerland
|
Taiwan
|
TANZANIA
|
|
Thailand
|
Tobago
|
Trinidad
West Ind
|
Turkey
|
|
Turkey
|
Turks
& Caicos Islands
|
UK
|
Ukraine
|
|
United
Arab Emirates
|
United
Kingdom
|
Uruguay
|
Venezuela
|
|
Virgin
Islands
|
|
|
|
|