Baselight

Road Freight Transport Vehicle Movements By Loading Status, Type Of Transport And Territorial Coverage (vehicle-km, Journeys) - Annual Data

Eurostat code: road_go_ta_vm ยท (1999 - 2023)

@eurostat.road_go_ta_vm

Road Freight Transport Vehicle Movements By Loading Status, Type Of Transport And Territorial Coverage (vehicle-km, Journeys) - Annual Data - Unpivoted
@eurostat.road_go_ta_vm.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.

  • 142.28 KB
  • 36226 rows
  • 8 columns
freq

Freq

tra_type

Tra Type

loadstat

Loadstat

tra_cov

Tra Cov

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualHire or rewardEmptyInternational transportMillion vehicle-kilometres (VKM)Austria1999203
AnnualHire or rewardEmptyInternational transportMillion vehicle-kilometres (VKM)Germany1999503
AnnualHire or rewardEmptyInternational transportMillion vehicle-kilometres (VKM)Denmark199968
AnnualHire or rewardEmptyInternational transportMillion vehicle-kilometres (VKM)Spain1999211
AnnualHire or rewardEmptyInternational transportMillion vehicle-kilometres (VKM)Finland199940
AnnualHire or rewardEmptyInternational transportMillion vehicle-kilometres (VKM)France1999392
AnnualHire or rewardEmptyInternational transportMillion vehicle-kilometres (VKM)Ireland199929
AnnualHire or rewardEmptyInternational transportMillion vehicle-kilometres (VKM)Luxembourg199962
AnnualHire or rewardEmptyInternational transportMillion vehicle-kilometres (VKM)Norway199924
AnnualHire or rewardEmptyInternational transportMillion vehicle-kilometres (VKM)Portugal199951

CREATE TABLE tidy (
  "freq" VARCHAR,
  "tra_type" VARCHAR,
  "loadstat" VARCHAR,
  "tra_cov" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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