Length Of Roads Network, ENP-East Countries

Eurostat code: enpe_road_if · (2005 - 2023)

@eurostat.enpe_road_if

Table List

2 tables(21.53 KB)

Length Of Roads Network, ENP-East Countries - Raw

Length Of Roads Network, ENP-East Countries - Unpivoted

Length Of Roads Network, ENP-East Countries - Unpivoted

@eurostat.enpe_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.4 KB
183 rows
6 columns

freq Freq	unit Unit	tra_infr Tra Infr	geo Geo	time_period Time Period	value Value
Annual	Kilometre	Motorways	Armenia	2005	1500
Annual	Kilometre	Motorways	Azerbaijan	2005
Annual	Kilometre	Motorways	Ukraine	2005	15
Annual	Kilometre	Other roads	Armenia	2005	6000
Annual	Kilometre	Other roads	Azerbaijan	2005	18799
Annual	Kilometre	Other roads	Belarus	2005	95171
Annual	Kilometre	Other roads	Georgia	2005	20300
Annual	Kilometre	Other roads	Moldova	2005	9467
Annual	Kilometre	Other roads	Ukraine	2005	169308
Annual	Kilometre	Motorways	Armenia	2006	1500


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.