Transit Transport By Group Of Goods (1982-2002)

Eurostat code: rail_go_trsggds · (1982 - 2002)

@eurostat.rail_go_trsggds

Table List

2 tables(64.93 KB)

Transit Transport By Group Of Goods (1982-2002) - Raw

Transit Transport By Group Of Goods (1982-2002) - Unpivoted

Transit Transport By Group Of Goods (1982-2002) - Unpivoted

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

24.44 KB
7837 rows
7 columns

freq Freq	unit Unit	consign Consign	nstr24 Nstr24	geo Geo	time_period Time Period	value Value
Annual	Million tonne-kilometre (TKM)	Total	Cereals	Belgium	1982	54
Annual	Million tonne-kilometre (TKM)	Total	Cereals	Germany	1982	6
Annual	Million tonne-kilometre (TKM)	Total	Cereals	France	1982	15
Annual	Million tonne-kilometre (TKM)	Total	Cereals	Italy	1982
Annual	Million tonne-kilometre (TKM)	Total	Cereals	Luxembourg	1982	10
Annual	Million tonne-kilometre (TKM)	Total	Potatoes, other fresh or frozen fruits and vegetables	Belgium	1982	15
Annual	Million tonne-kilometre (TKM)	Total	Potatoes, other fresh or frozen fruits and vegetables	Germany	1982	298
Annual	Million tonne-kilometre (TKM)	Total	Potatoes, other fresh or frozen fruits and vegetables	Denmark	1982	32
Annual	Million tonne-kilometre (TKM)	Total	Potatoes, other fresh or frozen fruits and vegetables	France	1982	621
Annual	Million tonne-kilometre (TKM)	Total	Potatoes, other fresh or frozen fruits and vegetables	Italy	1982	1


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

Share link

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