Dataset: Strategic Trade Atlas Data 2017-2021

The compressed CSV file contains 105592 records about the Revealed Comparative Advantage by countries measured on the trade of strategic 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); STRATEGIC COMMODITY SHORT DESCRIPTION; RCA VALUE USD (the Revealed Comparative Advantage measured on the value of trade); RCA QUANTITY KG (the Revealed Comparative Advantage measured on the quantity of trade); NRCA VALUE USD (the Normalized Revealed Comparative Advantage measured on the value of trade); NRCA QUANTITY KG (the Normalized Revealed Comparative Advantage measured on the quantity of trade).

flow FLOW	period PERIOD	reporter REPORTER	reporter_iso2 REPORTER ISO2	reporter_iso3 REPORTER ISO3	strategic_commodity_short_description STRATEGIC COMMODITY SHORT DESCRIPTION	nrca_quantity_kg NRCA QUANTITY KG	nrca_value_usd NRCA VALUE USD	rca_quantity_kg RCA QUANTITY KG	rca_value_usd RCA VALUE USD
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Costa Rica	CR	CRI	Isostatic presses	-0.5	-0.9	0.3	0.1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Cuba	CU	CUB	Isostatic presses	-0.8	-1	0.1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Cape Verde	CV	CPV	Isostatic presses	-0.8	-0.9	0.1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Curacao	CW	CUW	Isostatic presses	-1	-1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Cyprus	CY	CYP	Isostatic presses	-0.9	-0.9	0.1	0.1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Czech Rep.	CZ	CZE	Isostatic presses	0.7	0.1	6.5	1.3
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Germany	DE	DEU	Isostatic presses	0.7	0.5	6.1	2.6
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Djibouti	DJ	DJI	Isostatic presses	-0.8	-1	0.1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Denmark	DK	DNK	Isostatic presses	0.6	0.1	4.1	1.3
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Dominica	DM	DMA	Isostatic presses	-0.9	-1

flow

FLOW

period

PERIOD

reporter

REPORTER

reporter_iso2

REPORTER ISO2

reporter_iso3

REPORTER ISO3

strategic_commodity_short_description

STRATEGIC COMMODITY SHORT DESCRIPTION

nrca_quantity_kg

NRCA QUANTITY KG

nrca_value_usd

NRCA VALUE USD

rca_quantity_kg

RCA QUANTITY KG

rca_value_usd

RCA VALUE USD

Export

Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)

Costa Rica

CRI

Isostatic presses

-0.5

-0.9

0.3

0.1

Export

Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)

Cuba

CUB

Isostatic presses

-0.8

-1

0.1

Export

Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)

Cape Verde

CPV

Isostatic presses

-0.8

-0.9

0.1

Export

Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)

Curacao

CUW

Isostatic presses

-1

Export

Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)

Cyprus

CYP

Isostatic presses

-0.9

0.1

Export

Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)

Czech Rep.

CZE

Isostatic presses

0.7

0.1

6.5

1.3

Export

Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)

Germany

DEU

Isostatic presses

0.7

0.5

6.1

2.6

Export

Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)

Djibouti

DJI

Isostatic presses

-0.8

-1

0.1

Export

Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)

Denmark

DNK

Isostatic presses

0.6

0.1

4.1

1.3

Export

Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)

Dominica

DMA

Isostatic presses

-0.9

-1

CREATE TABLE table_2 ( "flow" VARCHAR, "period" TIMESTAMP, "reporter" VARCHAR, "reporter_iso2" VARCHAR, "reporter_iso3" VARCHAR, "strategic_commodity_short_description" VARCHAR, "nrca_quantity_kg" DOUBLE, "nrca_value_usd" DOUBLE, "rca_quantity_kg" DOUBLE, "rca_value_usd" DOUBLE );

Strategic Trade Atlas Data 2017-2021

Table List

Table 2

@ecjrc.n_615fdfdd_4d29_4b0c_b558_56b8b8276da0.table_2

flow

period

reporter

reporter_iso2

reporter_iso3

strategic_commodity_short_description

nrca_quantity_kg

nrca_value_usd

rca_quantity_kg

rca_value_usd

Share link