Length Of Electric And Non-electric Railway Lines By Nature Of Transport

Eurostat code: rail_if_line_na · (1990 - 2023)

@eurostat.rail_if_line_na

Table List

2 tables(114.16 KB)

Length Of Electric And Non-electric Railway Lines By Nature Of Transport - Raw

Length Of Electric And Non-electric Railway Lines By Nature Of Transport - Unpivoted

Length Of Electric And Non-electric Railway Lines By Nature Of Transport - Unpivoted

@eurostat.rail_if_line_na.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.37 KB
11803 rows
7 columns

freq Freq	unit Unit	tra_infr Tra Infr	tra_meas Tra Meas	geo Geo	time_period Time Period	value Value
Annual	Kilometre	Electrified railway lines	Freight only	Albania	1990
Annual	Kilometre	Electrified railway lines	Freight only	Bosnia and Herzegovina	1990
Annual	Kilometre	Electrified railway lines	Freight only	Belgium	1990	122
Annual	Kilometre	Electrified railway lines	Freight only	Bulgaria	1990
Annual	Kilometre	Electrified railway lines	Freight only	Switzerland	1990	62
Annual	Kilometre	Electrified railway lines	Freight only	Czechia	1990
Annual	Kilometre	Electrified railway lines	Freight only	Germany	1990	1087
Annual	Kilometre	Electrified railway lines	Freight only	Denmark	1990	7
Annual	Kilometre	Electrified railway lines	Freight only	Estonia	1990
Annual	Kilometre	Electrified railway lines	Freight only	Greece	1990


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

Share link

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