Difference between revisions of "Energy data"

From embargo
Jump to navigation Jump to search
 
(25 intermediate revisions by 5 users not shown)
Line 4: Line 4:
  
 
== Trading Hub Europe ==
 
== Trading Hub Europe ==
 
+
* {{Citation | vauthors=((THE: Market area monitor)) | title=Germany: Import / Export / Consumption / Storage | url=https://www.tradinghub.eu/en-gb/Publications/Transparency/Market-area-monitor}}
{{Citation | vauthors=((THE)) | title=Germany: Daily gas consumption | url=https://www.tradinghub.eu/en-gb/Publications/Transparency/Aggregated-consumption-data#}}
+
* {{Citation | vauthors=((THE)) | title=Germany: Daily gas consumption | url=https://www.tradinghub.eu/en-gb/Publications/Transparency/Aggregated-consumption-data#}}
 +
* Historical data (before Oct. 2021): {{Citation | title=GASPOOL: Aggregated gas consumption | url=https://www.tradinghub.eu/Portals/0/Archiv%20GASPOOL/verbrauchsdaten-gesamt[1].csv?ver=BY7wJ3jSq7CqEWv7Qtka1w%3d%3d}} / {{Citation | title=NetConnect: Aggregated gas consumption | url=https://www.tradinghub.eu/Portals/0/Archiv%20NCG/AggregatedConsumptionData[1].csv?ver=QvIUEDkSVZrhNqQ9YEsu8w%3d%3d}}
 +
* API documentation: https://datenservice.tradinghub.eu/Dokumente/The_XML_Interface_V1.0_en.pdf
 +
** e.g. query on consumption <code> https://datenservice.tradinghub.eu/XmlInterface/getXML.ashx?ReportId=AggregatedConsumptionData&Start=01-08-2022&End=15-08-2022</code>
 +
* Aggregated data from 2011 to 2022: https://files.embargo.energy/the-analysis/the_gas_consumption_2011_to_2022.ods
 +
* Dashboard visualizing daily gas consumption in Germany see https://embargo.energy:3000/d/bRM7QBZVk/the?orgId=1&from=1504453425838&to=1662219825839 , this is is using downloads of the aforementioned XML interface as well as the aforemented historical data, python scripts: git clone https://git.embargo.energy/entsog.git.
 +
* Interpretation at zeit.de (Split consumer/producer):  <nowiki>https://twitter.com/c_endt/status/1566689441992810497</nowiki>
  
 
== Bundesnetzagentur ==
 
== Bundesnetzagentur ==
  
 
{{Citation | vauthors=BNetzA | title=Germany: Daily briefings about gas imports, storage, and consumption | url=https://www.bundesnetzagentur.de/DE/Fachthemen/ElektrizitaetundGas/Versorgungssicherheit/aktuelle_gasversorgung/start.html}}
 
{{Citation | vauthors=BNetzA | title=Germany: Daily briefings about gas imports, storage, and consumption | url=https://www.bundesnetzagentur.de/DE/Fachthemen/ElektrizitaetundGas/Versorgungssicherheit/aktuelle_gasversorgung/start.html}}
 
:
 
  
 
{| class="wikitable" style=";text-align:right;width:50%"
 
{| class="wikitable" style=";text-align:right;width:50%"
Line 24: Line 28:
 
| Feb || 121.2 || 106 || -15.2 || -12.5 %
 
| Feb || 121.2 || 106 || -15.2 || -12.5 %
 
|-
 
|-
| Mar || 109.7 || 92.5 || -17.2 || -15.7%
+
| Mar || 109.7 || 92.5 || -17.2 || -15.7 %
 
|-
 
|-
| Apr || 95.9 || 82.0 || -13.9 || -14.5%
+
| Apr || 95.9 || 82.0 || -13.9 || -14.5 %
 
|-
 
|-
| May || 68.2 || 51.0 || -17.2 || -25.2%
+
| May || 68.2 || 51.0 || -17.2 || -25.2 %
 
|-
 
|-
| Jun || 46.1 || 33.6 || -12.5 || -27.1%
+
| Jun || 46.1 || 39.6 || -6.5 || -14.1 %
 
|-
 
|-
| Jul || 40.4 || || ||  
+
| Jul || 40.4 || 39.1 || -1.3 || -3.2 %
 
|-
 
|-
 
| Aug || 38.8 ||  ||  ||  
 
| Aug || 38.8 ||  ||  ||  
Line 44: Line 48:
 
| Dec || 125.6 ||  ||  ||  
 
| Dec || 125.6 ||  ||  ||  
 
|-
 
|-
| TOTAL || 1016.4 ||  || -89.3 ||  
+
| TOTAL || 1016.4 ||  || -84.6 ||  
 
|}
 
|}
 +
 +
 +
https://www.bundesnetzagentur.de/DE/Fachthemen/ElektrizitaetundGas/Versorgungssicherheit/aktuelle_gasversorgung/_downloads/08_August/220825_gaslage.pdf?__blob=publicationFile&v=3#page=5
 +
https://www.bundesnetzagentur.de/DE/Fachthemen/ElektrizitaetundGas/Versorgungssicherheit/aktuelle_gasversorgung/start.html
  
 
== BDEW ==
 
== BDEW ==
Line 76: Line 84:
  
 
* {{Citation | vauthors=Bruegel | title=EU: Natural gas imports (plots) | url=https://www.bruegel.org/dataset/european-natural-gas-imports | access-date=12 July 2022}}
 
* {{Citation | vauthors=Bruegel | title=EU: Natural gas imports (plots) | url=https://www.bruegel.org/dataset/european-natural-gas-imports | access-date=12 July 2022}}
 +
* {{Citation | vauthors=Bruegel | title=Energy policy responses to crisis | url=https://www.bruegel.org/dataset/national-energy-policy-responses-energy-crisis | access-date=19 October 2022}}
 +
* https://www.bruegel.org/dataset/european-natural-gas-demand-tracker
  
 
== ENTSOG gas data ==
 
== ENTSOG gas data ==
Line 87: Line 97:
 
* https://files.embargo.energy/entsog-analysis/
 
* https://files.embargo.energy/entsog-analysis/
  
=== ENTSOG data as relational database ===
+
[[ENTSOG data analysis]]
 
 
(Experimental, physical flow data from 01 Jan 2021 to 05 Aug 2022, where flow value is not null)
 
 
 
Postgres access: <code> psql -h embargo.energy -U embargo entsog </code>; password: 9mTc_9hPjk}&D27/F,VHC8qG
 
 
 
Some tentative examples:
 
 
 
Give out consumption (apparently underestimation)
 
 
 
<code>
 
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);
 
</code>
 
 
 
Sort by distribution points
 
<code>
 
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 ;
 
</code>
 
  
Python scripts: <code>git clone https://git.embargo.energy/entsog.git</code>
 
  
 
== EU: Energy prices ==
 
== EU: Energy prices ==
  
 
* {{Citation | vauthors=((European Commission)) | title=EU: Energy price dashboard - historical data | url=https://energy.ec.europa.eu/data-and-analysis/energy-prices-and-costs-europe/dashboard-energy-prices-eu-and-main-trading-partners_en | access-date=23 July 2022}}
 
* {{Citation | vauthors=((European Commission)) | title=EU: Energy price dashboard - historical data | url=https://energy.ec.europa.eu/data-and-analysis/energy-prices-and-costs-europe/dashboard-energy-prices-eu-and-main-trading-partners_en | access-date=23 July 2022}}

Latest revision as of 21:55, 25 October 2022

Here we list energy open data:

Germany[edit | edit source]

Trading Hub Europe[edit | edit source]

Bundesnetzagentur[edit | edit source]

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 39.6 -6.5 -14.1 %
Jul 40.4 39.1 -1.3 -3.2 %
Aug 38.8
Sep 45.3
Oct 73.2
Nov 109.7
Dec 125.6
TOTAL 1016.4 -84.6


https://www.bundesnetzagentur.de/DE/Fachthemen/ElektrizitaetundGas/Versorgungssicherheit/aktuelle_gasversorgung/_downloads/08_August/220825_gaslage.pdf?__blob=publicationFile&v=3#page=5 https://www.bundesnetzagentur.de/DE/Fachthemen/ElektrizitaetundGas/Versorgungssicherheit/aktuelle_gasversorgung/start.html

BDEW[edit | edit source]

BDEW: Monthly gas consumption in Germany 2022 vs. 2021

Eurostat[edit | edit source]

EU[edit | edit source]

Gas storage inventory[edit | edit source]

Data not in AGSI summary:

Bruegel[edit | edit source]

ENTSOG gas data[edit | edit source]

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

Some analyses (experimental, feedback welcome):

ENTSOG data analysis


EU: Energy prices[edit | edit source]