Rail Equipment: Number Of Locomotives And Passenger Railways Vehicles

Eurostat code: med_ra2 · (2005 - 2019)

@eurostat.med_ra2

Table List

2 tables(18.92 KB)

Rail Equipment: Number Of Locomotives And Passenger Railways Vehicles - Raw

Rail Equipment: Number Of Locomotives And Passenger Railways Vehicles - Unpivoted

Rail Equipment: Number Of Locomotives And Passenger Railways Vehicles - Raw

@eurostat.med_ra2.raw

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

13.59 KB
12 rows
19 columns

freq Freq	unit Unit	vehicle Vehicle	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	Number	Locomotives	Algeria	245	245	267	275	275	275	275	275	275	275	275	295	295	303
Annual	Number	Locomotives	Egypt			701	772	820	820	1001	1000	1002	820	816	810	810	791
Annual	Number	Locomotives	Israel	74	72	77	81	81	88	88	103	115	121	127	130	134	139
Annual	Number	Locomotives	Jordan	29	29	33	33	33	33	33	35	46	47	48	49	49	36
Annual	Number	Locomotives	Morocco	209	209	224	232	228	233	231	231	257	258	256	251	234	230
Annual	Number	Locomotives	Tunisia	131	131	131	130	130	130	129	129	148	148	138	138	138	138	138
Annual	Number	Passenger railway vehicles	Algeria	454	440	432	440	480	505	505	505	505	505	497	497	497	336
Annual	Number	Passenger railway vehicles	Egypt					3619	3620	3562	3562			3745	3524	3516	3242
Annual	Number	Passenger railway vehicles	Israel	315	359	361	372	372	412	444	592	591	648	645	645	674	719
Annual	Number	Passenger railway vehicles	Jordan	16	16	16	16	16	16	16	16	10	13	15	15	13	15


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