Length Of Paved And Unpaved Roads

Eurostat code: road_if_bsurfa · (1970 - 2023)

@eurostat.road_if_bsurfa

Table List

2 tables(66.58 KB)

Length Of Paved And Unpaved Roads - Unpivoted

Length Of Paved And Unpaved Roads - Unpivoted

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

16.71 KB
1831 rows
6 columns

freq Freq	tra_infr Tra Infr	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Kilometre	Belgium	1970	94218
Annual	Total	Kilometre	Germany	1970	440322
Annual	Total	Kilometre	Denmark	1970	62678
Annual	Total	Kilometre	Greece	1970	35257
Annual	Total	Kilometre	Spain	1970	123720
Annual	Total	Kilometre	France	1970	783000
Annual	Total	Kilometre	Italy	1970	280325
Annual	Total	Kilometre	Luxembourg	1970	4949
Annual	Total	Kilometre	Portugal	1970	18668
Annual	Total	Kilometre	Sweden	1970	160515


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.