New Motor Coaches, Buses And Trolley Buses By Type Of Motor Energy (until 2013)

Eurostat code: road_eqs_busmot_h · (1970 - 2013)

@eurostat.road_eqs_busmot_h

Table List

2 tables(60.68 KB)

New Motor Coaches, Buses And Trolley Buses By Type Of Motor Energy (until 2013) - Raw

New Motor Coaches, Buses And Trolley Buses By Type Of Motor Energy (until 2013) - Unpivoted

New Motor Coaches, Buses And Trolley Buses By Type Of Motor Energy (until 2013) - Unpivoted

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

16.97 KB
1981 rows
6 columns

freq Freq	unit Unit	mot_nrg Mot Nrg	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	Italy	1970	32899
Annual	Number	Total	Lithuania	1970	5035


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

Share link

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