Baselight

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

Eurostat code: road_go_ia_rctg ยท (1999 - 2007)

@eurostat.road_go_ia_rctg

International Road Freight Transport Of Reporting Countryby Country Of Loading And Unloading And Type Of Goods (t, Tkm) - Annual Data (1999-2007) - Unpivoted
@eurostat.road_go_ia_rctg.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.22 MB
  • 467934 rows
  • 8 columns
freq

Freq

nstr_gg

Nstr Gg

c_load

C Load

c_unload

C Unload

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAgricultural products and live animalsAndorraAll countries of the worldMillion tonne-kilometre (TKM)Spain199915
AnnualAgricultural products and live animalsAndorraAll countries of the worldThousand tonnesSpain19996
AnnualAgricultural products and live animalsAlbaniaGermanyMillion tonne-kilometre (TKM)Netherlands1999
AnnualAgricultural products and live animalsAlbaniaGermanyThousand tonnesNetherlands1999
AnnualAgricultural products and live animalsAlbaniaEuropean Union - 15 countries (1995-2004)Million tonne-kilometre (TKM)Netherlands1999
AnnualAgricultural products and live animalsAlbaniaEuropean Union - 15 countries (1995-2004)Thousand tonnesNetherlands1999
AnnualAgricultural products and live animalsAlbaniaEuropean Union - 25 countries (2004-2006)Million tonne-kilometre (TKM)Netherlands1999
AnnualAgricultural products and live animalsAlbaniaEuropean Union - 25 countries (2004-2006)Thousand tonnesNetherlands1999
AnnualAgricultural products and live animalsAlbaniaEuropean Union - 27 countries (2007-2013)Million tonne-kilometre (TKM)Netherlands1999
AnnualAgricultural products and live animalsAlbaniaEuropean Union - 27 countries (2007-2013)Thousand tonnesNetherlands1999

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