Baselight
Sign In

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

Eurostat code: road_go_ia_tc ยท (1999 - 2013)

@eurostat.road_go_ia_tc

International Road Freight Transport By Country Of Loading And Unloading (t, Tkm) - Annual Data, EU Aggregates (1999-2013) - Unpivoted
@eurostat.road_go_ia_tc.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.

  • 213.8 KB
  • 62710 rows
  • 7 columns
freq

Freq

unit

Unit

c_load

C Load

c_unload

C Unload

geo

Geo

time_period

Time Period

value

Value

AnnualMillion tonne-kilometre (TKM)AlbaniaGermanyEuropean Union - 15 countries (1995-2004)19991
AnnualMillion tonne-kilometre (TKM)AlbaniaEuropean Union - 15 countries (1995-2004)European Union - 15 countries (1995-2004)19992
AnnualMillion tonne-kilometre (TKM)AlbaniaEuropean Union - 25 countries (2004-2006)European Union - 15 countries (1995-2004)19992
AnnualMillion tonne-kilometre (TKM)AlbaniaAll countries of the worldEuropean Union - 15 countries (1995-2004)19992
AnnualMillion tonne-kilometre (TKM)AustriaBelgiumEuropean Union - 15 countries (1995-2004)1999473
AnnualMillion tonne-kilometre (TKM)AustriaBulgariaEuropean Union - 15 countries (1995-2004)19997
AnnualMillion tonne-kilometre (TKM)AustriaSwitzerlandEuropean Union - 15 countries (1995-2004)1999245
AnnualMillion tonne-kilometre (TKM)AustriaCzechiaEuropean Union - 15 countries (1995-2004)1999101
AnnualMillion tonne-kilometre (TKM)AustriaGermanyEuropean Union - 15 countries (1995-2004)19994790
AnnualMillion tonne-kilometre (TKM)AustriaDenmarkEuropean Union - 15 countries (1995-2004)1999228

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