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. 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. Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables. Attachment A Formatting Instructions "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 A date Text - YYYY_M M 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 B census_block Text 060871008004005 Fifteen-digit FIPS code (with leading zeros) for the census block served by the Company C zip_plusfour Text 95060-1972 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 95060 Five-digit zip code (with leading zeros) associated with the census block E market_id Text 383233 Unique identifier for the market associated with this census block F market_name Text Monterey Name of market associated with this census block G centraloffice_id Integer 123 The unique identifier associated with the central office serving this census block H centraloffice Text San Jose Name of central office associated with this census block I lineup_id Integer 289 The unique identifier for the system lineup associated with this census block J lineup_name Text Monterey The name for the system lineup associated with this census block K cuid Text WI0000 The Community Unit Identifier (CUID) associated this census block L psid Text 100000 The Physical System Identifier (PSID) associated this census block M dma_code Integer 828 The number (code) of the DMA associated with this census block N dma_name Text Monterey The name of the DMA associated with this census block Attachment A: Template for "Geographic Units Crosswalk" Table Geographic Units Crosswalk Template Page 3 of 3 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. A B C D E F G H I J K L M N date census_block zip_plusfour zip market_id market centraloffice_id centraloffice lineup_id lineup_name cuid psid dma_code dma_name 2012_06 060871008004005 95060-1972 95060 383233 Monterey 123 San Jose 289 Monterey WI0000 100000 828 Monterey- Salinas