Volume Of Containers Transported To/from Main Ports - Quarterly Data (1997 - 1999)

Eurostat code: mar_go_qm_c1999 · (1997-Q1 - 1999-Q4)

@eurostat.mar_go_qm_c1999

Table List

2 tables(2.07 MB)

Volume Of Containers Transported To/from Main Ports - Quarterly Data (1997 - 1999) - Raw

Volume Of Containers Transported To/from Main Ports - Quarterly Data (1997 - 1999) - Unpivoted

Volume Of Containers Transported To/from Main Ports - Quarterly Data (1997 - 1999) - Unpivoted

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

1.11 MB
423761 rows
9 columns

freq Freq	par_mar Par Mar	direct Direct	cargo Cargo	loadstat Loadstat	unit Unit	rep_mar Rep Mar	time_period Time Period	value Value
Quarterly	United Arab Emirates	Inwards	Large containers - 20-ft freight units	Empty	Twenty-foot equivalent unit (TEU)	Antwerpen	1997-Q1
Quarterly	United Arab Emirates	Inwards	Large containers - 20-ft freight units	Total loaded and empty	Twenty-foot equivalent unit (TEU)	Belgium	1997-Q1	112
Quarterly	United Arab Emirates	Inwards	Large containers - 20-ft freight units	Total loaded and empty	Twenty-foot equivalent unit (TEU)	Antwerpen	1997-Q1	112
Quarterly	United Arab Emirates	Inwards	Large containers - 40-ft freight units	Empty	Twenty-foot equivalent unit (TEU)	Antwerpen	1997-Q1
Quarterly	United Arab Emirates	Inwards	Large containers - 40-ft freight units	Total loaded and empty	Twenty-foot equivalent unit (TEU)	Belgium	1997-Q1	46
Quarterly	United Arab Emirates	Inwards	Large containers - 40-ft freight units	Total loaded and empty	Twenty-foot equivalent unit (TEU)	Antwerpen	1997-Q1	46
Quarterly	United Arab Emirates	Inwards	Large containers - freight units > 40-ft	Empty	Twenty-foot equivalent unit (TEU)	Antwerpen	1997-Q1
Quarterly	United Arab Emirates	Inwards	Large containers - freight units > 40-ft	Total loaded and empty	Twenty-foot equivalent unit (TEU)	Belgium	1997-Q1	2
Quarterly	United Arab Emirates	Inwards	Large containers - freight units > 40-ft	Total loaded and empty	Twenty-foot equivalent unit (TEU)	Antwerpen	1997-Q1	2
Quarterly	United Arab Emirates	Inwards	Large containers - unspecified size	Empty	Twenty-foot equivalent unit (TEU)	Antwerpen	1997-Q1


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

Share link

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