Trade In Goods, By Main World Traders - EU27 (from 2020)

Eurostat code: tet00071 · (2013 - 2024)

@eurostat.tet00071

Table List

2 tables(23.07 KB)

Trade In Goods, By Main World Traders - EU27 (from 2020) - Raw

Trade In Goods, By Main World Traders - EU27 (from 2020) - Unpivoted

Trade In Goods, By Main World Traders - EU27 (from 2020) - Unpivoted

@eurostat.tet00071.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.

8.13 KB
580 rows
6 columns

freq Freq	indic_et Indic Et	sitc06 Sitc06	geo Geo	time_period Time Period	value Value
Annual	Trade balance in million ECU/EURO	Total - all products	Canada	2013	-3905.4
Annual	Trade balance in million ECU/EURO	Total - all products	European Union - 27 countries (from 2020)	2013	149369.3
Annual	Trade balance in million ECU/EURO	Total - all products	India	2013	-97458.2
Annual	Trade balance in million ECU/EURO	Total - all products	Japan	2013	-88900.5
Annual	Trade balance in million ECU/EURO	Total - all products	South Korea	2013	33164.4
Annual	Trade balance in million ECU/EURO	Total - all products	Mexico	2013	-949.4
Annual	Trade balance in million ECU/EURO	Total - all products	Russia	2013	159868.1
Annual	Trade balance in million ECU/EURO	Total - all products	Singapore	2013	24007.9
Annual	Trade balance in million ECU/EURO	Total - all products	United Kingdom	2013	-82208.2
Annual	Trade balance in million ECU/EURO	Total - all products	United States	2013	-563965.8


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

Share link

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