Road Infrastructure: Lenght Of Road Network

Eurostat code: med_rd1 · (2005 - 2018)

@eurostat.med_rd1

Table List

2 tables(18.53 KB)

Road Infrastructure: Lenght Of Road Network - Raw

Road Infrastructure: Lenght Of Road Network - Unpivoted

Road Infrastructure: Lenght Of Road Network - Raw

@eurostat.med_rd1.raw

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

13.07 KB
16 rows
18 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
Annual	Kilometre	Motorways	Algeria				167	557	957	1038	1048	1102	1118	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
Annual	Kilometre	Motorways	Jordan
Annual	Kilometre	Motorways	Lebanon	170	300	300	300	300	300	300	300	300	300	300	300	300	300
Annual	Kilometre	Motorways	Morocco	611	639	827	866	917	1096	1398	1416	1416	1511	1588	1770	1800
Annual	Kilometre	Motorways	Tunisia	195	262		360	360	360	360	360	360	360	360	407
Annual	Kilometre	Total	Algeria				111428	112596	113504	115755	117000	119669	123646	124783	128032	128502	129474
Annual	Kilometre	Total	Egypt	102894	106854	99829						154647	163070	168376	174605	176927
Annual	Kilometre	Total	Israel	17591	17714	17872	18105	18318	18482	18569	18719	18868	19063	19221	19366	19555	19758


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
);

Share link

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