Baselight

Climate Related Economic Losses

Eurostat code: sdg_13_40 ยท (1980 - 2023)

@eurostat.sdg_13_40

Climate Related Economic Losses - Unpivoted
@eurostat.sdg_13_40.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.

  • 19 KB
  • 3892 rows
  • 7 columns
freq

Freq

statinfo

Statinfo

unit

Unit

stk_flow

Stk Flow

geo

Geo

time_period

Time Period

value

Value

AnnualAnnual valueCurrent prices, euro per capitaLossesAustria1980
AnnualAnnual valueCurrent prices, euro per capitaLossesBelgium1980
AnnualAnnual valueCurrent prices, euro per capitaLossesBulgaria1980
AnnualAnnual valueCurrent prices, euro per capitaLossesSwitzerland1980
AnnualAnnual valueCurrent prices, euro per capitaLossesCyprus1980
AnnualAnnual valueCurrent prices, euro per capitaLossesCzechia1980
AnnualAnnual valueCurrent prices, euro per capitaLossesGermany19800.78
AnnualAnnual valueCurrent prices, euro per capitaLossesDenmark1980
AnnualAnnual valueCurrent prices, euro per capitaLossesEstonia1980
AnnualAnnual valueCurrent prices, euro per capitaLossesGreece1980

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

Share link

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