Gross Weight Of Goods Transported To/from Main Ports - Portugal

Eurostat code: mar_go_am_pt · (1997 - 2023)

@eurostat.mar_go_am_pt

Table List

2 tables(4.75 MB)

Gross Weight Of Goods Transported To/from Main Ports - Portugal - Raw

Gross Weight Of Goods Transported To/from Main Ports - Portugal - Unpivoted

Gross Weight Of Goods Transported To/from Main Ports - Portugal - Unpivoted

@eurostat.mar_go_am_pt.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.

2.48 MB
1205572 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
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Former Netherlands Antilles	Portugal	1997	3
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Former Netherlands Antilles	Sines	1997	3
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Belgium	Portugal	1997	10
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Belgium	Lisboa	1997	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Belgium	Setúbal	1997	8
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany	Portugal	1997	19
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany	Aveiro	1997	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany	Leixões	1997	3
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany	Lisboa	1997	14
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany: North Sea	Portugal	1997	4


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.