Rail Equipment: Number And Capacity Of Railways Vehicles

Eurostat code: med_ra3 · (2005 - 2019)

@eurostat.med_ra3

Table List

2 tables(19.21 KB)

Rail Equipment: Number And Capacity Of Railways Vehicles - Raw

Rail Equipment: Number And Capacity Of Railways Vehicles - Unpivoted

Rail Equipment: Number And Capacity Of Railways Vehicles - Raw

@eurostat.med_ra3.raw

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

13.64 KB
6 rows
20 columns

freq Freq	vehicle Vehicle	unit Unit	train Train	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	Passenger railway vehicles	Number	Total	Algeria	454	440	432	440	480	505	505	505	505	505	497	497	497	336
Annual	Passenger railway vehicles	Number	Total	Egypt					3619	3620	3562	3562			3745	3524	3516	3242
Annual	Passenger railway vehicles	Number	Total	Israel	315	359	361	372	372	412	444	592	591	648	645	645	674	719
Annual	Passenger railway vehicles	Number	Total	Jordan	16	16	16	16	16	16	16	16	10	13	15	15	13	15
Annual	Passenger railway vehicles	Number	Total	Morocco	330	310	328	408	443	486	492	500	500	500	546	562	594	555
Annual	Passenger railway vehicles	Number	Total	Tunisia	286	292	280	288	290	319	264	287	285	301	309	308	308	292	292


CREATE TABLE raw (
  "freq" VARCHAR,
  "vehicle" VARCHAR,
  "unit" VARCHAR,
  "train" 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.