How do I merge your Gravity data with Comtrade or WITS trade data?

In most cases, the iso3_o and iso3_d codes should match without issue to bilateral trade data. The combination of iso3_oiso3_d, and year uniquely identify an observation in the dataset. However, the table below describes several countries that we are aware of with different letter codes in the Dynamic Gravity, Comtrade, and WITS datasets.

Country name

Dynamic Gravity

Comtrade

WITS

Congo, Dem. Rep. of the

ZAR (1971-1997)

COD (1998-2016)

COD

ZAR

East Timor TLS TLS TMP
Montenegro MNE MNE MNT
Neutral Zone NTZ n/a NZE
Pacific Islands PCI PCI PCE

Romania

ROM (1948-2001)

ROU (2002-2016)

ROU

ROM

Serbia SRB SRB SER
Sikkim SKM n/a SIK
Sudan SDN SDN SUD
Taiwan TWN 490 OAS
U.S. Miscellaneous Pacific Islands PUS n/a USP
Vietnam, South VNM VNM SVR
Yemen, South YMD YMD YDR