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

Capture Fisheries Vs Aquaculture

@kaggle.sergegeukjian_fish_and_overfishing.capture_fisheries_vs_aquaculture

152.12 KB
14674 rows
5 columns

entity Entity	code Code	year Year	aquaculture_production_metric_tons Aquaculture Production (metric Tons)	capture_fisheries_production_metric_tons Capture Fisheries Production (metric Tons)
Afghanistan	AFG	1969	60	400
Afghanistan	AFG	1970	60	400
Afghanistan	AFG	1971	60	500
Afghanistan	AFG	1972	60	500
Afghanistan	AFG	1973	60	500
Afghanistan	AFG	1974	60	500
Afghanistan	AFG	1975	60	600
Afghanistan	AFG	1976	170	600
Afghanistan	AFG	1977	170	600
Afghanistan	AFG	1978	170	600


CREATE TABLE capture_fisheries_vs_aquaculture (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "aquaculture_production_metric_tons" DOUBLE,
  "capture_fisheries_production_metric_tons" DOUBLE
);