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 - Unpivoted

@eurostat.med_ra2.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

5.32 KB
162 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Number	Locomotives	Algeria	2005	245
Annual	Number	Locomotives	Israel	2005	74
Annual	Number	Locomotives	Jordan	2005	29
Annual	Number	Locomotives	Morocco	2005	209
Annual	Number	Locomotives	Tunisia	2005	131
Annual	Number	Passenger railway vehicles	Algeria	2005	454
Annual	Number	Passenger railway vehicles	Israel	2005	315
Annual	Number	Passenger railway vehicles	Jordan	2005	16
Annual	Number	Passenger railway vehicles	Morocco	2005	330
Annual	Number	Passenger railway vehicles	Tunisia	2005	286


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "vehicle" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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