Maritime Equipment - Number Of Ships Of 300 Grt And Over

Eurostat code: med_ma3 · (2005 - 2018)

@eurostat.med_ma3

Table List

2 tables(16.53 KB)

Maritime Equipment - Number Of Ships Of 300 Grt And Over - Raw

Maritime Equipment - Number Of Ships Of 300 Grt And Over - Unpivoted

Maritime Equipment - Number Of Ships Of 300 Grt And Over - Unpivoted

@eurostat.med_ma3.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.55 KB
18 rows
6 columns

freq Freq	unit Unit	vessel Vessel	geo Geo	time_period Time Period	value Value
Annual	Number	Merchant ship	Algeria	2005	47
Annual	Number	Merchant ship	Algeria	2006	35
Annual	Number	Merchant ship	Algeria	2007	32
Annual	Number	Merchant ship	Algeria	2008	34
Annual	Number	Merchant ship	Algeria	2009	35
Annual	Number	Merchant ship	Algeria	2010	37
Annual	Number	Merchant ship	Algeria	2011	36
Annual	Number	Merchant ship	Algeria	2012	34
Annual	Number	Merchant ship	Algeria	2013	34
Annual	Number	Merchant ship	Algeria	2014	26


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

Share link

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