Semi-trailers By Load Capacity (until 2012)

Eurostat code: road_eqs_semitn · (1975 - 2012)

@eurostat.road_eqs_semitn

Table List

2 tables(57.13 KB)

Semi-trailers By Load Capacity (until 2012) - Raw

Semi-trailers By Load Capacity (until 2012) - Unpivoted

Semi-trailers By Load Capacity (until 2012) - Unpivoted

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

17.68 KB
2237 rows
6 columns

freq Freq	unit Unit	weight Weight	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Norway	1975	2413
Annual	Number	Total	Belgium	1979	26605
Annual	Number	Total	Germany	1979	60706
Annual	Number	Total	Spain	1979	30676
Annual	Number	Total	France	1979	124796
Annual	Number	Total	Portugal	1979	30676
Annual	Number	Total	Belgium	1980	28879
Annual	Number	Total	Germany	1980	65283
Annual	Number	Total	Spain	1980	33875
Annual	Number	Total	France	1980	126190


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.