Passengers Transported

Eurostat code: rail_pa_total · (2004 - 2023)

@eurostat.rail_pa_total

Table List

2 tables(35.69 KB)

Passengers Transported - Unpivoted

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

12.16 KB
1183 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Millions of passenger-kilometres	Austria	2004	8274
Annual	Millions of passenger-kilometres	Belgium	2004	9225
Annual	Millions of passenger-kilometres	Czechia	2004	6580
Annual	Millions of passenger-kilometres	Germany	2004	75903
Annual	Millions of passenger-kilometres	Denmark	2004	5921
Annual	Millions of passenger-kilometres	Estonia	2004	193
Annual	Millions of passenger-kilometres	Greece	2004	1668
Annual	Millions of passenger-kilometres	Spain	2004	20328
Annual	Millions of passenger-kilometres	Finland	2004	3352
Annual	Millions of passenger-kilometres	France	2004	74359


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.