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

Eurostat code: road_go_ta_ru · (1999 - 2023)

@eurostat.road_go_ta_ru

Table List

2 tables(3.25 MB)

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

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

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

@eurostat.road_go_ta_ru.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.49 MB
477330 rows
6 columns

freq Freq	c_unload C Unload	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Andorra	Million tonne-kilometre (TKM)	Spain	1999	55
Annual	Andorra	Million tonne-kilometre (TKM)	European Union - 27 countries (from 2020)	1999	67
Annual	Andorra	Thousand journeys	Spain	1999	19
Annual	Andorra	Thousand journeys	European Union - 27 countries (from 2020)	1999	23
Annual	Andorra	Thousand tonnes	Spain	1999	260
Annual	Andorra	Thousand tonnes	European Union - 27 countries (from 2020)	1999	298
Annual	Albania	Million tonne-kilometre (TKM)	European Union - 27 countries (from 2020)	1999	21
Annual	Albania	Million tonne-kilometre (TKM)	Netherlands	1999	4
Annual	Albania	Thousand journeys	European Union - 27 countries (from 2020)	1999
Annual	Albania	Thousand journeys	Netherlands	1999


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

Share link

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