Strategic Trade Atlas Data 2013-2017

Joint Research Centre

@ecjrc.n_3a775da0_420f_444c_9813_74a0aefa65c9

Table List

3 tables(33.95 MB)

Table 2

@ecjrc.n_3a775da0_420f_444c_9813_74a0aefa65c9.table_2

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

33.47 MB
2174200 rows
13 columns

commodity_code Commodity Code	commodity_description Commodity Description	flow Flow	partner_iso2 Partner Iso2	partner_iso3 Partner Iso3	partner Partner	period Period	quantity_kg Quantity Kg	reporter_iso2 Reporter Iso2	reporter_iso3 Reporter Iso3	reporter Reporter	strategic_commodity_short_description Strategic Commodity Short Description	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	TN	TUN	Tunisia	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	39600	EG	EGY	Egypt	CWC scheduled chemicals	66737.49
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	DZ	DZA	Algeria	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	655.64	TN	TUN	Tunisia	CWC scheduled chemicals	11606.8
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	EG	EGY	Egypt	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	428	TN	TUN	Tunisia	CWC scheduled chemicals	6263
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	LY	LBY	Libya	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1897102	TN	TUN	Tunisia	CWC scheduled chemicals	490216
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	DZ	DZA	Algeria	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14	TN	TUN	Tunisia	Radioactive elements	9070
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	LY	LBY	Libya	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	316	TN	TUN	Tunisia	Radioactive elements	74225
2904.9	Sulphonated, nitrated or nitrosated derivatives of hydrocarbons, whether or not halogenated (excl. those containing only sulpho, nitro or nitroso groups)	Export	TN	TUN	Tunisia	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	4156134	DZ	DZA	Algeria	CWC scheduled chemicals	7640292
3002	Human blood; animal blood prepared for therapeutic, prophylactic or diagnostic uses; antisera and other blood fractions and immunological products, whether or not modified or obtained by means of biotechnological processes; vaccines, toxins, cultures of micro-organisms (excl. yeasts) and similar pro…	Export	TN	TUN	Tunisia	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	12	DZ	DZA	Algeria	Micro-organisms and toxins	2950
3002	Human blood; animal blood prepared for therapeutic, prophylactic or diagnostic uses; antisera and other blood fractions and immunological products, whether or not modified or obtained by means of biotechnological processes; vaccines, toxins, cultures of micro-organisms (excl. yeasts) and similar pro…	Export	DZ	DZA	Algeria	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	95	EG	EGY	Egypt	Micro-organisms and toxins	197295
3002	Human blood; animal blood prepared for therapeutic, prophylactic or diagnostic uses; antisera and other blood fractions and immunological products, whether or not modified or obtained by means of biotechnological processes; vaccines, toxins, cultures of micro-organisms (excl. yeasts) and similar pro…	Export	TN	TUN	Tunisia	Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	12998	MA	MAR	Morocco	Micro-organisms and toxins	1419261


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