USAspending Subaward Scraper — Prime Contractor Mapping

Extract federal subaward records from usaspending.gov with full prime contractor mapping. Returns contracts and grants flowing through prime awardees to subawardees — including UEI identifiers, NAICS codes, awarding agencies, dollar amounts, and place of performance — for government contracting intelligence, compliance monitoring, and BD pipeline analysis.

What does the USAspending Subaward Scraper do?

• Queries the USAspending.gov subawards API for contracts (Type A–D) and grants/loans (Types 02–11)
• Returns prime contractor name, UEI, and state alongside subawardee name, UEI, and state for each record
• Filters by UEI list, NAICS code (2 or 4 or 6 digits), awarding agency, date range, and minimum award amount
• Returns one record per subaward — no aggregation across the prime/sub relationship

What data does it extract?

Field	Description
subaward_id	Unique subaward identifier
prime_award_id	Prime award (FAIN or PIID) that this subaward belongs to
subaward_type	Contract subaward or grant subaward
subawardee_name	Name of the subawardee organization
subawardee_uei	Subawardee SAM.gov UEI
subawardee_state	Subawardee state
prime_contractor_name	Name of the prime contractor or grantee
prime_contractor_uei	Prime's SAM.gov UEI
prime_contractor_state	Prime contractor state
awarding_agency	Awarding federal agency name
awarding_subagency	Awarding subagency or component
subaward_amount_usd	Subaward dollar amount
prime_award_amount_usd	Total prime award dollar amount
naics_code	NAICS code for the subaward
naics_description	NAICS code description
psc_code	Product Service Code
psc_description	PSC description
place_of_performance_state	State where work is performed
subaward_action_date	Date the subaward was obligated
description	Subaward description
source_url	USAspending.gov URL for this record

How to use it

Set awardType to scope between contracts (A/B/C/D) or grants and loans (02 through 11). Use ueiList to pull all subawards for specific prime contractors by their SAM.gov UEI. Use naicsCode with 2-digit (sector), 4-digit (industry group), or 6-digit (full code) precision — note that 3-digit NAICS codes are silently skipped.

Field	Type	Default	Description
awardType	string	—	Award type: A, B, C, D (contracts) or 02–11 (grants/loans)
ueiList	array	—	SAM.gov UEIs of prime contractors to filter by
naicsCode	string	—	NAICS code (2, 4, or 6 digits only). 3-digit codes are silently skipped — use 54 or 5413 instead of 541.
awardingAgency	string	—	Awarding agency filter (20 major agencies supported)
dateFrom	string	—	Subaward action date lower bound (YYYY-MM-DD)
dateTo	string	—	Subaward action date upper bound (YYYY-MM-DD)
minAmount	number	—	Minimum subaward amount in USD
maxItems	integer	—	Maximum records to return

Use cases

• BD pipeline intelligence — track all subawards through a specific prime — Set ueiList to the prime's SAM.gov UEI and filter by your target NAICS code to see every company in their supply chain receiving federal pass-through dollars.
• Competitive subcontracting analysis — Identify which companies are winning subcontract awards under the same prime in your NAICS sector; use naicsCode at 6-digit precision to scope to direct competitors.
• Small business compliance monitoring — Verify that primes are meeting small business subcontracting plan commitments by comparing subawardee_uei against SAM.gov small business designations.
• Agency spend mapping — Filter by awardingAgency and date range to build a spending map showing how federal dollars flow from a specific agency through primes to the subcontractor ecosystem.
• Academic and policy research — Analyze geographic concentration of subaward spending (place_of_performance_state) by sector and agency for federal procurement equity studies.

FAQ

Why is my NAICS code returning no results? NAICS codes must be exactly 2, 4, or 6 digits. A 3-digit code like 541 is silently skipped rather than returning an error — use 54 (2-digit sector) or 5413 (4-digit industry group, Professional, Scientific, and Technical Services) instead. Verify which level of precision returns results for your sector.

What is the difference between award types A–D and 02–11? Types A, B, C, and D correspond to delivery orders, purchase orders, BPAs, and definitive contracts respectively (procurement subawards). Types 02 through 11 correspond to grant, cooperative agreement, loan, and other financial assistance award categories. The correct type must match the prime_award_id format.

Can I track a company's subcontracting history across agencies? Yes. Set ueiList to the company's UEI and leave awardingAgency empty to retrieve subawards across all federal agencies. The prime_contractor_uei field identifies which prime passed the work down.

Results are available for export in JSON, CSV, and Excel formats from the Apify dataset tab.