Strategic Trade Atlas Data 2014-2018

Joint Research Centre

@ecjrc.aab8a6e1_de9e_415b_b905_08c2a5f516e7

Table List

3 tables(68.6 MB)

Table 2

@ecjrc.aab8a6e1_de9e_415b_b905_08c2a5f516e7.table_2

The compressed CSV file contains about 2606568 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.

34.28 MB
2606568 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
2811.19	Inorganic acids (excl. hydrogen chloride "hydrochloric acid", chlorosulphuric acid, sulphuric acid, oleum, nitric acid, sulphonitric acids, phosphoric acid, polyphosphoric acids, boric acids and hydrogen fluoride "hydrofluoric acid")	Export	Tunisia	TN	TUN	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	EG	EGY	CWC scheduled chemicals	35152.98	59119
2811.19	Inorganic acids (excl. hydrogen chloride "hydrochloric acid", chlorosulphuric acid, sulphuric acid, oleum, nitric acid, sulphonitric acids, phosphoric acid, polyphosphoric acids, boric acids and hydrogen fluoride "hydrofluoric acid")	Export	Libya	LY	LBY	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tunisia	TN	TUN	CWC scheduled chemicals	880	2064
2853	Inorganic compounds, incl. distilled or conductivity water and water of similar purity, n.e.s.; liquid air, whether or not rare gases have been removed; compressed air; amalgams (excl. amalgams of precious metals)	Export	Algeria	DZ	DZA	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tunisia	TN	TUN	CWC scheduled chemicals	456.05	7601
2853	Inorganic compounds, incl. distilled or conductivity water and water of similar purity, n.e.s.; liquid air, whether or not rare gases have been removed; compressed air; amalgams (excl. amalgams of precious metals)	Export	Egypt	EG	EGY	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tunisia	TN	TUN	CWC scheduled chemicals	12	178
2853	Inorganic compounds, incl. distilled or conductivity water and water of similar purity, n.e.s.; liquid air, whether or not rare gases have been removed; compressed air; amalgams (excl. amalgams of precious metals)	Export	Libya	LY	LBY	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tunisia	TN	TUN	CWC scheduled chemicals	815800	335854
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	Libya	LY	LBY	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tunisia	TN	TUN	Radioactive elements	108	41723
2904.9	Sulphonated, nitrated or nitrosated derivatives of hydrocarbons, whether or not halogenated (excl. those containing only sulpho, nitro or nitroso groups)	Export	Tunisia	TN	TUN	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Algeria	DZ	DZA	CWC scheduled chemicals	3355000	5911024
2918.19	Carboxylic acids with additional oxygen function and their anhydrides, halides, peroxides and peroxyacids; their halogenated, sulphonated, nitrated or nitrosated derivatives (excl. lactic acid, tartaric acid, citric acid, gluconic acid and their salts and esters, and chlorobenzilate [ISO])	Export	Algeria	DZ	DZA	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tunisia	TN	TUN	CWC scheduled chemicals	3010	34854
2920.9	Esters of other inorganic acids of non-metals and their salts; their halogenated, sulphonated, nitrated or nitrosated derivatives (excl. esters of hydrogen halides, and thiophosphoric esters "phosphorothioates", their salts and their halogenated, sulphonated, nitrated or nitrosated derivatives, and …	Export	Tunisia	TN	TUN	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Algeria	DZ	DZA	CWC scheduled chemicals	144	20494
2920.9	Esters of other inorganic acids of non-metals and their salts; their halogenated, sulphonated, nitrated or nitrosated derivatives (excl. esters of hydrogen halides, and thiophosphoric esters "phosphorothioates", their salts and their halogenated, sulphonated, nitrated or nitrosated derivatives, and …	Export	Algeria	DZ	DZA	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tunisia	TN	TUN	CWC scheduled chemicals	10	1298


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
);