National Road Freight Transport By Distance Class, Type Of Goods And Type Of Transport (t) - Annual Data (from 2008 Onwards)

Eurostat code: road_go_na_dctg · (2008 - 2023)

@eurostat.road_go_na_dctg

Table List

2 tables(922.07 KB)

National Road Freight Transport By Distance Class, Type Of Goods And Type Of Transport (t) - Annual Data (from 2008 Onwards) - Raw

National Road Freight Transport By Distance Class, Type Of Goods And Type Of Transport (t) - Annual Data (from 2008 Onwards) - Unpivoted

National Road Freight Transport By Distance Class, Type Of Goods And Type Of Transport (t) - Annual Data (from 2008 Onwards) - Unpivoted

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

404.03 KB
116092 rows
8 columns

freq Freq	tra_type Tra Type	distance Distance	nst07 Nst07	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Hire or reward	From 150 to 499 km	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Austria	2008	1111
Annual	Hire or reward	From 150 to 499 km	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Belgium	2008	1503
Annual	Hire or reward	From 150 to 499 km	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Bulgaria	2008	466
Annual	Hire or reward	From 150 to 499 km	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Switzerland	2008	1085
Annual	Hire or reward	From 150 to 499 km	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Czechia	2008	1611
Annual	Hire or reward	From 150 to 499 km	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Germany	2008	23205
Annual	Hire or reward	From 150 to 499 km	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Denmark	2008	3591
Annual	Hire or reward	From 150 to 499 km	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Estonia	2008	597
Annual	Hire or reward	From 150 to 499 km	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Greece	2008	1901
Annual	Hire or reward	From 150 to 499 km	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Spain	2008	25810


CREATE TABLE tidy (
  "freq" VARCHAR,
  "tra_type" VARCHAR,
  "distance" 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.