Length Of Motorways And E-roads

Eurostat code: road_if_motorwa · (1970 - 2023)

@eurostat.road_if_motorwa

Table List

2 tables(62.84 KB)

Length Of Motorways And E-roads - Unpivoted

Length Of Motorways And E-roads - Unpivoted

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

13.73 KB
1992 rows
6 columns

freq Freq	tra_infr Tra Infr	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Motorways	Kilometre	Belgium	1970	501
Annual	Motorways	Kilometre	Germany	1970	4461
Annual	Motorways	Kilometre	Denmark	1970	198
Annual	Motorways	Kilometre	Greece	1970	65
Annual	Motorways	Kilometre	Spain	1970	1585
Annual	Motorways	Kilometre	Finland	1970	152
Annual	Motorways	Kilometre	France	1970	1542
Annual	Motorways	Kilometre	Italy	1970	3913
Annual	Motorways	Kilometre	Luxembourg	1970	7
Annual	Motorways	Kilometre	Netherlands	1970	975


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.