Vessels Arriving In The Main Ports By Type And Size Of Vessels - Quarterly Data

Eurostat code: mar_tf_qm · (1997-Q1 - 2024-Q4)

@eurostat.mar_tf_qm

Table List

2 tables(23.68 MB)

Vessels Arriving In The Main Ports By Type And Size Of Vessels - Quarterly Data - Raw

Vessels Arriving In The Main Ports By Type And Size Of Vessels - Quarterly Data - Unpivoted

Vessels Arriving In The Main Ports By Type And Size Of Vessels - Quarterly Data - Unpivoted

@eurostat.mar_tf_qm.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.89 MB
4653155 rows
7 columns

freq Freq	tonnage Tonnage	vessel Vessel	unit Unit	rep_mar Rep Mar	time_period Time Period	value Value
Quarterly	From 100 to 499 gross tonnage	Dry bulk carrier	Number	Denmark	1997-Q1	50
Quarterly	From 100 to 499 gross tonnage	Dry bulk carrier	Number	Aabenraa	1997-Q1	13
Quarterly	From 100 to 499 gross tonnage	Dry bulk carrier	Number	Aalborg	1997-Q1	10
Quarterly	From 100 to 499 gross tonnage	Dry bulk carrier	Number	Århus	1997-Q1	8
Quarterly	From 100 to 499 gross tonnage	Dry bulk carrier	Number	Fredericia (Og Shell-Havnen)	1997-Q1	5
Quarterly	From 100 to 499 gross tonnage	Dry bulk carrier	Number	Rønne	1997-Q1	14
Quarterly	From 100 to 499 gross tonnage	Dry bulk carrier	Number	Sweden	1997-Q1	15
Quarterly	From 100 to 499 gross tonnage	Dry bulk carrier	Number	Sweden: Baltic Sea	1997-Q1	7
Quarterly	From 100 to 499 gross tonnage	Dry bulk carrier	Number	Karlshamn	1997-Q1	3
Quarterly	From 100 to 499 gross tonnage	Dry bulk carrier	Number	Malmö	1997-Q1	2


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

Share link

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