Passengers (excluding Cruise Passengers) Transported From/to The Main Ports

Eurostat code: mar_mp_am_cft · (2004 - 2023)

@eurostat.mar_mp_am_cft

Table List

2 tables(30.83 KB)

Passengers (excluding Cruise Passengers) Transported From/to The Main Ports - Raw

Passengers (excluding Cruise Passengers) Transported From/to The Main Ports - Unpivoted

Passengers (excluding Cruise Passengers) Transported From/to The Main Ports - Unpivoted

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

9.46 KB
1049 rows
5 columns

freq Freq	unit Unit	rep_mar Rep Mar	time_period Time Period	value Value
Annual	Thousand	Belgium	2004	742
Annual	Thousand	Bulgaria	2004
Annual	Thousand	Cyprus	2004
Annual	Thousand	Germany	2004	20744
Annual	Thousand	Denmark	2004	36559
Annual	Thousand	Estonia	2004	6452
Annual	Thousand	Greece	2004	47747
Annual	Thousand	Spain	2004	14201
Annual	Thousand	European Union - 15 countries (1995-2004)	2004	216535
Annual	Thousand	European Union - 25 countries (2004-2006)	2004	220945


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

Share link

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