Catches - West-central Pacific

Eurostat code: fish_ca_pac71 · (1950 - 2011)

@eurostat.fish_ca_pac71

Table List

2 tables(36.69 KB)

Catches - West-central Pacific - Unpivoted

Catches - West-central Pacific - Unpivoted

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

6.79 KB
807 rows
7 columns

freq Freq	species Species	fishreg Fishreg	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total fishery products	Pacific, Western Central	Tonnes live weight	European Economic Area (EU15 - 1995-2004 and IS, LI, NO)	1999	7176
Annual	Total fishery products	Pacific, Western Central	Tonnes live weight	European Economic Area (EU25 - 2004-2006 and IS, LI, NO)	1999	7176
Annual	Total fishery products	Pacific, Western Central	Tonnes live weight	European Economic Area (EU27 - 2007-2013 and IS, LI, NO)	1999	7176
Annual	Total fishery products	Pacific, Western Central	Tonnes live weight	Spain	1999	7176
Annual	Total fishery products	Pacific, Western Central	Tonnes live weight	European Union - 15 countries (1995-2004)	1999	7176
Annual	Total fishery products	Pacific, Western Central	Tonnes live weight	European Union - 25 countries (2004-2006)	1999	7176
Annual	Total fishery products	Pacific, Western Central	Tonnes live weight	European Union - 27 countries (2007-2013)	1999	7176
Annual	Total aquatic animals	Pacific, Western Central	Tonnes live weight	European Economic Area (EU15 - 1995-2004 and IS, LI, NO)	1999	7176
Annual	Total aquatic animals	Pacific, Western Central	Tonnes live weight	European Economic Area (EU25 - 2004-2006 and IS, LI, NO)	1999	7176
Annual	Total aquatic animals	Pacific, Western Central	Tonnes live weight	European Economic Area (EU27 - 2007-2013 and IS, LI, NO)	1999	7176


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.