Country Level - Gross Weight Of Goods Handled In Main Ports

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

@eurostat.mar_qg_qm_cwh

Table List

2 tables(154.03 KB)

Country Level - Gross Weight Of Goods Handled In Main Ports - Raw

Country Level - Gross Weight Of Goods Handled In Main Ports - Unpivoted

Country Level - Gross Weight Of Goods Handled In Main Ports - Raw

@eurostat.mar_qg_qm_cwh.raw

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

110.15 KB
135 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)	Belgium	5.9	-1	2.1	-2.8	9.6	-4.5	6.4	0.4	0.9	1.8	4.1	-3	7.6	-3.3	-6.4	-17.1	5.5	2.9	1.3	1	8.9	-0.5	2	1.5	0.8	-5.3	-2.8	2.4	-0.6	-1.3	-1.2	1.5	4.7	-3.2	1.6	0.7	3.6	0.1	1.7	-1.4	2.7	-3.5	2.5	1.8	5.7	-3	-1.3	0.9	4.7	-2.9	0.4	4	3.6	-3.2	-0.6	-1.5	11.6	-6.8	2.9	1.9	-11.1	1.4	6.2	3.2	5.3	-5.8	4.1	-0.2	4.3	-8.5	-0.2	0.9	0.3	-6.7	2.1	5	2.7	-8.2
Quarterly	Growth rate on previous period (t/t-1)	Bulgaria	-0.4	11.9	-3.3	3.8	-2.5	18.5	-12	-15.4	14.7	3.8	-13.7	-4	25.4	6.3	-15	-21.7	-4.5	25.6	2.4	-31.8	30.9	30.5	-14	-9.5	8.7	16.6	-7.6	-17.3	25.3	11.1	-14.8	-9.3	16.2	29.7	-12.9	-37.3	37.6	19.2	3.3	-20.5	0.5	15.9	-9.1	-15.5	14.9	32.4	-13	-8.8	-2.9	35.2	-9.9	-31.5	8.9	43.5	-16	-2.9	-2.3	24.2	-5.8	-12.5	-18.8	6.9	-2.2	-4	6.3	24.9	-25.2	26.3	13.7	-2.9	-13.2	-9.2	5.6	30.3	-7.2	-19.9	17.6	9.7
Quarterly	Growth rate on previous period (t/t-1)	Cyprus	6.4	7.5	-4.4	3.1	-0.9	4.9	-6.8	-3.1	6.9	-3.8	4	0.7	4	11.7	-21.8	-0.3	-5.5	9.7	-14.1	13.8	-5.5	-2.4	14.8	-11.9	3.1	-5.1	-1.6	-5.2	8.2	-1.6	-7.3	15.3	12.4	-5.5	-6.9	11.9	-3.1	-4.3	-4.6	7.1	-4.9	11.3	5.2	21.2	18.2	-7.4	-13.5	2.1	-15.7	-15.3	10.7	-22.9	29.3	0.5	-2.7	9.4	-7	4	-11.7	5.7	-6.5	14.4	10.1	-22.3	0.9	13.1	-1.7	4.3	25.1	-13.9	-9.4	0.3	16.2	16.9	-15.2	-13.2	11.4	10.6
Quarterly	Growth rate on previous period (t/t-1)	Germany	4.2	-1.6	5	-2	6.9	-1.3	-0.1	1.7	2.4	-2.7	4.8	-2.5	5.7	-3.1	-4.2	-17.4	2	4.4	-2.7	-2.1	6.5	-1.6	4.1	-1.8	6.1	1.7	0.2	0.1	0.3	-2.9	-1	0.4	6.1	-1.9		0.7	1.8	0.4	-2.5	1	0.7	-3.7	-3.7	2.5	5.8	-1.6	-4.1	5.1	-1.8	1.8	-4.8	1.5	0.6	-1.9	4.9	-2.5	3.2	-4.2	-4.1	0.4	-8	4	6.9	-1.5	0.2	1.6	2.1	-3.9	-0.2	-1	-4.8	1	1.9	-4.7	0.9	1.1	3.9	-0.2
Quarterly	Growth rate on previous period (t/t-1)	Denmark	11.9	-4.3	6	-3.6	9.3	-5.1	9.5	-2.3	-3.4	-3.9	7.6	-0.8	3.8	-11.6	0.9	-7	-10.3	9.5	-2.9	-5.4	-0.6	0.5	9	2.3	3.2	-6.9	-5.3	-0.8	9.4	-9.4	-2.3	3.8	4.6	-0.1	-5.3	-4.7	6.4	-1.5	0.6	11.5	-1.3		-3.2	2.9	-2.1	4.2	-0.7	0.3	-3.1	-3.5	4.8	2.3	0.7	-6.8	3.1	1	-2.4	-1.9	5.1	-2.3	-1.4	-3.4	3.8	3.3	0.6	-7.1	9.4	2.9	-0.5	-1.1	-1	4	-5.7	-10.7	7.9		1	-0.2
Quarterly	Growth rate on previous period (t/t-1)	Estonia	4.1	-10.3	12.5	0.6	5.3	-7.5	3.3	11.1	-11.7	-31.6	9	4.7	-15.7	3.5	2.3	1.5	0.8	5.6	3.1	8.4	13.5	0.9	1.1	-1.1	12.7	-16.7	6	3.1	-12.7	-9.7	9.1	8.4	-7.1	-10.3	8.8	14.3	-11.6	-8.9	13.9	-13.9	-9.2	-13.9	13	2.5	-4.3	1	-10.4	18.7	-3.9	-10.6	13.4	-2.9	6.9	-1.3	0.5	-3.3	13.3	-10.1	15	-15	15.5	-5.7	4.3	3.2	9.3	2.6	-17.8	3.6	-5	-9.1	-2.6	-18.3	-0.4	-18.4	-0.4	11.3	-2.1	-6.6
Quarterly	Growth rate on previous period (t/t-1)	Greece	5.2	3.3	-4.3	0.6	2.2	9.9	-9.4	-6	11.8	3.5	-1.5	-15.4	3.6	5.3	-3.9	-8.4	0.9	3.3	-12.4	-2.5	7.8	1.6	-2.3	-3.6	3.2	12.6	-5.5	11.4	9	-4.3	1.3	-2.6	8.3	4	-0.5	-8	10.7	3.2	-1.7	-5.2	1.8	3.5	5.7	-8.7	6.1	12	-7.1	-3.1	9	-2.8	-0.7	1.8	5.5	1.7	-2.2	-2.4	11	-0.6	-4.8	-4.2	-4.2	4.1	-4.4	-5.9	13.5	-1.7	-2.3	-16	16.8	0.6	-3.3	3	6.4	2.7	-4.8	-3.6	8.2	1.4
Quarterly	Growth rate on previous period (t/t-1)	Spain	6.4	0.2	-1.2	-1.3	4.3	1.5	1.1	-5.6	7	1.5	0.9	-4.8	5.3	-5.2	-7.4	-11.2	8.1	-1.8	2.3	-6.2	6.5	1.4	7	-7.7	7.1	1.8	6	-4.9	2.3	0.6	-0.6	-9.5	6.8	2.4	-7.3	4.4	5.9	3.7	-0.7	-4.7	7.9	1.2	0.7	-4.4	2.1		3.6	-2.7	4.6	8.2	-3.7	-2.7	4.9	-1	1.6	-2.8	3.1	-0.4	-5	-2.2	-8.9	6.3	3.1	-2.9	4.6	3.2	-1.1	-1.9	8.6	-5.7	-2.5	-1.5	3.4	-3	-1.9	2.8	7.8	-6.2
Quarterly	Growth rate on previous period (t/t-1)	European Union - 27 countries (from 2020)	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)	Finland	-2.6	-3.2	12.9	-5.9	12.6	-3	7.6	-8	7.4	3	-2.6	-0.6	4.1	-0.4	-1.4	-22.8	-2.1	12.6	4.3	-14	24.7	6.5	2.7	-16.2	17.4		-0.4	-12.5	1.4	1	4.4	-9.2	4	3.5	5.1	-14.7	14	-3.8	7.1	-9.9	-9.4	10.1	3.6	-6.9	9.5	-0.3	2.3	-5.4	7.4	-0.8	7.4	-6	8.6	-1.9	4.3	-4.6	6.2	-2.1	-0.6	-3.9	-3.6	-8.2	4.9	-6.6	-4.2	8.5	4.1	-8.2	7.9	-2.9	3.5	-13	7.3	-9.9	6.1	-9.3	3.3	8.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
);