Annual Captures Of Fish - Live Weight In Tonnes - By Fishing Areas

Eurostat code: med_ag41 · (2005 - 2018)

@eurostat.med_ag41

Table List

2 tables(20.68 KB)

Annual Captures Of Fish - Live Weight In Tonnes - By Fishing Areas - Raw

Annual Captures Of Fish - Live Weight In Tonnes - By Fishing Areas - Unpivoted

Annual Captures Of Fish - Live Weight In Tonnes - By Fishing Areas - Unpivoted

@eurostat.med_ag41.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.68 KB
237 rows
7 columns

freq Freq	fishreg Fishreg	species Species	aquaenv Aquaenv	geo Geo	time_period Time Period	value Value
Annual	Total fishing areas	Total fishery products	Total	Algeria	2005	139458.6
Annual	Total fishing areas	Total fishery products	Total	Egypt	2005	265750
Annual	Total fishing areas	Total fishery products	Total	Israel	2005	2680
Annual	Total fishing areas	Total fishery products	Total	Jordan	2005	7
Annual	Total fishing areas	Total fishery products	Total	Lebanon	2005	8000
Annual	Total fishing areas	Total fishery products	Total	Morocco	2005	1036408
Annual	Total fishing areas	Total fishery products	Total	Palestine*	2005	1813.9
Annual	Total fishing areas	Total fishery products	Total	Tunisia	2005	108699
Annual	Total fishing areas except Mediterranean and Black Sea	Total fishery products	Total	Egypt	2005	158297
Annual	Total fishing areas except Mediterranean and Black Sea	Total fishery products	Total	Jordan	2005	7


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

Share link

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