EU Level - Gross Weight Of Goods Handled In Main Ports, By Direction

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

@eurostat.mar_qg_qm_ewhd

Table List

2 tables(70.68 KB)

EU Level - Gross Weight Of Goods Handled In Main Ports, By Direction - Raw

EU Level - Gross Weight Of Goods Handled In Main Ports, By Direction - Unpivoted

EU Level - Gross Weight Of Goods Handled In Main Ports, By Direction - Raw

@eurostat.mar_qg_qm_ewhd.raw

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

61.37 KB
15 rows
82 columns

freq Freq	direct Direct	unit Unit	n_2005_q1 2005-Q1	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	Inwards	Growth rate on previous period (t/t-1)		2	-0.2	1.3	-0.9	3	1.3	3	-3.3	3.8	1.1	1.2	-1.2	2.6	-2.1	-5.4	-9.8	-4	3.1	0.5	0.6	5.3	0.7	-0.1	-1.8	5.4	-1.4	-2.9	-0.4	0.7	-1.2	-1.7	0.2	1.4	-0.4	-1.2	-0.3	3.5	0.4	-0.1	-0.2	0.8	0.9	-1.3	-0.4	1	1.8	-0.4	0.6	2.2	1.4	-0.2	-0.7	2.4	1.5	1.4	-0.4	2.1	-3.7	-2.3	-2.9	-5.5	0.9	1.6	-0.1	5.7	2	0.5	-0.9	7.2	-2.7	-1.7	-1.7	1.4	-2.7	-1.8	-2.6	7.2	-3.1
Quarterly	Inwards	Rolling 4-quarter growth rate								4.1	4.5	4.9	4.8	3.9	4.2	3.9	2.9	0.7	-4	-9.9	-13.9	-15	-11.8	-4.7	1.4	5.9	6.9	5.5	4.2	2.3	1.5	-0.5	-2	-2.4	-3	-2.4	-1.6	-1	-0.6	0.1	0.8	1.6	2.6	2.5	2.3	1.5	0.6	0.5	0.4	0.9	1.6	2.6	3.3	3.8	3.7	3.4	3.2	3.4	3.9	4.4	3.4	1.1	-1.8	-6.4	-8.6	-9	-8.2	-2.8	2	5.6	8.3	8.5	7.1	5.4	3.8	0.4	-1.8	-3.3	-4.8	-3.7	-2.7
Quarterly	Inwards	Growth rate on the same quarter in previous year					2.1	3.2	4.7	6.4	3.8	4.6	4.4	2.7	4.9	3.7	0.5	-6.1	-14.2	-19.7	-15.4	-10.2	0.2	9.9	7.3	6.6	4	4.1	2	-0.8	0.7	-3.8	-3.7	-2.6	-2	-1.4	-0.6		-0.6	1.5	2.3	3.4	3.5	0.9	1.4	0.2		0.2	1.1	2	3	4.3	3.8	4.1	2.7	2.9	3	4.7	5	4.7	-0.6	-4.3	-6.7	-13.7	-9.5	-5.9	-3.2	8.3	9.5	8.2	7.4	8.9	3.9	1.6	0.8	-4.6	-4.6	-4.6	-5.5	-0.2	-0.6
Quarterly	Inwards	Thousand tonnes	475794	485289	484392	490562	485994	500592	506944	521983	504651	523831	529492	536063	529450	543376	531951	503473	454290	436233	449816	452142	455019	479293	482511	482106	473376	499077	492235	478159	476470	480035	474162	465900	466922	473342	471342	465881	464281	480319	482072	481528	480511	484427	488730	482537	480699	485568	494271	492251	495286	506282	513258	512362	508792	521062	528829	536422	534399	545791	525425	513372	498684	471279	475442	483242	482880	510343	520517	523005	518374	555732	540868	531468	522620	530152	516072	506781	493627	529349	513130
Quarterly	Inwards	Sum of the last 4 quarters (in thousand tonnes)				1936036	1946236	1961540	1984092	2015513	2034170	2057409	2079957	2094036	2118836	2138381	2140840	2108250	2033090	1925947	1843812	1792481	1793210	1836270	1868965	1898929	1917286	1937071	1946795	1942848	1945941	1926899	1908826	1896567	1887019	1880327	1877506	1877487	1874846	1881822	1892552	1908199	1924430	1928537	1935196	1936205	1936393	1937534	1943075	1952789	1967376	1988090	2007077	2027188	2040694	2055475	2071045	2095105	2120713	2145441	2142038	2118988	2083273	2008760	1958778	1928647	1912843	1951907	1996981	2036744	2072238	2117628	2137979	2146442	2150688	2125108	2100312	2075625	2046631	2045829	2042886
Quarterly	Outwards	Growth rate on previous period (t/t-1)		6.7	-0.1	2.6	-2.9	4.8	-2.3	-0.1	2.1	2.3	-1.7	-0.5	0.5	4.1	-3.3	-6.3	-5.3	5.6	-1.1	-0.1	0.9	8	-1	0.7	1.3	2.8	-1.5	2.4	-0.3	2.6	-1.7	-1.1	0.8	4.3	-2.3	-1	2	2.2	-0.9	2	-0.3	4.6	-4.6	0.5	-0.7	4.9	-1.8	-0.1	-0.9	3	1.6	-0.1	-2.1	5.6	-0.8	-0.9	-3.8	5.9	-4	0.6	-3.3	-5.7	2.1	6.7	-3.1	0.7	0.8	0.1	-6.1	4.8	-2.3	-2.2	-1.6	2.6	-1.3	0.9	-3.1	4.4	-3.8
Quarterly	Outwards	Rolling 4-quarter growth rate								2.8	2.5	1.9	2.1	2.8	1.9	1.9	1.4	-0.4	-3.2	-6.2	-8.1	-7.2	-3.5	1	4.9	7.4	8.3	7.2	6.1	5.3	3.9	3.8	3.7	2.2	1.5	1.3	0.9	1.5	2	1.6	1.8	2.7	2.8	3.9	3.8	2.4	1.6	0.2	0.5	1.1	1.7	1.8	2	2.3	2.3	3.5	3.2	2.8	2.2	1	-0.4	-1.2	-1.4	-4.5	-5.3	-5.1	-4.9	-0.4	2.5	2.2	1.2	-0.5	-2.7	-3.8	-3.1	-3.8	-3.4	-1.8	-1.7	-0.6	-0.4
Quarterly	Outwards	Growth rate on the same quarter in previous year					6.1	4.2	2	-0.7	4.5	2	2.6	2.2	0.6	2.3	0.6	-5.2	-10.7	-9.4	-7.3	-1.2	5.3	7.7	7.7	8.6	9	3.8	3.3	5.1	3.4	3.2	3	-0.6	0.5	2.2	1.5	1.6	2.8	0.7	2.2	5.3	2.9	5.4	1.5		-0.4	-0.2	2.8	2.2	2	0.2	3.5	3.5	2.2	4.8	2.4	1.6	-0.1	0.2	-3.1	-1.7	-1.1	-11.9	-6.4	-0.6	-0.5	6.3	5.1	-1.5	-4.6	-0.8	-3.9	-6.1	-1.5	-3.5	-2.6	0.5	-1.1	0.7	-1.8
Quarterly	Outwards	Thousand tonnes	263485	281144	280879	288090	279615	293021	286366	286129	292253	298957	293908	292445	293961	305874	295773	277248	262484	277227	274297	274016	276400	298590	295490	297584	301397	309970	305367	312768	311760	319821	314404	310908	313438	326820	319141	315945	322155	329187	326163	332596	331533	346875	330962	332570	330202	346297	340228	339911	336773	346854	352248	351818	344312	363487	360638	357422	343925	364078	349414	351508	340047	320626	327220	349263	338499	340946	343768	344003	322895	338245	330459	323189	318121	326304	322020	324928	314720	328674	316148
Quarterly	Outwards	Sum of the last 4 quarters (in thousand tonnes)				1113599	1129728	1141605	1147092	1145131	1157770	1163706	1171248	1177563	1179271	1186188	1188053	1172856	1141379	1112732	1091256	1088024	1101940	1123303	1144496	1168064	1193061	1204441	1214319	1229503	1239866	1249717	1258754	1256893	1258571	1265570	1270306	1275343	1284060	1286428	1293450	1310101	1319480	1337167	1341965	1341939	1340608	1340030	1349297	1356638	1363209	1363766	1375786	1387693	1395232	1411866	1420256	1425860	1425472	1426063	1414838	1408924	1405046	1361594	1339401	1337157	1335608	1355929	1372476	1367216	1351612	1348911	1335601	1314787	1310013	1298072	1289633	1291372	1287971	1290340	1284469


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