Cross-trade Road Freight Transport Of Reporting Country By Country Of Loading And Unloading, Type Of Goods And Type Of Transport (t) - Annual Data (1990-2007)

Eurostat code: road_go_cta7gtt · (1990 - 2007)

@eurostat.road_go_cta7gtt

Table List

2 tables(4.01 MB)

Cross-trade Road Freight Transport Of Reporting Country By Country Of Loading And Unloading, Type Of Goods And Type Of Transport (t) - Annual Data (1990-2007) - Raw

Cross-trade Road Freight Transport Of Reporting Country By Country Of Loading And Unloading, Type Of Goods And Type Of Transport (t) - Annual Data (1990-2007) - Unpivoted

Cross-trade Road Freight Transport Of Reporting Country By Country Of Loading And Unloading, Type Of Goods And Type Of Transport (t) - Annual Data (1990-2007) - Unpivoted

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

1.73 MB
1244136 rows
9 columns

freq Freq	unit Unit	tra_type Tra Type	c_load C Load	c_unload C Unload	nstr_gg Nstr Gg	geo Geo	time_period Time Period
Annual	Thousand tonnes	Hire or reward	Northern Africa	Belgium	Cereals	Netherlands	1990
Annual	Thousand tonnes	Hire or reward	Northern Africa	Belgium	Potatoes, other fresh or frozen fruits and vegetables	Netherlands	1990
Annual	Thousand tonnes	Hire or reward	Northern Africa	Belgium	Live animals, sugar beet	Netherlands	1990
Annual	Thousand tonnes	Hire or reward	Northern Africa	Belgium	Wood and cork	Netherlands	1990
Annual	Thousand tonnes	Hire or reward	Northern Africa	Belgium	Textiles, textile articles and man-made fibres, other raw animal and vegetable materials	Netherlands	1990
Annual	Thousand tonnes	Hire or reward	Northern Africa	Belgium	Foodstuff and animal fodder	Netherlands	1990
Annual	Thousand tonnes	Hire or reward	Northern Africa	Belgium	Oil seeds and oleaginous fruits and fats	Netherlands	1990
Annual	Thousand tonnes	Hire or reward	Northern Africa	Belgium	Solid mineral fuels	Netherlands	1990
Annual	Thousand tonnes	Hire or reward	Northern Africa	Belgium	Petroleum products	Netherlands	1990
Annual	Thousand tonnes	Hire or reward	Northern Africa	Belgium	Crude petroleum	Netherlands	1990


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