Motor Coaches, Buses And Trolley Buses By Age

Eurostat code: road_eqs_busage · (1970 - 2023)

@eurostat.road_eqs_busage

Table List

2 tables(102.28 KB)

Motor Coaches, Buses And Trolley Buses By Age - Raw

Motor Coaches, Buses And Trolley Buses By Age - Unpivoted

Motor Coaches, Buses And Trolley Buses By Age - Unpivoted

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

33.12 KB
5078 rows
6 columns

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


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

Share link

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