Page 1 of 2
Attachment C.7
Data Formatting
All data should be submitted in a .csv (comma-delimited) format.  The sheets in the workbook provide a template for how the tables should be designed.
Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables.
Formatting Instructions
D end_bundle Integer 0 to 7 
The code for the Bundled services that the number of subscribers in Column F had at the end of the month one year 
later (0 = No Cable Services with the Company (disconnect); 1=standalone Telephone Service; 2=standalone MVPD 
Service; 3=standalone Internet Access Service; 4=MVPD and Telephone services; 5=MVPD and Internet Access services; 
6=Telephone and Internet Access services; 7=Telephone, MVPD and Internet Access services)
C begin_bundle Integer
1 to 7 The code for the Bundled services that the number of subscribers in Column F had at the end of the month 
(1=standalone Telephone Service; 2=standalone MVPD Service; 3=standalone Internet Access Service; 4=MVPD and 
Telephone services; 5=MVPD and Internet Access services; 6=Telephone and Internet Access services; 7=Telephone, 
MVPD and Internet Access services)
E reason Integer 1 to 5, -1 The reason why disconnecting subscribers (end_bundle=0) left the Company (-1 = not applicable, did not disconnect; 
1=any reason; 2=voluntary; 3=mover; 4=non-payment; 5=other)
B zip Text 20427 Five-digit zip code (with leading zeros) for the service plan. (Use code 00000 for the Company as a whole)
F subs Integer 10 Number of subscribers that correspond to each bundle combination defined by Columns C and D in the zip code and 
month
The table collects data on the bundles that subscribers had at the end of the previous month (begin_bundle) and the bundles they then had in the same month one 
year later (end_bundle).  The table should have 56 entries per zip code and month and a disconnection reason should be given for all subscribers coded as 
end_bundle=0. 
The required format for the entries in each column/field is indicated in the instructions for each sheet. Column entries in bold red indicate that the 
Company should enter only one of the possible entries listed for that column.  No other entries should be entered.
A date Text - YYYY_MM 2012_06 to 2014_08 The month and year for which the data is being provided
"Long Run Disconnects Data" Table
For each month beginning June 2012 and extending through August 2014, please provide the subscriber data by zip code requested in the table below.
Column Variable Name Format Possible Entries/ 
Example Entries
Description
A disconnect is a person who was subscribed to a Company Cable Service at the end of the previous month who is no longer subscribed to any Company Cable 
Services at the end of the current month.
A long-run disconnect in a month is a person who is subscribed to one or more of the Company Cable Services at the end of the previous month who is no longer 
subscribed to any Company Cable Service at the end of the same month of the following year.
Page 2 of 2
date zip begin_bundle end_bundle reason subs
2012_06 20427 1 0 1 22
2012_06 20427 2 0 1 11
2012_06 20427 3 0 1 15
… … … … … …
2012_06 20427 1 1 -1 20
2012_06 20427 1 2 -1 0
2012_06 20427 1 3 -1 1
2012_06 20427 1 4 -1 11
2012_06 20427 1 5 -1 12
2012_06 20427 1 6 -1 13
2012_06 20427 1 7 -1 20
2012_06 20427 2 1 -1 0
2012_06 20427 2 2 -1 20
2012_06 20427 2 3 -1 1
2012_06 20427 2 4 -1 11
2012_06 20427 2 5 -1 12
2012_06 20427 2 6 -1 13
2012_06 20427 2 7 -1 20
2012_06 20427 3 1 -1 0
2012_06 20427 3 2 -1 20
Long-Run Disconnects Data Template
Attachment C.7:  Template for "Long-Run Disconnects Data" Table
For each month beginning June 2012 and extending through August 2014, please provide the subscriber data by zip code requested in the 
table below.
Notes: In the table below, the first row indicates that in June 2012 there were 22 subscribers in zip code 20427 that had standalone 
Telephone service at the end of June 2012 and had disconnected All Company Cable Services by the end of June 2013.
Columns A through D define a unique entry in this data.