Length Of Roads Network

Eurostat code: enps_road_if · (2005 - 2022)

@eurostat.enps_road_if

Table List

2 tables(21.54 KB)

Length Of Roads Network - Unpivoted

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

5.7 KB
229 rows
6 columns

freq Freq	unit Unit	tra_infr Tra Infr	geo Geo	time_period Time Period	value Value
Annual	Kilometre	Motorways	Egypt	2005	134
Annual	Kilometre	Motorways	Israel	2005	325
Annual	Kilometre	Motorways	Jordan	2005
Annual	Kilometre	Motorways	Lebanon	2005	170
Annual	Kilometre	Motorways	Morocco	2005	611
Annual	Kilometre	Motorways	Tunisia	2005	195
Annual	Kilometre	Total	Egypt	2005	102894
Annual	Kilometre	Total	Israel	2005	17591
Annual	Kilometre	Total	Jordan	2005	7601
Annual	Kilometre	Total	Lebanon	2005	6720


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.