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

Eurostat code: road_eqs_busmot · (1992 - 2023)

@eurostat.road_eqs_busmot

Table List

2 tables(52.31 KB)

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

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

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

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

21.18 KB
4384 rows
6 columns

freq Freq	unit Unit	mot_nrg Mot Nrg	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Germany	1992	82573
Annual	Number	Alternative energy	Germany	2000	791
Annual	Number	Diesel	Germany	2000	85545
Annual	Number	Electricity	Germany	2000	105
Annual	Number	Petroleum products	Germany	2000	320
Annual	Number	Total	Germany	2000	86656
Annual	Number	Total	European Union - 27 countries (from 2020)	2000	711457
Annual	Number	Alternative energy	Germany	2007	1645
Annual	Number	Diesel	Germany	2007	73303
Annual	Number	Electricity	Germany	2007	92


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.