Passengers Embarked And Disembarked In All Ports By Direction - Annual Data

Eurostat code: mar_pa_aa · (1997 - 2024)

@eurostat.mar_pa_aa

Table List

2 tables(906.65 KB)

Passengers Embarked And Disembarked In All Ports By Direction - Annual Data - Raw

Passengers Embarked And Disembarked In All Ports By Direction - Annual Data - Unpivoted

Passengers Embarked And Disembarked In All Ports By Direction - Annual Data - Unpivoted

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

515.75 KB
227509 rows
6 columns

freq Freq	direct Direct	unit Unit	rep_mar Rep Mar	time_period Time Period	value Value
Annual	Inwards	Thousand passengers	Belgium	1997	925
Annual	Inwards	Thousand passengers	Belgium - other ports	1997
Annual	Inwards	Thousand passengers	Antwerpen	1997	1
Annual	Inwards	Thousand passengers	Bruxelles (Brussel)	1997
Annual	Inwards	Thousand passengers	Gent (Ghent)	1997
Annual	Inwards	Thousand passengers	Liège	1997
Annual	Inwards	Thousand passengers	Nieuwpoort	1997
Annual	Inwards	Thousand passengers	Oostende (Ostend)	1997	593
Annual	Inwards	Thousand passengers	Zeebrugge	1997	331
Annual	Inwards	Thousand passengers	Denmark	1997	37899


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

Share link

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