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

Eurostat code: mar_pa_qm_ee · (2002-Q1 - 2024-Q3)

@eurostat.mar_pa_qm_ee

Table List

2 tables(200.8 KB)

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

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

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

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

68.35 KB
41097 rows
8 columns

freq Freq	natvessr Natvessr	direct Direct	unit Unit	par_mar Par Mar	rep_mar Rep Mar	time_period Time Period
Quarterly	Antigua and Barbuda	Inwards	Thousand	Belgium	Estonia	2002-Q1
Quarterly	Antigua and Barbuda	Inwards	Thousand	Belgium	Tallinn	2002-Q1
Quarterly	Antigua and Barbuda	Inwards	Thousand	Finland	Estonia	2002-Q1
Quarterly	Antigua and Barbuda	Inwards	Thousand	Finland	Tallinn	2002-Q1
Quarterly	Antigua and Barbuda	Inwards	Thousand	Russia	Estonia	2002-Q1
Quarterly	Antigua and Barbuda	Inwards	Thousand	Russia	Tallinn	2002-Q1
Quarterly	Antigua and Barbuda	Inwards	Thousand	Russia: Baltic Sea (unspecified)	Estonia	2002-Q1
Quarterly	Antigua and Barbuda	Inwards	Thousand	Russia: Baltic Sea (unspecified)	Tallinn	2002-Q1
Quarterly	Antigua and Barbuda	Inwards	Thousand	Total	Estonia	2002-Q1
Quarterly	Antigua and Barbuda	Inwards	Thousand	Total	Tallinn	2002-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.