usda_nass_get_grain_stocks
Retrieve quarterly on-farm, off-farm, and total grain stocks in bushels by commodity and year for national or state estimates.
Instructions
Quarterly grain stocks of a commodity in a year, on farm, off farm and in total, in bushels.
The NASS Grain Stocks estimates (statisticcat_desc STOCKS, unit_desc
BU, domain_desc TOTAL, freq_desc POINT IN TIME, source_desc
SURVEY), state or national, every stocks day of the year together: one row per
day, position and class, sorted by day (begin_code, then
reference_period_desc), then util_practice_desc, then class_desc.
reference_period_desc names the day, FIRST OF MAR, FIRST OF JUN,
FIRST OF SEP or FIRST OF DEC, and begin_code its month (03 ... 12).
util_practice_desc tells the position as upstream spells it for the commodity:
for corn GRAIN (the total), ON FARM, GRAIN and OFF FARM, GRAIN; for
soybeans and wheat ALL UTILIZATION PRACTICES (the total), ON FARM and
OFF FARM. class_desc is ALL CLASSES; wheat's durum comes as rows of its
own, class_desc SPRING, DURUM, where NASS publishes it, as in the national
estimates. value is the quantity in bushels as published and value_number its
parsed form.
Args:
commodity: Upstream commodity_desc, e.g. "CORN", "SOYBEANS",
"WHEAT"; list_param_values("commodity_desc") lists them.
year: Year of the stocks days, e.g. 2024 for the stocks on 1 March, 1 June,
1 September and 1 December 2024; the current year returns only the stocks
days published so far.
state: Two-letter state code for the state estimates, e.g. "IA", "ND";
None returns the national US TOTAL estimates.
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": "<commodity>",
"year": "<year>"
},
"name": "usda_nass_get_grain_stocks"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | Yes | ||
| state | No | ||
| commodity | Yes |