Dataset: Strategic Trade Atlas Data 2016-2020

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

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
8479.89	Machines and mechanical appliances, n.e.s.	Export	Dominican Rep.	DO	DOM	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Canada	CA	CAN	Isostatic presses		148593
8479.89	Machines and mechanical appliances, n.e.s.	Export	El Salvador	SV	SLV	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Canada	CA	CAN	Isostatic presses	4511	166111
8479.89	Machines and mechanical appliances, n.e.s.	Export	Grenada	GD	GRD	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Canada	CA	CAN	Isostatic presses	100	696
8479.89	Machines and mechanical appliances, n.e.s.	Export	Guatemala	GT	GTM	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Canada	CA	CAN	Isostatic presses	5985	16628
8479.89	Machines and mechanical appliances, n.e.s.	Export	Honduras	HN	HND	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Canada	CA	CAN	Isostatic presses	9227	306313
8479.89	Machines and mechanical appliances, n.e.s.	Export	Jamaica	JM	JAM	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Canada	CA	CAN	Isostatic presses	2459	7709
8479.89	Machines and mechanical appliances, n.e.s.	Export	Mexico	MX	MEX	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Canada	CA	CAN	Isostatic presses		24392187
8479.89	Machines and mechanical appliances, n.e.s.	Export	Nicaragua	NI	NIC	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Canada	CA	CAN	Isostatic presses	7154	321738
8479.89	Machines and mechanical appliances, n.e.s.	Export	Panama	PA	PAN	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Canada	CA	CAN	Isostatic presses	1700	1833625
8479.89	Machines and mechanical appliances, n.e.s.	Export	Saint Kitts and Nevis	KN	KNA	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Canada	CA	CAN	Isostatic presses	36	1148

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

8479.89

Machines and mechanical appliances, n.e.s.

Export

Dominican Rep.

DOM

Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)

Canada

CAN

Isostatic presses

148593

8479.89

Machines and mechanical appliances, n.e.s.

Export

El Salvador

SLV

Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)

Canada

CAN

Isostatic presses

4511

166111

8479.89

Machines and mechanical appliances, n.e.s.

Export

Grenada

GRD

Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)

Canada

CAN

Isostatic presses

100

696

8479.89

Machines and mechanical appliances, n.e.s.

Export

Guatemala

GTM

Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)

Canada

CAN

Isostatic presses

5985

16628

8479.89

Machines and mechanical appliances, n.e.s.

Export

Honduras

HND

Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)

Canada

CAN

Isostatic presses

9227

306313

8479.89

Machines and mechanical appliances, n.e.s.

Export

Jamaica

JAM

Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)

Canada

CAN

Isostatic presses

2459

7709

8479.89

Machines and mechanical appliances, n.e.s.

Export

Mexico

MEX

Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)

Canada

CAN

Isostatic presses

24392187

8479.89

Machines and mechanical appliances, n.e.s.

Export

Nicaragua

NIC

Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)

Canada

CAN

Isostatic presses

7154

321738

8479.89

Machines and mechanical appliances, n.e.s.

Export

Panama

PAN

Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)

Canada

CAN

Isostatic presses

1700

1833625

8479.89

Machines and mechanical appliances, n.e.s.

Export

Saint Kitts and Nevis

KNA

Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)

Canada

CAN

Isostatic presses

1148

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

Strategic Trade Atlas Data 2016-2020

Table List

Table 3

@ecjrc.n_5d9937c8_5d7b_42dc_a09f_a5c28d959f5d.table_3

commodity_code

commodity_description

flow

partner

partner_iso2

partner_iso3

period

reporter

reporter_iso2

reporter_iso3

strategic_commodity_short_description

quantity_kg

value_usd

Share link