New Mopeds And Motorcycles By Type Of Motor Energy

Eurostat code: road_eqr_mopeds · (2012 - 2023)

@eurostat.road_eqr_mopeds

Table List

2 tables(37.82 KB)

New Mopeds And Motorcycles By Type Of Motor Energy - Raw

New Mopeds And Motorcycles By Type Of Motor Energy - Unpivoted

New Mopeds And Motorcycles By Type Of Motor Energy - Unpivoted

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

15.51 KB
1779 rows
7 columns

freq Freq	vehicle Vehicle	unit Unit	mot_nrg Mot Nrg	geo Geo	time_period Time Period	value Value
Annual	Motorcycles	Number	Total	Poland	2012	7750
Annual	Mopeds	Number	Fossil fuel	Austria	2013	16675
Annual	Mopeds	Number	Fossil fuel	Bosnia and Herzegovina	2013	626
Annual	Mopeds	Number	Fossil fuel	Belgium	2013	1153
Annual	Mopeds	Number	Fossil fuel	Cyprus	2013	188
Annual	Mopeds	Number	Fossil fuel	Estonia	2013	651
Annual	Mopeds	Number	Fossil fuel	Finland	2013	8337
Annual	Mopeds	Number	Fossil fuel	France	2013	105598
Annual	Mopeds	Number	Fossil fuel	Ireland	2013	153
Annual	Mopeds	Number	Fossil fuel	Lithuania	2013	985


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