Skip Navigation

Federal Communications Commission

English Display Options

Database Setup and Importing - Measuring Broadband America Data April 2012

Author: 
James Miller

FCC data is provided in a form that can be easily imported and manipulated.  The steps below describe how to prepare a database for manipulating FCC measurement data.

1. Getting the data from this program:

Both processed data used in reports as well as the raw unprocessed collected data is made available on the FCC website.  Data collected for the March 2011 Report is available for download here, and data for the July 2012 Report can be found here.

2. Selecting a database progam:

FCC measurement data is all released in a commonly supported comma-separated value (CSV) format and is easily imported into popular database packages.  A variety of Structured Query Language (SQL) database packages are used internally, including MySQL and Postgresql, and data processing scripts are implemented in SQL, but SQL is not a requirement for manipulating FCC data.

3.  Setting up a database for import:

A “data dictionary” and other documents describe the nature of the data stored in each field of test data provided.  The specific data type appropriate for any given field of test data may vary depending on the database application.  The SQL commands below are appropriate for creating tables for each test type, and can be used with minor modification for any SQL based database or as a reference for other applications.

MySQL Table Instantiation Sample

Postgresql Table Instantiation Sample

4.  Importing the data in my database tool:

The specific procedures for importing data into your database will vary but the references below are to MySQL and Postgresql import commands and a sample command line string to import a sample file in a local directory. 

MySQL Load Command: 

MySQL Load Command: http://dev.mysql.com/doc/refman/5.0/en/load-data.html

LOAD DATA INFILE "2011_march_httpget.csv" INTO TABLE validated_2011_march_httpget;

Postresql Copy Command:  http://www.postgresql.org/docs/8.2/static/sql-copy.html

COPY validated_2011_march_httpget FROM '2011_march_httpget.csv.txt' DELIMITERS ',' CSV;

5.  Contacting the FCC with questions about setting up or using the data:

The Measuring Broadband America Program is managed by the Office of Engineering and Technology and inquires can be directed to James Miller (James.Miller@fcc.gov) or Walter Johnston (Walter.Johnston@fcc.gov)

 

 

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.