Estimated Trends In Fish Stock Biomass, By Fishing Areas

Eurostat code: sdg_14_21 · (2003 - 2023)

@eurostat.sdg_14_21

Table List

2 tables(21.02 KB)

Estimated Trends In Fish Stock Biomass, By Fishing Areas - Raw

Estimated Trends In Fish Stock Biomass, By Fishing Areas - Unpivoted

Estimated Trends In Fish Stock Biomass, By Fishing Areas - Unpivoted

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

4.61 KB
61 rows
5 columns

freq Freq	fishreg Fishreg	indic_env Indic Env	time_period Time Period	value Value
Annual	Atlantic, Northeast	Fish stock biomass - index 2003 = 100	2003	100
Annual	EU total marine areas	Fish stock biomass - index 2003 = 100	2003	100
Annual	Mediterranean and Black Sea	Fish stock biomass - index 2003 = 100	2003	100
Annual	Atlantic, Northeast	Fish stock biomass - index 2003 = 100	2004	96
Annual	EU total marine areas	Fish stock biomass - index 2003 = 100	2004	87
Annual	Mediterranean and Black Sea	Fish stock biomass - index 2003 = 100	2004	89
Annual	Atlantic, Northeast	Fish stock biomass - index 2003 = 100	2005	91
Annual	EU total marine areas	Fish stock biomass - index 2003 = 100	2005	74
Annual	Mediterranean and Black Sea	Fish stock biomass - index 2003 = 100	2005	82
Annual	Atlantic, Northeast	Fish stock biomass - index 2003 = 100	2006	91


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

Share link

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