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 party 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.
"Residential Internet Access Service: Historical Data" Table
For the dates 12/31/2013 and 06/30/2014, please provide the Internet access service data requested in the "Residential Internet Access Service: Historical Data" table.  
In general, this table is intended to provide data on the number of residential locations for which your Company's Internet Access Service is available and residential
subscribers to Internet access service by census block, technology and bandwidth combination.
Column Variable Name Format Possible Entries/Example Entries Description
A date Text - YYYY_
MM_DD
2013_12_31, to 2014_06_30 The date for which the data is being collected
B block Text 110010062021037 15-digit FIPS code for the 2010 Census Block Identifier from the 2010 TIGER/Line Block State-based Shapefile or 
Block County-based Shapefile
C tech Integer 42 Technology code of the Internet Access Service (see Tech Table for codes)
D res_locs Integer 605 The total number of residential locations in the block
E res_ia_locs Integer 602 Residential customer locations for which the Company's Internet Access Service is available
F max_down Float 25 Maximum advertised download speed available to residential subscribers
G max_up Float 10 Maximum advertised upload speed available to residential subscribers
H down_speed Float 3 Downstream bandwidth of the service as sold in Mbps 
I up_speed Float 1.5 Upstream bandwidth of the service as sold in Mbps  
J residential_subs Integer 156 Residential subscribers of the Company subscribing to Internet Access Service with the specified downstream and 
upstream bandwidth
Notes by Column:
B: The block identifier is a concatenation of Census 2010 state FIPS code, Census 2010 county FIPS code, Census 2010 census tract code and Census 2010 tabulation block number.
Please see the 2010 TIGER/Line Shapefiles Technical Documentation, Chapter 5, Part 5.2 at http://www.census.gov/geo/maps-data/data/pdfs/tiger/tgrshp2010/TGRSHP10SF1CH5.pdf.
A, B, C, H, I: Any variation in Date, Block, and Technology necessitates the creation of a new, unique record.  Additionally, a new record should be created for each combination
Technology of Transmission Codes for Deployment of Internet acces  Access Service
Technology Code Description Details
10 Asymmetric xDSL Asymmetric xDSL and other than ADSL 2 and VDSL
11 ADSL 2 e.g., ADSL 2, ADSL 2+
12 VDSL VHDSL, VDSL 2
20 Symmetric xDSL
30 Other Copper Wireline All copper-wire based technologies other than xDSL (e.g., Ethernet over copper and T-1)
40 Cable Modem Cable modem other than DOCSIS 1, 1.1, 2.0, and 3.0
41 Cable Modem -- DOCSIS 1, 1.1, and 2.0
42 Cable Modem -- DOCSIS 3.0
50 Optical Carrier/Fiber to the End User Fiber to the home or business end user (does not include "fiber to the curb")
60 Satellite
70 Terrestrial Fixed Wireless
90 Electric Power Line
0 All Other Any specific technology not listed above