IFs Dyadic Trade Data

IFs dyadic database provides following sets of trade related tables for each sector (agriculture, energy, manufacturing, materials, ICT, and services), as well as for the overall sectors (goods & total).

• Exports & Imports in constant $2017
• Trade Complementarity Index (TCI)
• Tariff Revenues
• Weighted Tariff

There are 34 tables in total. Because there are no TCI & weighted tariff tables for the service sector. Raw data of trade and tariffs are originally provided by the World Bank's World Integrated Trade Solution (WITS) and the United Nations Comtrade database. However, in order to get a harmonized bilateral trade data, we directly gather trade values from the Centre d'Etudes Prospectives et d'Informations Internationales' BACI database. For more details on BACI's approach regarding their harmonization process, please refer to their methodology note here. However, trade data for the services sector are still collected from the UN Comtrade, as well as tariffs.

Product Concordance

Trade values are normally provided at commodity level using 6-digit HS nomenclature, an international standard reported under the UN Comtrade. Details on the nomencalture can be found here. Note that the Harmonized System (HS) codes are constantly updated throughout years, and currently we rely on converting all the data under one HS system, which is HS92, also known as HS0. The concordance can be done using the official mapping system, accessible through World Bank WITS' product concordance page.

In IFs, we only present economic activities under IFs sectors (agriculture, energy, manufacturing, materials, ICT, and services) as well as GTAP sectors. Hence, during the data processing steps, 6-digit commodity level values are aggregated into GTAP sectors first, and then IFs sectors. The concordance table between HS codes and GTAP sectors can be found under WITS' product concordance page. The mapping table between GTAP sectors and IFs sectors can be found in the IFs system, under the table GTAPSectorConversion in the DATA/IFs.db file.

The data collection process for each data source is detailed below.

BACI

Data from BACI can be freely accessed from their official website. All years of data needed for IFs (1995 - now) can be downloaded under HS92 system. You will receive a zipped file with trade data by year, country and product codes, as well as a text note explaining the structure of data. Trade data by year are stored under the .csv format, with trade flows at the year - exporter - importer - product level. Products are under the Harmonized System 6-digit nomenclature, values are in thousand USD, and quantities are in metric tons. List of variables in each .csv file are,

t: year

i: exporter

j: importer

k: product

v: value

q: quantity