Passengers Transported (detailed Reporting Only) - (quarterly Data)

Eurostat code: rail_pa_quartal · (2004-Q1 - 2024-Q4)

@eurostat.rail_pa_quartal

Table List

2 tables(120.06 KB)

Passengers Transported (detailed Reporting Only) - (quarterly Data) - Raw

Passengers Transported (detailed Reporting Only) - (quarterly Data) - Unpivoted

Passengers Transported (detailed Reporting Only) - (quarterly Data) - Unpivoted

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

31.11 KB
4918 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Quarterly	Millions of passenger-kilometres	Austria	2004-Q1	2094
Quarterly	Millions of passenger-kilometres	Belgium	2004-Q1	2094
Quarterly	Millions of passenger-kilometres	Czechia	2004-Q1	1617
Quarterly	Millions of passenger-kilometres	Germany	2004-Q1	17161
Quarterly	Millions of passenger-kilometres	Denmark	2004-Q1	1355
Quarterly	Millions of passenger-kilometres	Estonia	2004-Q1	43
Quarterly	Millions of passenger-kilometres	Greece	2004-Q1	369
Quarterly	Millions of passenger-kilometres	Spain	2004-Q1	4734
Quarterly	Millions of passenger-kilometres	Finland	2004-Q1	842
Quarterly	Millions of passenger-kilometres	France	2004-Q1	17385


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.