Energy - Monthly Data

Eurostat code: ei_isen_m · (2008-01 - 2025-03)

@eurostat.ei_isen_m

Table List

2 tables(1016.19 KB)

Energy - Monthly Data - Unpivoted

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

392.05 KB
86168 rows
6 columns

freq Freq	s_adj S Adj	indic Indic	geo Geo	time_period Time Period	value Value
Monthly	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Consumption of electricity - GWh	Austria	2008-01	6187
Monthly	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Consumption of electricity - GWh	Belgium	2008-01	8400
Monthly	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Consumption of electricity - GWh	Bulgaria	2008-01	3808
Monthly	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Consumption of electricity - GWh	Cyprus	2008-01	436
Monthly	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Consumption of electricity - GWh	Czechia	2008-01	6352
Monthly	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Consumption of electricity - GWh	Germany	2008-01	44608
Monthly	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Consumption of electricity - GWh	Denmark	2008-01	3430
Monthly	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Consumption of electricity - GWh	Estonia	2008-01	864
Monthly	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Consumption of electricity - GWh	Greece	2008-01	4751
Monthly	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Consumption of electricity - GWh	Spain	2008-01	24597


CREATE TABLE tidy (
  "freq" VARCHAR,
  "s_adj" VARCHAR,
  "indic" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.