Strategic Trade Atlas Data 2014-2018 by European Commission Joint Research Centre (JRC) | Academic Research

About this Dataset

Strategic Trade Atlas Data 2014-2018

The slice of world trade data underlying the Strategic Trade Atlas is made available here, covering the trade period 2014-2018. The data is published in three sets. The first, named Strategic Trade Atlas Data, is the main set. It includes trade flow data between countries in strategic commodities over time. The second set, named Strategic Commodities RCA Data, provides the estimation of the Revealed Comparative Advantage by countries in the trade of strategic commodities for the time period of reference. The third set, named Total Trade Data, includes trade measures by countries in all commodities (strategic and non strategic). This is of use to compute the share of strategic trade versus all trade.
Publisher name: Joint Research Centre
Publisher URL: https://commission.europa.eu/about/departments-and-executive-agencies/joint-research-centre
Last updated: 2024-10-11T01:08:58Z

Tables

Table 1

@ecjrc.aab8a6e1_de9e_415b_b905_08c2a5f516e7.table_1

48.1 KB
2211 rows
7 columns


CREATE TABLE table_1 (
  "flow" VARCHAR,
  "period" TIMESTAMP,
  "reporter" VARCHAR,
  "reporter_iso2" VARCHAR,
  "reporter_iso3" VARCHAR,
  "quantity_kg" DOUBLE,
  "value_usd" BIGINT
);

Table 2

@ecjrc.aab8a6e1_de9e_415b_b905_08c2a5f516e7.table_2

34.28 MB
2606568 rows
13 columns


CREATE TABLE table_2 (
  "commodity_code" DOUBLE,
  "commodity_description" VARCHAR,
  "flow" VARCHAR,
  "partner" VARCHAR,
  "partner_iso2" VARCHAR,
  "partner_iso3" VARCHAR,
  "period" TIMESTAMP,
  "reporter" VARCHAR,
  "reporter_iso2" VARCHAR,
  "reporter_iso3" VARCHAR,
  "strategic_commodity_short_description" VARCHAR,
  "quantity_kg" DOUBLE,
  "value_usd" BIGINT
);

Table 3

@ecjrc.aab8a6e1_de9e_415b_b905_08c2a5f516e7.table_3

34.28 MB
2606568 rows
13 columns


CREATE TABLE table_3 (
  "commodity_code" DOUBLE,
  "commodity_description" VARCHAR,
  "flow" VARCHAR,
  "partner" VARCHAR,
  "partner_iso2" VARCHAR,
  "partner_iso3" VARCHAR,
  "period" TIMESTAMP,
  "reporter" VARCHAR,
  "reporter_iso2" VARCHAR,
  "reporter_iso3" VARCHAR,
  "strategic_commodity_short_description" VARCHAR,
  "quantity_kg" DOUBLE,
  "value_usd" BIGINT
);