Page 1 of 8 Attachment C.9 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 Column A B C D E F 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. "Recent Downgrades Data" Table For each month beginning June 2012 and extending through August 2015, please provide the data by zip code requested in the table below. 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. Text - YYYY_MM 2012_06 to 2015_08 Variable Name Format Possible Entries/ Example Entries A downgrade is a person that dropped one or more of the Company's Cable Services in the month but was still subscribed to at least one Company Cable Service at the end of the month. The month and year for which the data is being collected Description date Text 20427 Five-digit zip code (with leading zeros) (Use code 00000 for the Company as a whole) zip 70 245 15 28 recent_downgrades_standalone_in ternet Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that, at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service always_internet_phone Total number of subscribers to the Company's bundled Internet Access and Telephone (no MVPD Service) service in this zip code at the end of the previous month that, at no point during the previous twelve months, had subscribed to the Company's MVPD Service Integer Integer Integer Integer Total number of subscribers to the Company's bundled Internet Access and Telephone (no MVPD Service) services in this zip code at the end of the previous month that, at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service always_standalone_internet Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that, at no point during the previous twelve months, had subscribed to the Company's MVPD Service recent_downgrades_internet_pho ne Page 2 of 8 Column G H I J K L M 60 3 220Integer Integer Variable Name Format Possible Entries/ Example Entries Description 7Integer recent_downgrades_standalone_in ternet_continue Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) continued to subscribe to the Company's standalone Internet Access Service through the end of the current month Integer always_standalone_internet_conti nue Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at no point during the previous twelve months, had subscribed to the Company's MVPD Service; and (2) continued to subscribe to the Company's standalone Internet Access Service through the end of the current month "Recent Downgrades Data" Table For each month beginning June 2012 and extending through August 2015, please provide the data by zip code requested in the table below. recent_downgrades_standalone_in ternet_voluntary_disconnects Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) voluntarily (i.e., not because of moving, non-payment, or other reasons) disconnected from the Company's services in the current month always_internet_phone_voluntary _disconnects Total number of subscribers to the Company's bundled Internet Access and Telephone (no MVPD Service) services in this zip code at the end of the previous month that (1) at no point during the previous twelve months had subscribed to the Company's MVPD Service; and (2) voluntarily (i.e., not because of moving, non-payment, or other reasons) disconnected from the Company's services in the current month always_standalone_internet_volun tary_disconnects Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at no point during the previous twelve months, had subscribed to the Company's MVPD Service; and (2) voluntarily (i.e., not because of moving, non-payment, or other reasons) disconnected from the Company's services in the current month recent_downgrades_internet_pho ne_voluntary_disconnects Total number of subscribers to the Company's bundled Internet Access and Telephone (no MVPD Service) services in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) voluntarily (i.e., not because of moving, non-payment, or other reasons) disconnected from the Company's services in the current month Integer Integer Integer 14 3 5 recent_downgrades_internet_pho ne_downgrade_internet Total number of subscribers to the Company's bundled Internet and phone (no MVPD) service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) downgraded to the Company's standalone Internet Access Service in the current month Page 3 of 8 Column N O P Q R S T 4 0 0 0 0 0 Integer Integer Integer Integer always_standalone_internet_switc h_standalone_phone Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at no point during the previous twelve months, had subscribed to the Company's MVPD Service; and (2) switched to the Company's standalone Telephone Service in the current month always_internet_phone_downgrad e_internet Total number of subscribers to the Company's bundled Internet and phone (no MVPD) service in this zip code at the end of the previous month that (1) at no point during the previous twelve months had subscribed to the Company's MVPD Service; and (2) downgraded to the Company's standalone Internet Access Service in the current month recent_downgrades_standalone_in ternet_switch_standalone_video Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) switched to the Company's standalone MVPD Service in the current month always_bundled_internet_phone_s witch_standalone_video Total number of subscribers to the Company's bundled Internet Access and Telephone (no MVPD Service) services in this zip code at the end of the previous month that (1) at no point during the previous twelve months, had subscribed to the Company's MVPD Service; and (2) switched to the Company's standalone MVPD Service in the current month recent_downgrades_standalone_in ternet_switch_standalone_phone Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) switched to the Company's standalone Telephone Service in the current month recent_downgrades_bundled_inter net_phone_switch_standalone_vid eo Total number of subscribers to the Company's bundled Internet Access and Telephone (no MVPD Service) services in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) switched to the Company's standalone MVPD Service in the current month always_standalone_internet_switc h_standalone_video Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at no point during the previous twelve months, had subscribed to the Company's MVPD Service; and (2) switched to the Company's standalone MVPD Service in the current month "Recent Downgrades Data" Table For each month beginning June 2012 and extending through August 2015, please provide the data by zip code requested in the table below. Variable Name Format Possible Entries/ Example Entries Description Integer Integer 0 Integer Page 4 of 8 Column U V W X Y Z AA Integer recent_downgrades_internet_pho ne_downgrade_phone recent_downgrades_standalone_in ternet_upgrade_internet_phone Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at no point during the previous twelve months, had subscribed to the Company's MVPD Service; and (2) upgraded to the Company's bundled Internet and MVPD (no phone) service in the current month recent_downgrades_internet_pho ne_switch_internet_video 1Integer Integer 0 Integer 22 Integer 30 "Recent Downgrades Data" Table For each month beginning June 2012 and extending through August 2015, please provide the data by zip code requested in the table below. always_standalone_internet_upgra de_internet_video 5 4 1 Total number of subscribers to the Company's bundled Internet Access and Telephone (no MVPD Service) services in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) downgraded to the Company's standalone Telephone Service in the current month always_internet_phone_downgrad e_phone Total number of subscribers to the Company's bundled Internet Access and Telephone (no MVPD Service) services in this zip code at the end of the previous month that (1) at no point during the previous twelve months had subscribed to the Company's MVPD Service; and (2) downgraded to the Company's standalone Telephone Service in the current month recent_downgrades_standalone_in ternet_upgrade_internet_video Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) upgraded to the Company's bundled Internet and MVPD (no phone) service in the current month Variable Name Format Possible Entries/ Example Entries Description Integer Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) upgraded to the Company's bundled Internet and phone (no MVPD) service in the current month Total number of subscribers to the Company's bundled Internet Access and Telephone (no MVPD Service) services in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) switched to the Company's bundled Internet and MVPD (no phone) service in the current month always_internet_phone_switch_int ernet_video Total number of subscribers to the Company's bundled Internet Access and Telephone (no MVPD Service) services in this zip code at the end of the previous month that (1) at no point during the previous twelve months had subscribed to the Company's MVPD Service; and (2) switched to the Company's bundled Internet and MVPD (no phone) service in the current month Integer Page 5 of 8 Column AB AC AD AE AF AG AH "Recent Downgrades Data" Table For each month beginning June 2012 and extending through August 2015, please provide the data by zip code requested in the table below. Variable Name Format Possible Entries/ Example Entries Description Integer Integer Integer 2 12 26 recent_downgrades_internet_pho ne_continue Total number of subscribers to the Company's bundled Internet and phone (no MVPD) service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) continued to subscribe to the Company's bundled Internet and phone (no MVPD) service through the end of the current month always_internet_phone_continue Total number of subscribers to the Company's bundled Internet and phone (no MVPD) service in this zip code at the end of the previous month that (1) at no point during the previous twelve months had subscribed to the Company's MVPD Service; and (2) continued to subscribe to the Company's bundled Internet and phone (no MVPD) service through the end of the current month Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at no point during the previous twelve months, had subscribed to the Company's MVPD Service; and (2) upgraded to the Company's bundled Internet and Telephone Service (no MVPD) in the current month recent_downgrades_bundled_inter net_phone_switch_video_phone Total number of subscribers to the Company's bundled Internet and phone (no MVPD) service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) switched to the Company's bundled MVPD and phone (no Internet) service in the current month always_bundled_internet_phone_s witch_video_phone Total number of subscribers to the Company's bundled Internet and phone (no MVPD) service in this zip code at the end of the previous month that (1) at no point during the previous twelve months, had subscribed to the Company's MVPD Service; and (2) switched to the Company's bundled MVPD and phone (no Internet) service in the current month recent_downgrades_standalone_in ternet_switch_video_phone 0 always_standalone_internet_upgra de_internet_phone Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) switched to the Company's bundled MVPD and phone (no Internet) service in the current month always_standalone_internet_switc h_video_phone Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at no point during the previous twelve months, had subscribed to the Company's MVPD Service; and (2) switched to the Company's bundled MVPD and phone (no Internet) service in the current month Integer Integer Integer Integer 0 0 0 Page 6 of 8 Column AI AJ AK AL Integer Integer Integer Integer 2 1 0 3 "Recent Downgrades Data" Table For each month beginning June 2012 and extending through August 2015, please provide the data by zip code requested in the table below. Variable Name Format Possible Entries/ Example Entries Description recent_downgrades_internet_pho ne_upgrade_triple_play Total number of subscribers to the Company's bundled Internet and phone (no MVPD) service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) upgraded to the Company's bundled Internet, MVPD, and Telephone Service in the current month always_internet_phone_upgrade_t riple_play Total number of subscribers to the Company's bundled Internet and phone (no MVPD) service in this zip code at the end of the previous month that (1) at no point during the previous twelve months had subscribed to the Company's MVPD Service; and (2) upgraded to the Company's bundled Internet, MVPD, and Telephone Service in the current month recent_downgrades_standalone_in ternet_upgrade_triple_play Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at some point during the previous twelve months, had subscribed to (and subsequently downgraded) the Company's MVPD Service; and (2) upgraded to the Company's bundled Internet, MVPD, and Telephone Service in the current month always_standalone_internet_upgra de_triple_play Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the previous month that (1) at no point during the previous twelve months, had subscribed to the Company's MVPD Service; and (2) upgraded to the Company's bundled Internet, MVPD, and Telephone Service in the current month Page 7 of 8 date zip recent downgrades standalone internet always standalone internet recent downgrades internet phone always internet phone recent downgrades standalone internet voluntary disconnects always standalone internet voluntary disconnects recent downgrades internet phone voluntary disconnects always internet phone voluntary disconnects recent downgrades standalone internet continue always standalone internet continue recent downgrades internet phone downgrade internet always internet phone downgrade internet recent downgrades standalone internet switch standalone video always standalone internet switch standalone video recent downgrades bundled internet phone switch standalone video always bundled internet phone switch standalone video recent downgrades standalone internet switch standalone phone always standalone internet switch standalone phone recent downgrades internet phone downgrade phone always internet phone downgrade phone recent downgrades standalone internet upgrade internet video always standalone internet upgrade internet video recent downgrades internet phone switch internet video always internet phone switch internet video recent downgrades standalone internet upgrade internet phone always standalone internet upgrade internet phone 2012 06 20427 70 245 15 28 7 14 3 5 60 220 3 4 0 0 0 0 0 0 1 0 22 30 5 4 1 2 Recent Downgrades Data Template For each month beginning June 2012 and extending through August 2015, please provide data by zip code requested in the table below. Attachment C.9: Template for "Recent Downgrades Data" Table Notes: Columns A through AL define unique records in this data. Page 8 of 8 Attachment C 9: Template for "Recent recent_downgrades_internet_phone_continue always_internet_phone_continue recent_downgrades_standalone_internet_switch_video_phone always_standalone_internet_switch_video_phone recent_downgrades_bundled_internet_phone_switch_video_phone always_bundled_internet_phone_switch_video_phone recent_downgrades_standalone_internet_upgrade_triple_play always_standalone_internet_upgrade_triple_play recent_downgrades_internet_phone_upgrade_triple_play always_internet_phone_upgrade_triple_play 12 26 0 0 0 0 2 1 0 3 Recent Downgrades Data Template