Rail Passenger Traffic

Eurostat code: enps_rail_pa · (2005 - 2023)

@eurostat.enps_rail_pa

Table List

2 tables(21.1 KB)

Rail Passenger Traffic - Unpivoted

@eurostat.enps_rail_pa.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.35 KB
196 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	Thousand	Algeria	2005	25708
Annual	Thousand	Egypt	2005	437996
Annual	Thousand	Israel	2005	26767
Annual	Thousand	Jordan	2005	42.4


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

Share link

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