Baselight
Sign In

Passengers (excluding Cruise Passengers) Transported From/to The Main Ports By Direction And Transport Coverage - Quarterly Data

Eurostat code: mar_pa_qm · (1997-Q1 - 2024-Q4)

@eurostat.mar_pa_qm

Passengers (excluding Cruise Passengers) Transported From/to The Main Ports By Direction And Transport Coverage - Quarterly Data - Unpivoted
@eurostat.mar_pa_qm.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.

  • 936.34 KB
  • 525030 rows
  • 7 columns
freq

Freq

direct

Direct

tra_cov

Tra Cov

unit

Unit

rep_mar

Rep Mar

time_period

Time Period

value

Value

QuarterlyInwardsInternational transport Intra-EU15 (1995-2004)ThousandBelgium1997-Q1163
QuarterlyInwardsInternational transport Intra-EU15 (1995-2004)ThousandAntwerpen1997-Q1
QuarterlyInwardsInternational transport Intra-EU15 (1995-2004)ThousandGent (Ghent)1997-Q1
QuarterlyInwardsInternational transport Intra-EU15 (1995-2004)ThousandOostende (Ostend)1997-Q195
QuarterlyInwardsInternational transport Intra-EU15 (1995-2004)ThousandZeebrugge1997-Q168
QuarterlyInwardsInternational transport Intra-EU15 (1995-2004)ThousandDenmark1997-Q12714
QuarterlyInwardsInternational transport Intra-EU15 (1995-2004)ThousandBagenkop1997-Q123
QuarterlyInwardsInternational transport Intra-EU15 (1995-2004)ThousandKøbenhavns Havn1997-Q1228
QuarterlyInwardsInternational transport Intra-EU15 (1995-2004)ThousandDragør1997-Q1166
QuarterlyInwardsInternational transport Intra-EU15 (1995-2004)ThousandEsbjerg1997-Q118

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

Share link

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