Gross Weight Of Goods Transported To/from Main Ports - Malta - Quarterly Data

Eurostat code: mar_go_qm_mt · (2003-Q1 - 2024-Q3)

@eurostat.mar_go_qm_mt

Table List

2 tables(697.04 KB)

Gross Weight Of Goods Transported To/from Main Ports - Malta - Quarterly Data - Raw

Gross Weight Of Goods Transported To/from Main Ports - Malta - Quarterly Data - Unpivoted

Gross Weight Of Goods Transported To/from Main Ports - Malta - Quarterly Data - Unpivoted

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

309.73 KB
289866 rows
8 columns

freq Freq	direct Direct	cargo Cargo	unit Unit	par_mar Par Mar	rep_mar Rep Mar	time_period Time Period	value Value
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Australia	Malta	2003-Q1	4
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Australia	Valletta	2003-Q1	4
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Belgium	Malta	2003-Q1
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Belgium	Valletta	2003-Q1
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Algeria	Malta	2003-Q1	8
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Algeria	Valletta	2003-Q1	8
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Greece	Malta	2003-Q1	2
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Greece	Valletta	2003-Q1	2
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Spain	Malta	2003-Q1	3
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Spain	Valletta	2003-Q1	3


CREATE TABLE tidy (
  "freq" VARCHAR,
  "direct" VARCHAR,
  "cargo" 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.