Top 5 Ports For Volume Of Containers - Volume (in TEUs) Of Containers Handled In Each Port

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

@eurostat.mar_qg_qm_pvh

Table List

2 tables(87.86 KB)

Top 5 Ports For Volume Of Containers - Volume (in TEUs) Of Containers Handled In Each Port - Raw

Top 5 Ports For Volume Of Containers - Volume (in TEUs) Of Containers Handled In Each Port - Unpivoted

Top 5 Ports For Volume Of Containers - Volume (in TEUs) Of Containers Handled In Each Port - Raw

@eurostat.mar_qg_qm_pvh.raw

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

71.86 KB
45 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	-0.9	-4.6	-4	5.7	-6.1	-4	11.8	1.4	3.9
Quarterly	Growth rate on previous period (t/t-1)	Antwerpen	7.7	3	-2.5	-0.9	13.2	-4.2		10.5	6.8	0.8	-1	0.8	13.4	-6	-9.1	-15	9	-2.8	2.9	7.2	8.5	-1.1	-2	3.1	2	-2	-5.3	5.7	-5.2	3.5	-1.6	-0.2	4.4	-4.2	3.5	0.8	5.1	2.2	-2.6	-0.7	10.6	-1.8	-0.9	3.7	4.1	-3.2	-1.7	-0.4	5	1	-1.6	4.4	5.9	-2.4	-0.6	0.5	10.9	-0.5	-1.1	1.5	-6.2	5.8	5.8	-1.9	-0.6	-4.7	-1.7
Quarterly	Growth rate on previous period (t/t-1)	Bremerhaven	6.8	-3.1	5.9	2.6	11.9	10.8	-6	1.3	2	7.4	-3.1	3.4	7.5	5	-7.7	-25.6	14.3	3.1	6.3	-10.3	13.2	-2.9	1.5	12.9	12.6	-6.9	-2	10.3	0.8	-4.4	-10.8	2.5	7.6	-0.1	-7.7	0.4	0.9	6.9	-6.6	-2.4	-2	6.2	-8.9	7.4	2.4	-2.5	-9.1	6.6	-7.8	10.4	6.5	-8.5	-0.2	2.9	-0.9	-9.5	0.2	-0.3	-8.9	5.6	-4.7	0.3	14.3	2.6	-6.2	-1.6	-2.8	3	-9.7	2.4	-1.9	-11.4	3.6	4.7	5.7	-0.9	-1.5	0.3
Quarterly	Growth rate on previous period (t/t-1)	Hamburg	7.4	8	2.8	-4.2	1.9	6.6	5.9	-2.4	4.9	6.9	-5.5	-1.3	3.1	-0.3	-10	-18	-7.9	2.4	-2.7	4.7	7	13.5	-6	4.1	5.4	7.8	-6.4	-1.5	-0.3	3.6	-6.4	2.7	6.2	4	-5.4	3	5	3.4	-9.8	-0.7	-4.7	1.2	-5.4	5.5	0.1	1.8	-2.2	0.3	1.4	2.2	-9.7	3.9	2	0.8	-2.8	6.7	1.8	1.4	-4.9	-3.7	-11.1	16.7	-1.7	-0.2	-3.4	3.2	2.2	0.1	-5.4	-5.2	-3.7	-3.7	6	1.3	-6.9	2.5	0.7	3.8
Quarterly	Growth rate on previous period (t/t-1)	Peiraias	-21.7	13.9	-4.2	0.1	21	7.8	-50.4	24.9	23.1	9.9	7.8	-85.1	80.1	31.1	-8.6	-0.5	34.9	13.7	-14.2	11	1.6	19.4	7.5	28.6	24.4	15.2	16.2	31.9	10.7	-15	9	-2.7	18.9	-3.3	13	-8.2	10.4	-3.6	1.1	-6.3	-0.7	2.5	2.1	1.4	7.6	8.4	-11.3	2.4	13.3	1.5	2	3.7	7.3	7.2	-2.3	5.1	7.3	4.6	-5.8	-3.7	-3.2	0.5	-6.4	-7.6	10.4	1.8	-16.5	-1.4	4	7.2	-1.8	-2.2	12.4	-2.7	-1.8	-15.6	11.4	12.7
Quarterly	Growth rate on previous period (t/t-1)	Algeciras	-0.2	1.5	-8.4	-4	9.8	9.1	2.9	-7.3	6.4	-1.6	-0.7	-5.8	5.7	-5.4	2.9	-16.3	0.2	11.3	1.5	-5	-0.9	-12.6	-0.5	6.8	28.5	11.8	5.3	-8.2	6.3	7.8	-3.5	-5.9	7.9	6.5	-31	48.7	-0.3	-3.2	-3.4	-6.8	4.9	14.8	-1	-3.9	2.4	1.9	-1.9	-16.3	16.1	-8.9	12.1	-4.7	8	2	-4.3	1.5	10.7	-2.2	-2.2	1.6	-5.3	5.7	-1.4	-10.8	4.5	5.9	-5	-3.3	2	4.8	-4.8	-5.3	8.5	0.5	-3.5	-0.5	4.3	-2.8
Quarterly	Growth rate on previous period (t/t-1)	Valencia	11	0.8	-4.4	1.8	10.5	1.5	-6.9	15.8	2.6	3.3	-2.8	6.4	11.7	11.2	-13.1	-2.2	10.2	-0.2	-4	2.7	13.4	6.4	-2.2	-7.3	7	3.7	-4	-4.1	8.7	1.2	-0.3	-4.9	2.7	-4.2	-1.7	-3.2	12.1	-1.9	0.5	3.7	1.2	-0.5	-7.6	6.2	5.4	-2.8	-0.7	-7	14.7	2.3	-6.3	-0.1	9.7	-0.5	4	-0.2	3.3	-1	-7.3	2	-6.9	16	4	-6.5	4.3	-2	-2.4	-10.2	14.9	-7.1	-18.4	3.1	14	-4.4	0.1	2.9	18.7	-2.8
Quarterly	Growth rate on previous period (t/t-1)	Gioia Tauro	-2.4	1.9	-10.2	-9	2.7	13.5	-3.4	13.9	11.8	-1.7	-18.6	-2.7	17.7	3.5	-24.5	18.3	0.3	-30.7	3	58.4	10.6	1.4	-4.3	1	-9.1	-23.2	8.6	8.2	24.5	-6.4	4	2.2	-4.2	-8.6	-5.8	3.2	23.7	-6.9	-15.5	-2.6	0.7	-14.7	4.2	1.7	78.4	-44.2	40.6	-18.4	-2.3	-6.2	26.2	-8.9	22	-2	-5.8	-44.9	30.6	9.2	20.4	-12.8	2.2	-3.7	6.1	-16.9	23.2	4.3	-3.3	-16.1	30.4	-1.9	-5.2	74.4	33.1	-11.1	0.1	-55.4	-12.7	-9
Quarterly	Growth rate on previous period (t/t-1)	Rotterdam	6.3	0.8	-0.1	-3.2	3.2	3.9	4.4	-0.6	6.2	4.3	-1	-3.7	1.5	1.2	-8.5	-9.9	4.6	2.5	4.2	3	7	3	-4	-2.3	8.1	2.4	-7.8	-2.1	10.6	-0.9	-5.4	-2.6	4.3	-0.7	-5.9	3.7	7.6	1.9	-3.4	3.1	-1.4	-1.4	-4.7	3.9	1.1	3.6	-0.8	4.6	5	3.1	-0.6	-0.2	3	2.4	0.1	1.3	1.4	-2.9	-0.8	-0.3	-4.8	9	-1.2	0.4	4.1	-0.1	-3.3	-3	-1.2	3.2	-8	-5	6.6	1.3	-7.2	0.9	6.9	1.9
Quarterly	Rolling 4-quarter growth rate	Antwerp-Bruges																																																																											-6.7	-3.9	-2.4	3.1


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
);