Baselight
Sign In

Final Energy Consumption In Households Per Capita

Eurostat code: sdg_07_20 ยท (2000 - 2023)

@eurostat.sdg_07_20

Final Energy Consumption In Households Per Capita - Unpivoted
@eurostat.sdg_07_20.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.

  • 8.25 KB
  • 923 rows
  • 5 columns
freq

Freq

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualKilogram of oil equivalent (KGOE)Albania2000123
AnnualKilogram of oil equivalent (KGOE)Austria2000792
AnnualKilogram of oil equivalent (KGOE)Belgium2000926
AnnualKilogram of oil equivalent (KGOE)Bulgaria2000257
AnnualKilogram of oil equivalent (KGOE)Cyprus2000253
AnnualKilogram of oil equivalent (KGOE)Czechia2000628
AnnualKilogram of oil equivalent (KGOE)Germany2000795
AnnualKilogram of oil equivalent (KGOE)Denmark2000790
AnnualKilogram of oil equivalent (KGOE)Estonia2000663
AnnualKilogram of oil equivalent (KGOE)Greece2000422

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