International Road Freight Transport - Unloaded Goods In Reporting Country By Country Of Loading, Type Of Goods And Type Of Transport (t) - Annual Data (from 2008 Onwards)

Eurostat code: road_go_ia_ugtt · (2008 - 2023)

@eurostat.road_go_ia_ugtt

Table List

2 tables(1.01 MB)

International Road Freight Transport - Unloaded Goods In Reporting Country By Country Of Loading, Type Of Goods And Type Of Transport (t) - Annual Data (from 2008 Onwards) - Raw

International Road Freight Transport - Unloaded Goods In Reporting Country By Country Of Loading, Type Of Goods And Type Of Transport (t) - Annual Data (from 2008 Onwards) - Unpivoted

International Road Freight Transport - Unloaded Goods In Reporting Country By Country Of Loading, Type Of Goods And Type Of Transport (t) - Annual Data (from 2008 Onwards) - Unpivoted

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

519.52 KB
207799 rows
8 columns

freq Freq	tra_type Tra Type	c_load C Load	nst07 Nst07	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Czechia	2008	85
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Germany	2008	219
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Hungary	2008	30
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Slovenia	2008	49
Annual	Hire or reward	Austria	Metal ores and other mining and quarrying products; peat; uranium and thorium	Thousand tonnes	Switzerland	2008	105
Annual	Hire or reward	Austria	Metal ores and other mining and quarrying products; peat; uranium and thorium	Thousand tonnes	Germany	2008	412
Annual	Hire or reward	Austria	Metal ores and other mining and quarrying products; peat; uranium and thorium	Thousand tonnes	Hungary	2008	73
Annual	Hire or reward	Austria	Metal ores and other mining and quarrying products; peat; uranium and thorium	Thousand tonnes	Slovenia	2008	207
Annual	Hire or reward	Austria	Food products, beverages and tobacco	Thousand tonnes	Czechia	2008	154
Annual	Hire or reward	Austria	Food products, beverages and tobacco	Thousand tonnes	Germany	2008	641


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