Baselight
Sign In

International Road Freight Transport Of Reporting Country, By Country Of Loading And Unloading (t, Tkm) - Annual Data

Eurostat code: road_go_ia_rc ยท (1999 - 2023)

@eurostat.road_go_ia_rc

International Road Freight Transport Of Reporting Country, By Country Of Loading And Unloading (t, Tkm) - Annual Data - Unpivoted
@eurostat.road_go_ia_rc.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.52 MB
  • 537330 rows
  • 7 columns
freq

Freq

c_load

C Load

c_unload

C Unload

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAndorraAll countries of the worldMillion tonne-kilometre (TKM)Spain199915
AnnualAndorraAll countries of the worldMillion tonne-kilometre (TKM)Netherlands1999
AnnualAndorraAll countries of the worldThousand tonnesSpain199915
AnnualAndorraAll countries of the worldThousand tonnesNetherlands1999
AnnualAlbaniaGermanyMillion tonne-kilometre (TKM)Netherlands19991
AnnualAlbaniaGermanyThousand tonnesNetherlands1999
AnnualAlbaniaEuropean Union - 15 countries (1995-2004)Million tonne-kilometre (TKM)Netherlands19991
AnnualAlbaniaEuropean Union - 15 countries (1995-2004)Thousand tonnesNetherlands1999
AnnualAlbaniaEuropean Union - 25 countries (2004-2006)Million tonne-kilometre (TKM)Netherlands19991
AnnualAlbaniaEuropean Union - 25 countries (2004-2006)Thousand tonnesNetherlands1999

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

Share link

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