USAspending Subaward to Prime-Contractor Mapping Scraper avatar

USAspending Subaward to Prime-Contractor Mapping Scraper

Pricing

Pay per event

Go to Apify Store
USAspending Subaward to Prime-Contractor Mapping Scraper

USAspending Subaward to Prime-Contractor Mapping Scraper

Extract USAspending federal subaward records with full prime-contractor mapping: subawardee, prime contractor (name, UEI), awarding agency, amounts, NAICS, PSC, and place of performance. Built for federal contracting analytics, competitive intel, and small-business teaming discovery.

Pricing

Pay per event

Rating

0.0

(0)

Developer

BowTiedRaccoon

BowTiedRaccoon

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

5 days ago

Last modified

Share

Extracts federal subaward records from USAspending.gov and maps each one to its prime contractor. Returns subawardee name and UEI, prime contractor name and UEI, awarding agency, NAICS code, PSC code, place of performance, and dollar amounts — structured JSON for the full subaward-to-prime graph.

USAspending Subaward Scraper Features

  • Extracts subaward records with direct links to the prime award on USAspending.gov
  • Maps subawardees to prime contractors — both name and SAM.gov UEI, so you can pivot in either direction
  • Enriches from award detail — NAICS code and description, PSC code and description, prime award total obligation, and prime contractor state all come from the award detail endpoint when the search results omit them
  • Filters by award type — contracts (A/B/C/D), grants (02–05), loans, direct payments, or any combination
  • Filters by awarding agency — DoD, DoE, HHS, NASA, GSA, and 16 other top-tier federal agencies
  • Filters by NAICS code — 2, 4, or 6-digit codes (the API is strict; 3 and 5-digit prefixes are silently skipped rather than returning HTTP 400)
  • Filters by minimum dollar amount — useful when you only care about material subcontracts
  • Filters by recipient UEI — track specific companies' subcontracting activity across the federal base
  • No API key needed — USAspending.gov is a public government API, no auth required

What Can You Do With USAspending Subaward Data?

  • Competitive intelligence analysts — map which small businesses are receiving work under specific prime contracts before those relationships show up elsewhere
  • Federal BD teams — identify primes awarding subawards in your NAICS codes and reach out before the next recompete
  • Teaming consultants — find small business subcontractors already working with target primes to assess teaming fit
  • Grant researchers — trace which nonprofits and universities receive subawards under federal grants by agency and period
  • Compliance and DCAA auditors — pull subaward activity for specific primes or recipients by contract type and date range
  • Data vendors and GovTech platforms — build enriched federal contracting datasets that the standard USAspending exports don't include

How It Works

  1. Configure your filters — set award type, awarding agency, NAICS code, date range, and minimum amount. Leave everything blank for all FY2025 contract and grant subawards.
  2. The scraper queries the USAspending API — it calls POST /api/v2/search/spending_by_award/ with subawards: true, paginating through results 100 at a time. Award type groups are split into separate queries since the API requires codes from a single group per request.
  3. Each record is enriched from the award detail endpointGET /api/v2/awards/<id>/ fills in NAICS, PSC, prime contractor UEI, prime contractor state, and total obligation when the search results don't include them. Results are cached per prime award to avoid redundant calls.
  4. Clean JSON lands in your dataset — one record per subaward, ready to export.

USAspending Subaward Scraper Input

{
"awardType": ["A", "B", "C", "D"],
"awardingAgency": "Department of Defense",
"naicsCode": "541330",
"dateFrom": "2024-10-01",
"dateTo": "2025-09-30",
"minAmount": 25000,
"maxItems": 100
}
FieldTypeDefaultDescription
awardTypearrayallAward type codes. Contracts: A, B, C, D. Grants: 02–05. Loans: 07, 08. Leave blank for contracts + grants.
awardingAgencystringallTop-tier federal awarding agency name.
naicsCodestringNAICS code filter. Must be 2, 4, or 6 digits.
ueiListarraySAM.gov UEIs to filter by (subaward recipient).
dateFromstring2024-10-01Start date for subaward action date (YYYY-MM-DD).
dateTostring2025-09-30End date for subaward action date (YYYY-MM-DD).
minAmountinteger0Minimum subaward dollar amount.
maxItemsinteger15Maximum number of records to return.

USAspending Subaward Scraper Output Fields

{
"subaward_id": "2025-ESC02395-0005",
"prime_award_id": "W912DY-24-C-0017",
"subaward_type": "sub-contract",
"subawardee_name": "ACME ENVIRONMENTAL SERVICES LLC",
"subawardee_uei": "MK3G7QQTZXP6",
"subawardee_state": "VA",
"prime_contractor_name": "PRIME DEFENSE CONTRACTOR INC",
"prime_contractor_uei": "J4WB9PHQLXK7",
"prime_contractor_state": "MD",
"awarding_agency": "Department of Defense",
"awarding_subagency": "Dept of the Army",
"subaward_amount_usd": 485000,
"prime_award_amount_usd": 12400000,
"naics_code": "562910",
"naics_description": "Remediation Services",
"psc_code": "F109",
"psc_description": "ENVIRONMENTAL PROTECTION/RESTORATION: HAZARDOUS MATERIAL CONTROL",
"place_of_performance_state": "VA",
"subaward_action_date": "2025-01-15",
"description": "Environmental remediation services at Fort Belvoir",
"source_url": "https://www.usaspending.gov/award/CONT_AWD_W912DY24C0017"
}
FieldTypeDescription
subaward_idstringSubaward number / identifier
prime_award_idstringPrime award PIID (contracts) or FAIN (grants)
subaward_typestring"sub-contract" or "sub-grant"
subawardee_namestringSub-awardee (sub-recipient) name
subawardee_ueistringSub-awardee SAM.gov Unique Entity Identifier
subawardee_statestringSub-awardee location state code
prime_contractor_namestringPrime contractor / prime recipient name
prime_contractor_ueistringPrime contractor SAM.gov Unique Entity Identifier
prime_contractor_statestringPrime contractor location state code
awarding_agencystringFederal agency that made the prime award
awarding_subagencystringSub-agency within the awarding agency
subaward_amount_usdnumberSubaward dollar amount
prime_award_amount_usdnumberPrime award total obligation
naics_codestringNAICS industry code (from prime award)
naics_descriptionstringNAICS industry description
psc_codestringProduct/Service Code (from prime award)
psc_descriptionstringProduct/Service Code description
place_of_performance_statestringPlace of performance state code
subaward_action_datestringSubaward action date (YYYY-MM-DD)
descriptionstringAward description
source_urlstringLink to the prime award on USAspending.gov

🔍 FAQ

How do I scrape subaward data from USAspending.gov?

USAspending Subaward Scraper calls the public USAspending REST API — no login, no API key. Configure your filters (agency, NAICS, date range, amount), set maxItems, and run it. Results appear in the dataset within seconds for small queries; longer date ranges or unfiltered runs take a few minutes.

What data can I get from USAspending subawards?

USAspending Subaward Scraper returns subawardee name and UEI, prime contractor name and UEI, awarding agency, NAICS and PSC codes, subaward and prime award dollar amounts, place of performance, and a direct link to the prime award record — the full graph for analyzing federal subcontracting relationships.

Can I filter by NAICS code?

USAspending Subaward Scraper accepts 2, 4, or 6-digit NAICS codes (for example, "54", "5413", or "541330"). The USAspending API rejects 3 and 5-digit prefixes with HTTP 400, so the scraper validates the length before sending the request. Enter a valid length and it works. Enter an odd-length code and the NAICS filter is silently skipped rather than failing the run.

Does USAspending Subaward Scraper need proxies?

USAspending Subaward Scraper does not use proxies. USAspending.gov is a public government API that accepts datacenter IPs at a reasonable request pace. No residential proxies, no browser — just direct API calls with a 200ms courtesy delay between pages.

How much does it cost to run?

USAspending Subaward Scraper charges $0.10 per start plus $0.001 per record. A run returning 500 subawards costs around $0.60. The enrichment calls (award detail endpoint) don't add to record count — you pay per subaward saved, not per API request made.


Need More Features?

Need custom fields, additional filter types, or a bulk export mode? File an issue or get in touch.

Why Use USAspending Subaward Scraper?

  • Subaward-to-prime graph — returns both sides of the relationship (subawardee and prime contractor, with UEIs for both) in a single record, which is what you actually need for competitive analysis
  • Enriched output — NAICS, PSC, total obligation, and prime contractor state come from the award detail endpoint when the search results omit them, so you get complete records even when the base API returns partial data
  • No infrastructure needed — no API keys, no proxies, no browser automation; it calls a public government API at a courteous pace and returns structured JSON