usda_psd_get_balance_sheet
Retrieve a USDA PSD supply and distribution balance sheet for one commodity, country, and market year, with attribute values and units for analysis.
Instructions
One country's PSD supply and distribution of a commodity in a market year, as one record.
One request to PSDData_GetCountryCommodityDataByYear; its records, one per
attribute, become the entries of attributes, keyed by the attribute's upstream
name ("Production", "Imports", "Ending Stocks", 15 of them for wheat in
the United States), in upstream order. Each entry carries attribute_id,
unit_id, value, calendar_year and month exactly as the record had
them. Units differ per attribute (wheat US: 1000 HA for area, 1000 MT for
quantities, MT/HA for yield), so read each entry's unit_id (enums.UnitId).
Nothing is derived, converted or renamed. Names are not unique upstream: an id
whose name the packaged list gives to several ids ("Total Disappearance" is 126
and 173, "Fresh Dom. Consumption" 133 and 135) is always keyed with its id,
"Total Disappearance (126)", so an id has the same key in every answer of a
package version; an id the packaged list lacks is keyed "attribute <id>". Keys
come from the packaged list: a reference refresh that renames an attribute, or adds
an id under an existing name, changes keys and is a breaking change (conventions
§12), recorded in the CHANGELOG. meta.vintage is the PSD release that last
revised the figures ("2026-07"); meta.published_at stays empty, since PSD
gives no day. Codes and the year are checked before the call. Valid codes without
data (PSD answers an empty list) raise NotFoundError, a market year without data
errors.NoDataForYear, both naming commodity, country and year.
Args:
commodity_code: PSD commodity code, seven digits, e.g. "0410000" (Wheat),
"0440000" (Corn), "2222000" (Oilseed, Soybean).
country_code: PSD country code (not ISO), e.g. "US" (United States), "BR"
(Brazil), "E4" (European Union). For the world use get_world_data.
market_year: PSD market year, e.g. 2023, 2022, 2021; data goes back to
1960 for most commodities.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"commodity_code": "<commodity_code>",
"country_code": "<country_code>",
"market_year": "<market_year>"
},
"name": "usda_psd_get_balance_sheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| market_year | Yes | ||
| country_code | Yes | ||
| commodity_code | Yes |