Road Equipment: Load Capacity Of Lorries

Eurostat code: med_rd4 · (2000 - 2015)

@eurostat.med_rd4

Table List

2 tables(19.23 KB)

Road Equipment: Load Capacity Of Lorries - Raw

Road Equipment: Load Capacity Of Lorries - Unpivoted

Road Equipment: Load Capacity Of Lorries - Unpivoted

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

5.3 KB
112 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	Lorries	Jordan	2000	246.6
Annual	Thousand tonnes	Semi-trailers	Jordan	2000	16.9
Annual	Thousand tonnes	Trailers	Jordan	2000	0.5
Annual	Thousand tonnes	Goods road vehicles	Jordan	2000	263.9
Annual	Thousand tonnes	Lorries	Jordan	2001	269.5
Annual	Thousand tonnes	Semi-trailers	Jordan	2001	17
Annual	Thousand tonnes	Trailers	Jordan	2001	0.5
Annual	Thousand tonnes	Goods road vehicles	Jordan	2001	286.9
Annual	Thousand tonnes	Lorries	Jordan	2002	280.4
Annual	Thousand tonnes	Semi-trailers	Jordan	2002	17


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

Share link

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