USAC E-Rate & Rural Health Care Scraper

Extract funding data from USAC (Universal Service Administrative Company) public datasets via the Socrata Open Data API. Query E-Rate FRN status, line items, Rural Health Care subsidies, and Form 470 bids for any US state.

Features

• 4 USAC datasets — E-Rate FRN Status, E-Rate Line Items, Rural Health Care, and Form 470 Bids
• Filter by state — Query any US state by two-letter code, or leave empty for nationwide data
• Funding year range — Specify min/max funding years (data available from ~1998 to present)
• Form version filter — Pull only "Current" form versions to avoid duplicates (E-Rate datasets)
• Automatic pagination — Handles Socrata API pagination transparently
• Clean structured output — camelCase field names, numeric dollar amounts, null-safe

Datasets

Key	Socrata ID	Description
erate_frn	qdmp-ygft	E-Rate Form 471 funding requests — who got subsidies, from which provider, how much
erate_line_items	hbj5-2bpj	E-Rate line item details — technology type, equipment, bandwidth, costs
rural_health_care	2kme-evqq	Rural Health Care program — hospital/clinic subsidies, provider names, service details
form470_bids	jt8s-3q52	Form 470 bidding data — what entities are requesting, service categories

Input

Field	Type	Default	Description
dataset	string	erate_frn	Which USAC dataset to query (required)
state	string	""	Two-letter US state code (empty = all states)
fundingYearMin	integer	2016	Earliest funding year
fundingYearMax	integer	2026	Latest funding year
formVersion	string	Current	Form version filter (E-Rate only)
maxResults	integer	10000	Max records to return (0 = unlimited)

Output

Output fields depend on the selected dataset. All datasets include a source field identifying the dataset name and a fundingYear numeric field.

E-Rate FRN Status

Key fields: organizationName, spinName, frnStatus, serviceType, fundingCommitmentRequest, discountPercent, totalAuthorizedDisbursement, narrative, contractExpirationDate

E-Rate Line Items

Key fields: organizationName, functionName, productName, manufacturerName, modelOfEquipment, preDiscountExtendedEligibleCosts

Rural Health Care

Key fields: participatingHcpName, serviceProviderName, serviceType, totalCommittedAmount, totalAuthorizedDisbursement, downloadSpeed, uploadSpeed

Form 470 Bids

Key fields: billedEntityName, applicantType, serviceType, certifiedDateTime, contactName

Data Source

All data is pulled from USAC's public Socrata Open Data portal at opendata.usac.org. No authentication required. The data is maintained by USAC as part of its regulatory obligation to publish Universal Service Fund program data.

Legal Disclaimer

This Actor extracts publicly available data from USAC's open data portal. The data is published by USAC for public use. Users are responsible for ensuring their use of the data complies with applicable laws and regulations. This Actor does not collect personal data beyond what is publicly published in USAC's datasets.