Baselight

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

Eurostat code: mar_sg_am_pwb ยท (2005 - 2023)

@eurostat.mar_sg_am_pwb

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

  • 12.54 KB
  • 1371 rows
  • 6 columns
freq

Freq

unit

Unit

rep_mar

Rep Mar

par_mar

Par Mar

time_period

Time Period

value

Value

AnnualThousand tonnesAntwerpenDeep Sea Shipping200516021
AnnualThousand tonnesAntwerpenShort Sea Shipping200510663
AnnualThousand tonnesAntwerpenTotal200526685
AnnualThousand tonnesGent (Ghent)Deep Sea Shipping20058717
AnnualThousand tonnesGent (Ghent)Short Sea Shipping20054338
AnnualThousand tonnesGent (Ghent)Total200513055
AnnualThousand tonnesHamburgDeep Sea Shipping200515763
AnnualThousand tonnesHamburgShort Sea Shipping200511249
AnnualThousand tonnesHamburgTotal200527012
AnnualThousand tonnesRavennaDeep Sea Shipping20052531

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.