National Transport Of Goods By Distance Class And Group Of Goods (1982-2002)

Eurostat code: rail_go_natdist · (1982 - 2002)

@eurostat.rail_go_natdist

Table List

2 tables(281.47 KB)

National Transport Of Goods By Distance Class And Group Of Goods (1982-2002) - Raw

National Transport Of Goods By Distance Class And Group Of Goods (1982-2002) - Unpivoted

National Transport Of Goods By Distance Class And Group Of Goods (1982-2002) - Unpivoted

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

123.11 KB
48649 rows
7 columns

freq Freq	unit Unit	nstr24 Nstr24	distance Distance	geo Geo	time_period Time Period	value Value
Annual	Million tonne-kilometre (TKM)	Cereals	From 150 to 499 km	Germany	1982	27
Annual	Million tonne-kilometre (TKM)	Cereals	From 150 to 499 km	Denmark	1982	2
Annual	Million tonne-kilometre (TKM)	Cereals	From 150 to 499 km	Greece	1982	6
Annual	Million tonne-kilometre (TKM)	Cereals	From 150 to 499 km	European Union - 15 countries (1995-2004)	1982	1074
Annual	Million tonne-kilometre (TKM)	Cereals	From 150 to 499 km	France	1982	923
Annual	Million tonne-kilometre (TKM)	Cereals	From 150 to 499 km	Italy	1982	86
Annual	Million tonne-kilometre (TKM)	Cereals	From 150 to 499 km	United Kingdom	1982	30
Annual	Million tonne-kilometre (TKM)	Cereals	From 50 to 149 km	Belgium	1982	1
Annual	Million tonne-kilometre (TKM)	Cereals	From 50 to 149 km	Germany	1982	18
Annual	Million tonne-kilometre (TKM)	Cereals	From 50 to 149 km	Greece	1982


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

Share link

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