Passengers (excluding Cruise Passengers) Transported From/to The Main Ports - Malta - Quarterly Data

Eurostat code: mar_pa_qm_mt · (2003-Q1 - 2024-Q3)

@eurostat.mar_pa_qm_mt

Table List

2 tables(76.09 KB)

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

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

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

@eurostat.mar_pa_qm_mt.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.06 KB
3808 rows
8 columns

freq Freq	natvessr Natvessr	direct Direct	unit Unit	par_mar Par Mar	rep_mar Rep Mar	time_period Time Period	value Value
Quarterly	Malta	Inwards	Thousand	Malta	Malta	2003-Q1	605
Quarterly	Malta	Inwards	Thousand	Malta	Cirkewwa	2003-Q1	303
Quarterly	Malta	Inwards	Thousand	Malta	Mgarr, Gozo	2003-Q1	303
Quarterly	Malta	Inwards	Thousand	Total	Malta	2003-Q1	605
Quarterly	Malta	Inwards	Thousand	Total	Cirkewwa	2003-Q1	303
Quarterly	Malta	Inwards	Thousand	Total	Mgarr, Gozo	2003-Q1	303
Quarterly	Malta	Outwards	Thousand	Malta	Malta	2003-Q1	605
Quarterly	Malta	Outwards	Thousand	Malta	Cirkewwa	2003-Q1	303
Quarterly	Malta	Outwards	Thousand	Malta	Mgarr, Gozo	2003-Q1	303
Quarterly	Malta	Outwards	Thousand	Total	Malta	2003-Q1	605


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

Share link

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