E-rate Recipient Details And Commitments

opendata.usac.org | Last Updated 5 Nov 2018

This dataset combines key fields captured from the E-rate Form 471 (Basic Information, FRN Status, FRN Line Items, Recipients Of Service, and Supplemental Entity Information).

Tags: schools, libraries, schools & libraries, schools and libraries, sld, e-rate, erate, e rate, form 471, 471, discount on services, basic information, applicant information, applicant, usac, broadband, usf, universal service fund, frn, frn line items, funding request number, service type, category of service, service provider, fiber, recipients of service, recipient information, recipients, entity information

This dataset has the following 69 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Recipient Entity Numberros_entity_numbertextThe number of the recipient of service assigned by USAC.
Recipient Entity Nameros_entity_nametextThe name of the recipient of service.
Recipient Entity Typeros_entity_typetextThe type of the recipient of service entity including school district, school, library system, library, consortium, and non-instructional facility (NIF).
Is Recipient Independent?is_school_library_independenttextA school/library is listed as independent (Yes) if it is not part of a school district/library system.
Recipient Tribal Typetribal_typetextIndicates if the school or library is maintained by a tribal government.
Recipient Subtyperos_subtypetextDescribes the type of school or library. Examples include: Public School, Private School, Research Library, Bookmobile, etc.
Recipient Statusros_statustextIndicates if an organization is active (open) or closed.
Recipient Physical Addressros_physical_addresstextStreet address where the recipient is located.
Recipient Physical Address 2ros_physical_address_2textAdditional recipient address information if applicable.
Recipient Physical Cityros_physical_citytextCity where the recipient is located.
Recipient Physical Stateros_physical_statetextU.S. state or territory where the recipient is located.
Recipient Physical Zip Coderos_physical_zipcodetextZip code for the recipient.
Recipient Physical Zip Code Extros_physical_zipcode_exttextFour-digit ZIP code extension for the recipient if applicable.
Recipient Physical Countyros_physical_countytextCounty where the recipient is located.
Recipient Latituderos_latitudenumberSystem-generated latitude coordinate of the recipient based on the physical address.
Recipient Longituderos_longitudenumberSystem-generated longitude coordinate of the recipient based on the physical address.
Recipient Congressional Districtros_congressional_districttextCongressional district in which the recipient is located.
Recipient Urban/Rural Statusros_urban_rural_statustextUser-entered urban/rural status for the recipient.
Recipient Square Footageros_square_footagenumberTotal interior area of the recipient library measured in square footage.
Recipient Total Number of Full-Time Studentsros_number_of_full_time_studentsnumberThe total number of full-time students for the recipient school.
Recipient Total Number of Part-Time Studentsros_total_number_of_part_time_studentsnumberThe total number of part-time students for the recipient school.
Recipient Peak Number of Part-Time Studentsros_peak_number_of_part_time_studentsnumberThe peak number of part-time students for the recipient school.
Recipient Number of NSLP Studentsros_number_of_nslp_studentsnumberNumber of students or calculated number of students eligible for the National School Lunch Program (NSLP) at the recipient school.
Billed Entity Numberbilled_entity_numbertextE-Rate Billed Entity Number for the FCC Form 471 applicant.
Billed Entity Nameorganization_nametext10-digit number that the FCC assigns to a business or individual that registers with the FCC.
Billed Entity Typeorganization_entity_type_nametextApplicant type including: school, school district, library, library system, or consortia.
Billed Entity Addressorg_address1textApplicant street address line 1.
Billed Entity Cityorg_citytextApplicant city.
Billed Entity Stateorg_statetextApplicant state.
Billed Entity Zip Codeorg_zipcodetextApplicant zip code.
Billed Entity Congressional Districtorg_congressional_districttextCongressional district in which the applicant is located.
Funding Yearfunding_yeartextFunding year for the FCC Form 471.
Application Numberapplication_numbertextUnique application number generated at the time an applicant begins to file the FCC Form 471 application. Applicants can request funding for multiple services under the same application number.
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.
Window Statusis_certified_in_windowtextIndicates whether the application has been certified during the FCC Form 471 application filing window.
Form Statusform_471_status_nametextCurrent status of the FCC Form 471. It can be used to filter the following statuses: Certified and Committed.
FRN Statusform_471_frn_status_nametextStatus of the funding request. It includes pending, funded, denied or cancelled.
FRN Pending Reasonpending_reasontextIndicates the review status of the Funding request. Pending Reason is limited to Current (Committed) forms.
Service Provider Namespin_nametextService provider name for the FRN.
Service Provider Numberspin_numbertextUnique nine-digit number assigned to identify the service provider.
Categories of Servicechosen_category_of_servicetextCategory of service for the funding requested.
Service Typeform_471_service_type_nametextFRN service type including Voice; Data Transmission and/or Internet Access; Basic Maintenance of Internal Connections; Internal Connections; or Managed Internal Broadband Services.
Fiber Typeform_471_frn_fiber_type_nametextFiber type for fiber FRNs including Lit Fiber, Dark Fiber, or Self Provisioned Fiber.
Fiber Sub Typeform_471_frn_fiber_sub_type_nametextFiber subtypes for fiber FRNs. Options include maintenance and operation, network equipment, network equipment and maintenance, or special construction.
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.
Upload Speedupload_speednumberInternet upload speed of the connection for the FRN line item. It can be used to filter list of FRN line items with certain range of upload speed.
Upload Speed Unitform_471_upload_speed_unit_nametextUpload speed units ( Mbps or Gbps) for the FRN line item service.
Download Speeddownload_speednumberInternet download speed of the connection for the FRN line item. It can be used to filter list of FRN line items with certain range of download speed.
Download Speed Unitform_471_download_speed_unit_nametextInternet download speed unit (e.g. Mbps or Gbps) for FRN line item.
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 Months 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 pre-discount eligible one-time charges of a funding request.
FRN Line Total Pre-Discount Costpre_discount_extended_eligible_line_item_costsnumberTotal eligible costs for the funding year prior to applying a discount for the FRN line item.
Discount Percentagedis_pctnumberDiscount rate applied to service or equipment for the FRN.
FRN Line Total Post-Discount Costpost_discount_extended_eligible_line_item_costsnumberTotal eligible costs for the funding year after applying a discount for the FRN line item.
FRN Line Total Post-Discount Applicant Sharepost_discount_applicant_sharenumberTotal applicant share of eligible costs for the funding year after applying a discount for the FRN line item.
Cost Allocationoriginal_allocationnumberCost allocation for the recipient of service for Category Two products and services.
Number of Linesqty_allocationnumberNumber of lines allocated to a recipient of service for Category One services.