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

Eurostat code: road_go_ia_lgtt · (2008 - 2023)

@eurostat.road_go_ia_lgtt

Table List

2 tables(1.13 MB)

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

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

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

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

563.72 KB
221556 rows
8 columns

freq Freq	tra_type Tra Type	c_unload C Unload	nst07 Nst07	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Hire or reward	Andorra	Total transported goods	Thousand tonnes	Spain	2008	98
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Czechia	2008	99
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Germany	2008	512
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Spain	2008	148
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Hungary	2008	170
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Netherlands	2008	28
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Slovenia	2008	126
Annual	Hire or reward	Austria	Products of agriculture, hunting, and forestry; fish and other fishing products	Thousand tonnes	Slovakia	2008	146
Annual	Hire or reward	Austria	Metal ores and other mining and quarrying products; peat; uranium and thorium	Thousand tonnes	Czechia	2008	206
Annual	Hire or reward	Austria	Metal ores and other mining and quarrying products; peat; uranium and thorium	Thousand tonnes	Germany	2008	270


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