Road Freight Transport By Region Of Loading (t, Tkm, Journeys) - Annual Data

Eurostat code: road_go_ta_rl · (1999 - 2023)

@eurostat.road_go_ta_rl

Table List

2 tables(3.17 MB)

Road Freight Transport By Region Of Loading (t, Tkm, Journeys) - Annual Data - Raw

Road Freight Transport By Region Of Loading (t, Tkm, Journeys) - Annual Data - Unpivoted

Road Freight Transport By Region Of Loading (t, Tkm, Journeys) - Annual Data - Unpivoted

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

1.44 MB
460158 rows
6 columns

freq Freq	c_load C Load	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Albania	Million tonne-kilometre (TKM)	European Union - 27 countries (from 2020)	1999	1
Annual	Albania	Million tonne-kilometre (TKM)	Netherlands	1999
Annual	Albania	Thousand journeys	European Union - 27 countries (from 2020)	1999
Annual	Albania	Thousand journeys	Netherlands	1999
Annual	Albania	Thousand tonnes	European Union - 27 countries (from 2020)	1999	4
Annual	Albania	Thousand tonnes	Netherlands	1999
Annual	Austria	Million tonne-kilometre (TKM)	Denmark	1999	112
Annual	Austria	Million tonne-kilometre (TKM)	European Union - 27 countries (from 2020)	1999	1783
Annual	Austria	Million tonne-kilometre (TKM)	Italy	1999	635
Annual	Austria	Million tonne-kilometre (TKM)	Luxembourg	1999	736


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

Share link

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