Load Capacity Of New Lorries, Semi-trailers And Trailers, By Type Of Carriage (until 2012)

Eurostat code: road_eqr_lsttt · (1988 - 2012)

@eurostat.road_eqr_lsttt

Table List

2 tables(36.74 KB)

Load Capacity Of New Lorries, Semi-trailers And Trailers, By Type Of Carriage (until 2012) - Raw

Load Capacity Of New Lorries, Semi-trailers And Trailers, By Type Of Carriage (until 2012) - Unpivoted

Load Capacity Of New Lorries, Semi-trailers And Trailers, By Type Of Carriage (until 2012) - Unpivoted

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

10.25 KB
1324 rows
7 columns

freq Freq	unit Unit	vehicle Vehicle	tra_type Tra Type	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	Lorries	Total	France	1988	503
Annual	Thousand tonnes	Semi-trailers	Total	France	1988	455
Annual	Thousand tonnes	Trailers	Total	France	1988	47
Annual	Thousand tonnes	Lorries	Total	Austria	1989	38
Annual	Thousand tonnes	Lorries	Total	France	1989	519
Annual	Thousand tonnes	Lorries	Total	Norway	1989	27
Annual	Thousand tonnes	Lorries	Total	Sweden	1989	126
Annual	Thousand tonnes	Semi-trailers	Total	France	1989	517
Annual	Thousand tonnes	Semi-trailers	Total	Norway	1989	4
Annual	Thousand tonnes	Semi-trailers	Total	Sweden	1989	32


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

Share link

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