Fish Catches By Fishing Areas

Eurostat code: enps_fish_ca_main · (2005 - 2022)

@eurostat.enps_fish_ca_main

Table List

2 tables(22.43 KB)

Fish Catches By Fishing Areas - Unpivoted

Fish Catches By Fishing Areas - Unpivoted

@eurostat.enps_fish_ca_main.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.3 KB
299 rows
6 columns

freq Freq	unit Unit	fishreg Fishreg	geo Geo	time_period Time Period	value Value
Annual	Tonnes live weight	Total fishing areas	Algeria	2005	139458.6
Annual	Tonnes live weight	Total fishing areas	Egypt	2005	265750
Annual	Tonnes live weight	Total fishing areas	Israel	2005	2680
Annual	Tonnes live weight	Total fishing areas	Jordan	2005	7
Annual	Tonnes live weight	Total fishing areas	Lebanon	2005	8000
Annual	Tonnes live weight	Total fishing areas	Morocco	2005	1036408
Annual	Tonnes live weight	Total fishing areas	Palestine*	2005	1813.9
Annual	Tonnes live weight	Total fishing areas	Tunisia	2005	108699
Annual	Tonnes live weight	Mediterranean and Black Sea	Algeria	2005	139458.6
Annual	Tonnes live weight	Mediterranean and Black Sea	Egypt	2005	107453


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

Share link

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