Baselight
Sign In

Strategic Trade Atlas Data 2017-2021

Joint Research Centre

@ecjrc.n_615fdfdd_4d29_4b0c_b558_56b8b8276da0

Table 3
@ecjrc.n_615fdfdd_4d29_4b0c_b558_56b8b8276da0.table_3

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

  • 48.2 KB
  • 2261 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

ExportSun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)AlgeriaDZDZA9483100229839517164846
ExportSun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)EgyptEGEGY4573537083233513162526
ExportSun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)LibyaLYLBY4366698082218175762311
ExportSun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)MoroccoMAMAR3805556900733726889681
ExportSun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)TunisiaTNTUN968698813516508281515
ExportSun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)AngolaAOAGO8471401490838687342140
ExportSun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)BeninBJBEN11871654451693569920
ExportSun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)BotswanaBWBWA9477512976981711655
ExportSun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)Br. Indian Ocean Terr.IOIOT685480917836942
ExportSun Dec 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)Burkina FasoBFBFA15594995805230356983

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

Share link

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