Page 1 of 2
Attachment C.6
Data Formatting
Formatting Instructions
Column Variable Name Format Possible Entries / 
Example Entries
A date Text - YYYY_MM 2012_06 to 2015_08
B zip Text 20427
C
service Integer 1, 2, 3
D
sidegrade_up Integer 227
E sidegrade_down Integer 45
All data should be submitted in a .csv (comma-delimited) format.  The sheets in the workbook provide a 
template 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.
The total number of subscribers to the Cable Service given in Column C that moved to a 
lower service tier in the month and zip code
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.
For each month beginning June 2012 and extending through August 2015, please provide the data by zip code requested in 
the table below.
A sidegrade is a subscriber that changed service tiers for one or more Cable Services between the end of the previous month and the end 
of the current month.
Description
Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables.
The month and year for which the data is being collected
Five-digit zip code (with leading zeros)  (Use code 00000 for the Company as a whole)
The code for the Cable Service which the subscribers in columns D and E changed 
service tiers (1=MVPD Service; 2=Internet Access Service; 3=Telephone Service)
The total number of subscribers to the Cable Service given in Column C that moved to a 
higher service tier in the month and zip code
"Sidegrades Data" Table
Page 2 of 2
Attachment C.6:  Template for "Sidegrades Data" Table
For each month beginning June 2012 and extending through August 2015, please 
provide data by zip code requested in the table below.
Notes: Columns A through C define unique records in this data.
date zip service sidegrade_up sidegrade_down
2012_06 20427 1 227 45
2012_06 20427 2 150 22
2012_06 20427 3 5 189
Sidegrades Data Template