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

Eurostat code: road_eqr_busmot · (2013 - 2023)

@eurostat.road_eqr_busmot

Table List

2 tables(35.92 KB)

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

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

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

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

14.52 KB
3903 rows
6 columns

freq Freq	unit Unit	mot_nrg Mot Nrg	geo Geo	time_period Time Period	value Value
Annual	Number	Alternative energy	Austria	2013	26
Annual	Number	Alternative energy	Bosnia and Herzegovina	2013
Annual	Number	Alternative energy	Belgium	2013
Annual	Number	Alternative energy	Bulgaria	2013	20
Annual	Number	Alternative energy	Switzerland	2013	4
Annual	Number	Alternative energy	Cyprus	2013
Annual	Number	Alternative energy	Germany	2013	128
Annual	Number	Alternative energy	Estonia	2013	7
Annual	Number	Alternative energy	Spain	2013	80
Annual	Number	Alternative energy	Finland	2013	8


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.