USAspending API ReferenceIndependent
Try the API

Agencies Spending Disaster/Emergency Funding via Loans

POST/api/v2/disaster/agency/loans/

This endpoint provides insights on the Agencies awarding loans from disaster/emergency funding per the requested filters.

Returns loan spending details of Agencies receiving supplemental funding budgetary resources

Request

curl -X POST 'https://api.usaspending.gov/api/v2/disaster/agency/loans/' \
  -H 'Content-Type: application/json' \
  -d '{
  "filter": {
    "def_codes": [
      "L",
      "M",
      "N",
      "O",
      "P",
      "U"
    ],
    "award_type_codes": [
      "07",
      "08"
    ]
  },
  "pagination": {
    "limit": 10,
    "page": 1,
    "sort": "award_count",
    "order": "desc"
  },
  "spending_type": "total"
}'

Request body

  • filterobject · FilterRequired3 fields
    • def_codesarray of DEFCRequired

      List of Disaster Emergency Fund (DEF) Codes (DEFC) defined by legislation at the time of writing. When filtering on award_type_codes this will filter on File D records that have at least one File C with the provided DEFC and belong to CARES Act DEFC. A list of current DEFC can be found here.

    • award_type_codesarray of string

      Only accepts loan award type 07 or 08 in the array, since this endpoint is specific to loans.

      If ANY award type codes are provided, loan amounts will be summed for the distinct set of toptier agencies, whose subtier agencies funded loan awards linked to FinancialAccountsByAwards records (which are derived from DABS File C).

      If this parameter is not provided, loan amounts will be summed for a different set of agencies: the distinct set of toptier agencies "owning" appropriations accounts used in funding any award spending for this disaster (i.e. from agencies "owning" Treasury Account Symbol (TAS) accounts on FinancialAccountsByAwards records, which are derived from DABS File C).

      Example ["07","08"]

    • querystring

      A "keyword" or "search term" to filter down results based on this text snippet

  • paginationobject · Pagination4 fields
    • pagenumber

      Requested page of results

      Default 1

    • limitnumber

      Page Size of results

      Default 10

    • orderenum (string)

      Indicates what direction results should be sorted by. Valid options include asc for ascending order or desc for descending order.

      Allowed values
      • desc
      • asc

      Default desc

    • sortenum (string)

      Optional parameter indicating what value results should be sorted by

      Allowed values
      • id
      • code
      • description
      • award_count
      • face_value_of_loan
      • obligation
      • outlay

      Default id

Try it

Runs against the live API. Responses are real data.

POST/api/v2/disaster/agency/loans/

Response · 200

  • totalsobject · TotalsRequired4 fields
    • award_countnumberRequiredNullable
    • face_value_of_loannumberRequired
    • obligationnumberRequired
    • outlaynumberRequired
  • resultsarray of ResultRequired8 fields
    • idstringRequired
    • codestringRequired
    • descriptionstringRequired
    • childrenarray of Result
    • award_countnumberRequired
    • obligationnumberRequiredNullable
    • outlaynumberRequiredNullable
    • face_value_of_loannumberRequiredNullable
  • page_metadataobject · PageMetadataRequired7 fields
    • pagenumberRequired
    • nextnumberRequiredNullable
    • previousnumberRequiredNullable
    • hasNextbooleanRequired
    • hasPreviousbooleanRequired
    • totalnumberRequired
    • limitnumberRequired
Example response
{
  "totals": {
    "award_count": 4574,
    "face_value_of_loan": 290416885040.71,
    "obligation": 364037369840.58,
    "outlay": 290416885040.71
  },
  "results": [
    {
      "id": 121,
      "code": "485",
      "description": "Corporation for National and Community Service",
      "children": [],
      "award_count": 1,
      "obligation": 16791.43,
      "outlay": 0,
      "face_value_of_loan": 0
    },
    {
      "id": 118,
      "code": "514",
      "description": "U.S. Agency for Global Media",
      "children": [],
      "award_count": 1,
      "obligation": 221438.82,
      "outlay": 0,
      "face_value_of_loan": 0
    }
  ],
  "page_metadata": {
    "page": 1,
    "total": 12,
    "limit": 2,
    "next": 2,
    "previous": null,
    "hasNext": true,
    "hasPrevious": false
  }
}

Recent changes

Generated from contracts/v2/disaster/agency/loans.md in the USAspending API repo.

Loading…