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 Possible Entries/ Example Entries A 2012_06 to 2015_08 B 20427 C 70 D 245 E 15 F 28 recent_downgrades_standalone _internet Integer date always_internet_phone Integer 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 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 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, at no point during the previous twelve months, had subscribed to the Company's MVPD Service recent_downgrades_internet_p hone 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. Text - YYYY_MM Variable Name Format 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. Text 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 Page 2 of 6 Column Possible Entries/ Example Entries G 7 H 14 I 3 J 5 K 60 L 220 M 3 N 4 "Recent Downgrades Data" Table recent_downgrades_standalone _internet_voluntary_disconnect s 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) 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 Format Description always_internet_phone_volunta ry_disconnects 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 (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 _internet_continue 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) continued to subscribe to the Company's standalone Internet Access Service through the end of the current month always_standalone_internet_vol untary_disconnects 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 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_p hone_voluntary_disconnects 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 (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 recent_downgrades_internet_p hone_downgrade_internet Integer 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_downgr ade_internet Integer 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 always_standalone_internet_co ntinue 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 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 Page 3 of 6 Column Possible Entries/ Example Entries O 0 P 0 Q 0 R 0 S 0 T 0 U 1 V 0 W 22 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 (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 _internet_upgrade_internet_vid eo 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 MVPD (no phone) service in 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) 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 Description always_standalone_internet_swi tch_standalone_phone 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 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_p hone_downgrade_phone 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 (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_downgr ade_phone recent_downgrades_standalone _internet_switch_standalone_vi deo 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) switched to the Company's standalone MVPD Service in the current month always_bundled_internet_phon e_switch_standalone_video 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 (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 _internet_switch_standalone_p hone 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) switched to the Company's standalone Telephone Service in the current month recent_downgrades_bundled_in ternet_phone_switch_standalon e_video 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 (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_swi tch_standalone_video Integer Page 4 of 6 Column Possible Entries/ Example Entries X 30 Y 5 Z 4 AA 1 AB 2 AC 12 AD 26 AE 0 recent_downgrades_standalone _internet_switch_video_phone 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) switched to the Company's bundled MVPD and phone (no Internet) service in the current month always_standalone_internet_up grade_internet_video 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 always_internet_phone_continu e Integer 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 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 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_p hone_continue Integer 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_up grade_internet_phone recent_downgrades_standalone _internet_upgrade_internet_ph one 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 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_p hone_switch_internet_video 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 (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 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 (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 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 Page 5 of 6 Column Possible Entries/ Example Entries AF 0 AG 0 AH 0 AI 2 AJ 1 AK 0 AL 3 recent_downgrades_bundled_in ternet_phone_switch_video_ph one Integer 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_phon e_switch_video_phone Integer 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 Format always_internet_phone_upgrad e_triple_play Integer 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 _internet_upgrade_triple_play 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, MVPD, and Telephone Service in the current month always_standalone_internet_up grade_triple_play 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 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 always_standalone_internet_swi tch_video_phone 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 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_internet_p hone_upgrade_triple_play Integer 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 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_ 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_bund led_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_ 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_ 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 For each month beginning June 2012 and extending through August 2015, please provide data by zip code requested in the table below.