National Transport By Loading Region And By Group Of Goods (Directive 80/1177/EEC) (1982-2002)

Eurostat code: rail_go_natlreg · (1982 - 2002)

@eurostat.rail_go_natlreg

Table List

2 tables(209.98 KB)

National Transport By Loading Region And By Group Of Goods (Directive 80/1177/EEC) (1982-2002) - Raw

National Transport By Loading Region And By Group Of Goods (Directive 80/1177/EEC) (1982-2002) - Unpivoted

National Transport By Loading Region And By Group Of Goods (Directive 80/1177/EEC) (1982-2002) - Unpivoted

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

88.58 KB
44184 rows
6 columns

freq Freq	unit Unit	nstr24 Nstr24	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	Cereals	Vlaams Gewest	1982	4
Annual	Thousand tonnes	Cereals	Prov. Antwerpen	1982	6
Annual	Thousand tonnes	Cereals	Baden-Württemberg East	1982	21
Annual	Thousand tonnes	Cereals	Baden-Württemberg North West	1982	21
Annual	Thousand tonnes	Cereals	Baden-Württemberg South West	1982	12
Annual	Thousand tonnes	Cereals	Bayern - East	1982	18
Annual	Thousand tonnes	Cereals	Bayern - North	1982	15
Annual	Thousand tonnes	Cereals	Bayern - South	1982	14
Annual	Thousand tonnes	Cereals	Berlin	1982	3
Annual	Thousand tonnes	Cereals	Bremen	1982	29


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "nstr24" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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