USAC E-Rate School & Library IT Procurement + Subsidy Intelligence Scraper

1. Who Buys This Data & How They Use It

• Target Paying Buyers:

  • K-12 & SLED Value-Added Resellers (VARs) & Managed Service Providers (MSPs) (e.g., CDW-G, SHI International, ConvergeOne, Presidio, Netsync, and regional K-12 IT integrators) bidding on open Category 2 internal network refreshes.
  • Enterprise Networking & Cybersecurity OEM Field Sales Teams (Cisco Meraki, HPE Aruba Networking, Fortinet, Palo Alto Networks, Extreme Networks, Ruckus, APC/Schneider Electric, Ubiquiti) tracking school districts requesting their hardware or open equivalents.
  • Fiber, Lit/Dark Transport & Enterprise ISP Account Executives (Crown Castle, AT&T, Spectrum Enterprise, Comcast Business, regional fiber providers) bidding on Category 1 WAN and dedicated internet access circuits.
  • E-Rate Consulting Firms & SLED Capture Teams identifying high-subsidy districts (80%–90% federal Universal Service Fund discount) where the local school board only pays 10–20 cents on the dollar.

• Immediate 5-Minute Buyer Workflows:

  • Cold Email Sequencers (Instantly.ai, Smartlead, Apollo, Lemlist): Map contact_first_name, contact_last_name, contact_email, organization_clean_name, and outreach_icebreaker directly into outbound sequences. Because USAC Form 470 filings frequently list external E-Rate consultants (@vstservices.com, @erateelite.com, @adtecerate.com) in the primary filing contact slot, this scraper disambiguates and promotes the verified internal school/library IT or procurement decision-maker (contact_email on the institution's own domain) while preserving the designated Form 470 RFP Bid Contact & Consulting Firm in dedicated columns (rfp_bid_contact_name, rfp_bid_contact_type, rfp_bid_contact_email, erate_consulting_firm).
  • Power Dialers (Orum, Nooks, RingCentral, GoHighLevel): Dial contact_phone_e164 (+1XXXXXXXXXX) or contact_phone_formatted sorted by allowable_contract_award_date (the mandatory 28-day competitive bidding close window).
  • Clay.com / HubSpot / Salesforce Territory Scoring: Enrich against organization_domain, filter numerically on erate_discount_rate_pct_num (>= 80), historical_erate_committed_usd_num, entities_served_count_num, and district_student_enrollment_num, and displace incumbent SPIN vendors listed in incumbent_it_service_providers.

---

2. Entity-Pure 4-Table Relational LEFT JOIN Architecture (Zero UNION ALL)

Every output record represents 1 distinct K-12 school district, charter/private school, or public library system (billed_entity_number_num) with an active, certified USAC FCC Form 470 RFP (application_number_num), enriched via 3 relational LEFT JOIN queries against official USAC Open Data Socrata APIs:

1. Base Entity Table (opendata.usac.org/resource/jp7a-89nd.json — Form 470 Basic Information):
   • Certified FCC Form 470 competitive IT/Telecom RFPs ordered by certified_datetime DESC and deduplicated by ben (billed_entity_number_num) so every row represents a distinct buying institution.
   • Extracts application_number_num, billed_entity_number_num, fcc_registration_number, rfp_certified_date, allowable_contract_award_date, form_470_pdf_url, technical contact, procurement contact, and authorized official metadata.
2. LEFT JOIN 1 (opendata.usac.org/resource/39tn-hjzv.json — Form 470 Requested Services & Function Categories):
   • Joined strictly on application_number = application_number_num.
   • Extracts service_category (Category 1, Category 2, or Category 1 & Category 2), requested_service_types, requested_functions (Switches, Wireless Access Points, Firewalls, UPS/Battery Backup, Cabling, Leased Lit Fiber), requested_manufacturers, and rfp_line_items_count_num.
3. LEFT JOIN 2 (opendata.usac.org/resource/srbr-2d59.json — Form 471 Historical Funding Commitments & Incumbent Vendors):
   • Joined strictly on ben = billed_entity_number_num.
   • Aggregates historical committed E-Rate funding (historical_erate_committed_usd_num, historical_erate_committed_formatted, historical_awards_count_num), extracts the institution's federal E-Rate subsidy rate (erate_discount_rate_pct_num, erate_discount_rate_formatted), ranks the top 3 historical incumbent IT/telecom vendors (incumbent_it_service_providers) with committed dollar totals, and resolves the internal EPC account_administrator_name.
4. LEFT JOIN 3 (opendata.usac.org/resource/9s6i-myen.json — Form 471 Basic Information & Student Enrollment):
   • Joined strictly on epc_organization_id = billed_entity_number_num.
   • Enriches district_student_enrollment_num and historical internal executive job titles (Director of Network Systems, Purchasing Manager, Technology Director, Chief School Business Official (CSBO)).

---

3. Complete Output Schema (43 Buyer-Ready Columns)

Field Name	Type	Gate	Description
application_number_num	string (numeric)	Gate 1 & 5	Primary Entity Key: USAC FCC Form 470 Application Number
billed_entity_number_num	string (numeric)	Gate 1 & 5	USAC Billed Entity Number (BEN) uniquely identifying the institution
fcc_registration_number	string	Gate 1	10-digit FCC Registration Number (FRN)
funding_year_num	string (numeric)	Gate 5	USAC E-Rate Funding Year (e.g., "2027")
rfp_certified_date	string (ISO date)	Gate 6	ISO YYYY-MM-DD date the Form 470 RFP was certified
allowable_contract_award_date	string (ISO date)	Gate 6	ISO YYYY-MM-DD mandatory 28-day competitive bidding close date
organization_clean_name	string	Gate 3	Clean Title-Case institution name with USAC abbreviations expanded
organization_raw_name	string	Gate 3	Original USAC billed_entity_name
applicant_type	string	Gate 1	School District, School, Library System, or Library
organization_domain	string	Gate 3	Verified root domain of the school district, school, or library
entities_served_count_num	string (numeric)	Gate 5	Number of eligible campuses or library branches served
district_student_enrollment_num	string (numeric)	Gate 5	Full-time student enrollment joined from USAC Form 471
service_category	string	Left Join 1	Category 1, Category 2, or Category 1 & Category 2
requested_service_types	string	Left Join 1	Semicolon-separated E-Rate service types requested
requested_functions	string	Left Join 1	Semicolon-separated hardware/telecom functions requested
requested_manufacturers	string	Left Join 1	Preferred OEM manufacturers or open competitive bidding status
rfp_line_items_count_num	string (numeric)	Gate 5	Number of Form 470 service request line items (39tn-hjzv)
rfp_technical_scope_summary	string	Base + Join 1	Concise technical scope and walk-through summary from the Form 470
erate_discount_rate_pct_num	string (numeric)	Gate 5	Federal E-Rate subsidy percentage (20 to 90)
erate_discount_rate_formatted	string	Left Join 2	Formatted federal subsidy and local district co-pay percentage
historical_erate_committed_usd_num	string (numeric)	Gate 5	Total historical USAC Form 471 committed E-Rate funding in USD
historical_erate_committed_formatted	string	Left Join 2	Formatted currency string of historical E-Rate commitments
historical_awards_count_num	string (numeric)	Gate 5	Count of funded historical Form 471 commitments for this BEN
incumbent_it_service_providers	string	Left Join 2	Top 3 historical incumbent SPIN vendors with committed USD totals
procurement_buying_signal	string	Left Join 2	Actionable B2B buying signal combining subsidy rate and historical spend
contact_first_name	string	Gate 2	Clean Title-Case first name of the internal decision-maker
contact_last_name	string	Gate 2	Clean Title-Case last name of the internal decision-maker
contact_full_name	string	Gate 2	Clean full name of the internal decision-maker
contact_role_title	string	Gate 2	Clean job title of the internal decision-maker
contact_email	string	Gate 4	Single verified internal school/library email address
contact_phone_e164	string	Gate 4	E.164 phone number (+1XXXXXXXXXX) for power dialers
contact_phone_formatted	string	Gate 4	Formatted US phone number ((XXX) XXX-XXXX)
rfp_bid_contact_name	string	Gate 4	Designated Form 470 RFP bid contact name
rfp_bid_contact_type	string	Gate 4	External E-Rate Consultant or Internal School/Library Contact
rfp_bid_contact_email	string	Gate 4	Designated Form 470 RFP bid submission email
erate_consulting_firm	string	Gate 4	External E-Rate consulting firm name or Self-Filed (In-House IT/Procurement Team)
org_street_address	string	Gate 6	Clean Title-Case street address
org_city	string	Gate 6	Clean Title-Case city
org_state	string	Gate 6	2-letter uppercase US state code
org_zip	string	Gate 6	5-digit US ZIP code
org_country	string	Gate 6	ISO country code ("US")
form_470_pdf_url	string	Base	Direct official URL to the certified USAC FCC Form 470 PDF
outreach_icebreaker	string	Gate 7	Ready-to-send personalized B2B cold outreach hook

---

4. Sample Enriched Record

{
  "application_number_num": "270003748",
  "billed_entity_number_num": "126392",
  "fcc_registration_number": "0011835683",
  "funding_year_num": "2027",
  "rfp_certified_date": "2026-11-05",
  "allowable_contract_award_date": "2026-12-03",
  "organization_clean_name": "Anne Arundel County Public Schools",
  "organization_raw_name": "Anne Arundel County Public Schools",
  "applicant_type": "School District",
  "organization_domain": "aacps.org",
  "entities_served_count_num": "131",
  "district_student_enrollment_num": "81641",
  "service_category": "Category 2",
  "requested_service_types": "Internal Connections",
  "requested_functions": "Firewall Services, Components, and Necessary Software and Licenses",
  "requested_manufacturers": "Open Competitive Bidding (Any E-Rate Eligible Vendor)",
  "rfp_line_items_count_num": "1",
  "rfp_technical_scope_summary": "Anne Arundel County Public Schools (AACPS) is seeking proposals for the following products. These products are known to meet the needs and specifications of AACPS and are compatible with the existing network infrastructure. In...",
  "erate_discount_rate_pct_num": "60",
  "erate_discount_rate_formatted": "60% Federal Subsidy (40% Local Co-Pay)",
  "historical_erate_committed_usd_num": "51043197",
  "historical_erate_committed_formatted": "$51,043,197",
  "historical_awards_count_num": "46",
  "incumbent_it_service_providers": "Anne Arundel County, Maryland ($40,497,772); DISYS Solutions ($7,192,993); Allied Telecom Group ($1,540,718)",
  "procurement_buying_signal": "ENTERPRISE_REPEAT_ERATE_BUYER ($51,043,197 Historical E-Rate Commitments · 60% Federal Subsidy)",
  "contact_first_name": "Mark",
  "contact_last_name": "Robbins",
  "contact_full_name": "Mark Robbins",
  "contact_role_title": "Form 470 Technical Contact & IT Lead",
  "contact_email": "mrobbins@aacps.org",
  "contact_phone_e164": "+14102225331",
  "contact_phone_formatted": "(410) 222-5331",
  "rfp_bid_contact_name": "Chris Lenhardt",
  "rfp_bid_contact_type": "External E-Rate Consultant",
  "rfp_bid_contact_email": "clenhardt@erateelite.com",
  "erate_consulting_firm": "E-Rate Elite Services",
  "org_street_address": "2644 Riva Road",
  "org_city": "Annapolis",
  "org_state": "MD",
  "org_zip": "21401",
  "org_country": "US",
  "form_470_pdf_url": "https://publicdata.usac.org/EPC/Prd/Form470/270003748/126392/22893575-USAC_FCC_FORM_470_APPLICATION_270003748_CERTIFIED.pdf",
  "outreach_icebreaker": "Hi Mark, saw Anne Arundel County Public Schools' certified Category 2 Form 470 (#270003748) for firewall services and components ahead of the 2026-12-03 allowable contract date. With your 60% E-Rate discount rate (40% local co-pay) and prior work with DISYS Solutions, we'd love to submit a competitive SPIN-eligible quote (and can copy Chris Lenhardt at E-Rate Elite Services on formal bid documents)."
}