Supply, Transformation And Consumption Of Electricity - Monthly Data

Eurostat code: nrg_cb_em · (2008-01 - 2025-02)

@eurostat.nrg_cb_em

Table List

2 tables(568.3 KB)

Supply, Transformation And Consumption Of Electricity - Monthly Data - Raw

Supply, Transformation And Consumption Of Electricity - Monthly Data - Unpivoted

Supply, Transformation And Consumption Of Electricity - Monthly Data - Unpivoted

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

197.97 KB
39586 rows
7 columns

freq Freq	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Monthly	Available to internal market	Electricity	Gigawatt-hour	Austria	2008-01	6187
Monthly	Available to internal market	Electricity	Gigawatt-hour	Belgium	2008-01	8400
Monthly	Available to internal market	Electricity	Gigawatt-hour	Bulgaria	2008-01	3808
Monthly	Available to internal market	Electricity	Gigawatt-hour	Cyprus	2008-01	436
Monthly	Available to internal market	Electricity	Gigawatt-hour	Czechia	2008-01	6352
Monthly	Available to internal market	Electricity	Gigawatt-hour	Germany	2008-01	44608
Monthly	Available to internal market	Electricity	Gigawatt-hour	Denmark	2008-01	3430
Monthly	Available to internal market	Electricity	Gigawatt-hour	Estonia	2008-01	864
Monthly	Available to internal market	Electricity	Gigawatt-hour	Greece	2008-01	4751
Monthly	Available to internal market	Electricity	Gigawatt-hour	Spain	2008-01	24597


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.