Length Of Railway Lines By Number Of Tracks And Electrification Of Lines

Eurostat code: rail_if_line_tr · (1990 - 2023)

@eurostat.rail_if_line_tr

Table List

2 tables(127.29 KB)

Length Of Railway Lines By Number Of Tracks And Electrification Of Lines - Raw

Length Of Railway Lines By Number Of Tracks And Electrification Of Lines - Unpivoted

Length Of Railway Lines By Number Of Tracks And Electrification Of Lines - Unpivoted

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

46.72 KB
10684 rows
7 columns

freq Freq	tra_infr Tra Infr	n_tracks N Tracks	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Electrified railway lines	1 track	Kilometre	Albania	1990
Annual	Electrified railway lines	1 track	Kilometre	Austria	1990	1586
Annual	Electrified railway lines	1 track	Kilometre	Bosnia and Herzegovina	1990	751
Annual	Electrified railway lines	1 track	Kilometre	Belgium	1990	162
Annual	Electrified railway lines	1 track	Kilometre	Bulgaria	1990	1680
Annual	Electrified railway lines	1 track	Kilometre	Switzerland	1990	3215
Annual	Electrified railway lines	1 track	Kilometre	Germany	1990	3134
Annual	Electrified railway lines	1 track	Kilometre	Denmark	1990	1
Annual	Electrified railway lines	1 track	Kilometre	Estonia	1990	64.3
Annual	Electrified railway lines	1 track	Kilometre	Greece	1990


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

Share link

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