Baselight

Motorcycles By Engine Size

Eurostat code: road_eqs_motorc ยท (1970 - 2023)

@eurostat.road_eqs_motorc

Motorcycles By Engine Size - Unpivoted
@eurostat.road_eqs_motorc.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.28 KB
  • 2747 rows
  • 6 columns
freq

Freq

unit

Unit

engine

Engine

geo

Geo

time_period

Time Period

value

Value

AnnualNumberTotalBulgaria1970246470
AnnualNumberTotalCzechia1970709000
AnnualNumberTotalGermany1970229000
AnnualNumberTotalCroatia197036000
AnnualNumberTotalIreland197041000
AnnualNumberTotalLithuania197017100
AnnualNumberTotalNorway197039000
AnnualNumberTotalRomania1970250000
AnnualNumberTotalSweden197045000
AnnualNumberTotalSweden197145000

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.