Baselight
Sign In

Annual Aquaculture Production - Live Weight In Tonnes

Eurostat code: med_ag42 ยท (2005 - 2018)

@eurostat.med_ag42

Annual Aquaculture Production - Live Weight In Tonnes - Unpivoted
@eurostat.med_ag42.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.95 KB
  • 266 rows
  • 7 columns
freq

Freq

fishreg

Fishreg

species

Species

aquaenv

Aquaenv

geo

Geo

time_period

Time Period

value

Value

AnnualArea not specifiedTotal fishery productsBrackish waterAlgeria200514
AnnualArea not specifiedTotal fishery productsBrackish waterIsrael2005669
AnnualArea not specifiedTotal fishery productsBrackish waterJordan2005250
AnnualArea not specifiedTotal fishery productsBrackish waterLebanon2005
AnnualArea not specifiedTotal fishery productsBrackish waterPalestine*2005
AnnualArea not specifiedTotal fishery productsBrackish waterTunisia2005
AnnualArea not specifiedTotal fishery productsFreshwaterAlgeria2005330
AnnualArea not specifiedTotal fishery productsFreshwaterEgypt200583803
AnnualArea not specifiedTotal fishery productsFreshwaterIsrael200518539
AnnualArea not specifiedTotal fishery productsFreshwaterJordan2005311

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

Share link

Anyone who has the link will be able to view this.