When German Chancellor Angela Merkel meets with POTUS today, one topic that’s most likely going to be addressed is the trade deficit between the United States and the EU, Germany in particular.

The Spiegel, a major German news outlet, has illustrated recent articles on this subject with the figure below. It shows the volume of trade between the United States and ‘selected countries’ (China, Canada, Mexico and the EU) in 2015. The values indicate the value of goods exported (green arrows) to these countries, and imported (blue) from them into the U.S. in billion US$.

Source: Spiegel Online

The interesting thing in this infographic is that the length of the arrows represents the value of goods traded. For example, the arrow for exports from the US to Europe (274 bnUS$ in 2015) is little over half the length of the blue incoming arrow (431 bnUS$ in 2015). This works fine, with the only exception being the green arrow for exports to Mexico.

This infographic of course invited a remake as Sankey diagram. As you all know, in Sankey diagrams the widths of the arrows represent the quantity.

I did two or three different versions, all very similar to the original infographic in style and color, even using the lower states map icon (sorry Alaska and Hawaii). I was not sure at first whether the separate arrows for Germany were values already included in the EU trade volume, or if they were meant to be on top of it. A quick look into the original data revealed that indeed they are included in the EU figures already. I therefore decided to highlight the German share in the Sankey diagram with a slightly brighter color, but keep those arrows stacked.

Here is my Sankey diagram version of the Spiegel infographic.

Not sure which version I prefer, but using the length instead the widths of the arrows to represent the flow quantity is definitely a unique approach. Worth sharing with you, I think.

This presentation from 2015 by Alicia Valero of the Spanish Research Centre for Energy Resources and Consumption (CIRCE, Zaragoza) is on critical materials, minerals scarcity, recycling and a “thermodynamic cradle-to-cradle approach”.

It features two Sankey-style diagrams depicting the mineral balance of the European Union (UE).

This first one is a Sankey diagram for the mineral balance without fossil fuels (‘Diagrama de Sankey para el balance mineral de la UE sin combustibles fósiles’).

Data is for the year 2011, Flows are shown in tons. Iron and limestone dominate the picture with 77% of the input. Limestone is produced (extracted) mainly within Europe, while iron is mostly imported.

The second Sankey diagram is a scarcity diagram (‘Diagrama de rareza para el balance mineral de la UE sin combustibles fósiles’) and takes into account thermodynamic exergy to obtain (mine) the minerals. Although it depicts aluminium, gold, ion, nickel and the likes, flows are shown in an en(x)ergy unit (Mtoe).

Iron and limestone which seemed to be the most important mass-wise only constitute some 10% of the input. Aluminium and potash seem to be much more difficult to produce. Rare earth elements (REE) are not included in this diagram.

The author points out that it is important to not only look at materials from a mass perspective. Looking at materials availability taking into account thermodynamic exergy paints a different picture of the real cost and scarcity.

For those interested, please check out the presentation (in Spanish) here.

Interested in the energy flows of the Euopean countrues (EU-28)? Check out the Sankey diagram tool on the EUROSTAT webpage (the European Statistics Office).

You can choose to view the energy flows for individual countries, or the total for all EU-28. Switching between the data for the years 1990 up to 2014 lets you compare the changes over the last 25 years. The sidebar offers display options for the Sankey diagram.

Nice visualisation and much more fun to work with than statistics data in tables.

An updated Sankey diagram for the energy flows in Europe (EU-28 countries) is available on the website of the European Environment Agency (EEA).

Copyright holder: European Environment Agency (EEA).

I have reported previously about the energy picture with data for 2012. The Sankey diagram structure is almost identical, just the values have been updated to reflect 2013 data. Minimal changes only, compare for yourself…

An updated diagram of the energy flows in Europe has been published on the European Energy Agency (EEA) website. This is for the EU-28 states.

Copyright holder: European Environment Agency (EEA)

I had previously posted about the 2010 diagram (here). The data is for 2012. Flows are in MToe.

Regular readers of this blog have seen the national energy flow diagrams (energy balances) before. I have featured them from many different countries already.

I finally came across a similar Sankey diagram the energy flows of Europe for 2010. It is featured on the European Energy Agency (EEA) website in a report titled ‘Overview of the European energy system (ENER 036) – Assessment published Mar 2013’.

“The figure is a Sankey diagram which shows the composition of the primary energy entering the energy system of the EU-27 in 2010, and where this primary energy was used, either as losses or as consumption by specific sectors of the economy”. It is based on EUROSTAT data for the EU-27 countries.

A legend is available below for the coloured arrows. The diagram is extensively explained and commented on the web page. The content on the source page has been removed, because there is an updated version.

In addition to what we have seen in such diagrams, the primary energy (fuels) is further differentiated with two separate input flows whether the energy carrier was imported or is from domestic European production. This is to visualize dependency on imports.

Blog reader Johannes send me a note and suggested to feature the below diagram. Thanks for that.

Tony Hirst from OUseful.info created it after seeing a map-based diagram for horse meat trade flows on the Guardian Data Blog. Tony used Mike Bostock’s D3s Sankey Plugin that allows creating this type of diagrams directly from data in Excel/CSV files. In his post he describes how he proceeded to build this Intra EU Horse Meat Trade diagram. Somewhat techie, but nevertheless makes an interesting read.

Overall trade quantity was more than 60.000 tonnes in 2012. Largest exporters are Belgium and Poland (left side), largest importers are Italy and France (right side). Data is from Eurostats.

The above is a only a static picture, but you can go here to play around with the interactive version. Data labels and quantities are available in the interactive version when you hover ths mouse over certain bands. You can also move the nodes up and down vertically and group the countries differently.

This special type of Sankey diagram is also refered to as distribution diagram and (…hate to say it in light of the current scandal) a Spaghetti diagram. Fineo and Parsets (see software list) can also be used for this type of diagrams where statistical data is grouped into categories (here: exporting and importing countries) and bands/streams/spaghettis are shown between the categories to represent the relationships between them.

Here is my May 2012 post on distribution diagrams with d3.js.

Browsing through the blogs on data visualization and infographics (check my blogroll) I often find inspiration in Nels’ MFA diagrams. From time to time I like to beef up the skinny MFA diagram skeletons a bit by converting them into Sankey diagrams. At the same time, by translating the numbers into Sankey arrows one gets a better idea what the main (mass) flows are.

This is a MFA diagram on Iron and Steel Flows in the European Union in 2000 as found in this post. Original data is from a 2008 OECD study, flows in Mt.

The description of the diagram says: “A study of iron and steel flows in 2000 in the European Union showed that an input of about 120 Mt of iron ore (of which 98 Mt was imported) yielded 98 Mt of primary crude steel (i.e. produced directly from iron ore and coke). A further 65 Mt, representing 40% of total crude steel production, were produced as secondary crude steel, produced from scrap steel.”

I did a first quick version of the flows as Sankey diagram, trying to stick very much to the layout of the original diagram. All nodes are the same size and more or less located at the position of the master. It already shows that the main steel flows: iron ore imported into the European Union, and steel scrap being recycled within the EU. Export of semi-finished steel products from the EU to the Rest of World (52 Mt) almost balanced with 47 Mt of semi-finished steel products imported into the EU.

I tried to improve the diagram by removing the three nodes ‘New Scrap’, ‘Prompt Scrap’ and ‘End of Life products’ since there is no transformation of these flows at the nodes (also no change in quantity). Further I reduced the size of some boxes and dragged the ‘Semi-finished Products’ (Rest of World) box closer to the ‘Finished Steel Products’ (European Union) box to avoid crossing streams. Wherever possible I try to avoid diagonal arrows.

The final result also has the Rest of World and European Union grouping. I am not to happy with the colors though.

Your thoughts?