Skip Navigation

Federal Communications Commission

English Display Options

Validated Data - Measuring Broadband America February 2013

Overview

This reference page for the Measuring Broadband America - February 2013 Report provides the validated data set that was used to produce this Report. It includes the detailed results for 13 tests that formed the basis for the Report, in addition to the results of a separate quality metric run to assess which reporting units were available. The September 2012 data set was validated as discussed in the Report and Technical Appendix (further details can be found on the Methodology February 2013 Report reference page). Note that the materials below used to produce the July 2012 Report are also applicable to data collected in September 2012 for the February 2013 Report.

Files

Statistical Averages

Description

Excel workbook of tabulated test results data. Contains the tabular test data from the validated September 2012 test results data. A full range of statistical measures for each test is given.

Why We Provide It

This is the comprehensive analysis of all tests conducted within this study comprising test results contained within the report and additional tests described but not presented in the report. Researchers can use this data to do further analysis of broadband performance in the United States.

Additional Information

See the section on methodology, exclusions and scripts for more information on how the statistical analysis was performed and how the data set was processed.

Download

statistical-averages-Sept-2012-v5.xlsx

Data Processing Flow

Description

This document provides an overview of how data is processed, from its raw form to the resulting report.

Why We Provide It

This file is provided as documentation to aid researchers and other parties interested in replicating or analyzing the data processing flow.

Download

data-processing-flow-apr-2012.docx | alternate mirror

Data Dictionary

Description

This document provides a brief explanation of each field included in the data set, and is provided as documentation on the structure of the data.

Why We Provide It

This file is provided as documentation on the structure of the data. This one file describes the contents on this page.

Download

data-dictionary-april-2012.xls

Data Cleansing

Description

This document outlines the data cleansing processes used to generate the "clean" data set from the "raw" data set.

Why We Provide It

This file is provided as documentation of how the raw data was cleansed to be included in the validated data set.

Download

validated-data-cleansing-april-2012.docx

SQL Cleanup Scripts

Description

SQL scripts associated with the data cleansing process used to prepare raw September 2012 data for statistical analysis.

Why We Provide It

These scripts are provided for full transparency and to facilitate researchers in examining the data. The SQL scripts are necessary to prepare the dataset for SQL processing operations.

Download

sql-scripts-cleanup-sept2012.tar.gz

SQL Processing Scripts

Description

SQL scripts used to prepare the per-unit averages used for statistical processing of the September 2012 data.

Why We Provide It

These scripts are provided for full transparency and to facilitate researchers in examining the data. The SQL scripts process data to to prepare for use in statistical processing.

Download

sql-scripts-processing-apr-2012.tar.gz

Unit Profile

Description

This document identifies the various details of each test unit, including ISP, technology, service tier, and general location. Each unit represents one volunteer panelists. The unit ID's were random, which served to protect the anonymity of the volunteer panelists. Technical note: This is a large, normalized data set which expands to multiple files. To use this data you will most likely need to import it into a relational databases.

Why We Provide It

This data is provided as reference look up information for the individual units running tests.

Download

FCC_unit-profile-april-Sept12.xlsx

Excluded Units

Description

A listing of units excluded from the statistical analysis with brief notations as to why.

Why We Provide It

This list is provided for transparency and identifies those units that were excluded from the validated March results used for the statistical analysis. Test results from the excluded units are contained in the Raw Bulk Data files (published soon).

Download

Excluded_units_Sept_2012.xlsx

Unit Census Block

Description

This spreadsheet identifies the census block in which each unit running test is located. Census block is from 2000 census and is in the FIPS block code format. No block contains less that 35 people.

Why We Provide It

To identify the general geographic location of the unit running the test.

Download

Unit_ID_Census_Block_Group (38 KB download, 38 KB expanded)

Validated September Data

Description

This document contains the validated September 2012 data set that was used to produce the Report. It includes the detailed results for all 13 tests that were run as part of this study, in addition to the results of a separate quality metric run to assess which reporting units were available. The September 2012 data set was validated as discussed in the Report and Technical Appendix; further details can be found in the Methodology section of this page. Technical note: This is a large, normalized data set which expands to multiple files. To use this data you will most likely need to import it into a relational database.

Why We Provide It

The validated data is provided for full transparency and to enable researchers to conduct their own analysis from a common pool of data.

Download

September 2012 Validated Data

close
FCC

You are leaving the FCC website

You are about to leave the FCC website and visit a third-party, non-governmental website that the FCC does not maintain or control. The FCC does not endorse any product or service, and is not responsible for, nor can it guarantee the validity or timeliness of the content on the page you are about to visit. Additionally, the privacy policies of this third-party page may differ from those of the FCC.