feed_grains_database
Get ERS feed grains data - the Feed Grains Yearbook acreage, supply, use, price, and trade tables, each pivoted to a wide layout by year.
Examples
from openbb import obb
obb.usda.feed_grains_database(provider='usda')
# Get corn and sorghum farm prices since 1990.
obb.usda.feed_grains_database(table='corn_and_sorghum_farm_prices', start_year=1990, provider='usda')
# Get U.S. corn and sorghum exports by selected destinations.
obb.usda.feed_grains_database(table='corn_and_sorghum_exports_by_destination', provider='usda')
Parameters
- standard
- usda
table: str | None
Default: corn_supply_and_use
Description
Feed Grains Yearbook table to retrieve. Each table is a set of named balance-sheet, price, or trade series indexed by year and period; the series become the wide value columns while any varying commodity, geography, and period are folded into a single pinned period label so each row is uniquely identified. Valid tables are:
acreage_production_and_price, foreign_coarse_grains_supply_and_use, feed_grains_supply_and_use, corn_supply_and_use, sorghum_supply_and_use, barley_supply_and_use, oats_supply_and_use, hay_production_and_stocks, corn_and_sorghum_farm_prices, barley_and_oats_farm_prices, hay_farm_prices, corn_cash_prices, sorghum_cash_prices, barley_and_oats_cash_prices, feed_price_ratios, byproduct_feed_prices, processed_corn_product_prices, corn_and_sorghum_exports, barley_and_oats_exports, corn_and_sorghum_imports, barley_and_oats_imports, corn_and_sorghum_exports_by_destination, barley_and_oats_exports_by_destination, corn_and_sorghum_imports_by_source, barley_and_oats_imports_by_source, white_corn_exports_by_destination, world_coarse_grain_trade, rail_rates_and_grain_shipments, processed_feeds_fed, animal_unit_indexes, corn_food_seed_and_industrial_use, ethanol_exports_by_destination, ethanol_imports_by_source, distillers_dregs_exports_by_destination, distillers_dregs_imports_by_source
start_year: int | None
Start year for filtering the data, compared against the integer year of the observation. If None, returns from the beginning of the series.
end_year: int | None
End year for filtering the data, compared against the integer year of the observation. If None, returns up to the most recent year.
Returns
results: FeedGrainsDatabase
Serializable results.
provider: str | None
Provider name.
warnings: Optional[list[Warning_]]
List of warnings.
chart: Optional[Chart]
Chart object.
extra: dict[str, Any]
Extra info.
Data
- standard
- usda
period: str
Row label of the observation: the year and published period token ('1975 Marketing year Sep-Aug', '2020 Sep', '2019 Marketing year Q1 Sep-Nov'), with any varying commodity group, commodity, or geography prefixed so each row is uniquely labeled.