Dataset: Strategic Trade Atlas Data 2016-2020

The compressed CSV file contains 107411 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
Import	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Guam	GU	GUM	Parts of military weapons	-0.9	-0.5		0.4
Import	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Hong Kong	HK	HKG	Parts of military weapons	-1	-1
Import	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Honduras	HN	HND	Parts of military weapons	-0.7	-0.6	0.1	0.3
Import	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Croatia	HR	HRV	Parts of military weapons	-0.8	-0.9	0.1	0.1
Import	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Hungary	HU	HUN	Parts of military weapons	-0.6	-0.8	0.3	0.1
Import	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Indonesia	ID	IDN	Parts of military weapons	-0.3	0.2	0.5	1.4
Import	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Ireland	IE	IRL	Parts of military weapons	-0.8	-0.9	0.1	0.1
Import	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Israel	IL	ISR	Parts of military weapons	-0.8	0.8	0.1	8.4
Import	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	India	IN	IND	Parts of military weapons	-0.8	-0.2	0.1	0.7
Import	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Iraq	IQ	IRQ	Parts of military weapons	-0.9	-0.8	0.1	0.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

Import

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

Guam

GUM

Parts of military weapons

-0.9

-0.5

0.4

Import

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

Hong Kong

HKG

Parts of military weapons

-1

Import

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

Honduras

HND

Parts of military weapons

-0.7

-0.6

0.1

0.3

Import

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

Croatia

HRV

Parts of military weapons

-0.8

-0.9

0.1

Import

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

Hungary

HUN

Parts of military weapons

-0.6

-0.8

0.3

0.1

Import

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

Indonesia

IDN

Parts of military weapons

-0.3

0.2

0.5

1.4

Import

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

Ireland

IRL

Parts of military weapons

-0.8

-0.9

0.1

Import

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

Israel

ISR

Parts of military weapons

-0.8

0.8

0.1

8.4

Import

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

India

IND

Parts of military weapons

-0.8

-0.2

0.1

0.7

Import

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

Iraq

IRQ

Parts of military weapons

-0.9

-0.8

0.1

CREATE TABLE table_1 ( "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 2016-2020

Table List

Table 1

@ecjrc.n_5d9937c8_5d7b_42dc_a09f_a5c28d959f5d.table_1

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