Train Traffic On The Rail Network - Switzerland (2020)

Eurostat code: rail_tf_ns20_ch · (2020 - 2020)

@eurostat.rail_tf_ns20_ch

Table List

2 tables(177.84 KB)

Train Traffic On The Rail Network - Switzerland (2020) - Raw

Train Traffic On The Rail Network - Switzerland (2020) - Unpivoted

Train Traffic On The Rail Network - Switzerland (2020) - Unpivoted

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

89.21 KB
8634 rows
6 columns

freq Freq	net_seg20 Net Seg20	train Train	unit Unit	time_period Time Period	value Value
Annual	Rupperswil Ost - Rupperswil	Goods trains	Number	2020	3192
Annual	Rupperswil Ost - Rupperswil	Other trains	Number	2020	1596
Annual	Rupperswil Ost - Rupperswil	Passenger trains	Number	2020	25406
Annual	Faido SMF Nord - Faido SMF	Goods trains	Number	2020	58
Annual	Faido SMF Nord - Faido SMF	Other trains	Number	2020	9
Annual	Faido SMF Nord - Faido SMF	Passenger trains	Number	2020	39
Annual	Faido SMF - Faido SMF Süd	Goods trains	Number	2020	40
Annual	Faido SMF - Faido SMF Süd	Other trains	Number	2020	14
Annual	Faido SMF - Faido SMF Süd	Passenger trains	Number	2020	29
Annual	La Chaux-de-Fonds Nord - La Chaux-de-Fonds	Goods trains	Number	2020	1


CREATE TABLE tidy (
  "freq" VARCHAR,
  "net_seg20" VARCHAR,
  "train" VARCHAR,
  "unit" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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