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
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
freqFreq | directDirect | unitUnit | n_2005_q12005-Q1 | n_2005_q22005-Q2 | n_2005_q32005-Q3 | n_2005_q42005-Q4 | n_2006_q12006-Q1 | n_2006_q22006-Q2 | n_2006_q32006-Q3 | n_2006_q42006-Q4 | n_2007_q12007-Q1 | n_2007_q22007-Q2 | n_2007_q32007-Q3 | n_2007_q42007-Q4 | n_2008_q12008-Q1 | n_2008_q22008-Q2 | n_2008_q32008-Q3 | n_2008_q42008-Q4 | n_2009_q12009-Q1 | n_2009_q22009-Q2 | n_2009_q32009-Q3 | n_2009_q42009-Q4 | n_2010_q12010-Q1 | n_2010_q22010-Q2 | n_2010_q32010-Q3 | n_2010_q42010-Q4 | n_2011_q12011-Q1 | n_2011_q22011-Q2 | n_2011_q32011-Q3 | n_2011_q42011-Q4 | n_2012_q12012-Q1 | n_2012_q22012-Q2 | n_2012_q32012-Q3 | n_2012_q42012-Q4 | n_2013_q12013-Q1 | n_2013_q22013-Q2 | n_2013_q32013-Q3 | n_2013_q42013-Q4 | n_2014_q12014-Q1 | n_2014_q22014-Q2 | n_2014_q32014-Q3 | n_2014_q42014-Q4 | n_2015_q12015-Q1 | n_2015_q22015-Q2 | n_2015_q32015-Q3 | n_2015_q42015-Q4 | n_2016_q12016-Q1 | n_2016_q22016-Q2 | n_2016_q32016-Q3 | n_2016_q42016-Q4 | n_2017_q12017-Q1 | n_2017_q22017-Q2 | n_2017_q32017-Q3 | n_2017_q42017-Q4 | n_2018_q12018-Q1 | n_2018_q22018-Q2 | n_2018_q32018-Q3 | n_2018_q42018-Q4 | n_2019_q12019-Q1 | n_2019_q22019-Q2 | n_2019_q32019-Q3 | n_2019_q42019-Q4 | n_2020_q12020-Q1 | n_2020_q22020-Q2 | n_2020_q32020-Q3 | n_2020_q42020-Q4 | n_2021_q12021-Q1 | n_2021_q22021-Q2 | n_2021_q32021-Q3 | n_2021_q42021-Q4 | n_2022_q12022-Q1 | n_2022_q22022-Q2 | n_2022_q32022-Q3 | n_2022_q42022-Q4 | n_2023_q12023-Q1 | n_2023_q22023-Q2 | n_2023_q32023-Q3 | n_2023_q42023-Q4 | n_2024_q12024-Q1 | n_2024_q22024-Q2 | n_2024_q32024-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
);