Road Freight Transport By Distance Class And Type Of Goods (t, Tkm, Vehicle-km, Basic Transport Operations) - Annual Data (1999-2007)

Eurostat code: road_go_ta7dctg · (1999 - 2007)

@eurostat.road_go_ta7dctg

Table List

2 tables(657.81 KB)

Road Freight Transport By Distance Class And Type Of Goods (t, Tkm, Vehicle-km, Basic Transport Operations) - Annual Data (1999-2007) - Raw

Road Freight Transport By Distance Class And Type Of Goods (t, Tkm, Vehicle-km, Basic Transport Operations) - Annual Data (1999-2007) - Unpivoted

Road Freight Transport By Distance Class And Type Of Goods (t, Tkm, Vehicle-km, Basic Transport Operations) - Annual Data (1999-2007) - Unpivoted

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

313.27 KB
117576 rows
7 columns

freq Freq	nstr_gg Nstr Gg	distance Distance	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Cereals	From 1 000 to 1 999 km	Million tonne-kilometre (TKM)	Austria	1999	31
Annual	Cereals	From 1 000 to 1 999 km	Million tonne-kilometre (TKM)	Denmark	1999	24
Annual	Cereals	From 1 000 to 1 999 km	Million tonne-kilometre (TKM)	France	1999	151
Annual	Cereals	From 1 000 to 1 999 km	Million tonne-kilometre (TKM)	Italy	1999	197
Annual	Cereals	From 1 000 to 1 999 km	Million tonne-kilometre (TKM)	Netherlands	1999	37
Annual	Cereals	From 1 000 to 1 999 km	Million tonne-kilometre (TKM)	United Kingdom	1999	77
Annual	Cereals	From 1 000 to 1 999 km	Million vehicle-kilometres (VKM)	Austria	1999	1
Annual	Cereals	From 1 000 to 1 999 km	Million vehicle-kilometres (VKM)	Denmark	1999	1
Annual	Cereals	From 1 000 to 1 999 km	Million vehicle-kilometres (VKM)	France	1999	8
Annual	Cereals	From 1 000 to 1 999 km	Million vehicle-kilometres (VKM)	Italy	1999	7


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

Share link

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