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

opendata.usac.org | Last Updated 21 Sep 2018

This dataset contains information about the FRN line items within each FCC Form 471, including individual product/service data, costs, quantities, and descriptions.

Tags: schools, libraries, schools & libraries, schools and libraries, sld, e-rate, erate, e rate, form 471, 471, basic information, applicant information, applicant, applicant contact information, usac, broadband, usf, universal service fund, frn, frn line items, funding request number

This dataset has the following 42 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 StatestatetextApplicant 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.
Billed Entity NumberbentextUnique billed entity number associated with the entity name on the FCC Form 471 application.
Applicant's Organization Nameorganization_nametextApplicant organization name.
Contact Emailcnct_emailtextEmail Address of the main contact provided by the applicant on the FCC Form 471.
Funding Request Numberfunding_request_numbertextUnique funding request number associated with the FCC Form 471.
FRN Line Item Numberform_471_line_item_numbertextFunding request line item number can be used to filter the records associated to a specific FRN line item
Function Typeform_471_function_nametextAdditional information about the FRN line item service or product. Examples include: routers, switches, copper, fiber, wireless, cabling/connectors, and racks.
Product Typeform_471_product_nametextProduct or service type for the FRN line Item. Examples include: ATM, data plan for portable device, OC-1, connectors, DS-4, and frame relay.
Purpose Typeform_471_purpose_nametextService purpose for the FRN Line Item. It can be used to filter the records of a particular type of purpose. There are five purposes: Backbone circuit for consortium that provides connectivity between aggregation points or other non-user facilities; Data Connection between two or more sites entirely within the applicant’s network; Data connection(s) for an applicant’s hub site to an Internet Service Provider or state/regional network where Internet access service is billed separately; and Internet access service with no circuit (data circuit to ISP state/regional network is billed separately).
Upload Speedupload_speednumberUpload speed for the FRN line item service.
Upload Speed Unitform_471_upload_speed_unit_nametextUpload speed units ( Mbps or Gbps) for the FRN line item service.
Download Speeddownload_speednumberDownload speed of the connection for the FRN line item service.
FCC Form 471 Download Speed Unitform_471_download_speed_unit_nametextInternet download speed unit (e.g. Mbps or Gbps) for FRN line item.
Burstable Speedburstable_speednumberFRN service maximum burstable speed.
Burstable Speed Unitform_471_burstable_unit_nametextBurstable speed unit ( Mbps or Gbps) for FRN line item.
Service Includes Basic Firewall Protectionfirewall_indicatortextIndicates if the service provider provides basic firewall protection as a standard component of the Internet access for the FRN line item.
Direct Connection to school, library or NIFconnection_directly_schooltextIndicates whether the service provider provides internet service directly to the School, Library or NIF or if it uses an Internet circuit to a district hub to connect.
Support Connection to school, library or NIFconnection_supports_servicetextIndicator whether the service provider provides a connection between eligible Schools, Libraries, and NIFs (i.e., a connection that provides a wide area network (WAN)).
Connection Used Byconnection_used_bytextNumber of buildings/sites that will use the connections listed in this FRN line item. Options include all buildings/sites listed; one building/site listed; or multiple buildings/sites listed.
Makeform_471_manufacturer_nametextManufacturer for the FRN line item product.
Other Manufacturer Descriptionother_manufacturer_desctextManufacturer not included in the drop down list.
Equipment Modelmodel_of_equipmenttextModel of the equipment on FRN Line Item. It can be used to filter FRN Line items of a particular model.
Installation included in pricepricetextIndicates whether the equipment installation is included in the price.
Leased or Non-Purchased Agreement?leasetextIndicates whether the equipment has been leased or has a non-purchase agreement for internal connection.
Unit Nameform_471_unit_nametextUnits of product or service for the FRN line item. Examples include: each, dozen, per foot, per hundred feet, or hours.
FRN Line Monthly Costtotal_monthly_costnumberTotal pre-discounted monthly charges for the FRN line item.
FRN Line Monthly Recurring Ineligible Costmonthly_recur_ineligible_costnumberTotal monthly ineligible costs for the FRN line item.
FRN Line Monthly Recurring eligible unit Costmonthly_recurring_unit_eligible_costsnumberTotal monthly eligible costs for the FRN line item.
FRN Line Monthly Quantitymonthly_quantitynumberNumber of units for the FRN line item monthly recurring costs.
FRN Line Monthly Eligible Recurring Coststotal_monthly_eligible_recurring_costsnumberPre-discounted eligible monthly charges for the FRN line item.
FRN Line Month of Servicemonths_of_servicenumberNumber of months during the funding year for the FRN line item service.
FRN Line Eligible Recurring Costtotal_eligible_recurring_costsnumberTotal pre-discounted eligible recurring charges for the FRN line item.
FRN Line One-Time Costtotal_one_time_costnumberPre-discounted non-recurring charges for the FRN line item.
FRN Line One-Time Ineligible Unit Costsone_time_ineligible_costnumberTotal one-time ineligible costs for the FRN line item.
FRN Line One-Time Eligible Unit Costone_time_eligible_costsnumberTotal one-time eligible costs for the FRN line item.
FRN Line One-Time Quantityone_time_quantitynumberQuantity for the one-time costs for the FRN line item.
FRN Line Eligible One-Time Costtotal_eligible_one_time_costsnumberTotal rediscount eligible one-time charges of a funding request. This field can be aggregated at an FRN line item level to generate metrics across service type or entities. This field should not be used to generate metrics at FRN level.
FRN Line Total Eligible Costpre_discount_extended_eligible_line_item_costsnumberTotal eligible costs for the funding year prior to applying a discount for the FRN line item.