Baselight

Cross-trade Road Freight Transport Of Reporting Country By Country Of Loading And Unloading And Type Of Transport (t, Tkm) - Quarterly Data

Eurostat code: road_go_ctq_tt ยท (1990-Q1 - 2024-Q2)

@eurostat.road_go_ctq_tt

Cross-trade Road Freight Transport Of Reporting Country By Country Of Loading And Unloading And Type Of Transport (t, Tkm) - Quarterly Data - Unpivoted
@eurostat.road_go_ctq_tt.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.

  • 4.44 MB
  • 2516180 rows
  • 8 columns
freq

Freq

unit

Unit

tra_type

Tra Type

c_load

C Load

c_unload

C Unload

geo

Geo

time_period

Time Period

value

Value

QuarterlyMillion tonne-kilometre (TKM)Hire or rewardAustriaEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)Belgium1990-Q19
QuarterlyMillion tonne-kilometre (TKM)Hire or rewardAustriaEuropean Economic Area except LiechtensteinBelgium1990-Q19
QuarterlyMillion tonne-kilometre (TKM)Hire or rewardAustriaEuropean Union - 15 countries (1995-2004)Belgium1990-Q19
QuarterlyMillion tonne-kilometre (TKM)Hire or rewardAustriaFranceBelgium1990-Q16
QuarterlyMillion tonne-kilometre (TKM)Hire or rewardAustriaNetherlandsBelgium1990-Q13
QuarterlyMillion tonne-kilometre (TKM)Hire or rewardAustriaAll countries of the worldBelgium1990-Q19
QuarterlyMillion tonne-kilometre (TKM)Hire or rewardBelgiumSwitzerlandUnited Kingdom1990-Q1
QuarterlyMillion tonne-kilometre (TKM)Hire or rewardBelgiumGermanyGreece1990-Q1
QuarterlyMillion tonne-kilometre (TKM)Hire or rewardBelgiumGermanySpain1990-Q116
QuarterlyMillion tonne-kilometre (TKM)Hire or rewardBelgiumGermanyFrance1990-Q1

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