New Trailers And Their Load Capacity (until 2012)

Eurostat code: road_eqr_trailn · (1988 - 2012)

@eurostat.road_eqr_trailn

Table List

2 tables(52.44 KB)

New Trailers And Their Load Capacity (until 2012) - Raw

New Trailers And Their Load Capacity (until 2012) - Unpivoted

New Trailers And Their Load Capacity (until 2012) - Unpivoted

@eurostat.road_eqr_trailn.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.7 KB
2939 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	1060
Annual	Number	From 5 000 to 9 999 kg	France	1988	756
Annual	Number	15 000 kg or over	France	1988	1261
Annual	Number	Less than 5 000 kg	France	1988	182
Annual	Number	Total	France	1988	3259
Annual	Thousand tonnes	From 10 000 to 14 999 kg	France	1988	14
Annual	Thousand tonnes	From 5 000 to 9 999 kg	France	1988	5
Annual	Thousand tonnes	15 000 kg or over	France	1988	27
Annual	Thousand tonnes	Less than 5 000 kg	France	1988	1
Annual	Thousand tonnes	Total	France	1988	47


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.