Skip to content

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's subawardReportNumber and USAspending's subaward_sam_report_id, lowercase. GET /api/assistance/subgrants/{key}/.
  • award_key (prime award): the canonical identifier of the prime assistance award, the same assistance_award_unique_key the financial-assistance resources take; fain is the prime's FAIN, and prime_assistance_group records 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 (the uuid of /api/entities/) minted from the prime, subgrantee and subgrantee-parent UEIs; null when 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 (always sub-grant), number, amount, action_date, fiscal_year
  • fsrs_details – last_modified_date (timestamp of the report's last modification), id (the report UUID), year, month
  • place_of_performance – city, state (two-letter code), zip, country_code, from the place record
  • highly_compensated_officers – name, amount, always five entries; one the report leaves empty has null for both
  • prime_recipient – uei, display_name, from the entity record
  • subgrant_recipient – uei, display_name, duns, from the entity record; an unregistered subgrantee returns its uei with display_name: null, and duns is always null
  • awarding_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 key for subgrant lookups. Use award_key or fain to link to the prime award; prime_assistance_group names 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 amount across them overstates.