Baselight
Sign In

Strategic Trade Atlas Data 2015-2019

Joint Research Centre

@ecjrc.fa20328f_15a6_43db_bad8_7fa58c56aef6

Table 3
@ecjrc.fa20328f_15a6_43db_bad8_7fa58c56aef6.table_3

The compressed CSV file contains 2251 records about the total trade by countries measured on the aggregation of all 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); Trade VALUE USD and QUANTITY KG.

  • 44.04 KB
  • 2251 rows
  • 7 columns
flow

FLOW

period

PERIOD

reporter

REPORTER

reporter_iso2

REPORTER ISO2

reporter_iso3

REPORTER ISO3

quantity_kg

QUANTITY KG

value_usd

VALUE USD

ExportThu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)AlgeriaDZDZA93951593533$38,021M
ExportThu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)EgyptEGEGY35159695092$28,336M
ExportThu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)LibyaLYLBY23468359003$10,301M
ExportThu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)MoroccoMAMAR30810030077$27,372M
ExportThu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)TunisiaTNTUN11387709321$15,837M
ExportThu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)AngolaAOAGO95860876018$37,447M
ExportThu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)BeninBJBEN1358891859$1,260M
ExportThu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)BotswanaBWBWA1284143298$5,351M
ExportThu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Br. Indian Ocean Terr.IOIOT4108373$32M
ExportThu Dec 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)Burkina FasoBFBFA1449100496$3,586M

CREATE TABLE table_3 (
  "flow" VARCHAR,
  "period" TIMESTAMP,
  "reporter" VARCHAR,
  "reporter_iso2" VARCHAR,
  "reporter_iso3" VARCHAR,
  "quantity_kg" BIGINT,
  "value_usd" VARCHAR
);

Share link

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