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

Eurostat code: road_go_na7tgtt · (1982 - 2007)

@eurostat.road_go_na7tgtt

Table List

2 tables(482.33 KB)

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

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

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

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

197.33 KB
54800 rows
7 columns

freq Freq	unit Unit	tra_type Tra Type	nstr_gg Nstr Gg	geo Geo	time_period Time Period	value Value
Annual	Million tonne-kilometre (TKM)	Hire or reward	Cereals	Belgium	1982	42
Annual	Million tonne-kilometre (TKM)	Hire or reward	Cereals	Germany	1982	275
Annual	Million tonne-kilometre (TKM)	Hire or reward	Cereals	Denmark	1982	146
Annual	Million tonne-kilometre (TKM)	Hire or reward	Cereals	Greece	1982	645
Annual	Million tonne-kilometre (TKM)	Hire or reward	Cereals	France	1982	1113
Annual	Million tonne-kilometre (TKM)	Hire or reward	Cereals	Ireland	1982	55
Annual	Million tonne-kilometre (TKM)	Hire or reward	Cereals	Luxembourg	1982
Annual	Million tonne-kilometre (TKM)	Hire or reward	Cereals	Netherlands	1982	75
Annual	Million tonne-kilometre (TKM)	Hire or reward	Cereals	United Kingdom	1982	1400
Annual	Million tonne-kilometre (TKM)	Hire or reward	Potatoes, other fresh or frozen fruits and vegetables	Belgium	1982	58


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

Share link

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