The data goes back to 1986 and is suited to join with the trade table.

Format

A data frame with 1,973,285 rows and 67 columns:

Variable nameVariable description
yearYear of observation
iso3_o3-digit ISO code of origin country
dynamic_code_oYear appropriate 3-digit code of origin country
iso3_d3-digit ISO code of destination country
dynamic_code_dYear appropriate 3-digit code of destination country
colony_of_destination_everOrigin country was ever a colony of the destination country
colony_of_origin_everDestination country was ever a colony of the origin country
colony_everCountry pair has been in a colonial relationship
common_colonizerCountry pair has been colonized by a common colonizer
common_legal_originCountry pair shares common legal origin
contiguityCountry pair shares a common border
distancePopulation weighted distance between country pair
member_gatt_oOrigin country is a General Agreement on Tariffs and Trade member
member_wto_oOrigin country is a World Trade Organization member
member_eu_oOrigin country is a European Union member
member_gatt_dDestination country is a General Agreement on Tariffs and Trade member
member_wto_dDestination country is a World Trade Organization member
member_eu_dDestination country is a European Union member
member_gatt_jointCountry pair are both members of the General Agreement on Tariffs and Trade
member_wto_jointCountry pair are both members of the World Trade Organization
member_eu_jointCountry pair are both members of the European Union
lat_oLatitude coordinate of origin country
lng_oLongitude coordinate of origin country
lat_dLatitude coordinate of destination country
lng_dLongitude coordinate of destination country
landlocked_oOrigin country is landlocked
island_oOrigin country is an island
region_id_oGeographic region of origin country
landlocked_dDestination country is landlocked
island_dDestination country is an island
region_id_dGeographic region of destination country
agree_pta_goodsCountry pair is in at least one active preferential trade agreement covering goods
agree_pta_servicesCountry pair is in at least one active preferential trade agreement covering services
agree_ftaCountry pair is in at least one free trade agreement
agree_eiaCountry pair is in at least one economic integration agreement
agree_cuCountry pair is in at least one customs union
agree_psaCountry pair is in at least one partial scope agreement
agree_fta_eiaCountry pair is in at least one free trade agreement and at least one economic integration agreement
agree_cu_eiaCountry pair is in at least one customs union and at least one economic integration agreement
agree_ptaCountry pair is in at least one active preferential trade agreement covering goods
capital_const_dCapital stock at constant prices of destination country
capital_const_oCapital stock at constant prices of origin country
capital_cur_dCapital stock at current PPP of destination country
capital_cur_oCapital stock at current PPP of origin country
gdp_pwt_const_dReal, inflation-adjusted, PPP-adjusted GDP of destination country (PWT)
gdp_pwt_const_oReal, inflation-adjusted, PPP-adjusted GDP of origin country (PWT)
gdp_pwt_cur_dReal, current, PPP-adjusted GDP of destination country (PWT)
gdp_pwt_cur_oReal, current, PPP-adjusted GDP of origin country (PWT)
pop_dPopulation of destination country
pop_oPopulation of origin country
hostility_level_oLevel of the origin/destination country’s hostility toward the destination country
hostility_level_dLevel of the origin/destination country’s hostility toward the origin country
common_languageResidents of country pair speak at least one common language
polity_oPolity (political stability) score of origin country
polity_dPolity (political stability) score of destination country
sanction_threatThere exists a threat of sanction between one country in a record towards the other
sanction_threat_tradeThere exists a threat of trade sanction between one country in a record towards the other
sanction_impositionThere exists a sanction between one country in a record towards the other
sanction_imposition_tradeThere exists a trade sanction between one country in a record towards the other
gdp_wdi_cur_oNominal GDP of origin country (WDI)
gdp_wdi_cap_cur_oNominal GDP per capita of origin country (WDI)
gdp_wdi_const_oReal, current, PPP-adjusted GDP of origin country (PWT)
gdp_wdi_cap_const_oReal GDP per capita of origin country (WDI)
gdp_wdi_cur_dNominal GDP of destination country (WDI)
gdp_wdi_cap_cur_dNominal GDP per capita of destination country (WDI)
gdp_wdi_const_dReal, current, PPP-adjusted GDP of destination country (PWT)
gdp_wdi_cap_const_dReal GDP per capita of destination country (WDI)

Source

The original data is available at https://www.usitc.gov/data/gravity/dgd.htm

Details

There are differences with respect to the original CSV files. This version provides a more compact representation of the data, with the following changes:

  • Starts in 1986 instead of 1948.

  • Is limited to ISO codes contained in the trade table.

  • The region_origin and region_destination columns are provided in the region names table as region_name and can be joined by using the region_id_ columns.

Author

USITC, adapted from WTO, UN COMTRADE, National Geographic and other sources