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

Eurostat code: road_go_ia7ugtt · (1982 - 2007)

@eurostat.road_go_ia7ugtt

Table List

2 tables(1.18 MB)

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

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

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

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

548.11 KB
388285 rows
8 columns

freq Freq	unit Unit	tra_type Tra Type	c_load C Load	nstr_gg Nstr Gg	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	Hire or reward	Northern Africa	Cereals	Germany	1982
Annual	Thousand tonnes	Hire or reward	Northern Africa	Cereals	Denmark	1982
Annual	Thousand tonnes	Hire or reward	Northern Africa	Cereals	Greece	1982
Annual	Thousand tonnes	Hire or reward	Northern Africa	Cereals	France	1982
Annual	Thousand tonnes	Hire or reward	Northern Africa	Cereals	United Kingdom	1982
Annual	Thousand tonnes	Hire or reward	Northern Africa	Potatoes, other fresh or frozen fruits and vegetables	Germany	1982
Annual	Thousand tonnes	Hire or reward	Northern Africa	Potatoes, other fresh or frozen fruits and vegetables	Denmark	1982
Annual	Thousand tonnes	Hire or reward	Northern Africa	Potatoes, other fresh or frozen fruits and vegetables	Greece	1982
Annual	Thousand tonnes	Hire or reward	Northern Africa	Potatoes, other fresh or frozen fruits and vegetables	France	1982	2
Annual	Thousand tonnes	Hire or reward	Northern Africa	Potatoes, other fresh or frozen fruits and vegetables	United Kingdom	1982


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

Share link

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