Catches - Antarctic - Total

Eurostat code: fish_ca_ant90 · (1950 - 2011)

@eurostat.fish_ca_ant90

Table List

2 tables(79.63 KB)

Catches - Antarctic - Total - Unpivoted

@eurostat.fish_ca_ant90.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

22.93 KB
7194 rows
7 columns

freq Freq	species Species	fishreg Fishreg	unit Unit	geo Geo	time_period Time Period
Annual	Champsocephalus gunnari (Mackerel icefish)	Antarctic - Total	Tonnes live weight	Germany	1970
Annual	Pleuragramma antarctica (Antarctic silverfish)	Antarctic - Total	Tonnes live weight	Germany	1970
Annual	Total fishery products	Antarctic - Total	Tonnes live weight	Germany	1970
Annual	Total aquatic animals	Antarctic - Total	Tonnes live weight	Germany	1970
Annual	Total shellfish	Antarctic - Total	Tonnes live weight	Germany	1970
Annual	Total finfish	Antarctic - Total	Tonnes live weight	Germany	1970
Annual	Total finfish and shellfish	Antarctic - Total	Tonnes live weight	Germany	1970
Annual	Marine fishes	Antarctic - Total	Tonnes live weight	Germany	1970
Annual	Cods, hakes, haddocks	Antarctic - Total	Tonnes live weight	Germany	1970
Annual	Miscellaneous coastal fishes	Antarctic - Total	Tonnes live weight	Germany	1970


CREATE TABLE tidy (
  "freq" VARCHAR,
  "species" VARCHAR,
  "fishreg" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" VARCHAR
);

Share link

Anyone who has the link will be able to view this.