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

@eurostat.med_ra3.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.57 KB
79 rows
7 columns

freq Freq	vehicle Vehicle	unit Unit	train Train	geo Geo	time_period Time Period	value Value
Annual	Passenger railway vehicles	Number	Total	Algeria	2005	454
Annual	Passenger railway vehicles	Number	Total	Israel	2005	315
Annual	Passenger railway vehicles	Number	Total	Jordan	2005	16
Annual	Passenger railway vehicles	Number	Total	Morocco	2005	330
Annual	Passenger railway vehicles	Number	Total	Tunisia	2005	286
Annual	Passenger railway vehicles	Number	Total	Algeria	2006	440
Annual	Passenger railway vehicles	Number	Total	Israel	2006	359
Annual	Passenger railway vehicles	Number	Total	Jordan	2006	16
Annual	Passenger railway vehicles	Number	Total	Morocco	2006	310
Annual	Passenger railway vehicles	Number	Total	Tunisia	2006	292


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

Share link

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