Baselight
Sign In

Length Of Electrified Railway Lines By Type Of Current

Eurostat code: rail_if_electri ยท (1990 - 2023)

@eurostat.rail_if_electri

Length Of Electrified Railway Lines By Type Of Current - Unpivoted
@eurostat.rail_if_electri.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.

  • 19.62 KB
  • 7240 rows
  • 6 columns
freq

Freq

unit

Unit

power

Power

geo

Geo

time_period

Time Period

value

Value

AnnualKilometreAlternating current - 16 2/3 Hz / 15 000 VAlbania1990
AnnualKilometreAlternating current - 16 2/3 Hz / 15 000 VAustria19903160
AnnualKilometreAlternating current - 16 2/3 Hz / 15 000 VBosnia and Herzegovina1990
AnnualKilometreAlternating current - 16 2/3 Hz / 15 000 VBulgaria1990
AnnualKilometreAlternating current - 16 2/3 Hz / 15 000 VSwitzerland19904145
AnnualKilometreAlternating current - 16 2/3 Hz / 15 000 VGermany199011555
AnnualKilometreAlternating current - 16 2/3 Hz / 15 000 VDenmark1990
AnnualKilometreAlternating current - 16 2/3 Hz / 15 000 VEstonia1990
AnnualKilometreAlternating current - 16 2/3 Hz / 15 000 VGreece1990
AnnualKilometreAlternating current - 16 2/3 Hz / 15 000 VSpain1990

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