Page 1 of 2 Attachment A 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 K cuid Text WI0000 L psid Text 100000 The Physical System Identifier (PSID) associated this census block market_name Text Milwaukee Name of market associated with this census block The Community Unit Identifier (CUID) associated this census block Milwaukee The name for the cable system lineup associated with this census block Name of headend associated with this census block The unique identifier for the cable system lineup associated with this census block B census_block Text 550791870002000 Fifteen-digit FIPS code (with leading zeros) for the census block served by the Company Five-digit zip code (with leading zeros), followed by four-digit extension (with leading zeros) and separated by hyphen associated with the census block D zip Text 53202 Five-digit zip code (with leading zeros) associated with the census block C I lineup_id Integer 289 zip_plusfour Text 53202-1972 headend Text Chicago A date Text - YYYY_MM 2012_06, 2012_12, 2013_06, 2013_12, 2014_06, 2014_12, 2015_06 The month and year for which the data is being collected "Geographic Units Crosswalk" Table For each time period as of June 30, 2012, Dec. 31, 2012, June 30, 2013, Dec. 31, 2013, June 30, 2014, Dec. 31, 2014, and June 30, 2015, and for each census block served by the Company, please provide the crosswalk data in the table below. The lowest unit of observation in the crosswalk is census block ID. Column Variable Name Format Possible Entries/ Example Entries Description N dma_name Text Milwaukee The name of the DMA associated with this census block M dma_code Integer 617 The number (code) of the DMA associated with this census block J H F E 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. G headend_id Integer 123 The unique identifier associated with the headend serving this census block market_id Text 383233 Unique identifier for the market associated with this census block lineup_name Text Page 2 of 2 Attachment A: Template for "Geographic Units Crosswalk" Table For each time period as of June 30, 2012, Dec. 31, 2012, June 30, 2013, Dec. 31, 2013, June 30, 2014, Dec. 31, 2014, and June 30, 2015, and for each census block served by the Company, please provide the crosswalk data in the table below. The lowest unit of observation in the crosswalk is census block ID. Notes: Columns A through N define unique records in this data. date census_block zip_plusfour zip market_id market headend_id headend lineup_id lineup_name cuid psid dma_code dma_name 2012_06 550791870002000 53202-1972 53202 383233 Southeast Wisconsin 123 Chicago 289 Milwaukee WI0000 100000 617 Milwaukee Geographic Units Crosswalk Template