Vessels Arriving In The Main Ports By Type Of Vessels - Annual Data

Eurostat code: mar_mt_am_csvi · (1997 - 2023)

@eurostat.mar_mt_am_csvi

Table List

2 tables(278.62 KB)

Vessels Arriving In The Main Ports By Type Of Vessels - Annual Data - Raw

Vessels Arriving In The Main Ports By Type Of Vessels - Annual Data - Unpivoted

Vessels Arriving In The Main Ports By Type Of Vessels - Annual Data - Unpivoted

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

117.04 KB
27233 rows
6 columns

freq Freq	unit Unit	vessel Vessel	rep_mar Rep Mar	time_period Time Period	value Value
Annual	Number	Dry bulk carrier	Belgium	1997	196
Annual	Number	Dry bulk carrier	Denmark	1997	1469
Annual	Number	Dry bulk carrier	Finland	1997	764
Annual	Number	Dry bulk carrier	Ireland	1997	669
Annual	Number	Dry bulk carrier	Netherlands	1997	2935
Annual	Number	Dry bulk carrier	Sweden	1997	1503
Annual	Number	Liquid bulk tanker	Belgium	1997	4371
Annual	Number	Liquid bulk tanker	Denmark	1997	2370
Annual	Number	Liquid bulk tanker	Finland	1997	1904
Annual	Number	Liquid bulk tanker	Ireland	1997	1428


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

Share link

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