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 - Raw

Catches - West-central Pacific - Unpivoted

Catches - West-central Pacific - Raw

@eurostat.fish_ca_pac71.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

29.9 KB
135 rows
52 columns

freq Freq	species Species	fishreg Fishreg	unit Unit	geo Geo	n_2000 2000	n_2001 2001	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011
Annual	Sphyraena spp (Barracudas nei)	Pacific, Western Central	Tonnes live weight	Russia
Annual	Thunnus obesus (Bigeye tuna)	Pacific, Western Central	Tonnes live weight	European Economic Area (EU15 - 1995-2004 and IS, LI, NO)	3644	734	884	834	750	3102	5824	3911
Annual	Thunnus obesus (Bigeye tuna)	Pacific, Western Central	Tonnes live weight	European Economic Area (EU25 - 2004-2006 and IS, LI, NO)	3644	734	884	834	750	3102	5824	3911
Annual	Thunnus obesus (Bigeye tuna)	Pacific, Western Central	Tonnes live weight	European Economic Area (EU27 - 2007-2013 and IS, LI, NO)	3644	734	884	834	750	3102	5824	3911
Annual	Thunnus obesus (Bigeye tuna)	Pacific, Western Central	Tonnes live weight	Spain	3644	734	884	834	750	3102	5824	3911	2	2044
Annual	Thunnus obesus (Bigeye tuna)	Pacific, Western Central	Tonnes live weight	European Union - 15 countries (1995-2004)	3644	734	884	834	750	3102	5824	3911		2044
Annual	Thunnus obesus (Bigeye tuna)	Pacific, Western Central	Tonnes live weight	European Union - 25 countries (2004-2006)	3644	734	884	834	750	3102	5824	3911		2044
Annual	Thunnus obesus (Bigeye tuna)	Pacific, Western Central	Tonnes live weight	European Union - 27 countries (2007-2013)	3644	734	884	834	750	3102	5824	3911		2044
Annual	Thunnus obesus (Bigeye tuna)	Pacific, West central / (not specified)	Tonnes live weight	Spain					750	3102	5824	3911		2044
Annual	Thunnus obesus (Bigeye tuna)	Pacific, West central / (not specified)	Tonnes live weight	European Union - 15 countries (1995-2004)					750	3102	5824	3911		2044


CREATE TABLE raw (
  "freq" VARCHAR,
  "species" VARCHAR,
  "fishreg" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1950" VARCHAR,
  "n_1951" VARCHAR,
  "n_1952" VARCHAR,
  "n_1953" VARCHAR,
  "n_1954" VARCHAR,
  "n_1955" VARCHAR,
  "n_1956" VARCHAR,
  "n_1957" VARCHAR,
  "n_1958" VARCHAR,
  "n_1959" VARCHAR,
  "n_1960" VARCHAR,
  "n_1961" VARCHAR,
  "n_1962" VARCHAR,
  "n_1963" VARCHAR,
  "n_1964" VARCHAR,
  "n_1980" VARCHAR,
  "n_1981" VARCHAR,
  "n_1982" VARCHAR,
  "n_1983" VARCHAR,
  "n_1984" VARCHAR,
  "n_1985" VARCHAR,
  "n_1986" VARCHAR,
  "n_1987" VARCHAR,
  "n_1988" VARCHAR,
  "n_1989" VARCHAR,
  "n_1990" VARCHAR,
  "n_1991" VARCHAR,
  "n_1992" VARCHAR,
  "n_1993" VARCHAR,
  "n_1994" VARCHAR,
  "n_1995" VARCHAR,
  "n_1996" VARCHAR,
  "n_1997" VARCHAR,
  "n_1998" VARCHAR,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" VARCHAR,
  "n_2003" VARCHAR,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE
);