Length Of Electrified And Non-electrified Railway Lines By Track Gauge

Eurostat code: rail_if_line_ga · (1990 - 2023)

@eurostat.rail_if_line_ga

Table List

2 tables(112.28 KB)

Length Of Electrified And Non-electrified Railway Lines By Track Gauge - Raw

Length Of Electrified And Non-electrified Railway Lines By Track Gauge - Unpivoted

Length Of Electrified And Non-electrified Railway Lines By Track Gauge - Unpivoted

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

41.1 KB
13746 rows
7 columns

freq Freq	unit Unit	tra_infr Tra Infr	gaugert Gaugert	geo Geo	time_period Time Period	value Value
Annual	Kilometre	Electrified railway lines	Large gauge	Albania	1990
Annual	Kilometre	Electrified railway lines	Large gauge	Austria	1990
Annual	Kilometre	Electrified railway lines	Large gauge	Bosnia and Herzegovina	1990
Annual	Kilometre	Electrified railway lines	Large gauge	Bulgaria	1990
Annual	Kilometre	Electrified railway lines	Large gauge	Switzerland	1990
Annual	Kilometre	Electrified railway lines	Large gauge	Czechia	1990
Annual	Kilometre	Electrified railway lines	Large gauge	Germany	1990
Annual	Kilometre	Electrified railway lines	Large gauge	Denmark	1990
Annual	Kilometre	Electrified railway lines	Large gauge	Estonia	1990	131.8
Annual	Kilometre	Electrified railway lines	Large gauge	Greece	1990


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

Share link

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