Baselight
Sign In

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

Eurostat code: mar_sg_am_pw ยท (2005 - 2023)

@eurostat.mar_sg_am_pw

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

  • 30.29 KB
  • 5089 rows
  • 6 columns
freq

Freq

unit

Unit

rep_mar

Rep Mar

par_mar

Par Mar

time_period

Time Period

value

Value

AnnualThousand tonnesAntwerpenDeep Sea Shipping200579259
AnnualThousand tonnesAntwerpenShort Sea Shipping200566463
AnnualThousand tonnesAntwerpenTotal2005145817
AnnualThousand tonnesAntwerpenUnknown200594
AnnualThousand tonnesGent (Ghent)Deep Sea Shipping200510639
AnnualThousand tonnesGent (Ghent)Short Sea Shipping200511489
AnnualThousand tonnesGent (Ghent)Total200522127
AnnualThousand tonnesZeebruggeDeep Sea Shipping20055210
AnnualThousand tonnesZeebruggeShort Sea Shipping200523232
AnnualThousand tonnesZeebruggeTotal200528442

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.