National Broadband Map Data

Note: If you have any questions about this data please e-mail sbdd@ntia.doc.gov. 


This folders contain broadband availibility data submitted to the National Telecommunications and Information  Administration (NTIA) on April 1, 2013 from State Broadband Initiative grantees in every state, Territory and the District of Columbia. This data is current as of December 31, 2012. For more information regarding the Grantees please visit http://www2.ntia.doc.gov/SBDD 

The following files are included for each grantee: 
	StateAbbreviation-NBM-CBLOCK-CSV-December-2012.zip --- Broadband Availibility data for Census Blocks less than 2 square miles
	StateAbbreviation-NBM-Wireless-CSV-December-2012.zip --- Broadband Availibility data for Wireless
	StateAbbreviation-NBM-Address-Street-CSV-December-2012.zip --- Broadband Availibility data for Large Blocks 
	StateAbbreviation_Methodology_YYYY_MM_DD.pdf --- Methodological description of grantee data collection proccess
	StateAbbreviation_DataPackage_YYYY_MM_DD.xls --- This is the List of providers that the grantee reached out to for inclusion
	
Note: Because data was originally submitted in a file geodatabase and converted to CSV for download, this data may look slightly different in this format than how it is displayed on BroadbandMap.gov. The HOCONUM and HOCONAME field values, were added during the data integration proccess and are a holding company roll-up based on the FCC Registration Numbers (FRNs). This allows you to identify unique providers accross the country. For a complete description of how the data was collected, please refer the NOFA, Technical Appendix, and NOFA clarification, which can be found here: http://www2.ntia.doc.gov/notices#mapping . 

When citing data, it should read, "US Dept of Commerce, National Telecommunications and Information Administration, State Broadband Initiative (CSV format December 31, 2012)."

Please consult the following information for each CSV file

###########Census Blocks with an area less than 2 square miles###########
NOTES: The following are column headings for the csv file named StateAbbreviation-NBM-CBLOCK-CSV-December-2012.zip. Each row is one record per provider technology, advertised speed, per census block less than 2 square miles. This includes data that was submitted at address level in census blocks less than 2 square miles, and speed data that was submitted in the address, roadsegment, block, or overview feature class by MSA or County. Address data has been aggregated to census block data, and was not provided in this dataset.

FRN - FCC Registration Number
PROVNAME - Provider Name
DBANAME - Doing Business As Name
HOCONUM - Holding Company Unique Number 
HOCONAME - Holding Company Name 
STATEABBR - 2 character State Abbreviation
FULLFIPSID - 2010 US Census Block 15 Character number
TRANSTECH - Technology Code (See below for valid values)
MAXADDOWN - Maximum Advertised Download Speed (see below for valid values) from record level
MAXADUP - Maximum Advertised Upload Speed (see below for valid values) from record level
TYPICDOWN - Typical Download Speed (see below for valid values)
TYPICUP - Typical Upload Speed (see below for valid values)
DOWnloadSPEED - Maximum Advertised Download Speed if provided from Oviewview table
UPLOADSPEED - Maximum Advertised Upload Speed if provided from Overview table
PROVIDER_TYPE - Type of Service Provider (see below for valid values)
END_USER_CAT - Type of Service provided by Provider (see below for valid values)
OBJECTID - These values are just a record count from the database and should be ignored


###########Wireless###########
NOTES: The following are column headings for the csv file named StateAbbreviation-NBM-Wireless-CSV-December-2012.zip. Each row displays one 
record per provider, technology, advertised speed, and coverage per percent overlay by block. This data was submitted to NTIA in 
shapefiles. In order to export this to CSV, the shapefiles were overlayed on top of census blocks and a Percentage of block per shape 
was calculated (PCT_BLK_IN_SHAPE).

DATASOURCE - Source of availability data (Originally submitted to NTIA in Shapefiles)
FRN - FCC Registration Number
PROVNAME - Provider Name
DBANAME - Doing Business As Name
HOCONUM - Holding Company Unique Number 
HOCONAME - Holding Company Name 
CENSUSBLOCK_FIPS - 2010 US Census Block 15 Character number
PCT_BLK_IN_SHAPE - the percent area of the wireless polygon overlay of the Census block
TRANSTECH - Technology Code (See below for valid values)
MAXADDOWN - Maximum Advertised Download Speed (see below for valid values) from record level
MAXADUP - Maximum Advertised Upload Speed (see below for valid values) from record level
TYPICDOWN - Typical Download Speed (see below for valid values)
TYPICUP - Typical Upload Speed (see below for valid values)
SPECTRUM - 
Spectrum used to transit wireless broadband
OBJECTID - These values are just a record count from the database and should be ignored


###########Large Blocks - Census blocks with an area over 2 square miles (Address and Street)###########
NOTES: The following are column headings for the csv file named StateAbbreviation-NBM-Address-Street-CSV-December-2012.txt. Each row displays one 
record per provider, technology, advertised speed, per census block greater than 2 square miles. This includes data that was submitted at 
address level and road segment level, and any associated speed data, including that which was submitted in the address, roadsegment, block, 
or overview feature class by MSA or County. 

DATASOURCE - Source of availability data (Originally submitted to NTIA as Road Segment or Address Points)
FRN - FCC Registration Number
PROVNAME - Provider Name
DBANAME - Doing Business As Name
HOCONUM - Holding Company Unique Number 
HOCONAME - Holding Company Name 
STATEABBR - 2 character State Abbreviation
FULLFIPSID - 2010 US Census Block 15 Character number
COUNTY_FIPS - The 5 character State + County 2010 US Census FIPS ID
TRANSTECH - Technology Code (See below for valid values)
MAXADDOWN - Maximum Advertised Download Speed (see below for valid values) from record level
MAXADUP - Maximum Advertised Upload Speed (see below for valid values) from record level
TYPICDOWN - Typical Download Speed (see below for valid values)
TYPICUP - Typical Upload Speed (see below for valid values)
DOWNLOADSPEED - Maximum Advertised Download Speed if provided from Overview table
UPLOADSPEED - Maximum Advertised Upload Speed if provided from Overview table
OBJECTID - These values are just a record count from the database and should be ignored
RANDOM_PT_OBJECTID - These values are just a record count from the database and should be ignored
PROVIDER_TYPE - Type of Service Provider (see below for valid values)
END_USER_CAT - Type of Service provided by Provider (see below for valid values)

###########Data_Dictionary###########
###########TransTech###########
Code	Description
10	Asymmetric xDSL
20	Symmetric xDSL
30	Other Copper Wire
40	Cable Modem - DOCSIS 3.0 Down
41	Cable Model - Other
50	Optical Carrier/Fiber to the End User
60	Satellite
70	Terrestrial Fixed - Unlicensed
71	Terrestrial Fixed - Licensed
80	Terrestrial Mobile Wireless
90	Electric Power Line
0	All Other

###########MaxAdDown###########
Code	Description
2	Greater than 200 kbps and less than 768 kbps
3	Greater than 768 kbps and less than 1.5 mbps
4	Greater than 1.5 mbps and less than 3 mbps
5	Greater than 3 mbps and less than 6 mbps
6	Greater than 6 mbps and less than 10 mbps
7	Greater than 10 mbps and less than 25 mbps
8	Greater than 25 mbps and less than 50 mbps
9	Greater than 50 mbps and less than 100 mbps
10	Greater than 100 mbps and less than 1 gbps
11	Greater than 1 gbps

###########MaxAdUp###########
Code	Description
2	Greater than 200 kbps and less than 768 kbps
3	Greater than 768 kbps and less than 1.5 mbps
4	Greater than 1.5 mbps and less than 3 mbps
5	Greater than 3 mbps and less than 6 mbps
6	Greater than 6 mbps and less than 10 mbps
7	Greater than 10 mbps and less than 25 mbps
8	Greater than 25 mbps and less than 50 mbps
9	Greater than 50 mbps and less than 100 mbps
10	Greater than 100 mbps and less than 1 gbps
11	Greater than 1 gbps

###########TYPICDOWN###########
Code	Description
2	Greater than 200 kbps and less than 768 kbps
3	Greater than 768 kbps and less than 1.5 mbps
4	Greater than 1.5 mbps and less than 3 mbps
5	Greater than 3 mbps and less than 6 mbps
6	Greater than 6 mbps and less than 10 mbps
7	Greater than 10 mbps and less than 25 mbps
8	Greater than 25 mbps and less than 50 mbps
9	Greater than 50 mbps and less than 100 mbps
10	Greater than 100 mbps and less than 1 gbps
11	Greater than 1 gbps

###########TYPICUP###########
Code	Description
2	Greater than 200 kbps and less than 768 kbps
3	Greater than 768 kbps and less than 1.5 mbps
4	Greater than 1.5 mbps and less than 3 mbps
5	Greater than 3 mbps and less than 6 mbps
6	Greater than 6 mbps and less than 10 mbps
7	Greater than 10 mbps and less than 25 mbps
8	Greater than 25 mbps and less than 50 mbps
9	Greater than 50 mbps and less than 100 mbps
10	Greater than 100 mbps and less than 1 gbps
11	Greater than 1 gbps


###########Provider Type###########

Code	Description

1	Broadband provider as described in the NOFA

2	Reseller

3	Other



###########EndUserCategory###########

Code	Description

1	Residential

2	Government

3	Small Business

4	Medium or Large Enterprise

5	Other

<end>