Estimated Trends In Fishing Pressure, By Fishing Area

Eurostat code: sdg_14_30 · (2003 - 2023)

@eurostat.sdg_14_30

Table List

2 tables(21.22 KB)

Estimated Trends In Fishing Pressure, By Fishing Area - Raw

Estimated Trends In Fishing Pressure, By Fishing Area - Unpivoted

Estimated Trends In Fishing Pressure, By Fishing Area - Unpivoted

@eurostat.sdg_14_30.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.74 KB
61 rows
5 columns

freq Freq	indic_env Indic Env	fishreg Fishreg	time_period Time Period	value Value
Annual	Fish stocks - model based median value	Atlantic, Northeast	2003	1.51
Annual	Fish stocks - model based median value	EU total marine areas	2003	1.56
Annual	Fish stocks - model based median value	Mediterranean and Black Sea	2003	1.64
Annual	Fish stocks - model based median value	Atlantic, Northeast	2004	1.5
Annual	Fish stocks - model based median value	EU total marine areas	2004	1.6
Annual	Fish stocks - model based median value	Mediterranean and Black Sea	2004	1.74
Annual	Fish stocks - model based median value	Atlantic, Northeast	2005	1.43
Annual	Fish stocks - model based median value	EU total marine areas	2005	1.57
Annual	Fish stocks - model based median value	Mediterranean and Black Sea	2005	1.76
Annual	Fish stocks - model based median value	Atlantic, Northeast	2006	1.37


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

Share link

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