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

Eurostat code: road_go_na7dctg · (1982 - 2007)

@eurostat.road_go_na7dctg

Table List

2 tables(988.21 KB)

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

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

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

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

415.06 KB
123816 rows
8 columns

freq Freq	unit Unit	tra_type Tra Type	distance Distance	nstr_gg Nstr Gg	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	Hire or reward	From 150 to 499 km	Cereals	Belgium	1982	27
Annual	Thousand tonnes	Hire or reward	From 150 to 499 km	Cereals	Germany	1982	162
Annual	Thousand tonnes	Hire or reward	From 150 to 499 km	Cereals	Denmark	1982	290
Annual	Thousand tonnes	Hire or reward	From 150 to 499 km	Cereals	Greece	1982	1442
Annual	Thousand tonnes	Hire or reward	From 150 to 499 km	Cereals	France	1982	1981
Annual	Thousand tonnes	Hire or reward	From 150 to 499 km	Cereals	Ireland	1982	122
Annual	Thousand tonnes	Hire or reward	From 150 to 499 km	Cereals	Luxembourg	1982
Annual	Thousand tonnes	Hire or reward	From 150 to 499 km	Cereals	Netherlands	1982	112
Annual	Thousand tonnes	Hire or reward	From 150 to 499 km	Cereals	United Kingdom	1982	2300
Annual	Thousand tonnes	Hire or reward	From 150 to 499 km	Potatoes, other fresh or frozen fruits and vegetables	Belgium	1982	49


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

Share link

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