Baselight
Sign In

Passengers (excluding Cruise Passengers) Transported From/to The Main Ports By Transport Coverage

Eurostat code: mar_mp_am_cftt ยท (2004 - 2023)

@eurostat.mar_mp_am_cftt

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

  • 30.39 KB
  • 9786 rows
  • 6 columns
freq

Freq

unit

Unit

tra_cov

Tra Cov

rep_mar

Rep Mar

time_period

Time Period

value

Value

AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Belgium2004100
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Germany200453.2
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Denmark200464.3
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Estonia200499.4
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Greece20044.7
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Spain20049.2
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)European Union - 15 countries (1995-2004)200433.9
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Finland200458.4
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)France200474.9
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Ireland2004100

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

Share link

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