Length Of State, Provincial And Communal Roads

Eurostat code: road_if_roadsc · (1970 - 2023)

@eurostat.road_if_roadsc

Table List

2 tables(98.62 KB)

Length Of State, Provincial And Communal Roads - Raw

Length Of State, Provincial And Communal Roads - Unpivoted

Length Of State, Provincial And Communal Roads - Unpivoted

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

31.74 KB
4436 rows
6 columns

freq Freq	unit Unit	tra_infr Tra Infr	geo Geo	time_period Time Period	value Value
Annual	Kilometre	Communal roads	Sweden	1970	62561
Annual	Kilometre	Provincial roads	Sweden	1970	85707
Annual	Kilometre	State roads	Sweden	1970	12247
Annual	Kilometre	Total	Belgium	1970	94218
Annual	Kilometre	Total	Germany	1970	440322
Annual	Kilometre	Total	Denmark	1970	62678
Annual	Kilometre	Total	Greece	1970	35257
Annual	Kilometre	Total	Spain	1970	123720
Annual	Kilometre	Total	France	1970	783000
Annual	Kilometre	Total	Italy	1970	280325


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

Share link

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