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

Eurostat code: road_go_ia7lgtt · (1982 - 2007)

@eurostat.road_go_ia7lgtt

Table List

2 tables(1.29 MB)

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

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

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

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

603.95 KB
411025 rows
8 columns

freq Freq	unit Unit	tra_type Tra Type	c_unload C Unload	nstr_gg Nstr Gg	geo Geo	time_period Time Period
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	Ireland	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


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

Share link

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