Number Of Principal Ports

Eurostat code: enps_mar_por · (2005 - 2022)

@eurostat.enps_mar_por

Table List

2 tables(18.62 KB)

Number Of Principal Ports - Raw

Number Of Principal Ports - Unpivoted

Number Of Principal Ports - Raw

@eurostat.enps_mar_por.raw

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

14.4 KB
8 rows
21 columns

freq Freq	unit Unit	geo Geo	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	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022
Annual	Number	Algeria	10	10	10	10	10	9	9	10	10	10	10	10	10	10	10	10	10	10
Annual	Number	Egypt	12	12	12	12	15	15	15	11	15	15	15	15		15	13	13
Annual	Number	Israel	3	3	3	3	3	3	4	4	4	4	4	4	4	4	4	4	6	6
Annual	Number	Jordan	1	1	1	1	1	1	1	1	1	1	1	1	1	1
Annual	Number	Lebanon	1	1	1	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2
Annual	Number	Libya	9		9	9	9	9	9	9	9	9	9	9	9	9	9	9	9	9
Annual	Number	Morocco									8	8	8	8
Annual	Number	Tunisia	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "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,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE
);

Share link

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