Baselight
Sign In

New Semi-trailers And Their Load Capacity, By Permissible Maximum Gross Weight

Eurostat code: road_eqr_semit ยท (2012 - 2023)

@eurostat.road_eqr_semit

New Semi-trailers And Their Load Capacity, By Permissible Maximum Gross Weight - Unpivoted
@eurostat.road_eqr_semit.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.

  • 13.64 KB
  • 1812 rows
  • 6 columns
freq

Freq

unit

Unit

weight

Weight

geo

Geo

time_period

Time Period

value

Value

AnnualNumberTotalPoland201218062
AnnualThousand tonnesTotalPoland2012448
AnnualNumberFrom 20 001 to 30 000 kgAustria201354
AnnualNumberFrom 20 001 to 30 000 kgBosnia and Herzegovina20132
AnnualNumberFrom 20 001 to 30 000 kgSwitzerland2013141
AnnualNumberFrom 20 001 to 30 000 kgGermany2013949
AnnualNumberFrom 20 001 to 30 000 kgDenmark201389
AnnualNumberFrom 20 001 to 30 000 kgSpain20132
AnnualNumberFrom 20 001 to 30 000 kgFinland20131168
AnnualNumberFrom 20 001 to 30 000 kgFrance2013619

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.