Baselight
Sign In

Length Of Railway Lines Equipped With The Railway Traffic Management System (ERTMS) By Type Of Signalling

Eurostat code: rail_if_traff ยท (2019 - 2024)

@eurostat.rail_if_traff

Length Of Railway Lines Equipped With The Railway Traffic Management System (ERTMS) By Type Of Signalling - Unpivoted
@eurostat.rail_if_traff.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.

  • 5.95 KB
  • 289 rows
  • 6 columns
freq

Freq

unit

Unit

signal

Signal

geo

Geo

time_period

Time Period

value

Value

AnnualKilometreRadio-signal (ETCS level 2)Austria2019344.2
AnnualKilometreRadio-signal (ETCS level 2)Belgium2019
AnnualKilometreRadio-signal (ETCS level 2)Bulgaria2019
AnnualKilometreRadio-signal (ETCS level 2)Czechia2019246.1
AnnualKilometreRadio-signal (ETCS level 2)Germany2019200.9
AnnualKilometreRadio-signal (ETCS level 2)Denmark2019
AnnualKilometreRadio-signal (ETCS level 2)Estonia2019
AnnualKilometreRadio-signal (ETCS level 2)Greece2019
AnnualKilometreRadio-signal (ETCS level 2)Spain2019521.5
AnnualKilometreRadio-signal (ETCS level 2)Finland2019

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

Share link

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