On and Off Topic

How to read the Bilateral Trade Explorer

I built the Bilateral Trade Explorer because people usually talk about trade between two countries as one number, a single surplus or deficit. In reality it's hundreds of products moving in both directions. I wanted to be able to pick any two countries and see all of it at once.

What it does

You pick two countries, or the European Union as a single bloc, and the explorer lists every category of goods they trade along with its value. The categories come from the Harmonized System, the classification countries use for traded goods. At the top level it has 97 chapters, ranging from live animals to works of art. All of them are shown, sorted by value, for the most recent full year of data.

Where the numbers come from

Trade values come from CEPII's BACI dataset. BACI takes the import and export figures countries report to the United Nations and reconciles them into one consistent set of bilateral flows. The tariff figures start from trade-weighted applied rates. For the largest economies (the United States, China, the European Union, the United Kingdom and Japan) I filled in current rates by hand, so those relationships show what is charged today and not an older baseline.

Reading the balance bars

Each chapter has a bar showing the trade balance in that category. The first country you picked is on the left, the second is on the right, and the bar leans toward whichever one exports more. I use this part the most. Two countries can have a fairly even overall relationship while being very lopsided product by product. Often one side ships raw materials and the other ships finished machinery, and the bars show that right away.

Drilling down

Click a two-digit chapter to open the four-digit products inside it. Electrical machinery, for example, splits into phones, circuits, wiring and dozens of other lines. You can keep narrowing until you find the specific products behind a relationship. Click the chapter again to collapse it.

Pairs worth trying

Start with the United States and China and see how much of their trade sits in a few electronics and machinery chapters. Canada and the United States look very different, with energy and vehicles on top. If you compare a small country with a large one, the balance bars usually lean the same way in almost every category. The flags next to each country name help when you're flipping between several pairs.

Open the tool and try a pair yourself: Bilateral Trade Explorer.