Passengers Embarked And Disembarked In The Top 20 EU Ports

Eurostat code: mar_mp_aa_pphd · (2005 - 2023)

@eurostat.mar_mp_aa_pphd

Table List

2 tables(49.3 KB)

Passengers Embarked And Disembarked In The Top 20 EU Ports - Raw

Passengers Embarked And Disembarked In The Top 20 EU Ports - Unpivoted

Passengers Embarked And Disembarked In The Top 20 EU Ports - Unpivoted

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

17.97 KB
3189 rows
6 columns

freq Freq	unit Unit	direct Direct	rep_mar Rep Mar	time_period Time Period	value Value
Annual	Thousand	Inwards	Burgstaaken/Fehmarn	2005
Annual	Thousand	Inwards	Puttgarden	2005	3316
Annual	Thousand	Inwards	Århus	2005	822
Annual	Thousand	Inwards	Helsingør (Elsinore)	2005	5501
Annual	Thousand	Inwards	Rødby (Færgehavn)	2005	3380
Annual	Thousand	Inwards	Sjællands Odde	2005	1174
Annual	Thousand	Inwards	Tallinn	2005	3358
Annual	Thousand	Inwards	Paloukia Salaminas	2005	5879
Annual	Thousand	Inwards	Perama	2005	5784
Annual	Thousand	Inwards	Peiraias	2005	5240


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

Share link

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