Baselight
Sign In

Country Level - Gross Weight Of Goods Transported To/from Main Ports, By Type Of Traffic

Eurostat code: mar_mg_am_cwtt ยท (1997 - 2023)

@eurostat.mar_mg_am_cwtt

Country Level - Gross Weight Of Goods Transported To/from Main Ports, By Type Of Traffic - Unpivoted
@eurostat.mar_mg_am_cwtt.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.

  • 66.28 KB
  • 14500 rows
  • 6 columns
freq

Freq

unit

Unit

tra_cov

Tra Cov

rep_mar

Rep Mar

time_period

Time Period

value

Value

AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Belgium199731.5
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Germany199745.4
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Denmark199738.4
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Finland199764.9
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Ireland199759.8
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Italy199715.5
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Netherlands199727.3
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Portugal199729.1
AnnualPercentage of totalInternational transport Intra-EU15 (1995-2004)Sweden199762.2
AnnualPercentage of totalInternational transport Intra-EU25 (2004-2006)Belgium199736.1

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