New Lorries By Motor Energy And Load Capacity Of +/- 1500kg (until 2012)

Eurostat code: road_eqr_lormot_h · (1988 - 2012)

@eurostat.road_eqr_lormot_h

Table List

2 tables(63.5 KB)

New Lorries By Motor Energy And Load Capacity Of +/- 1500kg (until 2012) - Raw

New Lorries By Motor Energy And Load Capacity Of +/- 1500kg (until 2012) - Unpivoted

New Lorries By Motor Energy And Load Capacity Of +/- 1500kg (until 2012) - Unpivoted

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

24.44 KB
3167 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	France	1988	404351
Annual	Number	Total	Total	France	1989	421764
Annual	Number	Total	Total	Sweden	1989	44801
Annual	Number	1 500 kg or over	Diesel	Sweden	1990	6642
Annual	Number	1 500 kg or over	Petroleum products	Sweden	1990	784
Annual	Number	1 500 kg or over	Total	Austria	1990	6568
Annual	Number	1 500 kg or over	Total	Sweden	1990	7426
Annual	Number	1 500 kg or over	Total	Türkiye	1990	15967
Annual	Number	Less than 1 500 kg	Diesel	Sweden	1990	3416
Annual	Number	Less than 1 500 kg	Petroleum products	Sweden	1990	22899


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

Share link

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