Dataset: Strategic Trade Atlas Data 2015-2019

The compressed CSV file contains 102783 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	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Andorra	AD	AND	Accelerometers and gyroscopes	-0.8	-0.3	0.1	0.5
Export	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	United Arab Emirates	AE	ARE	Accelerometers and gyroscopes	-0.6	-0.5	0.3	0.3
Export	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Afghanistan	AF	AFG	Accelerometers and gyroscopes	-0.9	-0.7		0.2
Export	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Antigua and Barbuda	AG	ATG	Accelerometers and gyroscopes	-0.8	-0.9	0.1	0.1
Export	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Angola	AO	AGO	Accelerometers and gyroscopes	-0.9	-0.9		0.1
Export	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Argentina	AR	ARG	Accelerometers and gyroscopes	-1	-1
Export	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Austria	AT	AUT	Accelerometers and gyroscopes	-0.6	-0.9	0.2	0.1
Export	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Australia	AU	AUS	Accelerometers and gyroscopes	-0.9	-0.1	0.1	0.8
Export	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Azerbaijan	AZ	AZE	Accelerometers and gyroscopes	-1	-1
Export	Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Barbados	BB	BRB	Accelerometers and gyroscopes	-0.5	-0.5	0.4	0.3

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

Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

Andorra

AND

Accelerometers and gyroscopes

-0.8

-0.3

0.1

0.5

Export

Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

United Arab Emirates

ARE

Accelerometers and gyroscopes

-0.6

-0.5

0.3

Export

Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

Afghanistan

AFG

Accelerometers and gyroscopes

-0.9

-0.7

0.2

Export

Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

Antigua and Barbuda

ATG

Accelerometers and gyroscopes

-0.8

-0.9

0.1

Export

Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

Angola

AGO

Accelerometers and gyroscopes

-0.9

0.1

Export

Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

Argentina

ARG

Accelerometers and gyroscopes

-1

Export

Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

Austria

AUT

Accelerometers and gyroscopes

-0.6

-0.9

0.2

0.1

Export

Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

Australia

AUS

Accelerometers and gyroscopes

-0.9

-0.1

0.1

0.8

Export

Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

Azerbaijan

AZE

Accelerometers and gyroscopes

-1

Export

Thu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)

Barbados

BRB

Accelerometers and gyroscopes

-0.5

0.4

0.3

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 2015-2019

Table List

Table 2

@ecjrc.fa20328f_15a6_43db_bad8_7fa58c56aef6.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