Strategic Trade Atlas Data 2012-2016

Joint Research Centre

@ecjrc.n_68002410_9be4_4f6d_8dc4_1c3b6904ca40

Table List

3 tables(32.86 MB)

Table 1

@ecjrc.n_68002410_9be4_4f6d_8dc4_1c3b6904ca40.table_1

The compressed CSV file contains about 2.1 Millions of 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.

32.38 MB
2119026 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
2931.9	Separate chemically defined organo-inorganic compounds (excl. organo-sulphur compounds and those of mercury, tetramethyl lead, tetraethyl lead and tributyltin compounds)	Export	AU	AUS	Australia	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	12	AR	ARG	Argentina	CWC scheduled chemicals	145166.73
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	NZ	NZL	New Zealand	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	4863	AR	ARG	Argentina	Micro-organisms and toxins	379156
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	AU	AUS	Australia	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2	BR	BRA	Brazil	Micro-organisms and toxins	3981
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	NZ	NZL	New Zealand	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	133.11	BR	BRA	Brazil	Micro-organisms and toxins	42266.09
3603	Safety fuses; detonating fuses; percussion or detonating caps; igniters; electric detonators (excl. grenade detonators and cartridge cases, whether or not with percussion caps)	Export	AU	AUS	Australia	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	259.87	BR	BRA	Brazil	Detonators	21856.7
3603	Safety fuses; detonating fuses; percussion or detonating caps; igniters; electric detonators (excl. grenade detonators and cartridge cases, whether or not with percussion caps)	Export	AU	AUS	Australia	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	228881.59	CL	CHL	Chile	Detonators	6826605.65
3603	Safety fuses; detonating fuses; percussion or detonating caps; igniters; electric detonators (excl. grenade detonators and cartridge cases, whether or not with percussion caps)	Export	NZ	NZL	New Zealand	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2066.58	CL	CHL	Chile	Detonators	94676.12
3603	Safety fuses; detonating fuses; percussion or detonating caps; igniters; electric detonators (excl. grenade detonators and cartridge cases, whether or not with percussion caps)	Export	NZ	NZL	New Zealand	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	485.32	PE	PER	Peru	Detonators	81191.22
3602	Prepared explosives (excl. propellent powders)	Export	AU	AUS	Australia	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	21263.17	CL	CHL	Chile	Explosives	436553.81
3602	Prepared explosives (excl. propellent powders)	Export	NZ	NZL	New Zealand	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	63758.98	CL	CHL	Chile	Explosives	319758.91


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