Fish And Overfishing

How the Global Fish production is done and managed throught the years

@kaggle.sergegeukjian_fish_and_overfishing

Table List

7 tables(650.64 KB)

Aquaculture Farmed Fish Production

Capture Fisheries Vs Aquaculture

Capture Fishery Production

Fish And Seafood Consumption Per Capita

Fish Stocks Within Sustainable Levels

Global Fishery Catch By Sector

Seafood And Fish Production Thousand Tonnes

Fish Stocks Within Sustainable Levels

@kaggle.sergegeukjian_fish_and_overfishing.fish_stocks_within_sustainable_levels

5.86 KB
51 rows
5 columns

entity Entity	code Code	year Year	share_of_fish_stocks_within_biologically_sustainable_l_7b32dd67 Share Of Fish Stocks Within Biologically Sustainable Levels (FAO, 2020)	share_of_fish_stocks_that_are_overexploited Share Of Fish Stocks That Are Overexploited
Eastern Central Atlantic	nan	2015	57.14286	42.85714
Eastern Central Atlantic	nan	2017	57.14285714	42.85714286
Eastern Central Pacific	nan	2015	86.66667	13.33333
Eastern Central Pacific	nan	2017	86.66666667	13.33333333
Eastern Indian Ocean	nan	2015	73.07692	26.92308
Eastern Indian Ocean	nan	2017	68.62745098	31.37254902
Mediterranean and Black Sea	nan	2015	37.83784	62.16216
Mediterranean and Black Sea	nan	2017	37.5	62.5
Northeast Central Atlantic	nan	2015	73.46939	26.53061
Northeast Central Atlantic	nan	2017	79.31034483	20.68965517


CREATE TABLE fish_stocks_within_sustainable_levels (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "share_of_fish_stocks_within_biologically_sustainable_l_7b32dd67" DOUBLE,
  "share_of_fish_stocks_that_are_overexploited" DOUBLE
);