query

100 Years of Corn Prices

Apr 5, 2021 3:23:01 PM / By Gravwell

For this query, we used a CSV from data.gov that covers grain prices over 100 years. We add the CSV as a resource, and use dump and compound queries to create a parsable date field, put the data into temporal mode, and chart corn prices over 100 years! 🌽

@date{
dump -r feedgrain SC_Frequency_ID==1 SC_GeographyIndented_Desc=="United States" SC_Group_Desc==Prices SC_GroupCommod_Desc==Corn
| eval setEnum("Date", Year_ID+"-"+Timeperiod_Desc)
};
dump -r @date -t Date -f "2006-Jan" | chart Amountdump -r @date -t Date -f "2006-Jan" | chart Amount

Additional information available at https://www.ers.usda.gov/data-products/feed-grains-database/feed-grains-yearbook-tables/

Gravwell
Written by Gravwell
TOP