Baselight

Gross Weight Of Goods Handled In The Top 20 EU Main Ports By Type Of Cargo

Eurostat code: mar_mg_am_pwhc ยท (2005 - 2023)

@eurostat.mar_mg_am_pwhc

Gross Weight Of Goods Handled In The Top 20 EU Main Ports By Type Of Cargo - Unpivoted
@eurostat.mar_mg_am_pwhc.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.

  • 36.43 KB
  • 8018 rows
  • 6 columns
freq

Freq

unit

Unit

cargo

Cargo

rep_mar

Rep Mar

time_period

Time Period

value

Value

AnnualPercentage of totalDry bulk goodsAntwerpen200518.3
AnnualPercentage of totalDry bulk goodsZeebrugge20056
AnnualPercentage of totalDry bulk goodsBremerhaven20050.4
AnnualPercentage of totalDry bulk goodsHamburg200525
AnnualPercentage of totalDry bulk goodsWilhelmshaven20054.1
AnnualPercentage of totalDry bulk goodsTallinn200518.5
AnnualPercentage of totalDry bulk goodsPeiraias20051.2
AnnualPercentage of totalDry bulk goodsBilbao200514.7
AnnualPercentage of totalDry bulk goodsAlgeciras20054.8
AnnualPercentage of totalDry bulk goodsBarcelona200510.9

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

Share link

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