Difference between revisions of "Energy data"

From embargo
Jump to navigation Jump to search
Line 68: Line 68:
 
* {{Citation | vauthors=Enercity | title=Gasspeicher Hannover | url=https://www.gasspeicher-hannover.de/speicherbau-und-betrieb/speicherbetrieb/aktuelle-bewegungsdaten.html}}
 
* {{Citation | vauthors=Enercity | title=Gasspeicher Hannover | url=https://www.gasspeicher-hannover.de/speicherbau-und-betrieb/speicherbetrieb/aktuelle-bewegungsdaten.html}}
 
* {{Citation | vauthors=TEAG | title=UGS Allmenhausen | url=https://www.thueringerenergie.de/Ueber_uns/Geschaeftsfelder/Speicher/Betriebsdaten}}
 
* {{Citation | vauthors=TEAG | title=UGS Allmenhausen | url=https://www.thueringerenergie.de/Ueber_uns/Geschaeftsfelder/Speicher/Betriebsdaten}}
 +
* {{Citation | vauthors=storengy | title=Gas storage portal | url=https://storageportal.storengy.de/storage-information/storage-info/map}}
  
 
== Bruegel ==
 
== Bruegel ==

Revision as of 18:36, 7 August 2022

Here we list energy open data:

Germany

Trading Hub Europe

THE, Germany: Daily gas consumption

Bundesnetzagentur

BNetzA, Germany: Daily briefings about gas imports, storage, and consumption

Realized gas savings in 2022
Month 2021 2022 Diff. Diff.
TWh TWh TWh %
Jan 142.3 129 -13.3 -9.3 %
Feb 121.2 106 -15.2 -12.5 %
Mar 109.7 92.5 -17.2 -15.7%
Apr 95.9 82.0 -13.9 -14.5%
May 68.2 51.0 -17.2 -25.2%
Jun 46.1 33.6 -12.5 -27.1%
Jul 40.4
Aug 38.8
Sep 45.3
Oct 73.2
Nov 109.7
Dec 125.6
TOTAL 1016.4 -89.3

BDEW

BDEW: Monthly gas consumption in Germany 2022 vs. 2021

Eurostat

EU

Gas storage inventory

Bruegel

ENTSOG gas data

ENTSOG example query to get physical flows on 01 March 2022:

Some analyses (experimental, feedback welcome):

ENTSOG data as relational database

(Experimental, physical flow data from 01 Jan 2021 to 05 Aug 2022, where flow value is not null)

Postgres access: psql -h embargo.energy -U embargo entsog ; password: 9mTc_9hPjk}&D27/F,VHC8qG

Some tentative examples:

Give out consumption (apparently underestimation)

select left(operatorkey,2), date_trunc('month', periodto), round(sum(value)) from flows where pointkey in (select pointKey from operator where pointtype = 'Aggregated Point - Final Consumers') and flowstatus = 'Confirmed' group by left(operatorkey,2), date_trunc('month', periodto) order by left(operatorkey,2), date_trunc('month', periodto);

Sort by distribution points select pointlabel, operatorlabel, sum(value) from flows where pointkey in (select pointKey from operator where pointtype = 'Aggregated Point - Final Consumers') and periodto > '2022-07-01' and periodto <= '2022-08-01' and left(operatorkey,2) = 'DE' group by operatorlabel, pointlabel order by operatorlabel ;

Python scripts: git clone https://git.embargo.energy/entsog.git

EU: Energy prices