Baselight

Gross Weight Of Goods Transported To/from Main Ports - United Kingdom

Eurostat code: mar_go_am_uk ยท (2000 - 2019)

@eurostat.mar_go_am_uk

Gross Weight Of Goods Transported To/from Main Ports - United Kingdom - Unpivoted
@eurostat.mar_go_am_uk.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.

  • 6.96 MB
  • 3103627 rows
  • 9 columns
freq

Freq

direct

Direct

cargo

Cargo

natvessr

Natvessr

unit

Unit

par_mar

Par Mar

rep_mar

Rep Mar

time_period

Time Period

value

Value

AnnualInwardsDry bulk goodsAntigua and BarbudaThousand tonnesFormer Netherlands AntillesUnited Kingdom20001
AnnualInwardsDry bulk goodsAntigua and BarbudaThousand tonnesFormer Netherlands AntillesUnited Kingdom: Great Britain and Northern Ireland20001
AnnualInwardsDry bulk goodsAntigua and BarbudaThousand tonnesFormer Netherlands AntillesCromarty Firth20001
AnnualInwardsDry bulk goodsAntigua and BarbudaThousand tonnesBelgiumUnited Kingdom200091
AnnualInwardsDry bulk goodsAntigua and BarbudaThousand tonnesBelgiumUnited Kingdom: Great Britain and Northern Ireland200091
AnnualInwardsDry bulk goodsAntigua and BarbudaThousand tonnesBelgiumTrent River20004
AnnualInwardsDry bulk goodsAntigua and BarbudaThousand tonnesBelgiumRiver Hull & Humber200011
AnnualInwardsDry bulk goodsAntigua and BarbudaThousand tonnesBelgiumBelfast20005
AnnualInwardsDry bulk goodsAntigua and BarbudaThousand tonnesBelgiumClydeport20001
AnnualInwardsDry bulk goodsAntigua and BarbudaThousand tonnesBelgiumForth20001

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

Share link

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