Dataset: Strategic Trade Atlas Data 2018-2022

The compressed CSV file contains 88031 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)	Andorra	AD	AND	Accelerometers and gyroscopes	-1	-0.9		0.1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	United Arab Emirates	AE	ARE	Accelerometers and gyroscopes	-0.6	-0.7	0.3	0.2
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Afghanistan	AF	AFG	Accelerometers and gyroscopes	-0.4	-0.8	0.5	0.1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Albania	AL	ALB	Accelerometers and gyroscopes	-0.9	-0.9
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Angola	AO	AGO	Accelerometers and gyroscopes	-1	-1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Argentina	AR	ARG	Accelerometers and gyroscopes	-1	-1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Austria	AT	AUT	Accelerometers and gyroscopes	-0.5	-0.9	0.3
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Australia	AU	AUS	Accelerometers and gyroscopes	-0.7	-0.3	0.2	0.5
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Azerbaijan	AZ	AZE	Accelerometers and gyroscopes	-1	-1
Export	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Bosnia Herzegovina	BA	BIH	Accelerometers and gyroscopes	-1	-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)

Andorra

AND

Accelerometers and gyroscopes

-1

-0.9

0.1

Export

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

United Arab Emirates

ARE

Accelerometers and gyroscopes

-0.6

-0.7

0.3

0.2

Export

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

Afghanistan

AFG

Accelerometers and gyroscopes

-0.4

-0.8

0.5

0.1

Export

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

Albania

ALB

Accelerometers and gyroscopes

-0.9

Export

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

Angola

AGO

Accelerometers and gyroscopes

-1

Export

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

Argentina

ARG

Accelerometers and gyroscopes

-1

Export

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

Austria

AUT

Accelerometers and gyroscopes

-0.5

-0.9

0.3

Export

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

Australia

AUS

Accelerometers and gyroscopes

-0.7

-0.3

0.2

0.5

Export

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

Azerbaijan

AZE

Accelerometers and gyroscopes

-1

Export

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

Bosnia Herzegovina

BIH

Accelerometers and gyroscopes

-1

CREATE TABLE table_3 ( "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 2018-2022

Table List

Table 3

@ecjrc.aa2af144_7549_45c7_a765_9d5a365809c7.table_3

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