Baselight
Sign In

Road Freight Transport By Load Capacity (LC) Of Vehicle And Type Of Transport (tkm, Vehicle-km, Journeys) - Annual Data

Eurostat code: road_go_ta_lc ยท (1999 - 2023)

@eurostat.road_go_ta_lc

Road Freight Transport By Load Capacity (LC) Of Vehicle And Type Of Transport (tkm, Vehicle-km, Journeys) - Annual Data - Unpivoted
@eurostat.road_go_ta_lc.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.

  • 166.28 KB
  • 45795 rows
  • 7 columns
freq

Freq

tra_type

Tra Type

weight

Weight

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualHire or rewardFrom 15.6 to 20.5 tMillion tonne-kilometre (TKM)Austria1999853
AnnualHire or rewardFrom 15.6 to 20.5 tMillion tonne-kilometre (TKM)Belgium19994290
AnnualHire or rewardFrom 15.6 to 20.5 tMillion tonne-kilometre (TKM)Germany199910540
AnnualHire or rewardFrom 15.6 to 20.5 tMillion tonne-kilometre (TKM)Denmark19992525
AnnualHire or rewardFrom 15.6 to 20.5 tMillion tonne-kilometre (TKM)Spain19991637
AnnualHire or rewardFrom 15.6 to 20.5 tMillion tonne-kilometre (TKM)Finland1999706
AnnualHire or rewardFrom 15.6 to 20.5 tMillion tonne-kilometre (TKM)France19992356
AnnualHire or rewardFrom 15.6 to 20.5 tMillion tonne-kilometre (TKM)Ireland1999699
AnnualHire or rewardFrom 15.6 to 20.5 tMillion tonne-kilometre (TKM)Italy19995738
AnnualHire or rewardFrom 15.6 to 20.5 tMillion tonne-kilometre (TKM)Luxembourg1999445

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