Baselight

Empty And Loaded Intermodal Transport Units

Eurostat code: rail_go_itu ยท (2003 - 2024)

@eurostat.rail_go_itu

Empty And Loaded Intermodal Transport Units - Unpivoted
@eurostat.rail_go_itu.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.

  • 49.93 KB
  • 27539 rows
  • 8 columns
freq

Freq

loadstat

Loadstat

tra_cov

Tra Cov

cargo

Cargo

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEmptyInternational transportRoad vehicles (accompanied)NumberSweden2003
AnnualEmptyInternational transportSemi-trailers (unaccompanied)NumberSweden2003498
AnnualEmptyInternational transportUnknownNumberSweden2003
AnnualEmptyInternational transport - incomingRoad vehicles (accompanied)NumberSweden2003
AnnualEmptyInternational transport - incomingSemi-trailers (unaccompanied)NumberSweden2003495
AnnualEmptyInternational transport - incomingUnknownNumberSweden2003
AnnualEmptyInternational transport - outgoingRoad vehicles (accompanied)NumberSweden2003
AnnualEmptyInternational transport - outgoingSemi-trailers (unaccompanied)NumberSweden20033
AnnualEmptyInternational transport - outgoingUnknownNumberSweden2003
AnnualEmptyNational transportRoad vehicles (accompanied)NumberSweden2003

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