E-rate Request for Discount on Services: Connectivity Information (FCC Form 471 and Related Information)

opendata.usac.org | Last Updated 31 May 2018

This collection contains connectivity data about the Funding Request Number (FRN) listed within each FCC Form 471, including service type, contract information, service provider data, and cost for the service, as well as related information from the E-rate Productivity Center (EPC).

Tags: schools, libraries, schools & libraries, schools and libraries, sid, e-rate, erate, e rate, form 471, 471, connectivity information, applicant information, applicant, applicant contact information, usac, broadband, usf, universal service fund

This dataset has the following 26 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Application Numberapplication_numbertextUnique application number is generated at the time an applicant begins to file FCC Form 471. Applicants can request funding for multiple services under the same application number.
Funding Yearfunding_yeartextFunding year for the application.
Billed Entity Stateorg_statetextApplicant's state.
Form Versionform_versiontextIndicates whether the form version of the application is "current" or "original." It can be used to aggregate the data between current and original applications. "Current" is the view of the form processed by USAC. "Original" is the view of the form originally submitted by the applicant upon certification.
Window Statusis_certified_in_windowtextIndicates whether the application has been certified in the window.
Parent's Billed Entity Numberepc_organization_idtextBilled entity number for applicant.
Applicant's Organization NamenametextApplicant's Organization Name.
Contact Emailcnct_emailtextEmail Address of the main contact provided by the applicant on the FCC Form 471.
Aggregated Internet AccessaggregatedtextAggregate Internet Access for the Entire District.
Download Speeddownload_speednumberInternet download speed reported for a parent entity. This information needs to be seen in context of the corresponding speed unit.
Form 471 Download Speed Unit Nameform_471_download_speed_unit_nametextInternet download speed unit for the parent entity (e.g. Mbps or Gbps).
Upload Speedupload_speednumberInternet upload speed for a parent entity. This information needs to be seen in context of the corresponding speed unit.
Upload Speed Unitform_471_upload_speed_unit_nametextUpload speed units (Mbps or Gbps) for the parent entity.
Connection Type Nameconnection_type_nametextConnection type for a parent entity (e.g. Dark Fiber, Wireless data service, Broadband Over Power Lines etc.).
Wi-Fi Qualitywifi_quality_nametextWi-Fi quality/sufficiency for the parent entity (e.g. Completely, Mostly, Sometimes etc.).
Connectivity's Barrier Nameconnectivity_barriers_nametextConnectivity barriers for a robust network for a parent entity (e.g. Equipment too costly, Outdated equipment, Physical structure or layout of building etc.).
Other Barrier Textother_barrier_texttextDescriptive information about the barrier when an applicant selects "Other" among the pre-populated connectivity barrier options available on the FCC Form 471 application.
Child Entity's Namechild_nametextName of child entity.
Child Entity's Numberchild_bentextEntity number for a child entity.
Child Entity's Download Speedchild_download_speednumberInternet download speed reported for the child entity. This information needs to be seen in context of the corresponding speed unit.
Child Entity's Form 471 Download Speed Unit Namechild_form_471_download_speed_unit_nametextInternet download speed unit for the child entity (e.g. Mbps or Gbps).
Child Entity's Upload Speedchild_upload_speednumberInternet upload speed reported for the child entity. This information needs to be seen in context of the corresponding speed unit.
Child Entity's Form 471 Upload Speed Unit Namechild_form_471_upload_speed_unit_nametextInternet upload speed unit for the child entity (e.g. Mbps or Gbps).
Child Entity's Connection Typechild_conn_typtextConnection type for a child entity (e.g. Dark Fiber, Wireless data service, Broadband Over Power Lines etc.)
Child Entity's Wi-Fi Qualitychild_wifitextWi-Fi quality/sufficiency for the child entity e.g. Completely, Mostly, Sometimes etc.
Child Entity's Barrierschild_barrierstextConnectivity barriers for a robust network for a child entity e.g. Equipment too costly, Outdated equipment, Physical structure or layout of building etc.