Baselight
Sign In

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

Eurostat code: mar_pa_qm_it ยท (1997-Q1 - 2024-Q3)

@eurostat.mar_pa_qm_it

Passengers (excluding Cruise Passengers) Transported From/to The Main Ports - Italy - Quarterly Data - Unpivoted
@eurostat.mar_pa_qm_it.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.

  • 415.54 KB
  • 219193 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

QuarterlyArgentinaInwardsThousandAggregates extraction areas not elsewhere specified and other activities not elsewhere specifiedGenova1997-Q1
QuarterlyArgentinaInwardsThousandTotalGenova1997-Q1
QuarterlyArgentinaInwardsThousandTotal unspecified and unknown locationsGenova1997-Q1
QuarterlyArgentinaOutwardsThousandAggregates extraction areas not elsewhere specified and other activities not elsewhere specifiedGenova1997-Q1
QuarterlyArgentinaOutwardsThousandTotalGenova1997-Q1
QuarterlyArgentinaOutwardsThousandTotal unspecified and unknown locationsGenova1997-Q1
QuarterlyArgentinaTotalThousandAggregates extraction areas not elsewhere specified and other activities not elsewhere specifiedGenova1997-Q1
QuarterlyArgentinaTotalThousandTotalGenova1997-Q1
QuarterlyArgentinaTotalThousandTotal unspecified and unknown locationsGenova1997-Q1
QuarterlyBelgiumInwardsThousandAggregates extraction areas not elsewhere specified and other activities not elsewhere specifiedPorto Foxi1997-Q1

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.