Road Freight Transport By Type Of Goods And Type Of Transport (t, Tkm) - Annual Data

Eurostat code: road_go_ta_tg · (2008 - 2023)

@eurostat.road_go_ta_tg

Table List

2 tables(546.1 KB)

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

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

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

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

230.93 KB
59548 rows
7 columns

freq Freq	tra_type Tra Type	nst07 Nst07	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Hire or reward	Products of agriculture, hunting, and forestry; fish and other fishing products	Million tonne-kilometre (TKM)	Austria	2008	1913
Annual	Hire or reward	Products of agriculture, hunting, and forestry; fish and other fishing products	Million tonne-kilometre (TKM)	Belgium	2008	1966
Annual	Hire or reward	Products of agriculture, hunting, and forestry; fish and other fishing products	Million tonne-kilometre (TKM)	Bulgaria	2008	711
Annual	Hire or reward	Products of agriculture, hunting, and forestry; fish and other fishing products	Million tonne-kilometre (TKM)	Switzerland	2008	1031
Annual	Hire or reward	Products of agriculture, hunting, and forestry; fish and other fishing products	Million tonne-kilometre (TKM)	Cyprus	2008	33
Annual	Hire or reward	Products of agriculture, hunting, and forestry; fish and other fishing products	Million tonne-kilometre (TKM)	Czechia	2008	3306
Annual	Hire or reward	Products of agriculture, hunting, and forestry; fish and other fishing products	Million tonne-kilometre (TKM)	Germany	2008	15478
Annual	Hire or reward	Products of agriculture, hunting, and forestry; fish and other fishing products	Million tonne-kilometre (TKM)	Denmark	2008	2106
Annual	Hire or reward	Products of agriculture, hunting, and forestry; fish and other fishing products	Million tonne-kilometre (TKM)	Estonia	2008	658
Annual	Hire or reward	Products of agriculture, hunting, and forestry; fish and other fishing products	Million tonne-kilometre (TKM)	Greece	2008	1694


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

Share link

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