Baselight
Sign In

Strategic Trade Atlas Data 2018-2022

Joint Research Centre

@ecjrc.aa2af144_7549_45c7_a765_9d5a365809c7

Table 2
@ecjrc.aa2af144_7549_45c7_a765_9d5a365809c7.table_2

The compressed CSV file contains 2,156,684 trade records. A record contains the following fields: REPORTER (country reporting trade, expressed in full text name, as well as ISO2 and ISO3 country codes); PARTNER (country partner in trade, expressed in full text name, as well as ISO2 and ISO3 country codes); FLOW of trade (import, export); PERIOD of trade (a year); COMMODITY CODE and COMMODITY DESCRIPTION (expressed in the Harmonized System); STRATEGIC COMMODITY SHORT DESCRIPTION; Trade VALUE USD and QUANTITY KG.

  • 24.19 MB
  • 2156684 rows
  • 13 columns
commodity_code

COMMODITY CODE

commodity_description

COMMODITY DESCRIPTION

flow

FLOW

partner

PARTNER

partner_iso2

PARTNER ISO2

partner_iso3

PARTNER ISO3

period

PERIOD

reporter

REPORTER

reporter_iso2

REPORTER ISO2

reporter_iso3

REPORTER ISO3

strategic_commodity_short_description

STRATEGIC COMMODITY SHORT DESCRIPTION

quantity_kg

QUANTITY KG

value_usd

VALUE USD

7020Articles of glass, n.e.s.ExportMaltaMTMLTMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)EgyptEGEGYRadiation-shielding windows3053
7020Articles of glass, n.e.s.ExportNetherlandsNLNLDMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)EgyptEGEGYRadiation-shielding windows7263
7020Articles of glass, n.e.s.ExportPolandPLPOLMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)EgyptEGEGYRadiation-shielding windows3101222
7020Articles of glass, n.e.s.ExportSlovakiaSKSVKMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)EgyptEGEGYRadiation-shielding windows643069
7020Articles of glass, n.e.s.ExportSwedenSESWEMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)EgyptEGEGYRadiation-shielding windows10005150
7020Articles of glass, n.e.s.ExportUnited KingdomGBGBRMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)EgyptEGEGYRadiation-shielding windows271417975
7020Articles of glass, n.e.s.ExportAustriaATAUTMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)MoroccoMAMARRadiation-shielding windows80209
7020Articles of glass, n.e.s.ExportBelgiumBEBELMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)MoroccoMAMARRadiation-shielding windows597
7020Articles of glass, n.e.s.ExportFranceFRFRAMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)MoroccoMAMARRadiation-shielding windows1447799248
7020Articles of glass, n.e.s.ExportGermanyDEDEUMon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)MoroccoMAMARRadiation-shielding windows221511345

CREATE TABLE table_2 (
  "commodity_code" DOUBLE,
  "commodity_description" VARCHAR,
  "flow" VARCHAR,
  "partner" VARCHAR,
  "partner_iso2" VARCHAR,
  "partner_iso3" VARCHAR,
  "period" TIMESTAMP,
  "reporter" VARCHAR,
  "reporter_iso2" VARCHAR,
  "reporter_iso3" VARCHAR,
  "strategic_commodity_short_description" VARCHAR,
  "quantity_kg" BIGINT,
  "value_usd" BIGINT
);

Share link

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