Rail Passenger And Freight Traffic

Eurostat code: med_ra5 · (2005 - 2019)

@eurostat.med_ra5

Table List

2 tables(20.53 KB)

Rail Passenger And Freight Traffic - Raw

Rail Passenger And Freight Traffic - Unpivoted

Rail Passenger And Freight Traffic - Unpivoted

@eurostat.med_ra5.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.

6.22 KB
345 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Millions of passenger-kilometres	Algeria	2005	929
Annual	Millions of passenger-kilometres	Egypt	2005	55187
Annual	Millions of passenger-kilometres	Israel	2005	1618
Annual	Millions of passenger-kilometres	Jordan	2005	1.6
Annual	Millions of passenger-kilometres	Morocco	2005	2987
Annual	Millions of passenger-kilometres	Tunisia	2005	1317
Annual	Million tonne-kilometre (TKM)	Algeria	2005	1471
Annual	Million tonne-kilometre (TKM)	Egypt	2005	4064
Annual	Million tonne-kilometre (TKM)	Israel	2005	1149
Annual	Million tonne-kilometre (TKM)	Jordan	2005	500.7


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

Share link

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