USDA ERS' new visualization tool offers interactive ways to explore wheat statistics

USDA, Economic Research Service (ERS) has developed an interactive tool to explore trends in U.S. and international wheat markets. Now available on the ERS website, the Wheat Data Visualization tool works on all types of devices with many mobile-friendly options. The tool provides graphic overviews of the wide array of data ERS publishes each month in the Wheat Data product—a resource that includes statistics on the five classes of wheat: hard red winter, hard red spring, soft red winter, white, and durum, all by year and by quarter. Monthly domestic and international price data are included, as well as monthly trade data by product and class, interactive maps of U.S. export markets, and a feature for mapping changes to the data from the USDA, Foreign Agricultural Service’s Production, Supply, and Distribution database.

Each month, ERS updates the Wheat Data Visualization tool after USDA releases the World Agricultural Supply and Demand Estimates (WASDE). The tool includes calculations and data from the WASDE; U.S. Department of Commerce, Bureau of the Census; USDA, National Agricultural Statistics Service; and several other sources. Some data series in the visualization date as far back as 1950 and take users to the present day.

Wheat Data Visualization users can flip through six dashboards by clicking on navigation icons at the top of each dashboard. Options for interactive visualizations include line, area, and bar graphs. One dashboard, showing U.S. wheat trade destinations around the world, features an interactive map that allows users to toggle over different locations and view U.S. wheat trade flows over time. The Trade Data By-Class dashboard highlights a series unique to the ERS Wheat Data product with monthly, quarterly, and marketing year data on U.S. wheat exports by class. Drop-down menus allow users to select their preferred view (for example, by stacked area or separate line graphs), choose between export or import data, and choose the marketing years and classes to appear in the visualization. A similar dashboard is available for monthly, quarterly, and marketing year views of U.S. wheat trade by product type (grain, flour, and products). An overview dashboard provides quarterly and marketing year U.S. wheat supply and distribution statistics, including by-class data. To view the underlying data for some of the dashboards, users can click on a data point and generate a table that contains the data series for a selected marketing year. In addition, the complete dataset that supports each dashboard can be downloaded through a ″Download Data″ button below the navigation icons.

Download higher resolution chart (4267 pixels by 6925, 300 dpi)

For more information on how to use the Wheat Data Visualization tool, a recording of a data training webinar for wheat data is available on the ERS website.

This article is drawn from...
Wheat Data Visualization, by Bryn Swearingen, USDA, Economic Research Service, July 2023