New Lorries By Load Capacity (until 2012)

Eurostat code: road_eqr_lorrin_h · (1988 - 2012)

@eurostat.road_eqr_lorrin_h

Table List

2 tables(61.29 KB)

New Lorries By Load Capacity (until 2012) - Raw

New Lorries By Load Capacity (until 2012) - Unpivoted

New Lorries By Load Capacity (until 2012) - Unpivoted

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

22.17 KB
3260 rows
6 columns

freq Freq	unit Unit	weight Weight	geo Geo	time_period Time Period	value Value
Annual	Number	Total	France	1988	404351
Annual	Number	Total	France	1989	421764
Annual	Number	Total	Sweden	1989	44801
Annual	Number	From 1 000 to 1 499 kg	Sweden	1990	7550
Annual	Number	From 10 000 to 14 999 kg	Austria	1990	940
Annual	Number	From 10 000 to 14 999 kg	Sweden	1990	2202
Annual	Number	From 10 000 to 14 999 kg	Türkiye	1990	11221
Annual	Number	From 1 500 to 2 999 kg	Sweden	1990	1565
Annual	Number	From 3 000 to 4 999 kg	Sweden	1990	600
Annual	Number	From 5 000 to 6 999 kg	Austria	1990	1080


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

Share link

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