Lorries, By Type Of Motor Energy

Eurostat code: road_eqs_lormot · (2013 - 2023)

@eurostat.road_eqs_lormot

Table List

2 tables(86.04 KB)

Lorries, By Type Of Motor Energy - Unpivoted

Lorries, By Type Of Motor Energy - Unpivoted

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

39.46 KB
8668 rows
7 columns

freq Freq	unit Unit	vehicle Vehicle	mot_nrg Mot Nrg	geo Geo	time_period Time Period	value Value
Annual	Number	Lorries > 3.5 tonnes	Alternative energy	Austria	2013	56
Annual	Number	Lorries > 3.5 tonnes	Alternative energy	Bosnia and Herzegovina	2013	9
Annual	Number	Lorries > 3.5 tonnes	Alternative energy	Belgium	2013	4292
Annual	Number	Lorries > 3.5 tonnes	Alternative energy	Switzerland	2013	128
Annual	Number	Lorries > 3.5 tonnes	Alternative energy	Cyprus	2013
Annual	Number	Lorries > 3.5 tonnes	Alternative energy	Denmark	2013	19
Annual	Number	Lorries > 3.5 tonnes	Alternative energy	Estonia	2013	8
Annual	Number	Lorries > 3.5 tonnes	Alternative energy	Finland	2013	227
Annual	Number	Lorries > 3.5 tonnes	Alternative energy	France	2013	302
Annual	Number	Lorries > 3.5 tonnes	Alternative energy	Hungary	2013	31


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

Share link

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