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.

Pricing

This Actor uses pay-per-result pricing:

Event	Price
Actor Start	$0.00005
Per result	$0.002

A typical run of 1,000 records costs approximately $2.00 in Actor fees plus minimal Apify compute costs.

FAQ

Is it legal to scrape USAC E-Rate data?

Yes. This Actor accesses publicly available data from USAC's Socrata Open Data portal. The data is published by USAC as part of its regulatory obligation to publish Universal Service Fund program data. No authentication is required.

How Much Does It Cost to Scrape USAC E-Rate Data?

See the pricing table above. At $0.002 per result, fetching 10,000 E-Rate records costs approximately $20.00 in Actor fees plus minimal Apify compute costs.

Can I export E-Rate data to Excel or CSV?

Yes. Apify supports exporting results in JSON, CSV, Excel, XML, and other formats directly from the Dataset tab after a run completes.

How often is the USAC data updated?

USAC updates their open data portal regularly as funding decisions are made and disbursements are processed. You can schedule this Actor to run at any interval to capture new records.

What funding years are available?

Data is available from approximately 1998 to the present. The Actor defaults to funding years 2016-2026 but you can adjust the range.

Other Scrapers by SeatSignal

• Federal Audit Scraper — Extract federal audit and grant data from the Federal Audit Clearinghouse
• SBIR Awards Scraper — Extract government grant and contract award data
• Treasury Fiscal Data Scraper — Extract national debt, interest rates, and government financial data
• NIH Grants Scraper — Extract NIH research grant awards data
• HUD Fair Market Rents Scraper — Extract HUD housing affordability 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.