Baselight
Sign In

Strategic Trade Atlas Data 2018-2022

Joint Research Centre

@ecjrc.aa2af144_7549_45c7_a765_9d5a365809c7

Table 1
@ecjrc.aa2af144_7549_45c7_a765_9d5a365809c7.table_1

The compressed CSV file contains 2260 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.18 KB
  • 2260 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

ExportMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)AlgeriaDZDZA8220043240739453729141
ExportMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)EgyptEGEGY4527884272127554849961
ExportMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)LibyaLYLBY5595932181128889521011
ExportMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)MoroccoMAMAR3867833387136552112546
ExportMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)TunisiaTNTUN1092171607318124126726
ExportMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)AngolaAOAGO7410941286344086451656
ExportMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)BeninBJBEN10260556151071806481
ExportMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)BotswanaBWBWA11539816496636479537
ExportMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Br. Indian Ocean Terr.IOIOT57555768784432
ExportMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Burkina FasoBFBFA13104928965659911060

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