New Semi-trailers And Their Load Capacity (until 2012)

Eurostat code: road_eqr_semitn · (1988 - 2012)

@eurostat.road_eqr_semitn

Table List

2 tables(49.54 KB)

New Semi-trailers And Their Load Capacity (until 2012) - Raw

New Semi-trailers And Their Load Capacity (until 2012) - Unpivoted

New Semi-trailers And Their Load Capacity (until 2012) - Unpivoted

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

16.56 KB
3178 rows
6 columns

freq Freq	unit Unit	weight Weight	geo Geo	time_period Time Period	value Value
Annual	Number	From 10 000 to 14 999 kg	France	1988	661
Annual	Number	From 15 000 to 19 999 kg	France	1988	801
Annual	Number	From 5 000 to 9 999 kg	France	1988	147
Annual	Number	20 000 kg or over	France	1988	17000
Annual	Number	Less than 5 000 kg	France	1988	53
Annual	Number	Total	Germany	1988	6565
Annual	Number	Total	France	1988	18662
Annual	Number	Total	Norway	1988	232
Annual	Thousand tonnes	From 10 000 to 14 999 kg	France	1988	9
Annual	Thousand tonnes	From 15 000 to 19 999 kg	France	1988	17


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.