Short Sea Shipping - EU Level - Gross Weight Of Goods Transported To/from Main Ports, By Type Of Cargo For Each Sea Region Of Partner Ports

Eurostat code: mar_sg_am_ewx · (2005 - 2023)

@eurostat.mar_sg_am_ewx

Table List

2 tables(40.36 KB)

Short Sea Shipping - EU Level - Gross Weight Of Goods Transported To/from Main Ports, By Type Of Cargo For Each Sea Region Of Partner Ports - Raw

Short Sea Shipping - EU Level - Gross Weight Of Goods Transported To/from Main Ports, By Type Of Cargo For Each Sea Region Of Partner Ports - Unpivoted

Short Sea Shipping - EU Level - Gross Weight Of Goods Transported To/from Main Ports, By Type Of Cargo For Each Sea Region Of Partner Ports - Unpivoted

@eurostat.mar_sg_am_ewx.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.

13.97 KB
1888 rows
6 columns

freq Freq	unit Unit	cargo Cargo	seabasin Seabasin	time_period Time Period	value Value
Annual	Percentage of total	Dry bulk goods	North East Atlantic Ocean	2005	24
Annual	Percentage of total	Dry bulk goods	Baltic Sea	2005	21.8
Annual	Percentage of total	Dry bulk goods	Black Sea	2005	19.3
Annual	Percentage of total	Dry bulk goods	Mediterranean Sea	2005	16.4
Annual	Percentage of total	Dry bulk goods	North Sea	2005	19.4
Annual	Percentage of total	Dry bulk goods	Other sea basins	2005	18.9
Annual	Percentage of total	Dry bulk goods	Total	2005	19.3
Annual	Percentage of total	Liquid bulk goods	North East Atlantic Ocean	2005	35.6
Annual	Percentage of total	Liquid bulk goods	Baltic Sea	2005	41.7
Annual	Percentage of total	Liquid bulk goods	Black Sea	2005	70


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

Share link

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