Global Cereal Trade

Visualising foodshocks

Select foodshock percentage


This webpage allows a user to visualize the trade amounts of cereals at food shock levels incrementing from 30% to 90% at both the country and region level. This draws focus to the individual countries that will be most impacted by food trade shocks. Cereals can be defined as edible grains, and include wheat, rice, oat, and corn (Food and Agriculture Organization, 2022). It is especially important to focus on the security of cereal trade routes for two reasons: these grains are a large percentage of global dietary calories – wheat alone contributing 20%, and coarse cereals, which are drought adaptive with high nutritional value, are beginning to be seen as a solution to decreasing global food security (Acevedo et al., 2018, pp. 81-110; Zou et al., 2023).

In a 2022 study by Grassia, et al. titled “Insights into countries’ exposure and vulnerability to food trade shocks from network-based simulations,” foodshocks were defined as a decrease in food production at any scale (2022, pp. 1). The chart below outlines how foodshocks impact the countries that, in 2022, had the most cereal imports globally.

Foodshock Impacts for Top 5 Cereal Importers

The change in kilograms imported with 30%, 60%, and 90% foodshocks.

Subregions box chart



Insights on the Global Cereal Trade

Key figures

Common causes of global-scale food shocks are as follows: political instability and violence, crop and livestock destruction, the global climate crisis, economic stress, and forced displacement (Hasegawa et al., 2021, pp. 587-589; World Food Programme, 2023). To simplify calculations, this project took all causes into consideration and defined food shocks as a decrease in food production for any reason.

Another way to visualize the global cereal trade is by aggregating the data to the United Nation's defined subregions, rather than parsing through each individual country. The chart below outlines the descriptive statistics for the cereal trade of each global subregion.

Statistics box chart

Data and Methods

The flow map displays the FAOSTAT global cereal trade in 2022, the latest year available. It maps import and export directions and quantities (in kilograms) between countries. The category cereal includes cereal straw, husks, unprepared, ground, pressed, or in the form of pellets, cereal preparations, cereals n.e.c. Following the FAO data names, “Reporter countries” are exporters and “Partner countries” importers. The first step of data processing was to make the data into a spatial format where flow lines could be created. This process included several steps

  1. Creating centroid points of each country using the UN Country boundaries dataset, which was used as the “origin” and “destination” points of our flows.
  2. Exporting an Excel spreadsheet with the X/Y coordinates of each country.
  3. In addition, exporting a similar Excel spreadsheet from the UN specifying the larger global regions each country is a part of.
  4. We then wrote a python script that systematically joined each spreadsheet with each other, being careful to keep the data for “Reporter Country” and “Partner Country” separate. After joining all the data, we had six final columns: “Reporter Country”, “Reporter Country Coordinates”, “Reporter Subregion”, “Partner Country”, “Partner Country Coordinates”, “Partner Subregion”. For each pair of reporters and partner countries there was a value of trade in US tons.
  5. US tons were converted to kilograms.
  6. Our project also highlighted changes in trade patterns in the face of shocks to food production, as such, we created 9 additional value columns showing the cereal trade values in kilograms after a 30%, 60% and 90% decrease in production and subsequent trade.

The final data products were an Excel table containing all the country and subregion trade routes with their respective yearly exports and imports for 2022 and a second table containing the country names, code (as per the FAO) and coordinates for the Flowmap.city map.

Partner countries are the origin and reporter countries are the destination. This shows the direction in which cereal is travelling. The arrows are proportional to the amount in kilograms of cereal exported/imported. A hover over shows the exact value of the exchange. The arrows can be filtered by country or location points can clicked on to show only the arrows to and from that point.

Methodology

Limitation

The limitations of this visualisation include the map projection and the limited data. The map is currently shown in the Web Mercator projection and can not be changed in Flowmap.city. Although good for its familiarity, it is a skewed view of the globe and distorts the shape, size and relative position of every country and continent. The data had to be limited to cereal trade only (as opposed to several food groups) for processing and visualisation purposes leaving room for future developments.

Sources

This section lists the resources and data sets used for the map.

Contact

Any questions? Get in touch at madzieboyles@outlook.com