US Department Of Agriculture Commodities Timeseries

Snowflake table name : CYBERSYN.US_DEPARTMENT_OF_AGRICULTURE_COMMODITIES_TIMESERIES

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
GEO_ID	A unique identifier for a country joinable to the GEOGRAPHY_INDEX table.	VARCHAR	country/JPN
VARIABLE	Unique identifier for a variable, which defines the USDA dataset that the data originates (e.g., ESR - Export Sales Report), the commodity associated with that variable, and what is being measured.	VARCHAR	ESR_rice_long_grain_milled_outstanding_sales
VARIABLE_NAME	Human-readable description of the reported attribute, including commodity type and a description of what is being recorded.	VARCHAR	All Rice: Weekly Exports
DATE	Date associated with the value (e.g., for ESR variables, it represents the sales week end). See the ATTRIBUTES table for more details.	DATE	2024-02-15
VALUE	Value reported for the variable.	FLOAT	0.0
UNIT	Unit of measurement for the reported value (ex. Metric Tons).	VARCHAR	Metric Tons
CALENDAR_YEAR	Calendar year associated with the value.	DATE	1970-01-01
MARKETING_YEAR	The marketing year tied to the agricultural seasons and harvest periods of a specific crop. A marketing year typically begins in the month when a particular crop's harvest starts and ends just before the next year's harvest begin. This period can vary significantly between different crops and different countries.	VARCHAR	2024