Page 1 of 6 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 Format Possible Entries/ Example Entries A Text - YYYY_MM 2012_06 to 2015_08 B Text 20427 C Integer 70 D Integer 245 E Integer 15 F Integer 28 Description The month and year for which the data is being provided Five-digit zip code (with leading zeros). (Use code 00000 for the Company as a whole) 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. Variable Name 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. zip 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 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_ phone recent_downgrades_standalone_in ternet date 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 Page 2 of 6 Column Format Possible Entries/ Example Entries G Integer 7 H Integer 14 I Integer 3 J Integer 5 K Integer 60 L Integer 220 M Integer 3 N Integer 4 always_standalone_internet_ 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 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_internet_phon e_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 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_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 always_standalone_internet_ 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 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_ 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 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 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 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 Description "Recent Downgrades Data" Table Page 3 of 6 Column Format Possible Entries/ Example Entries O Integer 0 P Integer 0 Q Integer 0 R Integer 0 S Integer 0 T Integer 0 U Integer 1 V Integer 0 W Integer 22 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_ internet_phone_switch_ 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 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_ 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 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 Description 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 recent_downgrades_internet_ phone_downgrade_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 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_ downgrade_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 Page 4 of 6 Column Format Possible Entries/ Example Entries X Integer 30 Y Integer 5 Z Integer 4 AA Integer 1 AB Integer 2 AC Integer 12 AD Integer 26 AE Integer 0 "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 Description always_standalone_internet_ 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 phone (no MVPD) service in 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_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 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_standalone_internet_ upgrade_internet_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_ phone_switch_internet_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 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_ internet_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 recent_downgrades_standalone_in ternet_switch_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 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 Page 5 of 6 Column Format Possible Entries/ Example Entries AF Integer 0 AG Integer 0 AH Integer 0 AI Integer 2 AJ Integer 1 AK Integer 0 AL Integer 3always_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_ 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 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_internet_ phone_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 recent_downgrades_bundled_ internet_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 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 Description always_standalone_internet_ switch_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 6 of 6 Attachment C.9: Template for "Recent Downgrades Data" Table 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 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 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 12 26 0 0 0 0 2 1 0 3 Recent Downgrades Data Template Notes: Columns A through AL define unique records in this data. For each month beginning June 2012 and extending through August 2015, please provide data by zip code requested in the table below.