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

Eurostat code: mar_sg_am_cwk · (2005 - 2023)

@eurostat.mar_sg_am_cwk

Table List

2 tables(69.43 KB)

Short Sea Shipping - Country Level - Gross Weight Of Goods Transported To/from Main Ports, By Type Of Cargo - Raw

Short Sea Shipping - Country Level - Gross Weight Of Goods Transported To/from Main Ports, By Type Of Cargo - Unpivoted

Short Sea Shipping - Country Level - Gross Weight Of Goods Transported To/from Main Ports, By Type Of Cargo - Unpivoted

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

29.42 KB
3861 rows
6 columns

freq Freq	rep_mar Rep Mar	cargo Cargo	unit Unit	time_period Time Period	value Value
Annual	Belgium	Dry bulk goods	Thousand tonnes	2005	17705
Annual	Belgium	Liquid bulk goods	Thousand tonnes	2005	33592
Annual	Belgium	Large containers	Thousand tonnes	2005	22272
Annual	Belgium	Other cargo not elsewhere specified	Thousand tonnes	2005	9785
Annual	Belgium	Ro-Ro - mobile non-self-propelled units	Thousand tonnes	2005	18692
Annual	Belgium	Ro-Ro - mobile self-propelled units	Thousand tonnes	2005	6606
Annual	Belgium	Total	Thousand tonnes	2005	108653
Annual	Bulgaria	Dry bulk goods	Thousand tonnes	2005	5494
Annual	Bulgaria	Liquid bulk goods	Thousand tonnes	2005	8248
Annual	Bulgaria	Large containers	Thousand tonnes	2005	1270


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

Share link

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