Vessels Arriving In The Main Ports By Type And Size Of Vessels - Quarterly Data
Eurostat code: mar_tf_qm ยท (1997-Q1 - 2024-Q4)
@eurostat.mar_tf_qm
Vessels Arriving In The Main Ports By Type And Size Of Vessels - Quarterly Data - Raw
@eurostat.mar_tf_qm.raw
This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.
- 10.8 MB
- 148521 rows
- 117 columns
- Only the first 100 columns are shown
freqFreq | tonnageTonnage | vesselVessel | unitUnit | rep_marRep Mar | n_1997_q11997-Q1 | n_1997_q21997-Q2 | n_1997_q31997-Q3 | n_1997_q41997-Q4 | n_1998_q11998-Q1 | n_1998_q21998-Q2 | n_1998_q31998-Q3 | n_1998_q41998-Q4 | n_1999_q11999-Q1 | n_1999_q21999-Q2 | n_1999_q31999-Q3 | n_1999_q41999-Q4 | n_2000_q12000-Q1 | n_2000_q22000-Q2 | n_2000_q32000-Q3 | n_2000_q42000-Q4 | n_2001_q12001-Q1 | n_2001_q22001-Q2 | n_2001_q32001-Q3 | n_2001_q42001-Q4 | n_2002_q12002-Q1 | n_2002_q22002-Q2 | n_2002_q32002-Q3 | n_2002_q42002-Q4 | n_2003_q12003-Q1 | n_2003_q22003-Q2 | n_2003_q32003-Q3 | n_2003_q42003-Q4 | n_2004_q12004-Q1 | n_2004_q22004-Q2 | n_2004_q32004-Q3 | n_2004_q42004-Q4 | 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 | n_2024_q42024-Q4 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Quarterly | From 100 to 499 gross tonnage | Dry bulk carrier | Number | Belgium | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Quarterly | From 100 to 499 gross tonnage | Dry bulk carrier | Number | Gent (Ghent) | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Quarterly | From 100 to 499 gross tonnage | Dry bulk carrier | Number | Bulgaria | 1 | 2 | 1 | 2 | 4 | 6 | 1 | 2 | 6 | 3 | 5 | 7 | 4 | 1 | 5 | 3 | 4 | 4 | 7 | 4 | 1 | 3 | 4 | 1 | 2 | 5 | 1 | 1 | 2 | 2 | 2 | 5 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Quarterly | From 100 to 499 gross tonnage | Dry bulk carrier | Number | Burgas | 1 | 1 | 2 | 2 | 1 | 2 | 3 | 4 | 6 | 4 | 2 | 1 | 1 | 3 | 2 | 1 | 1 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Quarterly | From 100 to 499 gross tonnage | Dry bulk carrier | Number | Varna | 1 | 1 | 2 | 4 | 6 | 1 | 2 | 4 | 1 | 5 | 7 | 3 | 1 | 3 | 3 | 1 | 1 | 1 | 1 | 3 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Quarterly | From 100 to 499 gross tonnage | Dry bulk carrier | Number | Cyprus | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Quarterly | From 100 to 499 gross tonnage | Dry bulk carrier | Number | Larnaka | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Quarterly | From 100 to 499 gross tonnage | Dry bulk carrier | Number | Lemesos | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Quarterly | From 100 to 499 gross tonnage | Dry bulk carrier | Number | Germany | 214 | 302 | 299 | 270 | 285 | 301 | 263 | 211 | 135 | 242 | 294 | 233 | 214 | 292 | 288 | 232 | 75 | 125 | 100 | 128 | 77 | 91 | 54 | 60 | 80 | 41 | 52 | 60 | 34 | 53 | 74 | 66 | 62 | 42 | 81 | 32 | 632 | 723 | 611 | 506 | 10 | 15 | 29 | 43 | 14 | 9 | 30 | 9 | 5 | 7 | 29 | 38 | 28 | 54 | 48 | 43 | 31 | 54 | 35 | 19 | 7 | 13 | 31 | 17 | 8 | 44 | 72 | 32 | 25 | 27 | 54 | 28 | 2 | 15 | 7 | 8 | 8 | 9 | 17 | 16 | 31 | |||||||||||||||||||||||||||||||
| Quarterly | From 100 to 499 gross tonnage | Dry bulk carrier | Number | Germany: North Sea | 151 | 246 | 237 | 213 | 219 | 255 | 194 | 141 | 77 | 195 | 216 | 147 | 109 | 184 | 202 | 157 | 67 | 119 | 85 | 111 | 71 | 81 | 46 | 56 | 77 | 31 | 46 | 55 | 23 | 47 | 64 | 51 | 58 | 28 | 72 | 27 | 18 | 47 | 28 | 22 | 10 | 12 | 28 | 42 | 14 | 7 | 30 | 9 | 5 | 7 | 29 | 38 | 18 | 24 | 19 | 25 | 23 | 21 | 20 | 1 | 5 | 12 | 3 | 6 | 37 | 69 | 31 | 25 | 26 | 50 | 28 | 14 | 7 | 8 | 8 | 9 | 12 | 16 | 31 |
CREATE TABLE raw (
"freq" VARCHAR,
"tonnage" VARCHAR,
"vessel" VARCHAR,
"unit" VARCHAR,
"rep_mar" VARCHAR,
"n_1997_q1" DOUBLE,
"n_1997_q2" DOUBLE,
"n_1997_q3" DOUBLE,
"n_1997_q4" DOUBLE,
"n_1998_q1" DOUBLE,
"n_1998_q2" DOUBLE,
"n_1998_q3" DOUBLE,
"n_1998_q4" DOUBLE,
"n_1999_q1" DOUBLE,
"n_1999_q2" DOUBLE,
"n_1999_q3" DOUBLE,
"n_1999_q4" DOUBLE,
"n_2000_q1" DOUBLE,
"n_2000_q2" DOUBLE,
"n_2000_q3" DOUBLE,
"n_2000_q4" DOUBLE,
"n_2001_q1" DOUBLE,
"n_2001_q2" DOUBLE,
"n_2001_q3" DOUBLE,
"n_2001_q4" DOUBLE,
"n_2002_q1" DOUBLE,
"n_2002_q2" DOUBLE,
"n_2002_q3" DOUBLE,
"n_2002_q4" DOUBLE,
"n_2003_q1" DOUBLE,
"n_2003_q2" DOUBLE,
"n_2003_q3" DOUBLE,
"n_2003_q4" DOUBLE,
"n_2004_q1" DOUBLE,
"n_2004_q2" DOUBLE,
"n_2004_q3" DOUBLE,
"n_2004_q4" DOUBLE,
"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
);