Baselight

Global Mean Surface Seawater Acidity

Eurostat code: sdg_14_50 ยท (1985 - 2022)

@eurostat.sdg_14_50

Global Mean Surface Seawater Acidity - Unpivoted
@eurostat.sdg_14_50.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.

  • 3.92 KB
  • 38 rows
  • 4 columns
freq

Freq

indic_env

Indic Env

time_period

Time Period

value

Value

AnnualGlobal pH value19858.110209
AnnualGlobal pH value19868.10902
AnnualGlobal pH value19878.107591
AnnualGlobal pH value19888.104618
AnnualGlobal pH value19898.103392
AnnualGlobal pH value19908.102387
AnnualGlobal pH value19918.101378
AnnualGlobal pH value19928.100578
AnnualGlobal pH value19938.100015
AnnualGlobal pH value19948.098082

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

Share link

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