Disaggregated Final Energy Consumption In Households - Quantities

Eurostat code: nrg_d_hhq · (2010 - 2023)

@eurostat.nrg_d_hhq

Table List

2 tables(427.97 KB)

Disaggregated Final Energy Consumption In Households - Quantities - Raw

Disaggregated Final Energy Consumption In Households - Quantities - Unpivoted

Disaggregated Final Energy Consumption In Households - Quantities - Unpivoted

@eurostat.nrg_d_hhq.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.

210.66 KB
57128 rows
7 columns

freq Freq	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Final consumption - other sectors - households - energy use	Electricity	Gigawatt-hour	Albania	2010	2997.45
Annual	Final consumption - other sectors - households - energy use	Electricity	Gigawatt-hour	Austria	2010	17657.493
Annual	Final consumption - other sectors - households - energy use	Electricity	Gigawatt-hour	Bosnia and Herzegovina	2010
Annual	Final consumption - other sectors - households - energy use	Electricity	Gigawatt-hour	Belgium	2010
Annual	Final consumption - other sectors - households - energy use	Electricity	Gigawatt-hour	Bulgaria	2010	10559
Annual	Final consumption - other sectors - households - energy use	Electricity	Gigawatt-hour	Cyprus	2010
Annual	Final consumption - other sectors - households - energy use	Electricity	Gigawatt-hour	Czechia	2010
Annual	Final consumption - other sectors - households - energy use	Electricity	Gigawatt-hour	Germany	2010	141700
Annual	Final consumption - other sectors - households - energy use	Electricity	Gigawatt-hour	Denmark	2010
Annual	Final consumption - other sectors - households - energy use	Electricity	Gigawatt-hour	Euro area – 20 countries (from 2023)	2010	448642.857


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.