Supply, Transformation And Consumption Of Electricity

Eurostat code: nrg_cb_e · (1990 - 2023)

@eurostat.nrg_cb_e

Table List

2 tables(602.23 KB)

Supply, Transformation And Consumption Of Electricity - Raw

Supply, Transformation And Consumption Of Electricity - Unpivoted

Supply, Transformation And Consumption Of Electricity - Unpivoted

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

264.93 KB
74156 rows
7 columns

freq Freq	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Available for final consumption	Electricity	Gigawatt-hour	Albania	1990	1780
Annual	Available for final consumption	Electricity	Gigawatt-hour	Austria	1990	43577
Annual	Available for final consumption	Electricity	Gigawatt-hour	Belgium	1990	59108
Annual	Available for final consumption	Electricity	Gigawatt-hour	Bulgaria	1990	36484
Annual	Available for final consumption	Electricity	Gigawatt-hour	Cyprus	1990	1816
Annual	Available for final consumption	Electricity	Gigawatt-hour	Czechia	1990	53037
Annual	Available for final consumption	Electricity	Gigawatt-hour	Germany	1990	481001
Annual	Available for final consumption	Electricity	Gigawatt-hour	Denmark	1990	28862
Annual	Available for final consumption	Electricity	Gigawatt-hour	Euro area – 20 countries (from 2023)	1990	1536580.643
Annual	Available for final consumption	Electricity	Gigawatt-hour	Estonia	1990	7299


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.