Baselight

Short Sea Shipping - Country Level - Gross Weight Of Goods Transported To/from Main Ports, By Sea Region Of Partner Ports

Eurostat code: mar_sg_am_cws ยท (2005 - 2023)

@eurostat.mar_sg_am_cws

Short Sea Shipping - Country Level - Gross Weight Of Goods Transported To/from Main Ports, By Sea Region Of Partner Ports - Unpivoted
@eurostat.mar_sg_am_cws.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.

  • 28.57 KB
  • 3843 rows
  • 6 columns
freq

Freq

unit

Unit

rep_mar

Rep Mar

seabasin

Seabasin

time_period

Time Period

value

Value

AnnualThousand tonnesBelgiumNorth East Atlantic Ocean200515015
AnnualThousand tonnesBelgiumBaltic Sea200521666
AnnualThousand tonnesBelgiumBlack Sea20051092
AnnualThousand tonnesBelgiumMediterranean Sea200523916
AnnualThousand tonnesBelgiumNorth Sea200546816
AnnualThousand tonnesBelgiumOther sea basins2005149
AnnualThousand tonnesBelgiumTotal2005108653
AnnualThousand tonnesBulgariaNorth East Atlantic Ocean2005731
AnnualThousand tonnesBulgariaBlack Sea200510808
AnnualThousand tonnesBulgariaMediterranean Sea20056152

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

Share link

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