Baselight
Sign In

Annual Captures Of Fish - Live Weight In Tonnes - By Fishing Areas

Eurostat code: med_ag41 ยท (2005 - 2018)

@eurostat.med_ag41

Annual Captures Of Fish - Live Weight In Tonnes - By Fishing Areas - Unpivoted
@eurostat.med_ag41.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.68 KB
  • 237 rows
  • 7 columns
freq

Freq

fishreg

Fishreg

species

Species

aquaenv

Aquaenv

geo

Geo

time_period

Time Period

value

Value

AnnualTotal fishing areasTotal fishery productsTotalAlgeria2005139458.6
AnnualTotal fishing areasTotal fishery productsTotalEgypt2005265750
AnnualTotal fishing areasTotal fishery productsTotalIsrael20052680
AnnualTotal fishing areasTotal fishery productsTotalJordan20057
AnnualTotal fishing areasTotal fishery productsTotalLebanon20058000
AnnualTotal fishing areasTotal fishery productsTotalMorocco20051036408
AnnualTotal fishing areasTotal fishery productsTotalPalestine*20051813.9
AnnualTotal fishing areasTotal fishery productsTotalTunisia2005108699
AnnualTotal fishing areas except Mediterranean and Black SeaTotal fishery productsTotalEgypt2005158297
AnnualTotal fishing areas except Mediterranean and Black SeaTotal fishery productsTotalJordan20057

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