Catches - South-west Atlantic

Eurostat code: fish_ca_atl41_h · (1950 - 1999)

@eurostat.fish_ca_atl41_h

Table List

2 tables(96.59 KB)

Catches - South-west Atlantic - Unpivoted

Catches - South-west Atlantic - Unpivoted

@eurostat.fish_ca_atl41_h.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.

34.32 KB
11561 rows
7 columns

freq Freq	species Species	fishreg Fishreg	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total fishery products	Atlantic, Southwest	Tonnes live weight	Germany	1965
Annual	Total aquatic animals	Atlantic, Southwest	Tonnes live weight	Germany	1965
Annual	Total finfish	Atlantic, Southwest	Tonnes live weight	Germany	1965
Annual	Total finfish and shellfish	Atlantic, Southwest	Tonnes live weight	Germany	1965
Annual	Marine fishes	Atlantic, Southwest	Tonnes live weight	Germany	1965
Annual	Cods, hakes, haddocks	Atlantic, Southwest	Tonnes live weight	Germany	1965
Annual	Marine fishes not identified	Atlantic, Southwest	Tonnes live weight	Germany	1965
Annual	Gadiformes (Gadiformes nei)	Atlantic, Southwest	Tonnes live weight	Germany	1965
Annual	Actinopterygii (Marine fishes nei)	Atlantic, Southwest	Tonnes live weight	Germany	1965
Annual	Total fishery products	Atlantic, Southwest	Tonnes live weight	Germany	1966	200


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.