New Motor Coaches, Buses And Trolley Buses , By Type Of Vehicles

Eurostat code: road_eqr_busveh · (1979 - 2023)

@eurostat.road_eqr_busveh

Table List

2 tables(55.31 KB)

New Motor Coaches, Buses And Trolley Buses , By Type Of Vehicles - Raw

New Motor Coaches, Buses And Trolley Buses , By Type Of Vehicles - Unpivoted

New Motor Coaches, Buses And Trolley Buses , By Type Of Vehicles - Unpivoted

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

13.5 KB
1836 rows
6 columns

freq Freq	vehicle Vehicle	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Number	Belgium	1979	1560
Annual	Total	Number	Germany	1979	6461
Annual	Total	Number	Denmark	1979	743
Annual	Total	Number	Greece	1979	1578
Annual	Total	Number	Spain	1979	1466
Annual	Total	Number	France	1979	4605
Annual	Total	Number	Italy	1979	3789
Annual	Total	Number	Luxembourg	1979	94
Annual	Total	Number	Netherlands	1979	973
Annual	Total	Number	Portugal	1979	650


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

Share link

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