Seat/berth Capacity Of Passenger Railway Vehicles

Eurostat code: rail_eq_pa_csb · (1990 - 2023)

@eurostat.rail_eq_pa_csb

Table List

2 tables(54.2 KB)

Seat/berth Capacity Of Passenger Railway Vehicles - Raw

Seat/berth Capacity Of Passenger Railway Vehicles - Unpivoted

Seat/berth Capacity Of Passenger Railway Vehicles - Unpivoted

@eurostat.rail_eq_pa_csb.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.14 KB
2496 rows
6 columns

freq Freq	unit Unit	seat Seat	geo Geo	time_period Time Period	value Value
Annual	Thousand	Berths in couchettes and sleeping cars	Switzerland	1990	6
Annual	Thousand	Berths in couchettes and sleeping cars	Finland	1990	4
Annual	Thousand	Berths in couchettes and sleeping cars	Norway	1990	3
Annual	Thousand	Berths in couchettes and sleeping cars	Sweden	1990	10
Annual	Thousand	Seats, first class	Belgium	1990	41
Annual	Thousand	Seats, first class	Switzerland	1990	47
Annual	Thousand	Seats, first class	Germany	1990	122
Annual	Thousand	Seats, first class	Denmark	1990	4
Annual	Thousand	Seats, first class	Greece	1990	4
Annual	Thousand	Seats, first class	Finland	1990	3


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

Share link

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