Socrata

Close
Author
Tom Nesbitt
Description
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).
Category
E-rate
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
Rating
Current value: 0 out of 5
Data Provided By
Universal Service Administrative Company
Source Link
http://usac.org
License
Public Domain
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Recipient Entity Number
ros_entity_number
Recipient Entity Name
ros_entity_name
Recipient Entity Type
ros_entity_type
Is Recipient Independent?
is_school_library_independent
Recipient Tribal Type
tribal_type
Recipient Subtype
ros_subtype
Recipient Status
ros_status
Recipient Physical Address
ros_physical_address
Recipient Physical Address 2
ros_physical_address_2
Recipient Physical City
ros_physical_city
Recipient Physical State
ros_physical_state
Recipient Physical Zip Code
ros_physical_zipcode
Recipient Physical Zip Code Ext
ros_physical_zipcode_ext
Recipient Physical County
ros_physical_county
Recipient Latitude
ros_latitude
Recipient Longitude
ros_longitude
Recipient Congressional District
ros_congressional_district
Recipient Urban/Rural Status
ros_urban_rural_status
Recipient Square Footage
ros_square_footage
Recipient Total Number of Full-Time Students
ros_number_of_full_time_students
Recipient Total Number of Part-Time Students
ros_total_number_of_part_time_students
Recipient Peak Number of Part-Time Students
ros_peak_number_of_part_time_students
Recipient Number of NSLP Students
ros_number_of_nslp_students
Billed Entity Number
billed_entity_number
Billed Entity Name
organization_name
Billed Entity Type
organization_entity_type_name
Billed Entity Address
org_address1
Billed Entity City
org_city
Billed Entity State
org_state
Billed Entity Zip Code
org_zipcode
Billed Entity Congressional District
org_congressional_district
Funding Year
funding_year
Application Number
application_number
Funding Request Number
funding_request_number
FRN Line Item Number
form_471_line_item_number
Window Status
is_certified_in_window
Form Status
form_471_status_name
FRN Status
form_471_frn_status_name
FRN Pending Reason
pending_reason
Service Provider Name
spin_name
Service Provider Number
spin_number
Categories of Service
chosen_category_of_service
Service Type
form_471_service_type_name
Fiber Type
form_471_frn_fiber_type_name
Fiber Sub Type
form_471_frn_fiber_sub_type_name
Function Type
form_471_function_name
Product Type
form_471_product_name
Upload Speed
upload_speed
Upload Speed Unit
form_471_upload_speed_unit_name
Download Speed
download_speed
Download Speed Unit
form_471_download_speed_unit_name
FRN Line Monthly Cost
total_monthly_cost
FRN Line Monthly Recurring Ineligible Cost
monthly_recur_ineligible_cost
FRN Line Monthly Recurring eligible unit Cost
monthly_recurring_unit_eligible_costs
FRN Line Monthly Quantity
monthly_quantity
FRN Line Monthly Eligible Recurring Costs
total_monthly_eligible_recurring_costs
FRN Line Months of Service
months_of_service
FRN Line Eligible Recurring Cost
total_eligible_recurring_costs
FRN Line One-Time Cost
total_one_time_cost
FRN Line One-time Ineligible Unit Costs
one_time_ineligible_cost
FRN Line One-time Eligible Unit Cost
one_time_eligible_costs
FRN Line One-Time Quantity
one_time_quantity
FRN Line Eligible One Time Cost
total_eligible_one_time_costs
FRN Line Total Pre-Discount Cost
pre_discount_extended_eligible_line_item_costs
Discount Percentage
dis_pct
FRN Line Total Post-Discount Cost
post_discount_extended_eligible_line_item_costs
FRN Line Total Post-Discount Applicant Share
post_discount_applicant_share
Cost Allocation
original_allocation
Number of Lines
qty_allocation

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.