govcon_subaward_search
When a prime wins federal work, who does it flow subcontracts and subgrants down to? Search USAspending subawards (File F prime → sub cascade) by sub-recipient or prime name/UEI, prime award id, awarding agency, NAICS, PSC, subaward type (contract/grant), place-of-performance state, amount, or action date. Set new_subawardee=true for first-time subawardees — subs with NO prime award on record, coming up through subcontracts (a bonding/staffing/lending/teaming lead). Public federal records. [price: $0.05/row]
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| psc | No | Product/Service Code(s), CSV — exact. | |
| sort | No | field:direction — amount | action_date. Default 'action_date:desc'. | |
| type | No | contract | grant (sub-contract vs sub-grant). CSV for both. | |
| limit | No | Max rows (default 25, cap 100). | |
| naics | No | NAICS code prefix(es), CSV. Example: '5415' covers all IT services. | |
| state | No | Place-of-performance state code(s), CSV. | |
| agency | No | Awarding agency or sub-agency name fragment. Example: 'navy'. | |
| offset | No | Rows to skip, for paging. | |
| sub_uei | No | Sub-recipient Unique Entity Identifier (SAM UEI), exact match. | |
| new_since | No | Sub-recipient's FIRST observed subaward on or after this date (YYYY-MM-DD). | |
| prime_uei | No | Prime recipient Unique Entity Identifier (SAM UEI), exact match. | |
| amount_max | No | Maximum subaward amount in USD. | |
| amount_min | No | Minimum subaward amount in USD. | |
| awarded_after | No | Subaward action date on or after (YYYY-MM-DD). | |
| sub_recipient | No | Sub-recipient (subcontractor/subgrantee) name fragment. | |
| awarded_before | No | Subaward action date on or before (YYYY-MM-DD). | |
| new_subawardee | No | true → only first-time subawardees: subs with NO prime award on record. | |
| prime_award_id | No | Prime award PIID / FAIN, exact match — all subs under one prime. | |
| prime_recipient | No | Prime recipient name fragment. Example: 'lockheed'. |