International Trade By SITC - 1–000 EUR

Eurostat code: med_ecet · (2005 - 2019)

@eurostat.med_ecet

Table List

2 tables(88.09 KB)

International Trade By SITC - 1–000 EUR - Raw

International Trade By SITC - 1–000 EUR - Unpivoted

International Trade By SITC - 1–000 EUR - Unpivoted

@eurostat.med_ecet.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

40.77 KB
4566 rows
7 columns

freq Freq	stk_flow Stk Flow	partner Partner	sitc06 Sitc06	geo Geo	time_period Time Period	value Value
Annual	Exports	European Union - 28 countries (2013-2020)	Food and live animals	Algeria	2005	34735.8
Annual	Exports	European Union - 28 countries (2013-2020)	Food and live animals	Egypt	2005	211963
Annual	Exports	European Union - 28 countries (2013-2020)	Food and live animals	Israel	2005	694951.2
Annual	Exports	European Union - 28 countries (2013-2020)	Food and live animals	Jordan	2005	12546.6
Annual	Exports	European Union - 28 countries (2013-2020)	Food and live animals	Morocco	2005	1213655.3
Annual	Exports	European Union - 28 countries (2013-2020)	Food and live animals	Palestine*	2005	1768.1
Annual	Exports	European Union - 28 countries (2013-2020)	Food and live animals	Tunisia	2005	190529
Annual	Exports	European Union - 28 countries (2013-2020)	Beverages and tobacco	Algeria	2005	4362
Annual	Exports	European Union - 28 countries (2013-2020)	Beverages and tobacco	Egypt	2005	1680
Annual	Exports	European Union - 28 countries (2013-2020)	Beverages and tobacco	Israel	2005	5999.8


CREATE TABLE tidy (
  "freq" VARCHAR,
  "stk_flow" VARCHAR,
  "partner" VARCHAR,
  "sitc06" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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