vegetables_and_pulses
Get ERS vegetables and pulses yearbook data - U.S. and world vegetable and pulse-crop supply, availability, per capita use, price, trade, and cash receipts, each table pivoted to a wide layout with the data elements as columns and years as rows.
Examples
from openbb import obb
obb.usda.vegetables_and_pulses(provider='usda')
# Get the U.S. fresh asparagus balance sheet since 2015.
obb.usda.vegetables_and_pulses(table='Table13_Asparagus', start_year=2015, provider='usda')
# Get selected world vegetable production since 2020.
obb.usda.vegetables_and_pulses(table='Table09_WorldVegProduction', start_year=2020, provider='usda')
Parameters
- standard
- usda
table: str | None
Default: Table33_Potatoes
Description
Yearbook table to retrieve. Each table is a supply, availability, price, cash-receipts, or world-production series for one commodity or aggregate; the data elements (production, supply, imports, exports, availability, price) become the wide columns while year, commodity, and location stay as rows. Valid tables are:
Table09_WorldVegProduction, Table10_CashReceipts, Table11_TotalFresh, Table12_Artichokes, Table13_Asparagus, Table14_Broccoli, Table15_BrusselsSprouts, Table16_Cabbage, Table17_Carrots, Table18_Cauliflower, Table19_Celery, Table20_CollardGreens, Table21_Cucumbers, Table22_Eggplant, Table23_EscaroleandEndive, Table24_Garlic, Table25_HeadLettuce, Table26_LeafandRomaine, Table27_Kale, Table28_Mushrooms, Table29_MustardGreens, Table30_Okra, Table31_Onions, Table32_PeppersBell, Table33_Potatoes, Table34_Pumpkins, Table35_Radishes, Table36_SnapBeans, Table37_Spinach, Table38_Squash, Table39_SweetCorn, Table40_SweetPotatoes, Table41_Tomatoes, Table42_TurnipGreens, Table43_TotalVeg_Pr, Table44a_Asparagus_Pr, Table44b_Asparagus_Cn, Table44c_Asparagus_Fz, Table45_Broccoli_Pr, Table46_Cabbage_Pr, Table47a_Carrots_Pr, Table47b_Carrots_Fz, Table47c_Carrots_Cn, Table48_Cauliflower_Pr, Table49_Cucumbers_Pr, Table50a_GreenLimaBeans_Pr, Table50b_GreenLimaBeans_Cn, Table50c_GreenLimaBeans_Fz, Table51_Mushrooms_Pr, Table52_Onions_Dehy, Table53a_GreenPeas_Pr, Table53b_GreenPeas_Cn, Table53c_GreenPeas_Fz, Table54_ChiliPeppers_Pr, Table55a_Potatoes_Cn, Table55b_Potatoes_Chip, Table55c_Potatoes_Dehy, Table55d_Potatoes_Fz, Table56a_SnapBeans_Pr, Table56b_SnapBeans_Cn, Table56c_SnapBeans_Fz, Table57a_Spinach_Pr, Table57b_Spinach_Cn, Table57c_Spinach_Fz, Table58a_SweetCorn_Pr, Table58b_SweetCorn_Cn, Table58c_SweetCorn_Fz, Table59_Tomatoes_Pr, Table60_AllDryBeans, Table61_Pinto, Table62_Navy, Table63_GreatNorthern, Table64_Black, Table65_Lima, Table66_RedKidney, Table67_Blackeye, Table68_Garbanzo, Table69_SmallWhite, Table70_SmallRed, Table71_Pink, Table72_Other
start_year: int | None
Start year for filtering the data, compared against the observation year. If None, returns from the beginning of the series.
end_year: int | None
End year for filtering the data, compared against the observation year. If None, returns up to the most recent year.
Returns
results: VegetablesAndPulses
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
year: int
Year of the observation.
commodity: str | None
Vegetable or pulse commodity, as published.
location: str | None
Location of the observation: a country for the world-production table, a state or the United States for the cash-receipts table, and the United States for the commodity supply tables.
end_use: str | None
Market of the observation, as published, e.g. 'Fresh', 'Processing', 'Dry', 'Canning', 'Freezing', or 'All uses'.
geographical_level: str | None
Geographical level of the location, 'Country' or 'State'.