Maritime Transport Infrastructure: Ports

Eurostat code: med_ma1 · (2005 - 2019)

@eurostat.med_ma1

Table List

2 tables(17.98 KB)

Maritime Transport Infrastructure: Ports - Raw

Maritime Transport Infrastructure: Ports - Unpivoted

Maritime Transport Infrastructure: Ports - Unpivoted

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

4.87 KB
89 rows
6 columns

freq Freq	unit Unit	port_infr Port Infr	geo Geo	time_period Time Period	value Value
Annual	Number	Number of principal ports	Algeria	2005	10
Annual	Number	Number of principal ports	Egypt	2005	12
Annual	Number	Number of principal ports	Israel	2005	3
Annual	Number	Number of principal ports	Jordan	2005	1
Annual	Number	Number of principal ports	Lebanon	2005	1
Annual	Number	Number of principal ports	Tunisia	2005	7
Annual	Number	Number of principal ports	Algeria	2006	10
Annual	Number	Number of principal ports	Egypt	2006	12
Annual	Number	Number of principal ports	Israel	2006	3
Annual	Number	Number of principal ports	Jordan	2006	1


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

Share link

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