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

Eurostat code: road_go_cta_gtt · (2008 - 2023)

@eurostat.road_go_cta_gtt

Table List

2 tables(8.03 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 (from 2008 Onwards) - 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 (from 2008 Onwards) - 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 (from 2008 Onwards) - Unpivoted

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

3.97 MB
1897046 rows
9 columns

freq Freq	tra_type Tra Type	c_load C Load	c_unload C Unload	nst07 Nst07	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Hire or reward	Austria	Austria	Grouped goods: a mixture of types of goods which are transported together	Thousand tonnes	Hungary	2008	12
Annual	Hire or reward	Austria	Austria	Total transported goods	Thousand tonnes	Hungary	2008	44
Annual	Hire or reward	Austria	Belgium	Total transported goods	Thousand tonnes	Hungary	2008	29
Annual	Hire or reward	Austria	Switzerland	Food products, beverages and tobacco	Thousand tonnes	Liechtenstein	2008	10
Annual	Hire or reward	Austria	Switzerland	Total transported goods	Thousand tonnes	Germany	2008	74
Annual	Hire or reward	Austria	Switzerland	Total transported goods	Thousand tonnes	Hungary	2008	25
Annual	Hire or reward	Austria	Switzerland	Total transported goods	Thousand tonnes	Liechtenstein	2008	21
Annual	Hire or reward	Austria	Czechia	Total transported goods	Thousand tonnes	Slovakia	2008	34
Annual	Hire or reward	Austria	Germany	Food products, beverages and tobacco	Thousand tonnes	Czechia	2008	150
Annual	Hire or reward	Austria	Germany	Food products, beverages and tobacco	Thousand tonnes	Hungary	2008	52


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