Road Freight Transport By Type Of Operation And Type Of Transport (t, Tkm, Vehicle-km) - Annual Data

Eurostat code: road_go_ta_tott · (1999 - 2023)

@eurostat.road_go_ta_tott

Table List

2 tables(517.61 KB)

Road Freight Transport By Type Of Operation And Type Of Transport (t, Tkm, Vehicle-km) - Annual Data - Raw

Road Freight Transport By Type Of Operation And Type Of Transport (t, Tkm, Vehicle-km) - Annual Data - Unpivoted

Road Freight Transport By Type Of Operation And Type Of Transport (t, Tkm, Vehicle-km) - Annual Data - Unpivoted

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

222.38 KB
61142 rows
7 columns

freq Freq	tra_type Tra Type	tra_oper Tra Oper	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Hire or reward	Empty - international transport - total	Million vehicle-kilometres (VKM)	Austria	1999	203
Annual	Hire or reward	Empty - international transport - total	Million vehicle-kilometres (VKM)	Germany	1999	503
Annual	Hire or reward	Empty - international transport - total	Million vehicle-kilometres (VKM)	Denmark	1999	68
Annual	Hire or reward	Empty - international transport - total	Million vehicle-kilometres (VKM)	Spain	1999	211
Annual	Hire or reward	Empty - international transport - total	Million vehicle-kilometres (VKM)	Finland	1999	40
Annual	Hire or reward	Empty - international transport - total	Million vehicle-kilometres (VKM)	France	1999	392
Annual	Hire or reward	Empty - international transport - total	Million vehicle-kilometres (VKM)	Ireland	1999	29
Annual	Hire or reward	Empty - international transport - total	Million vehicle-kilometres (VKM)	Luxembourg	1999	62
Annual	Hire or reward	Empty - international transport - total	Million vehicle-kilometres (VKM)	Norway	1999	24
Annual	Hire or reward	Empty - international transport - total	Million vehicle-kilometres (VKM)	Portugal	1999	51


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

Share link

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