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

Eurostat code: mar_pa_qm_lv · (2001-Q1 - 2024-Q4)

@eurostat.mar_pa_qm_lv

Table List

2 tables(80.56 KB)

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

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

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

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

9.96 KB
3972 rows
8 columns

freq Freq	natvessr Natvessr	direct Direct	unit Unit	par_mar Par Mar	rep_mar Rep Mar	time_period Time Period
Quarterly	Total	Inwards	Thousand	Total	Latvia - other ports	2001-Q1
Quarterly	Total	Inwards	Thousand	Unknown	Latvia - other ports	2001-Q1
Quarterly	Total	Inwards	Thousand	Total unspecified and unknown locations	Latvia - other ports	2001-Q1
Quarterly	Total	Outwards	Thousand	Total	Latvia - other ports	2001-Q1
Quarterly	Total	Outwards	Thousand	Unknown	Latvia - other ports	2001-Q1
Quarterly	Total	Outwards	Thousand	Total unspecified and unknown locations	Latvia - other ports	2001-Q1
Quarterly	Total	Total	Thousand	Total	Latvia - other ports	2001-Q1
Quarterly	Total	Total	Thousand	Unknown	Latvia - other ports	2001-Q1
Quarterly	Total	Total	Thousand	Total unspecified and unknown locations	Latvia - other ports	2001-Q1
Quarterly	Unknown	Inwards	Thousand	Total	Latvia - other ports	2001-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.