Country Level - Passengers Embarked And Disembarked In All Ports, By Direction

Eurostat code: mar_mp_aa_cphd · (1997 - 2023)

@eurostat.mar_mp_aa_cphd

Table List

2 tables(76.36 KB)

Country Level - Passengers Embarked And Disembarked In All Ports, By Direction - Raw

Country Level - Passengers Embarked And Disembarked In All Ports, By Direction - Unpivoted

Country Level - Passengers Embarked And Disembarked In All Ports, By Direction - Unpivoted

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

27.41 KB
6606 rows
6 columns

freq Freq	unit Unit	direct Direct	rep_mar Rep Mar	time_period Time Period	value Value
Annual	Percentage of total	Inwards	Belgium	1997	47.5
Annual	Percentage of total	Inwards	Denmark	1997	49.9
Annual	Percentage of total	Inwards	Greece	1997	50.1
Annual	Percentage of total	Inwards	Spain	1997	49.9
Annual	Percentage of total	Inwards	Finland	1997	50.1
Annual	Percentage of total	Inwards	France	1997	50
Annual	Percentage of total	Inwards	Ireland	1997	50.4
Annual	Percentage of total	Inwards	Italy	1997	50
Annual	Percentage of total	Inwards	Netherlands	1997	49.6
Annual	Percentage of total	Inwards	Portugal	1997	54.7


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.