Baselight

Gross Weight Of Goods In Containers Transported In Short Sea Shipping From/to The Top 5 EU Ports For Goods In Containers

Eurostat code: mar_sg_am_pwc ยท (2005 - 2023)

@eurostat.mar_sg_am_pwc

Gross Weight Of Goods In Containers Transported In Short Sea Shipping From/to The Top 5 EU Ports For Goods In Containers - Unpivoted
@eurostat.mar_sg_am_pwc.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.

  • 11.07 KB
  • 1151 rows
  • 6 columns
freq

Freq

unit

Unit

rep_mar

Rep Mar

par_mar

Par Mar

time_period

Time Period

value

Value

AnnualThousand tonnesAntwerpenDeep Sea Shipping200539216
AnnualThousand tonnesAntwerpenShort Sea Shipping200520313
AnnualThousand tonnesAntwerpenTotal200559529
AnnualThousand tonnesBremerhavenDeep Sea Shipping200516694
AnnualThousand tonnesBremerhavenShort Sea Shipping200512815
AnnualThousand tonnesBremerhavenTotal200529509
AnnualThousand tonnesHamburgDeep Sea Shipping200540540
AnnualThousand tonnesHamburgShort Sea Shipping200524897
AnnualThousand tonnesHamburgTotal200565438
AnnualThousand tonnesHamburgUnknown2005

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "rep_mar" VARCHAR,
  "par_mar" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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