Passengers Transported By Type Of Train Speed

Eurostat code: rail_pa_speed · (2008 - 2023)

@eurostat.rail_pa_speed

Table List

2 tables(39.65 KB)

Passengers Transported By Type Of Train Speed - Raw

Passengers Transported By Type Of Train Speed - Unpivoted

Passengers Transported By Type Of Train Speed - Unpivoted

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

15.67 KB
2169 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Millions of passenger-kilometres	Total	Austria	2008	10837
Annual	Millions of passenger-kilometres	Total	Belgium	2008	10403
Annual	Millions of passenger-kilometres	Total	Bulgaria	2008	2334.9
Annual	Millions of passenger-kilometres	Total	Switzerland	2008	17776
Annual	Millions of passenger-kilometres	Total	Czechia	2008	6803
Annual	Millions of passenger-kilometres	Total	Germany	2008	81764
Annual	Millions of passenger-kilometres	Total	Denmark	2008	6096
Annual	Millions of passenger-kilometres	Total	Estonia	2008	273
Annual	Millions of passenger-kilometres	Total	Greece	2008	1657
Annual	Millions of passenger-kilometres	Total	Spain	2008	22073


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

Share link

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