Maritime Traffic: Ship Movements

Eurostat code: med_ma6 · (2000 - 2015)

@eurostat.med_ma6

Table List

2 tables(19.94 KB)

Maritime Traffic: Ship Movements - Raw

Maritime Traffic: Ship Movements - Unpivoted

Maritime Traffic: Ship Movements - Raw

@eurostat.med_ma6.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

14.24 KB
16 rows
20 columns

freq Freq	unit Unit	direct Direct	geo Geo	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015
Annual	Number	Inwards	Algeria	8763	8976	10220	10190	10154	10201	10114	9973	10407	10647	10390	10040	10486	10696	10793	11224
Annual	Number	Inwards	Egypt	10908	11074	11104	12492	13580	16341	18389	19665	20301	20278	20343	18159	17795	17513	16332
Annual	Number	Inwards	Israel						6229	5571	5324	5310	5884	6197	6421	6827	6316	5703	5893
Annual	Number	Inwards	Jordan	1253	1337	1395	1347	1444	1467	1442	1471	1512	1450	1451	1446	1544	1442	1347	1338
Annual	Number	Inwards	Lebanon	3073	3200	3037	2886	2989	2720	2186	2665	2859	3234	2285	2167	2125	2114	1962	1807
Annual	Number	Inwards	Morocco	15078	15375	16181	18105	19388	20194	19076	19799	19035	18051	16158	12605
Annual	Number	Inwards	Syria	2798	2827	2979	3012	3711	4397	4496	4225
Annual	Number	Inwards	Tunisia	6184	6756	6950	6643	6528	6690	7253	7898	7871	7832	7405	5955	5903	5971	5580	5101
Annual	Number	Outwards	Algeria	9744	8995	10167	10109	10134	10187	10117	9961	10349	10680	10384	10048	10458	10706	10801	11185
Annual	Number	Outwards	Egypt	10863	11081	11101	12487	13444	16298	18349	19640	20231	20278	20343	18159	17795	17513	16332


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "direct" VARCHAR,
  "geo" VARCHAR,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE
);

Share link

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