Maritime Traffic: Ship Movements

Eurostat code: med_ma6 · (2000 - 2015)

@eurostat.med_ma6

Table List

2 tables(19.94 KB)

Maritime Traffic: Ship Movements - Unpivoted

Maritime Traffic: Ship Movements - Unpivoted

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

5.7 KB
214 rows
6 columns

freq Freq	unit Unit	direct Direct	geo Geo	time_period Time Period	value Value
Annual	Number	Inwards	Algeria	2000	8763
Annual	Number	Inwards	Egypt	2000	10908
Annual	Number	Inwards	Jordan	2000	1253
Annual	Number	Inwards	Lebanon	2000	3073
Annual	Number	Inwards	Morocco	2000	15078
Annual	Number	Inwards	Syria	2000	2798
Annual	Number	Inwards	Tunisia	2000	6184
Annual	Number	Outwards	Algeria	2000	9744
Annual	Number	Outwards	Egypt	2000	10863
Annual	Number	Outwards	Israel	2000	6041


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "direct" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.