Baselight
Sign In

Strategic Trade Atlas Data 2013-2017

Joint Research Centre

@ecjrc.n_3a775da0_420f_444c_9813_74a0aefa65c9

Table 1
@ecjrc.n_3a775da0_420f_444c_9813_74a0aefa65c9.table_1

The compressed CSV file contains 2210 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.1 KB
  • 2211 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

ExportWed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)AlgeriaDZDZA9670632211763949242140
ExportWed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)EgyptEGEGY4004443418833875866746
ExportWed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)LibyaLYLBY2787553210319447806358
ExportWed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)MoroccoMAMAR2122410008223588074577
ExportWed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)TunisiaTNTUN1132956965518448176028
ExportWed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)AngolaAOAGO9420464444363808147492
ExportWed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)BeninBJBEN749996308.61048899909
ExportWed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)Br. Indian Ocean Terr.IOIOT813894.1327989524
ExportWed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)Burkina FasoBFBFA375098710.42017415714
ExportWed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)BurundiBIBDI90374461.25332500330

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

Share link

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