Strategic Trade Atlas Data 2017-2021

Joint Research Centre

@ecjrc.n_615fdfdd_4d29_4b0c_b558_56b8b8276da0

Table List

3 tables(29.85 MB)

Table 1

@ecjrc.n_615fdfdd_4d29_4b0c_b558_56b8b8276da0.table_1

The compressed CSV file contains 2,621,656 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.

29.32 MB
2621656 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
6903	Retorts, crucibles, mufflers, nozzles, plugs, supports, cupels, tubes, pipes, sheaths, rods and other refractory ceramic goods (excl. those of siliceous fossil meals or of similar siliceous earths, and refractory bricks, blocks, tiles and similar refractory ceramic constructional goods)	Export	United Arab Emirates	AE	ARE	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Tunisia	TN	TUN	Ceramic crucibles	40281	120621
7019	Glass fibres, incl. glass wool, and articles thereof (excl. mineral wools and articles thereof, optical fibres, fibre bundles or cable, electrical insulators or parts thereof, brushes of glass fibres, dolls' wigs)	Export	Azerbaijan	AZ	AZE	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	EG	EGY	Glass fibre	19154	27610
7019	Glass fibres, incl. glass wool, and articles thereof (excl. mineral wools and articles thereof, optical fibres, fibre bundles or cable, electrical insulators or parts thereof, brushes of glass fibres, dolls' wigs)	Export	Bahrain	BH	BHR	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	EG	EGY	Glass fibre	26793	37401
7019	Glass fibres, incl. glass wool, and articles thereof (excl. mineral wools and articles thereof, optical fibres, fibre bundles or cable, electrical insulators or parts thereof, brushes of glass fibres, dolls' wigs)	Export	Iraq	IQ	IRQ	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	EG	EGY	Glass fibre	4888	15350
7019	Glass fibres, incl. glass wool, and articles thereof (excl. mineral wools and articles thereof, optical fibres, fibre bundles or cable, electrical insulators or parts thereof, brushes of glass fibres, dolls' wigs)	Export	Jordan	JO	JOR	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	EG	EGY	Glass fibre	41703	286731
7019	Glass fibres, incl. glass wool, and articles thereof (excl. mineral wools and articles thereof, optical fibres, fibre bundles or cable, electrical insulators or parts thereof, brushes of glass fibres, dolls' wigs)	Export	Kuwait	KW	KWT	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	EG	EGY	Glass fibre	136440	304887
7019	Glass fibres, incl. glass wool, and articles thereof (excl. mineral wools and articles thereof, optical fibres, fibre bundles or cable, electrical insulators or parts thereof, brushes of glass fibres, dolls' wigs)	Export	Lebanon	LB	LBN	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	EG	EGY	Glass fibre	215402	500017
7019	Glass fibres, incl. glass wool, and articles thereof (excl. mineral wools and articles thereof, optical fibres, fibre bundles or cable, electrical insulators or parts thereof, brushes of glass fibres, dolls' wigs)	Export	Occ. Palestinian Terr.	PS	PSE	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	EG	EGY	Glass fibre	49	246
7019	Glass fibres, incl. glass wool, and articles thereof (excl. mineral wools and articles thereof, optical fibres, fibre bundles or cable, electrical insulators or parts thereof, brushes of glass fibres, dolls' wigs)	Export	Oman	OM	OMN	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	EG	EGY	Glass fibre	27874	256257
7019	Glass fibres, incl. glass wool, and articles thereof (excl. mineral wools and articles thereof, optical fibres, fibre bundles or cable, electrical insulators or parts thereof, brushes of glass fibres, dolls' wigs)	Export	Qatar	QA	QAT	Sun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Egypt	EG	EGY	Glass fibre	767777	725054


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