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
I
G
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.
H 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
N dma_code Integer 617 The number (code) of the DMA associated with this census block
O dma_name Text Milwaukee The name of the DMA associated with this census block
"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_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
J lineup_id Integer 289
zip_plusfour Text 53202-1972
E glid Text SE Wisconsin
headend Text Chicago
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
B census_block Text 550791870002000 Fifteen-digit FIPS code (with leading zeros) for the census block served by the Company
General Ledger ID associated with the zip code for this census block
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
L cuid Text WI0000
M psid Text 100000
Page 2 of 3
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 O define unique records in this data. 
date census_block zip_plusfour zip glid market_id market headend_id
2012_06 550791870002000 53202-1972 53202 SE Wisconsin 383233 Southeast Wisconsin 123
Geographic Units Crosswalk Template
Page 3 of 3
Attachment A:  Template for "Geographic Units Crosswalk" Table
headend lineup_id lineup_name cuid psid dma_code dma_name
Chicago 289 Milwaukee WI0000 100000 617 Milwaukee
Geographic Units Crosswalk Template