Tyler Data & Insights

Close
Author
Lorenzo Sanchez
Description
This dataset contains data from each Emergency Connectivity Fund (ECF) FCC Form 471 including applicant details such as applicant type, Billed Entity Number (BEN), student count, dollars requested and approved, as well as related information from the ECF portal; data from each Funding Request Number (FRN) including service provider and contract information, Funding Commitment Decision Letter (FCDL) related data, and invoicing details; and data from each FRN line item ID including individual product/service data, costs, quantities, and descriptions.
Category
Emergency Connectivity Fund
Tags
school, schools, schools & libraries, schools and libraries, form 471, 471, basic information, applicant information, applicant, applicant contact information, usac, broadband, emergency connectivity fund, connectivity information, connectivity data, funding request, funding request number, funding request number data, service type, contract information, service provider data, cost data, frn, frn line items, ecf, frn line item id
Rating
Current value: 0 out of 5
Data Provided By
USAC
Source Link
http://opendata@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:

Application Number
application_number
Form Version
form_version
Form PDF
form_pdf
Application Status
application_status
Application Nickname
application_nickname
Filing Window
filing_window
Applicant Name
applicant_name
Billed Entity Address
billed_entity_address
Billed Entity City
billed_entity_city
Billed Entity State
billed_entity_state
Billed Entity ZIP code
billed_entity_zip_code
Billed Entity ZIP Code Ext
billed_entity_zip_code_ext
Billed Entity Number (BEN)
billed_entity_number
FCC Registration Number
fcc_registration_number
Applicant Type
applicant_type
Applicant Subtype
applicant_subtype
Contact Name
contact_name
Contact Phone
contact_phone
Contact Email
contact_email
Consulting Firm
consulting_firm
Total Student Count
total_student_count
Urban/ Rural Status
urban_rural_status
Selected Members Entity Data
selected_members_entity_data
Total Count of Selected Members
total_count_of_selected_members
Unmet Student Needs 1 (At start of pandemic lacked access to device)
unmet_student_needs_1
Unmet Student Needs 2 (At start of pandemic lacked access to connection)
unmet_student_needs_2
Unmet Student Needs 3 (At start of pandemic lacked access to device and connection)
unmet_student_needs_3
Unmet Student Needs 4 (During 2020-2021 provided access to device)
unmet_student_needs_4
Unmet Student Needs 5 (During 2020-2021 provided access to connection)
unmet_student_needs_5
Unmet Student Needs 6 (During 2020-2021 provided access to device and connection)
unmet_student_needs_6
Unmet Student Needs 7 (With ECF funding will provide access to device)
unmet_student_needs_7
Unmet Student Needs 8 (With ECF funding will provide access to connection)
unmet_student_needs_8
Unmet Student Needs 9 (With ECF funding will provide access to device and connection)
unmet_student_needs_9
Unmet Student Needs 10 (After ECF funding will lack access to device)
unmet_student_needs_10
Unmet Student Needs 11 (After ECF funding will lack access to connection)
unmet_student_needs_11
Unmet Student Needs 12 (After ECF funding will lack access to device and connection)
unmet_student_needs_12
Total Funding Commitment Request Amount
total_funding_commitment_request_amount
Certified DateTime
certified_datetime
Window Status
window_status
Last Updated DateTime
last_updated_datetime
Funding Request Number (FRN)
funding_request_number
Funding Request Status
funding_request_status
Funding Request Nickname
funding_request_nickname
Service Type
service_type
Agreement Type
agreement_contract_type
Service Provider Name
service_provider_name
Service Provider Identification Number (SPIN)
service_provider_identification_number
Service Start Date
service_start_date
Service End Date
service_end_date
Invoicing Method
invoicing_method
New Construction or Self-Provisioned Network
new_construction_self_provisioned_network
Funding Request Narrative
funding_request_narrative
FRN Recurring Charges
frn_recurring_charges
FRN One-time Charges
frn_one_time_charges
FRN Total Charges
frn_total_charges
FRN Approved Amount
frn_approved_amount
FRN Recipients of Service (ROS) Entity Data
recipients_of_service_entity_data
FRN Total Count of Recipients of Service
frn_total_count_of_recipients_of_service
Invoice Deadline Date
invoice_deadline_date
Service Delivery Date
service_delivery_date
Obligation File #
obligation_file
FCDL Date
fcdl_date
FCDL Comment for FRN
fcdl_comment_for_frn
FRN Authorized Disbursement
frn_authorized_disbursement
FRN Line Item ID
frn_line_id
Product Type
product_type
Product Make
product_make
Product Model
product_model
Connection Type
connection_type
Bandwidth Download (Mbps)
bandwidth_download
Bandwidth Upload (Mbps)
bandwidth_upload
Firewall Included
firewall_included
Network Equipment Type
network_equipment_type
Network Equipment Make/ Model
network_equipment_make_model
Monthly Recurring Unit Cost
monthly_recurring_unit_cost
Monthly Quantity
monthly_quantity
Line Item ID Months of Service
line_id_months_of_service
Line Total Recurring Costs
line_total_recurring_costs
One-time Unit Cost
one_time_unit_cost
One-time Unit Quantity
one_time_unit_quantity
Line Total One-time Costs
line_total_one_time_costs
Line Total Cost
line_total_cost

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.