EU Level - Gross Weight Of Goods Handled In Main Ports, By Various Types Of Partner Geographical Areas

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

@eurostat.mar_qg_qm_ewhg

Table List

2 tables(92.79 KB)

EU Level - Gross Weight Of Goods Handled In Main Ports, By Various Types Of Partner Geographical Areas - Raw

EU Level - Gross Weight Of Goods Handled In Main Ports, By Various Types Of Partner Geographical Areas - Unpivoted

EU Level - Gross Weight Of Goods Handled In Main Ports, By Various Types Of Partner Geographical Areas - Raw

@eurostat.mar_qg_qm_ewhg.raw

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

74.52 KB
45 rows
82 columns

freq Freq	unit Unit	par_mar Par 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)	Africa	-1.4	1.9	3.8	-3.2	-1.1	-2.7	7.7	-7.8	0.6	0.6	3.2	4.8	-1.7	-1.2	2	-8.6	-1.2	-7.1	2.1	-3.8	0.9	2.6	2.4	-4.9	-3.8	6	1	3.6	0.7	1.4	-0.9	1.2	-3.5	-1.9	-2.2	2.7	0.4	2.2	4.9	-2	-1.5	-6.4	6.4	-8.4	-0.6	1.6	-3.1	-4.4	1.4	4	0.3	-1.4	0.5	-0.4	5.5	2.5	4	-3.8	2.1	-4.7	-9.1	-6.4	12.9	2.7	-1.5	1.6	4.4	-6.5	8.8	-4	4.4	4.9	-1.6	-5.7	7	-4.9	1	-8
Quarterly	Growth rate on previous period (t/t-1)	America	8.6	-2.7	-2.5	-3.4	11.7	-6.1	4.5	-5.4	8.9	3	3.4	-2.4	6.7	-1.9	-11.5	-20.4	2	5.3	4.4	-1.5	9	4.1	0.4	-2.8	13.5	-4	-4.8	-1.6	9	-7.7	-2.2	-4.3	13.2	-3	-0.8	-5.7	9.3	-1.1	-1.7	-7.5	14.3	-3.2	-4.5	-5.5	7.1	2.5	-6.8	0.6	5.1	4.5	-3.6	-4.5	9.1	2.2	-0.3	-3.3	3.1	-0.4	-1.2	-7.7	-8.5	11.3	-3.9	1.2	11.5		-6.4	0.1	13.7	0.1	-3.7	1.1	7.4	0.3	-3.4	-3.1	1.1	3.4
Quarterly	Growth rate on previous period (t/t-1)	Asia and Oceania	5	2.4	0.6	-0.3	5.8	3.2	4.8	-1.5	1	-0.7	-3.5	0.2	0.3	2.9	-7.2	-9.7	2.3	1.5	-5	8.2	9	-0.1	-7.8	2.6	10.4	6	-2.3	-3.8	1	4.5	-5.7	-1.2	0.6	3.4	-3.7	-2.2	4	5.7	-0.1	-2.8	2.2	-1	-0.5	2.9	-3.4	5	1	4.6	-0.3	-2.4	3.5	0.6	1.9	2.8	-4.7	2.4	2	-1.7	-4.1	-5.9	5.2	-7.8	6.6	-2.4	4	2.6	-2.4	-9.2	10.5	4.8	-3.2	-1.9	7.9	-2.6	-3.6	-6.9	9.2	-8.8
Quarterly	Growth rate on previous period (t/t-1)	Deep Sea Shipping	6	-0.5	-0.6	-1.1	7.2	-0.3	5.6	-4.8	4.8	1.8	1.5	-0.7	3.3	0.2	-7.1	-15.8	1.3	2.4	2	0.2	7.1	0.7	-0.5	-2.5	11.1	2.2	-2.1	-2.4	3.8	-0.7	-3.6	-1.2	4.4	0.8	-2.3	-2.2	5	1.8	0.2	-4.1	5.2	-2.9	-0.4	-4.1	0.6	4.3	-3.8	3.6	2.8	2	-1.3	-0.3	3.8	1.6	-1	1.5	1.7	-1.6	-1.5	-4.5	-6.5	2.7	1.7	-0.7	5.6	1.6	-2.3	-4.4	11.3	0.9	-3.1	-0.6	5.2	-2.3	-1.4	-4.8	3	-3.1
Quarterly	Growth rate on previous period (t/t-1)	European Union - 27 countries (from 2020)	4.1	-1.9	2.2	-1.1	2.8	-0.3	-0.6	2.5	2.4	-1.7	-0.1	-0.8	2.4	-3	-8.2	-3.2	-1.5	2.1	-1.2	2.5	7.7	-1.5	1.2	1.6	0.7	-3.4	0.2	0.8	-0.8	-2.9	-1.7	2.8	2.6	-1.9	-1.3	3.4	1.8	-0.7		0.9	1.2	-0.8	-3.1	2.7	4.1	-0.9	0.9	-2.6	2.4	3.9	-1.6	-1.8	6.7	0.2	-0.3	-3.8	8.8	-6.2	-2.4	-1.1	-4.5	1.1	2.9	-1.9	2.4	3.7	-0.6	-1.9	4.3	-0.8	-2.6	3.9	1.2	-2.4	-0.8	-2.7	9.5	-2.5
Quarterly	Growth rate on previous period (t/t-1)	European non-EU27 countries (from 2020)	2.1	2.2	2.5	-1.8	1.7	3.1	0.4	-0.7	3	1.8	1.1	-3.2	6.4	-4.5	-2.6	-7.9	-1.6	4.3	2.5	-0.4	5.4	-1.1	1.8	-5.6	6.9	-4.3	0.1	-2.2	1.4	0.6	1	0.1	0.7	-1.4	1.1	1.2	2.1	-2.9	1.7	0.6	-0.1	-0.1	1.3	-0.3	2.8	-0.9	1.5	0.7	3.7	-3	1.7	2.5	-1.1	0.4	2.8	3.5	-2.9	-3.2	1.7	-0.7	-9.4	5.3	3.9	-2.5	3.7	-1.5	5.7	-4.7	-6.8	-12.4	-1.6	-6.5	-4.2	-1.6	1.3	1.6	4.9	-3.1
Quarterly	Growth rate on previous period (t/t-1)	Short Sea Shipping	2.6		2.6	-2.1	2	-0.3	0.5	0.4	2.1	-0.6	0.3	-0.7	3	-3.5	-5.4	-4.6	-1.4	1.2	-0.3	1.5	6.4	-0.3	0.6	-0.9	1.5	-3.2	-0.1	0.5	0.3	-1.7	-0.6	1.3	1.6	-2.3	-0.5	2.3	2	-1	1	0.3	1	-1.1	-1.1	1.3	3.5	-1.1	1.1	-2.6	2.4	1.2	0.3	-1	3.8	0.4	1.1	-1.5	4.8	-5	-0.8	-2.3	-4.9	0.5	4.7	-1.5	2.7	1.6	1.7	-3.5	0.8	-4.7	-1.2	1.6	-0.1	-2.3	0.2	-1.9	8	-3.4
Quarterly	Growth rate on previous period (t/t-1)	Total	3.7	-0.2	1.7	-1.7	3.7		1.9	-1.4	3.2	0.1	0.6	-0.6	3.1	-2.5	-5.7	-8.2	-0.5	1.5	0.3	0.7	6.4		0.2	-0.6	4.4	-1.4	-0.8	-0.3	1.5	-1.4	-1.5	0.5	2.5	-1.2	-1.1	0.6	2.9	-0.2	0.7	-0.3	2.4	-1.4	-0.6	-0.5	2.6	0.3	-0.3		2.5	1.5	-0.2	-1.3	3.7	0.6	0.5	-1.7	3.6	-3.8	-1.1	-3	-5.6	1.4	3.7	-1.3	3.6	1.5	0.3	-3	6.3	-2.5	-1.9	-1.6	1.9	-2.1	-0.8	-2.8	6.1	-3.4
Quarterly	Growth rate on previous period (t/t-1)	Unknown	14.3	-2.3	11.9	8.3	14.4	20.5	-13	-12	27.2	-5.1	-3.8	6.6	7.9	-21.7	19.1	-3.1	8	-3.9	-6.1	-23.4	-17.8	0.7	-5.1	92.3	3.1	-0.9	-2.9	8.2	2.6	-5	5.7	0.2	3.7	2.7	1.3	-8.5	-0.6	-6	1	60.5	2.2	11	8.8	-1.5	2.7	-9.2	7.5	21.3	1.4	0.4	2.2	-14.7		-7.7	3.6	-44.3	-6.2	-0.3	-8.9	-4.5	-15.9	14.7	4.5	-9.4	2.8	-2.4	-1.7	66.7	105	3.3	-3.3	-57.8	9.4	4.8	-20.1	2.9	0.6	-9.2
Quarterly	Rolling 4-quarter growth rate	Africa							-0.2	-1.5	-2.5	-1.5	-2.6	0.8	3.1	4.2	6.3	1.4	-2.6	-7.3	-11.8	-11.9	-11.7	-8	-3.7	-1	0.1	-0.5	-1.5		3.7	5.6	7.5	6.3	3		-2.8	-4.6	-4.4	-2.4	1.7	4.4	5.6	3.4	-0.2	-4	-7.1	-6.3	-8	-7	-5.8	-6	-3.1	-0.4	1.5	1.9	2.7	3.7	5.9	8.2	8.3	5.4	-1.6	-7.7	-10.9	-10.6	-5.5	2.5	6.8	6.6	6.9	3.6	2.3	6.5	5.4	5.2	5.8	0.8	-0.8	-2.5


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "par_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
);