Length Of Railway Lines By Maximum Permitted Speed

Eurostat code: rail_if_line_sp · (1990 - 2023)

@eurostat.rail_if_line_sp

Table List

2 tables(52.9 KB)

Length Of Railway Lines By Maximum Permitted Speed - Raw

Length Of Railway Lines By Maximum Permitted Speed - Unpivoted

Length Of Railway Lines By Maximum Permitted Speed - Unpivoted

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

15.04 KB
3051 rows
6 columns

freq Freq	tra_infr Tra Infr	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Kilometre	Albania	1990	674
Annual	Total	Kilometre	Austria	1990	5624
Annual	Total	Kilometre	Bosnia and Herzegovina	1990	944
Annual	Total	Kilometre	Belgium	1990	3479
Annual	Total	Kilometre	Bulgaria	1990	4299
Annual	Total	Kilometre	Switzerland	1990	4908
Annual	Total	Kilometre	Czechia	1990	9451
Annual	Total	Kilometre	Germany	1990	44050
Annual	Total	Kilometre	Denmark	1990	2858
Annual	Total	Kilometre	Estonia	1990	1026


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

Share link

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