Mopeds And Motorcycles By Type Of Motor Energy

Eurostat code: road_eqs_mopeds · (1970 - 2023)

@eurostat.road_eqs_mopeds

Table List

2 tables(84.66 KB)

Mopeds And Motorcycles By Type Of Motor Energy - Raw

Mopeds And Motorcycles By Type Of Motor Energy - Unpivoted

Mopeds And Motorcycles By Type Of Motor Energy - Unpivoted

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

25.45 KB
3170 rows
7 columns

freq Freq	mot_nrg Mot Nrg	vehicle Vehicle	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Mopeds	Number	Bulgaria	1970	173880
Annual	Total	Mopeds	Number	Norway	1970	128000
Annual	Total	Motorcycles	Number	Bulgaria	1970	246470
Annual	Total	Motorcycles	Number	Czechia	1970	709000
Annual	Total	Motorcycles	Number	Germany	1970	229000
Annual	Total	Motorcycles	Number	Croatia	1970	36000
Annual	Total	Motorcycles	Number	Ireland	1970	41000
Annual	Total	Motorcycles	Number	Lithuania	1970	17100
Annual	Total	Motorcycles	Number	Norway	1970	39000
Annual	Total	Motorcycles	Number	Romania	1970	250000


CREATE TABLE tidy (
  "freq" VARCHAR,
  "mot_nrg" 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.