International Road Freight Transport By Country Of Loading And Unloading And Type Of Goods (t, Tkm) - Annual Data, EU Aggregates (1999-2007)

Eurostat code: road_go_ia_tctg · (1999 - 2007)

@eurostat.road_go_ia_tctg

Table List

2 tables(1.1 MB)

International Road Freight Transport By Country Of Loading And Unloading And Type Of Goods (t, Tkm) - Annual Data, EU Aggregates (1999-2007) - Raw

International Road Freight Transport By Country Of Loading And Unloading And Type Of Goods (t, Tkm) - Annual Data, EU Aggregates (1999-2007) - Unpivoted

International Road Freight Transport By Country Of Loading And Unloading And Type Of Goods (t, Tkm) - Annual Data, EU Aggregates (1999-2007) - Unpivoted

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

513.98 KB
196574 rows
8 columns

freq Freq	unit Unit	nstr_gg Nstr Gg	c_load C Load	c_unload C Unload	geo Geo	time_period Time Period
Annual	Million tonne-kilometre (TKM)	Agricultural products and live animals	Albania	Germany	European Union - 15 countries (1995-2004)	1999
Annual	Million tonne-kilometre (TKM)	Agricultural products and live animals	Albania	Germany	European Union - 25 countries (2004-2006)	1999
Annual	Million tonne-kilometre (TKM)	Agricultural products and live animals	Albania	European Union - 15 countries (1995-2004)	European Union - 15 countries (1995-2004)	1999
Annual	Million tonne-kilometre (TKM)	Agricultural products and live animals	Albania	European Union - 15 countries (1995-2004)	European Union - 25 countries (2004-2006)	1999
Annual	Million tonne-kilometre (TKM)	Agricultural products and live animals	Albania	European Union - 25 countries (2004-2006)	European Union - 15 countries (1995-2004)	1999
Annual	Million tonne-kilometre (TKM)	Agricultural products and live animals	Albania	European Union - 25 countries (2004-2006)	European Union - 25 countries (2004-2006)	1999
Annual	Million tonne-kilometre (TKM)	Agricultural products and live animals	Albania	European Union - 27 countries (2007-2013)	European Union - 15 countries (1995-2004)	1999
Annual	Million tonne-kilometre (TKM)	Agricultural products and live animals	Albania	European Union - 27 countries (2007-2013)	European Union - 25 countries (2004-2006)	1999
Annual	Million tonne-kilometre (TKM)	Agricultural products and live animals	Albania	All countries of the world	European Union - 15 countries (1995-2004)	1999
Annual	Million tonne-kilometre (TKM)	Agricultural products and live animals	Albania	All countries of the world	European Union - 25 countries (2004-2006)	1999


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

Share link

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