Name: Length Of Railway Lines By Number Of Tracks And Electrification Of Lines
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

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

This Eurostat dataset contains data on length of railway lines by number of tracks and electrification of lines, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-10-30T23:00:00+0100

Tables

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

@eurostat.rail_if_line_tr.raw

82.58 kB
360 rows
39 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "tra_infr" VARCHAR,
  "n_tracks" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1990" DOUBLE  -- 1990,
  "n_1991" DOUBLE  -- 1991,
  "n_1992" DOUBLE  -- 1992,
  "n_1993" DOUBLE  -- 1993,
  "n_1994" DOUBLE  -- 1994,
  "n_1995" DOUBLE  -- 1995,
  "n_1996" DOUBLE  -- 1996,
  "n_1997" DOUBLE  -- 1997,
  "n_1998" DOUBLE  -- 1998,
  "n_1999" DOUBLE  -- 1999,
  "n_2000" DOUBLE  -- 2000,
  "n_2001" DOUBLE  -- 2001,
  "n_2002" DOUBLE  -- 2002,
  "n_2003" DOUBLE  -- 2003,
  "n_2004" DOUBLE  -- 2004,
  "n_2005" DOUBLE  -- 2005,
  "n_2006" DOUBLE  -- 2006,
  "n_2007" DOUBLE  -- 2007,
  "n_2008" DOUBLE  -- 2008,
  "n_2009" DOUBLE  -- 2009,
  "n_2010" DOUBLE  -- 2010,
  "n_2011" DOUBLE  -- 2011,
  "n_2012" DOUBLE  -- 2012,
  "n_2013" DOUBLE  -- 2013,
  "n_2014" DOUBLE  -- 2014,
  "n_2015" DOUBLE  -- 2015,
  "n_2016" DOUBLE  -- 2016,
  "n_2017" DOUBLE  -- 2017,
  "n_2018" DOUBLE  -- 2018,
  "n_2019" DOUBLE  -- 2019,
  "n_2020" DOUBLE  -- 2020,
  "n_2021" DOUBLE  -- 2021,
  "n_2022" DOUBLE  -- 2022,
  "n_2023" DOUBLE  -- 2023
);

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

@eurostat.rail_if_line_tr.tidy

47.91 kB
10,704 rows
7 columns

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