Baselight

Goods Transported In Intermodal Transport Units

Eurostat code: rail_go_contwgt ยท (2003 - 2024)

@eurostat.rail_go_contwgt

Goods Transported In Intermodal Transport Units - Unpivoted
@eurostat.rail_go_contwgt.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.

  • 47.52 KB
  • 25509 rows
  • 7 columns
freq

Freq

tra_cov

Tra Cov

cargo

Cargo

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualInternational transportContainers and swap bodiesMillion tonne-kilometre (TKM)Sweden2003251
AnnualInternational transportContainers and swap bodiesThousand tonnesSweden2003611
AnnualInternational transportRoad vehicles (accompanied)Million tonne-kilometre (TKM)Sweden2003
AnnualInternational transportRoad vehicles (accompanied)Thousand tonnesSweden2003
AnnualInternational transportSemi-trailers (unaccompanied)Million tonne-kilometre (TKM)Sweden2003103
AnnualInternational transportSemi-trailers (unaccompanied)Thousand tonnesSweden2003326
AnnualInternational transportUnknownMillion tonne-kilometre (TKM)Sweden2003
AnnualInternational transportUnknownThousand tonnesSweden2003
AnnualInternational transport - incomingContainers and swap bodiesMillion tonne-kilometre (TKM)Sweden2003153
AnnualInternational transport - incomingContainers and swap bodiesThousand tonnesSweden2003343

CREATE TABLE tidy (
  "freq" VARCHAR,
  "tra_cov" VARCHAR,
  "cargo" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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