Country Level - Passengers Embarked And Disembarked In All Ports

Eurostat code: mar_mp_aa_cph · (1997 - 2023)

@eurostat.mar_mp_aa_cph

Table List

2 tables(40.74 KB)

Country Level - Passengers Embarked And Disembarked In All Ports - Raw

Country Level - Passengers Embarked And Disembarked In All Ports - Unpivoted

Country Level - Passengers Embarked And Disembarked In All Ports - Unpivoted

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

11.96 KB
1466 rows
5 columns

freq Freq	unit Unit	rep_mar Rep Mar	time_period Time Period	value Value
Annual	Thousand passengers	Belgium	1997	1946
Annual	Thousand passengers	Denmark	1997	75928
Annual	Thousand passengers	Greece	1997	32259
Annual	Thousand passengers	Spain	1997	13939
Annual	Thousand passengers	Finland	1997	15191
Annual	Thousand passengers	France	1997	33124
Annual	Thousand passengers	Ireland	1997	4380
Annual	Thousand passengers	Italy	1997	80181
Annual	Thousand passengers	Netherlands	1997	1964
Annual	Thousand passengers	Portugal	1997	34


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.