Subgrants Data Dictionary¶
This document describes the fields available in the Subgrants API endpoints (/api/assistance/subgrants/). For filtering, ordering, and pagination, see the Subgrants API Reference.
Overview¶
A subgrant is a subaward a prime recipient reports under a federal grant or cooperative agreement (2 CFR 170). Each row is one subaward report, keyed by the report's own UUID, and carries the report's facts plus the ids that link it to the prime assistance award, the recipients and the place of performance. Recipient and place details live on those records rather than on the subgrant. The contract-side reports are Subawards.
Sources¶
Two feeds carry the same reports under two spellings of the same report UUID, and Tango reads both:
- SAM.gov assistance subaward reporting — the system the prime files the report in, and the authoritative spelling of every field it publishes.
- USAspending — republishes the reports, with the place of performance, the officers and the fiscal-year framing SAM.gov does not publish.
Where both publish a field, SAM.gov's value wins; USAspending fills the rest. Amounts are served exactly as published, with amount_suspect flagging the implausible ones.
Identifiers¶
key(subgrant): the report UUID, SAM.gov'ssubawardReportNumberand USAspending'ssubaward_sam_report_id, lowercase.GET /api/assistance/subgrants/{key}/.award_key(prime award): the canonical identifier of the prime assistance award, the sameassistance_award_unique_keythe financial-assistance resources take;fainis the prime's FAIN, andprime_assistance_grouprecords which of the four resources held the prime when Tango processed the report (see Keys).prime_recipient_id,recipient_id,recipient_parent_id: the entity ids (theuuidof/api/entities/) minted from the prime, subgrantee and subgrantee-parent UEIs;nullwhen the report carries no UEI.place_of_performance_id: the place record the subgrant's place of performance resolves to, in the financial-assistance place dimension.
Note: The full set of fields is available via the shape query parameter. See Response Shaping for details.
Update Frequency¶
Subgrant reports are refreshed daily from USAspending's daily files and the SAM.gov assistance subaward feed, and reconciled against USAspending's full-year archives on each new pull.
Fields¶
| Field | Type | Description | Source |
|---|---|---|---|
key | UUID | The report UUID. | SAM.gov / USAspending |
award_key | String | Canonical identifier of the prime assistance award. | USAspending / Tango |
fain | String | Prime award FAIN. | SAM.gov / USAspending |
assistance_listings | String | The prime award's assistance listings (CFDA number and title) as reported; several are ;-separated. | USAspending / SAM.gov |
prime_assistance_group | String | Which financial-assistance resource held the prime award when Tango processed the report: grant, loan, direct_payment or other; null when the prime was not in Tango. It can lag an award that has since changed assistance type. | Tango (derived) |
prime_awardee_uei | String | Prime recipient UEI. | SAM.gov / USAspending |
prime_recipient_id | UUID | The prime recipient's entity id. | Tango (derived) |
recipient_uei | String | Subgrantee UEI. | SAM.gov / USAspending |
recipient_id | UUID | The subgrantee's entity id. | Tango (derived) |
recipient_parent_uei | String | Subgrantee parent UEI. | SAM.gov / USAspending |
recipient_parent_id | UUID | The subgrantee parent's entity id. | Tango (derived) |
place_of_performance_id | UUID | The place-of-performance record. | Tango (derived) |
pop_cd_original | String | Place-of-performance congressional district as reported. | USAspending |
pop_cd_current | String | Place-of-performance congressional district under current boundaries. | USAspending |
amount_suspect | Boolean | The reported amount is not plausibly a subgrant; see below. | Tango (derived) |
retired_at | Timestamp | When the report stopped being published; null while live. | Tango (derived) |
usaspending_permalink | String | The prime award's page on USAspending. | USAspending |
amount_suspect¶
true when either the amount is at or above one billion dollars, or the amount's digit string, six digits or longer, is one string written twice (25092509 for 2509), a known serialization defect in the reporting system. The amount is served as published either way; this flag says whether to trust it.
retired_at¶
Set when USAspending published the report and its newest full-year archive no longer does, with no re-filing on SAM.gov since; or when a later archive pull no longer carries the report at all. The timestamp is when Tango first saw the report gone, and it stays put; a report that reappears has it cleared. A report only SAM.gov holds is never retired. Lists omit retired reports unless include_retired=true.
Expansions (via shape)¶
subgrant_details–description,type(alwayssub-grant),number,amount,action_date,fiscal_yearfsrs_details–last_modified_date(timestamp of the report's last modification),id(the report UUID),year,monthplace_of_performance–city,state(two-letter code),zip,country_code, from the place recordhighly_compensated_officers–name,amount, always five entries; one the report leaves empty hasnullfor bothprime_recipient–uei,display_name, from the entity recordsubgrant_recipient–uei,display_name,duns, from the entity record; an unregistered subgrantee returns itsueiwithdisplay_name: null, anddunsis alwaysnullawarding_office/funding_office– office fields, from the prime award
Data Sources¶
- SAM.gov – Assistance subaward reports: the report, the prime, the subgrantee and its parent, the officers.
- USAspending – The same reports with the place of performance, the officers, the fiscal year, the prime's assistance listings and the permalink.
- Tango –
award_key, the entity and place ids,amount_suspect,retired_at, and the arbitration between the two feeds.
Usage Notes¶
- Use
keyfor subgrant lookups. Useaward_keyorfainto link to the prime award;prime_assistance_groupnames its endpoint, and nearly all subgrants sit under grant awards. - Scoped lists:
/api/assistance/{grants,loans,direct_payments,other}/{key}/subgrants/lists subgrants under a prime award on that endpoint (a retired key works; another endpoint's key returns an empty list);/api/entities/{uei}/subgrants/lists those where the entity is the subgrantee. - Several reports can describe one subgrant. A prime re-files a report when it amends or re-reports a subaward, so the same prime award, subaward number and subgrantee can appear under several keys with different action dates and amounts; summing
amountacross them overstates.