Baselight

Strategic Trade Atlas Data 2013-2017

Joint Research Centre

@ecjrc.n_3a775da0_420f_444c_9813_74a0aefa65c9

Table 3
@ecjrc.n_3a775da0_420f_444c_9813_74a0aefa65c9.table_3

The compressed CSV file contains 94541 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).

  • 448.51 KB
  • 94541 rows
  • 10 columns
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-0.9-0.5Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)0.10.4AEAREUnited Arab EmiratesAccelerometers and gyroscopes
Export-1-1Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)AOAGOAngolaAccelerometers and gyroscopes
Export-0.9-1Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)ARARGArgentinaAccelerometers and gyroscopes
Export-0.2-0.3Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)0.70.5ATAUTAustriaAccelerometers and gyroscopes
Export-0.8-0.7Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)0.10.2AUAUSAustraliaAccelerometers and gyroscopes
Export-0.10.6Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)0.94.7AWAWBArubaAccelerometers and gyroscopes
Export-1-1Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)AZAZEAzerbaijanAccelerometers and gyroscopes
Export-0.7-0.3Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)0.20.6BABIHBosnia HerzegovinaAccelerometers and gyroscopes
Export-0.4-0.8Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)0.50.1BDBGDBangladeshAccelerometers and gyroscopes
Export-0.4-0.5Tue Dec 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)0.40.3BEBELBelgium-LuxembourgAccelerometers 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
);

Share link

Anyone who has the link will be able to view this.