Baselight

Final Energy Consumption In Households By Type Of Fuel

Eurostat code: ten00125 ยท (2012 - 2023)

@eurostat.ten00125

Final Energy Consumption In Households By Type Of Fuel - Unpivoted
@eurostat.ten00125.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.

  • 36.65 KB
  • 5280 rows
  • 7 columns
freq

Freq

nrg_bal

Nrg Bal

siec

Siec

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFinal consumption - other sectors - households - energy useSolid fossil fuelsThousand tonnes of oil equivalentAlbania20120.235
AnnualFinal consumption - other sectors - households - energy useSolid fossil fuelsThousand tonnes of oil equivalentAustria201241.86
AnnualFinal consumption - other sectors - households - energy useSolid fossil fuelsThousand tonnes of oil equivalentBelgium201296.128
AnnualFinal consumption - other sectors - households - energy useSolid fossil fuelsThousand tonnes of oil equivalentBulgaria2012231.094
AnnualFinal consumption - other sectors - households - energy useSolid fossil fuelsThousand tonnes of oil equivalentCyprus2012
AnnualFinal consumption - other sectors - households - energy useSolid fossil fuelsThousand tonnes of oil equivalentCzechia2012937.825
AnnualFinal consumption - other sectors - households - energy useSolid fossil fuelsThousand tonnes of oil equivalentGermany2012742.845
AnnualFinal consumption - other sectors - households - energy useSolid fossil fuelsThousand tonnes of oil equivalentDenmark20120.437
AnnualFinal consumption - other sectors - households - energy useSolid fossil fuelsThousand tonnes of oil equivalentEstonia20125.857
AnnualFinal consumption - other sectors - households - energy useSolid fossil fuelsThousand tonnes of oil equivalentGreece20120.383

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.