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 - Raw

Length Of Roads Network - Unpivoted

Length Of Roads Network - Raw

@eurostat.enps_road_if.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

15.84 KB
16 rows
22 columns

freq Freq	unit Unit	tra_infr Tra Infr	geo Geo	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022
Annual	Kilometre	Motorways	Algeria				167	557	957	1038	1048	1102	1118	1132	1132	1132	1132	1132	1132
Annual	Kilometre	Motorways	Egypt	134	134	134	194	194	194	494	494
Annual	Kilometre	Motorways	Israel	325	340	344	379	447	460	460	464	466	506	506	555	605	622	637	637	692	699
Annual	Kilometre	Motorways	Jordan
Annual	Kilometre	Motorways	Lebanon	170	300	300	300	300	300	300	300	300	300	300	300	300	300	300	300	300	300
Annual	Kilometre	Motorways	Libya			11655	15000	15143	15143
Annual	Kilometre	Motorways	Morocco	611	639	827	866	917	1096	1398	1416	1416	1511	1588	1770	1800	1800	1800	1800	1800	1800
Annual	Kilometre	Motorways	Tunisia	195	262		360	360	360	360	360	360	360	360	407	563	562	613	613
Annual	Kilometre	Total	Algeria				111428	112596	113504	115755	117000	119669	123646	124783	128032	128502	129474	129913	129913
Annual	Kilometre	Total	Egypt	102894	106854	99829						113221	121981	124213	127417	127616	130264	137765	150052	153


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tra_infr" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE
);

Share link

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