Supply Electricity - Short Term Monthly Data

Eurostat code: nrg_ind_342m · (2008-01 - 2019-12)

@eurostat.nrg_ind_342m

Table List

2 tables(307.76 KB)

Supply Electricity - Short Term Monthly Data - Raw

Supply Electricity - Short Term Monthly Data - Unpivoted

Supply Electricity - Short Term Monthly Data - Unpivoted

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

85.04 KB
22490 rows
7 columns

freq Freq	unit Unit	product Product	indic_nrg Indic Nrg	geo Geo	time_period Time Period	value Value
Monthly	Gigawatt-hour	Electrical energy	Imports	Austria	2008-01	2503
Monthly	Gigawatt-hour	Electrical energy	Imports	Belgium	2008-01	1588
Monthly	Gigawatt-hour	Electrical energy	Imports	Bulgaria	2008-01	467
Monthly	Gigawatt-hour	Electrical energy	Imports	Cyprus	2008-01
Monthly	Gigawatt-hour	Electrical energy	Imports	Czechia	2008-01	1065
Monthly	Gigawatt-hour	Electrical energy	Imports	Germany	2008-01
Monthly	Gigawatt-hour	Electrical energy	Imports	Denmark	2008-01	752
Monthly	Gigawatt-hour	Electrical energy	Imports	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2008-01	15635
Monthly	Gigawatt-hour	Electrical energy	Imports	Estonia	2008-01	17
Monthly	Gigawatt-hour	Electrical energy	Imports	Greece	2008-01	130


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "product" VARCHAR,
  "indic_nrg" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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