Gross Weight Of Goods Transported To/from Main Ports - Latvia - Quarterly Data

Eurostat code: mar_go_qm_lv · (2002-Q1 - 2024-Q4)

@eurostat.mar_go_qm_lv

Table List

2 tables(1.23 MB)

Gross Weight Of Goods Transported To/from Main Ports - Latvia - Quarterly Data - Raw

Gross Weight Of Goods Transported To/from Main Ports - Latvia - Quarterly Data - Unpivoted

Gross Weight Of Goods Transported To/from Main Ports - Latvia - Quarterly Data - Unpivoted

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

558.14 KB
294254 rows
8 columns

freq Freq	direct Direct	cargo Cargo	unit Unit	par_mar Par Mar	rep_mar Rep Mar	time_period Time Period	value Value
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Total	Latvia	2002-Q1	358
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Total	Liepaja	2002-Q1	14
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Total	Riga	2002-Q1	209
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Total	Ventspils	2002-Q1	135
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Unknown	Latvia	2002-Q1	358
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Unknown	Liepaja	2002-Q1	14
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Unknown	Riga	2002-Q1	209
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Unknown	Ventspils	2002-Q1	135
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Total unspecified and unknown locations	Latvia	2002-Q1	358
Quarterly	Inwards	Dry bulk goods	Thousand tonnes	Total unspecified and unknown locations	Liepaja	2002-Q1	14


CREATE TABLE tidy (
  "freq" VARCHAR,
  "direct" VARCHAR,
  "cargo" 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.