Strategic Trade Atlas Data 2015-2019

Joint Research Centre

@ecjrc.fa20328f_15a6_43db_bad8_7fa58c56aef6

Table List

3 tables(28.44 MB)

Table 1

@ecjrc.fa20328f_15a6_43db_bad8_7fa58c56aef6.table_1

The compressed CSV file contains 2482872 trade records. A record contains the following fields: REPORTER (country reporting trade, expressed in full text name, as well as ISO2 and ISO3 country codes); PARTNER (country partner in trade, expressed in full text name, as well as ISO2 and ISO3 country codes); FLOW of trade (import, export); PERIOD of trade (a year); COMMODITY CODE and COMMODITY DESCRIPTION (expressed in the Harmonized System); STRATEGIC COMMODITY SHORT DESCRIPTION; Trade VALUE USD and QUANTITY KG.

27.93 MB
2482872 rows
13 columns

commodity_code COMMODITY CODE	commodity_description COMMODITY DESCRIPTION	flow FLOW	partner PARTNER	partner_iso2 PARTNER ISO2	partner_iso3 PARTNER ISO3	period PERIOD	reporter REPORTER	reporter_iso2 REPORTER ISO2	reporter_iso3 REPORTER ISO3	strategic_commodity_short_description STRATEGIC COMMODITY SHORT DESCRIPTION	quantity_kg QUANTITY KG	value_usd VALUE USD
2844.4	Radioactive elements, isotopes and compounds, and alloys and dispersions, incl. cermets, ceramic products and mixtures, containing these elements, isotopes and compounds; radioactive residues (excl. natural uranium, uranium enriched and depleted in U 235; plutonium, thorium and compounds of these pr…	Export	Oman	OM	OMN	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	ZA	ZAF	Radioactive elements	1498	182265
2844.4	Radioactive elements, isotopes and compounds, and alloys and dispersions, incl. cermets, ceramic products and mixtures, containing these elements, isotopes and compounds; radioactive residues (excl. natural uranium, uranium enriched and depleted in U 235; plutonium, thorium and compounds of these pr…	Export	Qatar	QA	QAT	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	ZA	ZAF	Radioactive elements	660	76036
2844.4	Radioactive elements, isotopes and compounds, and alloys and dispersions, incl. cermets, ceramic products and mixtures, containing these elements, isotopes and compounds; radioactive residues (excl. natural uranium, uranium enriched and depleted in U 235; plutonium, thorium and compounds of these pr…	Export	Saudi Arabia	SA	SAU	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	ZA	ZAF	Radioactive elements	237	39459
2844.4	Radioactive elements, isotopes and compounds, and alloys and dispersions, incl. cermets, ceramic products and mixtures, containing these elements, isotopes and compounds; radioactive residues (excl. natural uranium, uranium enriched and depleted in U 235; plutonium, thorium and compounds of these pr…	Export	United Arab Emirates	AE	ARE	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	ZA	ZAF	Radioactive elements	2021	217655
2844.4	Radioactive elements, isotopes and compounds, and alloys and dispersions, incl. cermets, ceramic products and mixtures, containing these elements, isotopes and compounds; radioactive residues (excl. natural uranium, uranium enriched and depleted in U 235; plutonium, thorium and compounds of these pr…	Export	Yemen	YE	YEM	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	ZA	ZAF	Radioactive elements	87	7423
2844.5	Spent "irradiated" fuel elements "cartridges" of nuclear reactors [Euratom]	Export	Qatar	QA	QAT	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	ZA	ZAF	Spent fuel	409	43968
2844.5	Spent "irradiated" fuel elements "cartridges" of nuclear reactors [Euratom]	Export	United Arab Emirates	AE	ARE	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	ZA	ZAF	Spent fuel	63	13988
3002.9	Human blood; animal blood prepared for therapeutic, prophylactic or diagnostic uses; toxins, cultures of micro-organisms and similar products (excl. yeasts and vaccines)	Export	United Arab Emirates	AE	ARE	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Mauritius	MU	MUS	Micro-organisms and toxins	2	1
3002.9	Human blood; animal blood prepared for therapeutic, prophylactic or diagnostic uses; toxins, cultures of micro-organisms and similar products (excl. yeasts and vaccines)	Export	Bahrain	BH	BHR	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	ZA	ZAF	Micro-organisms and toxins	5	279
3002.9	Human blood; animal blood prepared for therapeutic, prophylactic or diagnostic uses; toxins, cultures of micro-organisms and similar products (excl. yeasts and vaccines)	Export	Oman	OM	OMN	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	South Africa	ZA	ZAF	Micro-organisms and toxins	420	11832


CREATE TABLE table_1 (
  "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" BIGINT,
  "value_usd" BIGINT
);