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

Eurostat code: mar_go_am_es · (2000 - 2023)

@eurostat.mar_go_am_es

Table List

2 tables(23.42 MB)

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

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

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

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

12.72 MB
6174717 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	Bulgaria	Spain	2000	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Bulgaria	Spain: Mediterranean and South Atlantic	2000	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Bulgaria	Almería	2000	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany	Spain	2000	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany	Spain: Mediterranean and South Atlantic	2000	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany	Algeciras	2000	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany: Rhine	Spain	2000	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany: Rhine	Spain: Mediterranean and South Atlantic	2000	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Germany: Rhine	Algeciras	2000	2
Annual	Inwards	Dry bulk goods	Antigua and Barbuda	Thousand tonnes	Estonia	Spain	2000	1


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.