Seat Capacity Of New Motor Coaches, Buses And Trolley Buses

Eurostat code: road_eqr_bussea · (1989 - 2023)

@eurostat.road_eqr_bussea

Table List

2 tables(34.19 KB)

Seat Capacity Of New Motor Coaches, Buses And Trolley Buses - Raw

Seat Capacity Of New Motor Coaches, Buses And Trolley Buses - Unpivoted

Seat Capacity Of New Motor Coaches, Buses And Trolley Buses - Unpivoted

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

6.75 KB
427 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number	Norway	1989	22000
Annual	Number	Sweden	1989	70000
Annual	Number	Finland	1990	20000
Annual	Number	Norway	1990	36000
Annual	Number	Sweden	1990	63000
Annual	Number	Finland	1991	16000
Annual	Number	Norway	1991	51000
Annual	Number	Sweden	1991	56000
Annual	Number	Bulgaria	1992	20600
Annual	Number	Switzerland	1992	114000


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.