New Motorcycles By Engine Size

Eurostat code: road_eqr_motors · (1970 - 2023)

@eurostat.road_eqr_motors

Table List

2 tables(61.64 KB)

New Motorcycles By Engine Size - Unpivoted

New Motorcycles By Engine Size - Unpivoted

@eurostat.road_eqr_motors.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.55 KB
1795 rows
6 columns

freq Freq	unit Unit	engine Engine	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Ireland	1970	9464
Annual	Number	Total	Croatia	1975	2013
Annual	Number	Total	Belgium	1979	12464
Annual	Number	Total	Germany	1979	101199
Annual	Number	Total	Denmark	1979	2508
Annual	Number	Total	Greece	1979	7935
Annual	Number	Total	Spain	1979	50406
Annual	Number	Total	France	1979	133050
Annual	Number	Total	Italy	1979	129652
Annual	Number	Total	Luxembourg	1979	315


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

Share link

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