1 Structure of the dataset

WTFC provides harmonized unit values, and a classification of bilateral trade flows at the product level. Products are identified using the Harmonized System (HS), which is the standard nomenclature for international trade, used by most customs. We provide WTFC in the 1996 revision of the Harmonized System.

HS revision Years available Name of the files
96 2000-2018 WTFC_HS96_Yyear_Vversion.csv

Each version of WTFC is identified by the year and the month of its release, under the form YYYYMM (202005 for the May 2020 release, for instance)

year identifies the year during which the recorded trade flows took place.

Each trade flow within WTFC is characterized by a combination exporter-importer-product-year. There are 9 variables:

Variable Description
t Year
i Exporter (ISO 3-digit country code)
j Importer (ISO 3-digit country code)
k Product (HS 6-digit code)
v Value of the trade flow (in 1000 current USD)
uv Unit value of the trade flow (in current USD / metric ton)
GL Grubel-Lloyd index
trade_type Trade type: “OWT” (One-Way Trade), “TWT” (Two Way Trade), “TWH” (Two Way Horizontal trade) or “TWV” (Two Way Vertical trade)
price_range Price range: “H” (High), “M” (Medium) or “L” (Low)

All files are in CSV format, using commas as field delimiters, and dots as decimal separators. When reading the data, we advise you not to treat the product code (k) variable as numeric, this would remove the leading zeros of the HS codes.

Only the trade flows with value above 1000 USD are provided.

2 Additional files

price_range_chelem gives the value of trade in thousands of US dollars for the three different price ranges (High, Medium and Low), for each exporter, importer, year and group of product (industry) following the CHELEM nomenclature. There are 9 variables:

Variable Description
t Year
i Exporter (ISO 3-digit country code)
j Importer (ISO 3-digit country code)
Prod Product category (CHELEM classification)
Fil Chain of production (CHELEM classification)
Stg Stage of production (CHELEM classification)
H Value of trade in the High price range
M Value of trade in the Medium price range
L Value of trade in the Low price range
NV Value of trade unventilated

type_chelem gives the value of trade in thousands of US dollars for the four different trade types (OWT, TWT, TWH, TWV), for each exporter, importer, year and group of product following the CHELEM nomenclature. There are 11 variables:

Variable Description
t Year
i Exporter (ISO 3-digit country code)
j Importer (ISO 3-digit country code)
product Product category (CHELEM classification)
chain Chain of production (CHELEM classification)
stage Stage of production (CHELEM classification)
GL Grubel-Lloyd index
OWT Value of One-Way Trade
TWT Value of Two-Way Trade
TWH Value of Two-Way Horizontal Trade
TWV Value of Two-Way Vertical Trade