Rail Passenger Traffic

Eurostat code: enps_rail_pa · (2005 - 2023)

@eurostat.enps_rail_pa

Table List

2 tables(21.1 KB)

Rail Passenger Traffic - Raw

Rail Passenger Traffic - Unpivoted

Rail Passenger Traffic - Raw

@eurostat.enps_rail_pa.raw

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

15.75 KB
16 rows
22 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	n_2020 2020	n_2021 2021	n_2022 2022
Annual	Millions of passenger-kilometres	Algeria	929	821	813	937	1141	1046	1039	1141	1212	1185	1269	1337	1550	1602	1455	348	1096	1430
Annual	Millions of passenger-kilometres	Egypt	55187	54884	52624	56303		28077	27252			20107	28225	32157	32479	33615	42028	38579
Annual	Millions of passenger-kilometres	Israel	1618	1609	1834	1968	2011	1986	1927	2133	2376	2485	2608	2645	2765	3032	3580	1253	1956	3019
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	Lebanon
Annual	Millions of passenger-kilometres	Libya
Annual	Millions of passenger-kilometres	Morocco	2987	3333	3659	3820	4190	4399	4819	5074	5316	5449	5506.6	5208.2	4923	4475	5559	2721	4464	6012.3
Annual	Millions of passenger-kilometres	Tunisia	1317	1407	1487	1494	1487	1534	1114	1167	1250	1297.7	1246.2	1235.5	1163	1109.3	1022.8	581.2
Annual	Thousand	Algeria	25708	21895	21388	24744	27843	27299	27416	31456	33967	32739	36216	37686	42913	39536	34525	8457	29890	34569
Annual	Thousand	Egypt	437996	435593	418028	440026		293745	224800	310463	310463	182791	235064	236445	243152	244135	306777	253759


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,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" VARCHAR
);

Share link

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