Name: Annual Nominal Fish Catches
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Annual Nominal Fish Catches

The datasets provides data of annual nominal catches of more than 200 species of fish and shellfish in the Northeast Atlantic region, which are officially submitted by 20 International Council for the Exploration of the Sea (ICES) member countries between 2006 and 2014.

Tables

Country Codes

@kaggle.victorgenin_ices_fish_catch.country_codes

6 kB
34 rows
7 columns

CREATE TABLE country_codes (
  "code" VARCHAR,
  "n__description" VARCHAR  -- Description,
  "n__codetype" VARCHAR  -- CodeType,
  "n__deprecated" VARCHAR  -- Deprecated,
  "n__created" VARCHAR  -- Created,
  "n__modified" VARCHAR  -- Modified,
  "n" VARCHAR
);

Fish Catches

@kaggle.victorgenin_ices_fish_catch.fish_catches

450.09 kB
49,110 rows
25 columns

CREATE TABLE fish_catches (
  "species" VARCHAR,
  "area" VARCHAR,
  "units" VARCHAR,
  "country" VARCHAR,
  "n_2014" DOUBLE  -- 2014,
  "n_2013" DOUBLE  -- 2013,
  "n_2012" DOUBLE  -- 2012,
  "n_2011" DOUBLE  -- 2011,
  "n_2010" DOUBLE  -- 2010,
  "n_2009" DOUBLE  -- 2009,
  "n_2008" DOUBLE  -- 2008,
  "n_2007" DOUBLE  -- 2007,
  "n_2006" DOUBLE  -- 2006,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24
);