Dataset: Strategic Trade Atlas Data 2012-2016

The compressed CSV file contains 93474 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	nrca_quantity_kg Nrca Quantity Kg	nrca_value_usd Nrca Value Usd	period Period	rca_quantity_kg Rca Quantity Kg	rca_value_usd Rca Value Usd	reporter_iso2 Reporter Iso2	reporter_iso3 Reporter Iso3	reporter Reporter	strategic_commodity_short_description Strategic Commodity Short Description
Export	-1	-0.6	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)		0.3	AD	AND	Andorra	Accelerometers and gyroscopes
Export	-0.8	-0.5	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1	0.3	AE	ARE	United Arab Emirates	Accelerometers and gyroscopes
Export	-0.9	-0.5	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1	0.3	AF	AFG	Afghanistan	Accelerometers and gyroscopes
Export	-1	-0.9	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)		0.1	AL	ALB	Albania	Accelerometers and gyroscopes
Export	-0.8	0.4	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1	2.1	AM	ARM	Armenia	Accelerometers and gyroscopes
Export	-1	-1	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)			AO	AGO	Angola	Accelerometers and gyroscopes
Export	-1	-1	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)			AR	ARG	Argentina	Accelerometers and gyroscopes
Export	-0.8	-0.2	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1	0.6	AT	AUT	Austria	Accelerometers and gyroscopes
Export	-1	-0.6	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)		0.2	AU	AUS	Australia	Accelerometers and gyroscopes
Export	-1	-1	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)			AZ	AZE	Azerbaijan	Accelerometers and gyroscopes

flow

Flow

nrca_quantity_kg

Nrca Quantity Kg

nrca_value_usd

Nrca Value Usd

period

Period

rca_quantity_kg

Rca Quantity Kg

rca_value_usd

Rca Value Usd

reporter_iso2

Reporter Iso2

reporter_iso3

Reporter Iso3

reporter

Reporter

strategic_commodity_short_description

Strategic Commodity Short Description

Export

-1

-0.6

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

0.3

AND

Andorra

Accelerometers and gyroscopes

Export

-0.8

-0.5

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

0.1

0.3

ARE

United Arab Emirates

Accelerometers and gyroscopes

Export

-0.9

-0.5

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

0.1

0.3

AFG

Afghanistan

Accelerometers and gyroscopes

Export

-1

-0.9

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

0.1

ALB

Albania

Accelerometers and gyroscopes

Export

-0.8

0.4

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

0.1

2.1

ARM

Armenia

Accelerometers and gyroscopes

Export

-1

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

AGO

Angola

Accelerometers and gyroscopes

Export

-1

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

ARG

Argentina

Accelerometers and gyroscopes

Export

-0.8

-0.2

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

0.1

0.6

AUT

Austria

Accelerometers and gyroscopes

Export

-1

-0.6

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

0.2

AUS

Australia

Accelerometers and gyroscopes

Export

-1

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

AZE

Azerbaijan

Accelerometers and gyroscopes

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

Strategic Trade Atlas Data 2012-2016

Table List

Table 3

@ecjrc.n_68002410_9be4_4f6d_8dc4_1c3b6904ca40.table_3

flow

nrca_quantity_kg

nrca_value_usd

period

rca_quantity_kg

rca_value_usd

reporter_iso2

reporter_iso3

reporter

strategic_commodity_short_description

Share link