Electricity Production And Self-consumption By Sector And Fuel

Eurostat code: nrg_ind_epsc · (1990 - 2023)

@eurostat.nrg_ind_epsc

Table List

2 tables(84.09 KB)

Electricity Production And Self-consumption By Sector And Fuel - Raw

Electricity Production And Self-consumption By Sector And Fuel - Unpivoted

Electricity Production And Self-consumption By Sector And Fuel - Unpivoted

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

26.44 KB
22435 rows
8 columns

freq Freq	customer Customer	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period
Annual	Household	Autoconsumption	Natural gas	Gigawatt-hour	Denmark	1990
Annual	Household	Autoconsumption	Natural gas	Gigawatt-hour	Spain	1990
Annual	Household	Autoconsumption	Natural gas	Gigawatt-hour	Ireland	1990
Annual	Household	Autoconsumption	Biofuels	Gigawatt-hour	Denmark	1990
Annual	Household	Autoconsumption	Biofuels	Gigawatt-hour	Spain	1990
Annual	Household	Autoconsumption	Biofuels	Gigawatt-hour	Ireland	1990
Annual	Household	Autoconsumption	Wind	Gigawatt-hour	Denmark	1990
Annual	Household	Autoconsumption	Wind	Gigawatt-hour	Spain	1990
Annual	Household	Autoconsumption	Wind	Gigawatt-hour	Ireland	1990
Annual	Household	Autoconsumption	Solar	Gigawatt-hour	Denmark	1990


CREATE TABLE tidy (
  "freq" VARCHAR,
  "customer" 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.