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

Eurostat code: mar_go_am_mt · (2003 - 2023)

@eurostat.mar_go_am_mt

Table List

2 tables(727.58 KB)

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

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

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

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

367.46 KB
321251 rows
9 columns

freq Freq	direct Direct	cargo Cargo	natvessr Natvessr	unit Unit	par_mar Par Mar	rep_mar Rep Mar	time_period Time Period	value Value
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Spain	Malta	2003	8
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Spain	Valletta	2003	8
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Spain: Mediterranean and South Atlantic	Malta	2003	8
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Spain: Mediterranean and South Atlantic	Valletta	2003	8
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Italy	Malta	2003	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Italy	Valletta	2003	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Tunisia	Malta	2003
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Tunisia	Valletta	2003
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Total	Malta	2003	10
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Total	Valletta	2003	10


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