Seat Capacity Of Passenger Railway Vehicles By Type Of Vehicles

Eurostat code: rail_eq_pa_cty · (1990 - 2023)

@eurostat.rail_eq_pa_cty

Table List

2 tables(49.4 KB)

Seat Capacity Of Passenger Railway Vehicles By Type Of Vehicles - Raw

Seat Capacity Of Passenger Railway Vehicles By Type Of Vehicles - Unpivoted

Seat Capacity Of Passenger Railway Vehicles By Type Of Vehicles - Unpivoted

@eurostat.rail_eq_pa_cty.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.9 KB
1921 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Thousand	Coaches and railcar trailers	Belgium	1990	168
Annual	Thousand	Coaches and railcar trailers	Bulgaria	1990	124.772
Annual	Thousand	Coaches and railcar trailers	Spain	1990	55
Annual	Thousand	Coaches and railcar trailers	Finland	1990	47
Annual	Thousand	Coaches and railcar trailers	Croatia	1990	57
Annual	Thousand	Coaches and railcar trailers	Netherlands	1990	43
Annual	Thousand	Coaches and railcar trailers	Norway	1990	25
Annual	Thousand	Coaches and railcar trailers	Sweden	1990	72
Annual	Thousand	Passenger railcars	Belgium	1990	124
Annual	Thousand	Passenger railcars	Spain	1990	161


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.