Name: Fish And Overfishing
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Fish And Overfishing

Global production of fish and seafood has quadrupled over the past 50 years. Not only has the world population more than doubled over this period, the average person now eats almost twice as much seafood as half a century ago.

This has increased pressure on fish stocks across the world. Globally, the share of fish stocks which are overexploited – meaning we catch them faster than they can reproduce to sustain population levels – has more than doubled since the 1980s and this means that current levels of wild fish catch are unsustainable.

One innovation has helped to alleviate some of the pressure on wild fish catch: aquaculture, the practice of fish and seafood farming. The distinction between farmed fish and wild catch is similar to the difference between raising livestock rather than hunting wild animals. Except that for land-based animals, farming is many thousand years old while it was very uncommon for seafood until just over 50 years ago.

In the visualizations and tables we see:

Captured and farmed (production) levels per year and per country or region
Consumption levels throughout the world for the past 50 years
Levels of sustainable vs overexploited fish
Global fishery types and their production levels
Types of fish produced per country

Tables

Aquaculture Farmed Fish Production

@kaggle.sergegeukjian_fish_and_overfishing.aquaculture_farmed_fish_production

66.02 kB
11,657 rows
4 columns

CREATE TABLE aquaculture_farmed_fish_production (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "aquaculture_production_metric_tons" DOUBLE  -- Aquaculture Production (metric Tons)
);

Capture Fisheries Vs Aquaculture

@kaggle.sergegeukjian_fish_and_overfishing.capture_fisheries_vs_aquaculture

155.77 kB
14,674 rows
5 columns

CREATE TABLE capture_fisheries_vs_aquaculture (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "aquaculture_production_metric_tons" DOUBLE  -- Aquaculture Production (metric Tons),
  "capture_fisheries_production_metric_tons" DOUBLE  -- Capture Fisheries Production (metric Tons)
);

Capture Fishery Production

@kaggle.sergegeukjian_fish_and_overfishing.capture_fishery_production

97.34 kB
14,516 rows
4 columns

CREATE TABLE capture_fishery_production (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "capture_fisheries_production_metric_tons" DOUBLE  -- Capture Fisheries Production (metric Tons)
);

Fish And Seafood Consumption Per Capita

@kaggle.sergegeukjian_fish_and_overfishing.fish_and_seafood_consumption_per_capita

43.05 kB
11,028 rows
4 columns

CREATE TABLE fish_and_seafood_consumption_per_capita (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "fish_seafood_food_supply_quantity_kg_capita_yr_fao_2020" DOUBLE  -- Fish, Seafood- Food Supply Quantity (kg/capita/yr) (FAO, 2020)
);

Fish Stocks Within Sustainable Levels

@kaggle.sergegeukjian_fish_and_overfishing.fish_stocks_within_sustainable_levels

6 kB
51 rows
5 columns

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 Within Biologically Sustainable Levels (FAO, 2020),
  "share_of_fish_stocks_that_are_overexploited" DOUBLE
);

Global Fishery Catch By Sector

@kaggle.sergegeukjian_fish_and_overfishing.global_fishery_catch_by_sector

8.68 kB
61 rows
8 columns

CREATE TABLE global_fishery_catch_by_sector (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "artisanal_small_scale_commercial" BIGINT  -- Artisanal (small-scale Commercial),
  "discards" BIGINT,
  "industrial_large_scale_commercial" BIGINT  -- Industrial (large-scale Commercial),
  "recreational" BIGINT,
  "subsistence" BIGINT
);

Seafood And Fish Production Thousand Tonnes

@kaggle.sergegeukjian_fish_and_overfishing.seafood_and_fish_production_thousand_tonnes

289.38 kB
10,326 rows
10 columns

CREATE TABLE seafood_and_fish_production_thousand_tonnes (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "commodity_balances_livestock_and_fish_primary_equivale_84545c04" DOUBLE  -- Commodity Balances - Livestock And Fish Primary Equivalent - Pelagic Fish - 2763 - Production - 5510 - Tonnes,
  "commodity_balances_livestock_and_fish_primary_equivale_de8146f7" DOUBLE  -- Commodity Balances - Livestock And Fish Primary Equivalent - Crustaceans - 2765 - Production - 5510 - Tonnes,
  "commodity_balances_livestock_and_fish_primary_equivale_2e881831" DOUBLE  -- Commodity Balances - Livestock And Fish Primary Equivalent - Cephalopods - 2766 - Production - 5510 - Tonnes,
  "commodity_balances_livestock_and_fish_primary_equivale_5c2e32b3" DOUBLE  -- Commodity Balances - Livestock And Fish Primary Equivalent - Demersal Fish - 2762 - Production - 5510 - Tonnes,
  "commodity_balances_livestock_and_fish_primary_equivale_37e6b974" DOUBLE  -- Commodity Balances - Livestock And Fish Primary Equivalent - Freshwater Fish - 2761 - Production - 5510 - Tonnes,
  "commodity_balances_livestock_and_fish_primary_equivale_8501cda6" DOUBLE  -- Commodity Balances - Livestock And Fish Primary Equivalent - Molluscs, Other - 2767 - Production - 5510 - Tonnes,
  "commodity_balances_livestock_and_fish_primary_equivale_009dc365" DOUBLE  -- Commodity Balances - Livestock And Fish Primary Equivalent - Marine Fish, Other - 2764 - Production - 5510 - Tonnes
);