Load Capacity Of New Lorries (until 2012)

Eurostat code: road_eqr_lorrit_h · (1988 - 2012)

@eurostat.road_eqr_lorrit_h

Table List

2 tables(42.65 KB)

Load Capacity Of New Lorries (until 2012) - Raw

Load Capacity Of New Lorries (until 2012) - Unpivoted

Load Capacity Of New Lorries (until 2012) - Unpivoted

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

12.74 KB
2459 rows
6 columns

freq Freq	unit Unit	weight Weight	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	From 1 000 to 1 499 kg	France	1988	100
Annual	Thousand tonnes	From 10 000 to 14 999 kg	France	1988	80
Annual	Thousand tonnes	From 1 500 to 2 999 kg	France	1988	50
Annual	Thousand tonnes	From 3 000 to 4 999 kg	France	1988	25
Annual	Thousand tonnes	From 5 000 to 6 999 kg	France	1988	29
Annual	Thousand tonnes	From 7 000 to 9 999 kg	France	1988	66
Annual	Thousand tonnes	15 000 kg or over	France	1988	18
Annual	Thousand tonnes	Less than 1 000 kg	France	1988	135
Annual	Thousand tonnes	Total	France	1988	503
Annual	Thousand tonnes	From 1 000 to 1 499 kg	Austria	1989	14


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.