Top 5 Ports - Gross Weight Of Goods Handled In Each Port

Eurostat code: mar_qg_qm_pwh · (2005-Q1 - 2024-Q3)

@eurostat.mar_qg_qm_pwh

Table List

2 tables(89.47 KB)

Top 5 Ports - Gross Weight Of Goods Handled In Each Port - Raw

Top 5 Ports - Gross Weight Of Goods Handled In Each Port - Unpivoted

Top 5 Ports - Gross Weight Of Goods Handled In Each Port - Raw

@eurostat.mar_qg_qm_pwh.raw

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

72.66 KB
50 rows
82 columns

freq Freq	unit Unit	rep_mar Rep Mar	n_2005_q2 2005-Q2	n_2005_q3 2005-Q3	n_2005_q4 2005-Q4	n_2006_q1 2006-Q1	n_2006_q2 2006-Q2	n_2006_q3 2006-Q3	n_2006_q4 2006-Q4	n_2007_q1 2007-Q1	n_2007_q2 2007-Q2	n_2007_q3 2007-Q3	n_2007_q4 2007-Q4	n_2008_q1 2008-Q1	n_2008_q2 2008-Q2	n_2008_q3 2008-Q3	n_2008_q4 2008-Q4	n_2009_q1 2009-Q1	n_2009_q2 2009-Q2	n_2009_q3 2009-Q3	n_2009_q4 2009-Q4	n_2010_q1 2010-Q1	n_2010_q2 2010-Q2	n_2010_q3 2010-Q3	n_2010_q4 2010-Q4	n_2011_q1 2011-Q1	n_2011_q2 2011-Q2	n_2011_q3 2011-Q3	n_2011_q4 2011-Q4	n_2012_q1 2012-Q1	n_2012_q2 2012-Q2	n_2012_q3 2012-Q3	n_2012_q4 2012-Q4	n_2013_q1 2013-Q1	n_2013_q2 2013-Q2	n_2013_q3 2013-Q3	n_2013_q4 2013-Q4	n_2014_q1 2014-Q1	n_2014_q2 2014-Q2	n_2014_q3 2014-Q3	n_2014_q4 2014-Q4	n_2015_q1 2015-Q1	n_2015_q2 2015-Q2	n_2015_q3 2015-Q3	n_2015_q4 2015-Q4	n_2016_q1 2016-Q1	n_2016_q2 2016-Q2	n_2016_q3 2016-Q3	n_2016_q4 2016-Q4	n_2017_q1 2017-Q1	n_2017_q2 2017-Q2	n_2017_q3 2017-Q3	n_2017_q4 2017-Q4	n_2018_q1 2018-Q1	n_2018_q2 2018-Q2	n_2018_q3 2018-Q3	n_2018_q4 2018-Q4	n_2019_q1 2019-Q1	n_2019_q2 2019-Q2	n_2019_q3 2019-Q3	n_2019_q4 2019-Q4	n_2020_q1 2020-Q1	n_2020_q2 2020-Q2	n_2020_q3 2020-Q3	n_2020_q4 2020-Q4	n_2021_q1 2021-Q1	n_2021_q2 2021-Q2	n_2021_q3 2021-Q3	n_2021_q4 2021-Q4	n_2022_q1 2022-Q1	n_2022_q2 2022-Q2	n_2022_q3 2022-Q3	n_2022_q4 2022-Q4	n_2023_q1 2023-Q1	n_2023_q2 2023-Q2	n_2023_q3 2023-Q3	n_2023_q4 2023-Q4	n_2024_q1 2024-Q1	n_2024_q2 2024-Q2	n_2024_q3 2024-Q3
Quarterly	Growth rate on previous period (t/t-1)	Antwerp-Bruges																																																																					4.2	-7.7	-0.9	0.7	1.3	-6.8	2.9	5.1	2.7	-10.3
Quarterly	Growth rate on previous period (t/t-1)	Antwerpen	2.6	1.8	-0.2	-3.6	10.6	-5	4.7	3	-0.5	3.2	5.1	-4	7.7	-3.6	-5.6	-18.4	6.8	1.2	2	2.1	6.4	2.2	1.5	3.4	1.4	-3.6	-4.3	4.1	-1.5	-1.1	0.3	3.3	4.9	-4.6	2.5	1.5	2.8	0.6	1	1.2	4.3	-3	2.8	1.2	5	-3.2	-1.8	0.8	4.1	-1.9	0.5	4.6	3.1	-4	0.2	-2.2	10.5	-6.4	0.3	-0.5	-6.9	3.4	4.7	-0.7	4.1	-2.9	1.7
Quarterly	Growth rate on previous period (t/t-1)	Hamburg	2.5	4.1	3.9	-1.2	1.9	1.6	0.3	-0.6	1.1	1.2	0.1	-1.5	3.9	0.8	-8.1	-18.7	1.2	6.4	-4.1	3.4	5.2	1.9	5.5	-2.6	4.3	6.5	-3.2	-2.9	2.6	-3.4	1.5	0.8	7	0.6	-0.6	0.5	5.1	-0.7	-4.1	0.5		-5.4	-1.1	4.2	2.7	-2	-5.3	6.8	-1	-2.7	-5.2	0.1	6.6	-1.8	2.8	-1.1	0.2	-0.7	-7.2		-8.4	8.5	5.6	-4.7	-1.9	4.1	0.6	-5.5	-2.1	-0.3	-7.6	1.9	6.1	-6.3	-0.4	-2.4	3.7	-1.6
Quarterly	Growth rate on previous period (t/t-1)	Algeciras	-4.3	6.3	-7.1	3.7	11.3	1.1	-1.4	-2.9	4	1.3	3.2	-2.8	4.5	-11.3	4.3	-13.5	-1	12.7	2.5	-5.6	-1.7	-2.2	22.9	-8.1	3.6	4.4	25.2	-13.4	0.2	3.7	-7.6	-6.1	16.9	1.5	-33.4	47.1	5.2	-8.1	0.5	2.9	4.1	3.6	-0.8	1.8	2.4	-1.8	0.8	-8.4	7.4	5.8	0.8	0.1	2.3	2.1	-7.1	3.7	7	-5.1	-2.9	2.8	-3	0.4	3.6	-11.4	6.5	-0.9	-2.6	-1.4	2.5	-1.9	-3.7	-0.7	3.2	-2.4	2.2	3.9	-2.5	0.2
Quarterly	Growth rate on previous period (t/t-1)	HAROPA (Le Havre and Rouen)																																																																					2.3	2.7	-7	-6.8	1.2	11.2	-1	2.5	-8.4	0.9
Quarterly	Growth rate on previous period (t/t-1)	Le Havre	-7.5	7.4	-1.3	-1.1	-4.6	0.2	11.1	-6.5	7.4	-2.2	4.7	-1.6	-7.7	9.1	5.8	-10.2	-1.1	-10.7	7.3	-2.7	2.6	-1.3	-11.4	-3.1	7.7	3.1	6.2	-17.1	5.7	1.4	-2.5	3.5	8.7	-4.4	2.6	-11.4	3.7	4.7	2.4	-5.5	8.4	-3.2	-4.7	-3.5	-0.2	3.9	1.4	6.1		2.5	-1.7	-6.2	-1.4	13.7	-3.4	-7.7	2.3	-2.9	-12.5	-8.2	-14	20.9	2.6	-0.9	9	1.9	5.2
Quarterly	Growth rate on previous period (t/t-1)	Marseille	3.7	0.4	0.4	2.2	-3.9	3.4	4.7	-17.3	21.8	-8.7	0.8	0.3	-3.6	7.8	-8	-9.8	-3	-0.1	5.8	0.5	5.7	-7	-5	8.8	3.4	-4.2	-0.2	0.7	-4.1	2.2	-1	-5.6	1.8	-2.1	-3.8	-2.9	2.8	5.4	-2.7	1.9	-0.1	0.6	3.1	-3.2	-7.6	13.4	-4.2	-4.3	3	-1.3	3.2	2.9	-8.1	1	2.1	0.8	-4.6	5.7	-8.1	-1.1	-1	4.5	4.2	-7.4	3.2	-3.8	0.5	4.2	-11.2	6.4	-8.3	-7	23.4	-4.9	2.4	-11.7	10	-7.3
Quarterly	Growth rate on previous period (t/t-1)	Amsterdam	4.1	-5.1	2.5	2.4	26.4	-13.7	-7	13.1	7.8	-9.7	8.9	13	9.6	-11.9	-3.5	-10.1	9.7	-6.1	1.8	3.5	-2.8	1.8	9	-15.8	14.5	-5.9	6.9	-4.4	4.9	-1.6	0.4	-1.7	6.8	-6.9	1.4	9.6	0.4	-13	10.1	8	1.2	-13.6	5.5	2.4	-1.2	-4.9	11.9	4.4	-3.8	-8.6	10.2	-1.5	-4.8	2.6	7.3	0.7	0.4	-5.8	-4.3	-1.7	-2.2	-15	9.2	-2.3	11.4	-13.4	5.7	2.7	16.5	-7.8	-7.1	-4.2	1.8	-18.3	8.7	-0.7	5.1	-6
Quarterly	Growth rate on previous period (t/t-1)	Rotterdam	3.8	-1.8	0.7	-2.4	5.6	-1.6	3.3	-3.4	4.2	6.4	-0.2	0.2	0.4	0.2	-7.3	-5.9	0.7	2.1	7.1	5.6	-1.4	1.4	-1	0.9	1	5.5	-6.8	4.7	0.4	-1.7	-1.1	0.9	2.5	0.3	-3.2	2.5	1.2	-0.2	0.4	1.3	5.2	-5.5	1.1	0.3	-6.2	7.1	0.5	1.2	-1.7	-3.2	0.4	4.9	-5.7	4.1	0.8	4.8	-5.6	-3	0.8	-1.1	-6.9	-2.7	9.5	2.9	-0.9	3.2	-0.2	-4.7	5.4	-0.8	-1.2	-4	-3.2		1	-0.4	0.5	-1.8
Quarterly	Growth rate on previous period (t/t-1)	Gdansk	-6.2	15.4	-16.6	15.9	-3.9	-8.3	-5.1	3.2	8.2	-12.4	-12.8	-11.7	24.4	5	-25.6	6.8	19.2	14.5	-10.1	20	20	0.9	-3.8	6.7	-16.5	-23.1	24.2	-18.9	1.3	56.2	4.4	-9.2	-17.6	29.5	-3.3	1.3	-11.1	7.9	15	-8	9.2	9	-15.4	0.2	5.3	5.9	-4.4	-7.6	7.9	1	33.6	5.8	-4.2	-10.8	10.3	1.4	20.2	-17.6	3	-11.2	3.4	5.8	-6.8	13.3	-10.1	4.7	21.7	0.6	9.5	15.6	17.5	5.7	-1.1	-1.6	-4.4	-7.2	0.5	1.7


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "rep_mar" VARCHAR,
  "n_2005_q1" DOUBLE,
  "n_2005_q2" DOUBLE,
  "n_2005_q3" DOUBLE,
  "n_2005_q4" DOUBLE,
  "n_2006_q1" DOUBLE,
  "n_2006_q2" DOUBLE,
  "n_2006_q3" DOUBLE,
  "n_2006_q4" DOUBLE,
  "n_2007_q1" DOUBLE,
  "n_2007_q2" DOUBLE,
  "n_2007_q3" DOUBLE,
  "n_2007_q4" DOUBLE,
  "n_2008_q1" DOUBLE,
  "n_2008_q2" DOUBLE,
  "n_2008_q3" DOUBLE,
  "n_2008_q4" DOUBLE,
  "n_2009_q1" DOUBLE,
  "n_2009_q2" DOUBLE,
  "n_2009_q3" DOUBLE,
  "n_2009_q4" DOUBLE,
  "n_2010_q1" DOUBLE,
  "n_2010_q2" DOUBLE,
  "n_2010_q3" DOUBLE,
  "n_2010_q4" DOUBLE,
  "n_2011_q1" DOUBLE,
  "n_2011_q2" DOUBLE,
  "n_2011_q3" DOUBLE,
  "n_2011_q4" DOUBLE,
  "n_2012_q1" DOUBLE,
  "n_2012_q2" DOUBLE,
  "n_2012_q3" DOUBLE,
  "n_2012_q4" DOUBLE,
  "n_2013_q1" DOUBLE,
  "n_2013_q2" DOUBLE,
  "n_2013_q3" DOUBLE,
  "n_2013_q4" DOUBLE,
  "n_2014_q1" DOUBLE,
  "n_2014_q2" DOUBLE,
  "n_2014_q3" DOUBLE,
  "n_2014_q4" DOUBLE,
  "n_2015_q1" DOUBLE,
  "n_2015_q2" DOUBLE,
  "n_2015_q3" DOUBLE,
  "n_2015_q4" DOUBLE,
  "n_2016_q1" DOUBLE,
  "n_2016_q2" DOUBLE,
  "n_2016_q3" DOUBLE,
  "n_2016_q4" DOUBLE,
  "n_2017_q1" DOUBLE,
  "n_2017_q2" DOUBLE,
  "n_2017_q3" DOUBLE,
  "n_2017_q4" DOUBLE,
  "n_2018_q1" DOUBLE,
  "n_2018_q2" DOUBLE,
  "n_2018_q3" DOUBLE,
  "n_2018_q4" DOUBLE,
  "n_2019_q1" DOUBLE,
  "n_2019_q2" DOUBLE,
  "n_2019_q3" DOUBLE,
  "n_2019_q4" DOUBLE,
  "n_2020_q1" DOUBLE,
  "n_2020_q2" DOUBLE,
  "n_2020_q3" DOUBLE,
  "n_2020_q4" DOUBLE,
  "n_2021_q1" DOUBLE,
  "n_2021_q2" DOUBLE,
  "n_2021_q3" DOUBLE,
  "n_2021_q4" DOUBLE,
  "n_2022_q1" DOUBLE,
  "n_2022_q2" DOUBLE,
  "n_2022_q3" DOUBLE,
  "n_2022_q4" DOUBLE,
  "n_2023_q1" DOUBLE,
  "n_2023_q2" DOUBLE,
  "n_2023_q3" DOUBLE,
  "n_2023_q4" DOUBLE,
  "n_2024_q1" DOUBLE,
  "n_2024_q2" DOUBLE,
  "n_2024_q3" DOUBLE
);