Aquaculture Production By Aquatic Environment

Eurostat code: enps_fish_aq2a · (2005 - 2022)

@eurostat.enps_fish_aq2a

Table List

2 tables(23.21 KB)

Aquaculture Production By Aquatic Environment - Raw

Aquaculture Production By Aquatic Environment - Unpivoted

Aquaculture Production By Aquatic Environment - Unpivoted

@eurostat.enps_fish_aq2a.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.65 KB
330 rows
6 columns

freq Freq	unit Unit	aquaenv Aquaenv	geo Geo	time_period Time Period	value Value
Annual	Tonnes live weight	Brackish water	Algeria	2005	14
Annual	Tonnes live weight	Brackish water	Israel	2005	669
Annual	Tonnes live weight	Brackish water	Jordan	2005	250
Annual	Tonnes live weight	Brackish water	Lebanon	2005
Annual	Tonnes live weight	Brackish water	Palestine*	2005
Annual	Tonnes live weight	Brackish water	Tunisia	2005
Annual	Tonnes live weight	Freshwater	Algeria	2005	330
Annual	Tonnes live weight	Freshwater	Egypt	2005	83803
Annual	Tonnes live weight	Freshwater	Israel	2005	18539
Annual	Tonnes live weight	Freshwater	Jordan	2005	311


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "aquaenv" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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