Vessel Traffic

Eurostat code: iww_tf_vetf · (2007 - 2023)

@eurostat.iww_tf_vetf

Table List

2 tables(33.44 KB)

Vessel Traffic - Unpivoted

@eurostat.iww_tf_vetf.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

11.99 KB
1313 rows
7 columns

freq Freq	tra_cov Tra Cov	loadstat Loadstat	unit Unit	geo Geo	time_period Time Period	value Value
Annual	International transport	Empty	Thousand vessel-kilometres	Belgium	2007	2448
Annual	International transport	Empty	Thousand vessel-kilometres	Czechia	2007
Annual	International transport	Empty	Thousand vessel-kilometres	Luxembourg	2007	4
Annual	International transport	Empty	Thousand vessel-kilometres	Netherlands	2007	6530
Annual	International transport	Empty	Vessel movements	Belgium	2007	43402
Annual	International transport	Empty	Vessel movements	Czechia	2007	1
Annual	International transport	Empty	Vessel movements	Luxembourg	2007	124
Annual	International transport	Empty	Vessel movements	Netherlands	2007	57988
Annual	International transport	Loaded	Thousand vessel-kilometres	Belgium	2007	5780
Annual	International transport	Loaded	Thousand vessel-kilometres	Czechia	2007	43


CREATE TABLE tidy (
  "freq" VARCHAR,
  "tra_cov" VARCHAR,
  "loadstat" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.