Baselight

Supply, Transformation And Consumption Of Renewables And Wastes

Eurostat code: nrg_cb_rw · (1990 - 2023)

@eurostat.nrg_cb_rw

Supply, Transformation And Consumption Of Renewables And Wastes - Unpivoted
@eurostat.nrg_cb_rw.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.

  • 799.31 KB
  • 1326214 rows
  • 7 columns
freq

Freq

nrg_bal

Nrg Bal

siec

Siec

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualDistribution lossesPrimary solid biofuelsTerajouleAlbania1990
AnnualDistribution lossesPrimary solid biofuelsTerajouleAustria1990
AnnualDistribution lossesPrimary solid biofuelsTerajouleBelgium1990
AnnualDistribution lossesPrimary solid biofuelsTerajouleBulgaria1990
AnnualDistribution lossesPrimary solid biofuelsTerajouleCyprus1990
AnnualDistribution lossesPrimary solid biofuelsTerajouleCzechia1990
AnnualDistribution lossesPrimary solid biofuelsTerajouleGermany1990
AnnualDistribution lossesPrimary solid biofuelsTerajouleDenmark1990
AnnualDistribution lossesPrimary solid biofuelsTerajouleEuro area – 20 countries (from 2023)199080
AnnualDistribution lossesPrimary solid biofuelsTerajouleEstonia1990

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

Share link

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