Catches - North-east Pacific

Eurostat code: fish_ca_pac67 · (1970 - 2010)

@eurostat.fish_ca_pac67

Table List

2 tables(42.64 KB)

Catches - North-east Pacific - Unpivoted

Catches - North-east Pacific - Unpivoted

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

10.22 KB
1591 rows
7 columns

freq Freq	species Species	fishreg Fishreg	unit Unit	geo Geo	time_period Time Period
Annual	Gadus chalcogrammus (Alaska pollock(=Walleye poll.))	Pacific, Northeast	Tonnes live weight	Germany	1970
Annual	Squalidae (Dogfish sharks nei)	Pacific, Northeast	Tonnes live weight	Germany	1970
Annual	Total fishery products	Pacific, Northeast	Tonnes live weight	Germany	1970
Annual	Total aquatic animals	Pacific, Northeast	Tonnes live weight	Germany	1970
Annual	Total shellfish	Pacific, Northeast	Tonnes live weight	Germany	1970
Annual	Total finfish	Pacific, Northeast	Tonnes live weight	Germany	1970
Annual	Total finfish and shellfish	Pacific, Northeast	Tonnes live weight	Germany	1970
Annual	Marine fishes	Pacific, Northeast	Tonnes live weight	Germany	1970
Annual	Flounders, halibuts, soles	Pacific, Northeast	Tonnes live weight	Germany	1970
Annual	Cods, hakes, haddocks	Pacific, Northeast	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.