New Lorries, By Type Of Motor Energy

Eurostat code: road_eqr_lormot · (2013 - 2023)

@eurostat.road_eqr_lormot

Table List

2 tables(63.1 KB)

New Lorries, By Type Of Motor Energy - Raw

New Lorries, By Type Of Motor Energy - Unpivoted

New Lorries, By Type Of Motor Energy - Unpivoted

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

28.1 KB
7836 rows
7 columns

freq Freq	vehicle Vehicle	unit Unit	mot_nrg Mot Nrg	geo Geo	time_period Time Period	value Value
Annual	Lorries > 3.5 tonnes	Number	Alternative energy	Austria	2013	7
Annual	Lorries > 3.5 tonnes	Number	Alternative energy	Bosnia and Herzegovina	2013
Annual	Lorries > 3.5 tonnes	Number	Alternative energy	Belgium	2013	3
Annual	Lorries > 3.5 tonnes	Number	Alternative energy	Switzerland	2013	17
Annual	Lorries > 3.5 tonnes	Number	Alternative energy	Cyprus	2013
Annual	Lorries > 3.5 tonnes	Number	Alternative energy	Estonia	2013
Annual	Lorries > 3.5 tonnes	Number	Alternative energy	Finland	2013	19
Annual	Lorries > 3.5 tonnes	Number	Alternative energy	France	2013	14
Annual	Lorries > 3.5 tonnes	Number	Alternative energy	Hungary	2013	6
Annual	Lorries > 3.5 tonnes	Number	Alternative energy	Ireland	2013


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.