Lorries By Type Of Motor Energy And Load Capacity (until 2012)

Eurostat code: road_eqs_lormot_h · (1970 - 2012)

@eurostat.road_eqs_lormot_h

Table List

2 tables(92.65 KB)

Lorries By Type Of Motor Energy And Load Capacity (until 2012) - Raw

Lorries By Type Of Motor Energy And Load Capacity (until 2012) - Unpivoted

Lorries By Type Of Motor Energy And Load Capacity (until 2012) - Unpivoted

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

34.11 KB
4031 rows
7 columns

freq Freq	unit Unit	weight Weight	mot_nrg Mot Nrg	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Total	Belgium	1970	186639
Annual	Number	Total	Total	Czechia	1970	89000
Annual	Number	Total	Total	Germany	1970	1028116
Annual	Number	Total	Total	Denmark	1970	245347
Annual	Number	Total	Total	Greece	1970	105032
Annual	Number	Total	Total	Spain	1970	1100000
Annual	Number	Total	Total	France	1970	1504100
Annual	Number	Total	Total	Italy	1970	1260560
Annual	Number	Total	Total	Lithuania	1970	47386
Annual	Number	Total	Total	Luxembourg	1970	8528


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

Share link

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