Strategic Trade Atlas Data 2012-2016

Joint Research Centre

@ecjrc.n_68002410_9be4_4f6d_8dc4_1c3b6904ca40

Table List

3 tables(32.86 MB)

Table 2

@ecjrc.n_68002410_9be4_4f6d_8dc4_1c3b6904ca40.table_2

The compressed CSV file contains 2208 records about the total trade by countries measured on the aggregation of all commodities. A record contains the following fields: REPORTER (country reporting trade, expressed in full text name, as well as ISO2 and ISO3 country codes); FLOW of trade (import, export); PERIOD of trade (a year); Trade VALUE USD and QUANTITY KG.

51.64 KB
2208 rows
7 columns

flow Flow	period Period	quantity_kg Quantity Kg	reporter_iso2 Reporter Iso2	reporter_iso3 Reporter Iso3	reporter Reporter	value_usd Value Usd
Export	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	99364952439.97	DZ	DZA	Algeria	74046348294.44
Export	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	32123521926.22	EG	EGY	Egypt	25307430211.13
Export	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	65846410021.06	LY	LBY	Libya	51671774253.94
Export	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	17092909271.86	MA	MAR	Morocco	19131142157.6
Export	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	12339915317.03	TN	TUN	Tunisia	18621891578.54
Export	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	70459438461.37	AO	AGO	Angola	54307309917.83
Export	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	486459884.64	BJ	BEN	Benin	617809164.78
Export	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2994636.17	IO	IOT	Br. Indian Ocean Terr.	30798851.33
Export	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	175798075.89	BF	BFA	Burkina Faso	1954994421.23
Export	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	26077900.99	BI	BDI	Burundi	94463254.99


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

Share link

Anyone who has the link will be able to view this.