Baselight
Sign In

Fish Catches, ENP-East Countries

Eurostat code: enpe_fish_ca_main ยท (2005 - 2023)

@eurostat.enpe_fish_ca_main

Fish Catches, ENP-East Countries - Unpivoted
@eurostat.enpe_fish_ca_main.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.

  • 4.2 KB
  • 37 rows
  • 5 columns
freq

Freq

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualTonnes live weightAzerbaijan2005
AnnualTonnes live weightUkraine2005228190
AnnualTonnes live weightAzerbaijan2006
AnnualTonnes live weightUkraine2006192140
AnnualTonnes live weightAzerbaijan2007
AnnualTonnes live weightUkraine2007170460
AnnualTonnes live weightAzerbaijan2008
AnnualTonnes live weightUkraine2008203300
AnnualTonnes live weightAzerbaijan2009
AnnualTonnes live weightUkraine2009214650

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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