Rail Passenger And Freight Traffic

Eurostat code: med_ra5 · (2005 - 2019)

@eurostat.med_ra5

Table List

2 tables(20.53 KB)

Rail Passenger And Freight Traffic - Raw

Rail Passenger And Freight Traffic - Unpivoted

Rail Passenger And Freight Traffic - Raw

@eurostat.med_ra5.raw

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

14.31 KB
26 rows
18 columns

freq Freq	unit Unit	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
Annual	Millions of passenger-kilometres	Algeria	929	821	813	937	1141	1046	1039	1141	1211	1186	1251	1337	1550	1601
Annual	Millions of passenger-kilometres	Egypt	55187	54884	52624	56303		28077	27252	13550	13550	20107	28225	32157	32479	33615
Annual	Millions of passenger-kilometres	Israel	1618	1609	1834	1968	2011	1986	1927	2133	2376	2485	2608	2645	2765	3032
Annual	Millions of passenger-kilometres	Jordan	1.6	0.6	0.3	0.4	0.9	1.3	0.7	1	1	2	1	1	1	1
Annual	Millions of passenger-kilometres	Morocco	2987	3333	3659	3820	4190	4399	4819	5074	5316	5449	5506.6	5208.2	4923	4475
Annual	Millions of passenger-kilometres	Tunisia	1317	1407	1487	1494	1487	1534	1114	1167	1250	1297.7	1246.2	1235.5	1163	1109.3	582.2
Annual	Million tonne-kilometre (TKM)	Algeria	1471	1429	1425	1562	1302	1281	1248	1253	1131	1010	928	885	1009	1026
Annual	Million tonne-kilometre (TKM)	Egypt	4064	3833	2696	2701		1889	1965	1398	1166	1356	1511	1459	1461	1395
Annual	Million tonne-kilometre (TKM)	Israel	1149	1123	1177	1056	799	1062	1099	1011	1058	1165	1155	1404	1381	1235
Annual	Million tonne-kilometre (TKM)	Jordan	500.7	438.4	433.2	449	439.2	344.1	308.5	215.9	140	189	194.4	364	185.5


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" 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
);

Share link

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