Annual Nominal Fish Catches

Explore the impact of overfishing in the Northeast Atlantic region.

@kaggle.victorgenin_ices_fish_catch

Table List

2 tables(445.41 KB)

Fish Catches

@kaggle.victorgenin_ices_fish_catch.fish_catches

439.54 KB
49110 rows
25 columns

species Species	area Area	units Units	country Country	n_2014 2014	n_2013 2013	n_2012 2012	n_2011 2011	n_2010 2010	n_2009 2009	n_2008 2008	n_2007 2007	n_2006 2006
ANF	27	TLW	BE	993	1633	1716	1279	1031	853	964	1363	1193
ANF	27.4	TLW	BE	217	137	133	116	131	140	185	181	141
ANF	27.4.A	TLW	BE
ANF	27.4.B	TLW	BE	213	135	131	111	124	134	181	179	138
ANF	27.4.C	TLW	BE	4	2	2	6	7	6	4	3	3
ANF	27.7	TLW	BE	491	1124	1382	966	721	518	585	1040	907
ANF	27.7.A	TLW	BE	26	47	58	27	19	19	29	73	69
ANF	27.7.B	TLW	BE								1
ANF	27.7.D	TLW	BE	98	49	59	95	127	56	43	44	21
ANF	27.7.E	TLW	BE	42	95	144	138	94	73	101	242	217


CREATE TABLE fish_catches (
  "species" VARCHAR,
  "area" VARCHAR,
  "units" VARCHAR,
  "country" VARCHAR,
  "n_2014" DOUBLE,
  "n_2013" DOUBLE,
  "n_2012" DOUBLE,
  "n_2011" DOUBLE,
  "n_2010" DOUBLE,
  "n_2009" DOUBLE,
  "n_2008" DOUBLE,
  "n_2007" DOUBLE,
  "n_2006" DOUBLE,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR
);