Motor Coaches, Buses And Trolley Buses, By Type Of Vehicle

Eurostat code: road_eqs_busveh · (1970 - 2023)

@eurostat.road_eqs_busveh

Table List

2 tables(68.13 KB)

Motor Coaches, Buses And Trolley Buses, By Type Of Vehicle - Raw

Motor Coaches, Buses And Trolley Buses, By Type Of Vehicle - Unpivoted

Motor Coaches, Buses And Trolley Buses, By Type Of Vehicle - Unpivoted

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

17.75 KB
2069 rows
6 columns

freq Freq	vehicle Vehicle	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Number	Belgium	1970	16169
Annual	Total	Number	Bulgaria	1970	205
Annual	Total	Number	Czechia	1970	14489
Annual	Total	Number	Germany	1970	47253
Annual	Total	Number	Denmark	1970	5039
Annual	Total	Number	Greece	1970	10546
Annual	Total	Number	Spain	1970	44800
Annual	Total	Number	France	1970	41000
Annual	Total	Number	Croatia	1970	3333
Annual	Total	Number	Ireland	1970	2012


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.