Difference between revisions of "Energy data"
| Line 104: | Line 104: | ||
<code> | <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 ; | 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> | ||
| + | |||
| + | German cross-border transmissions | ||
| + | <code> | ||
| + | select left(operatorkey,2), date_trunc('month', periodto), round(sum(value)) from flows where pointkey in (select pointKey from operator where pointtype like 'Cross-Border Transmission IP%' and tsoCountry = 'DE' and isPipeInPipe = 'False') group by left(operatorkey,2), date_trunc('month', periodto) order by left(operatorkey,2), date_trunc('month', periodto); | ||
</code> | </code> | ||
Revision as of 21:30, 11 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
| 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 |
BDEW
- BDEW, Germany: Monatlicher Erdgasverbrauch in Deutschland 2022 - Vorjahresvergleich, retrieved 12 July 2022
Eurostat
- Eurostat, EU: Supply, transformation and consumption of gas, retrieved 30 March 2022
- Eurostat, EU: Imports of natural gas by partner country - monthly data, retrieved 4 April 2022
- Eurostat, GERMANY: Imports of natural gas by partner country - monthly data, retrieved 4 July 2022
- Eurostat, GERMANY: Exports of natural gas by partner country - monthly data, retrieved 4 July 2022
EU
Gas storage inventory
- AGSI, EU: Gas in storage (current + historical data)
- Uniper, Uniper: Gas storage dashboard
- storengy, Gas storage portal
Data not in AGSI summary:
- Enercity, Gasspeicher Hannover
- TEAG, UGS Allmenhausen
- Enovos, Gasspeicher Frankenthal
Bruegel
- Bruegel, EU: Natural gas imports (plots), retrieved 12 July 2022
ENTSOG gas data
- ENTSOG API manual ENTSOG (2018), ENTSOG Transparency Platform API User Manual (PDF)
- ENTSOG. “ENTSOG - TP User Manual_v_4.5.Pdf,” 2021. https://www.entsog.eu/sites/default/files/2021-07/ENTSOG%20-%20TP%20User%20Manual_v_4.5.pdf.
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 ;
German cross-border transmissions
select left(operatorkey,2), date_trunc('month', periodto), round(sum(value)) from flows where pointkey in (select pointKey from operator where pointtype like 'Cross-Border Transmission IP%' and tsoCountry = 'DE' and isPipeInPipe = 'False') group by left(operatorkey,2), date_trunc('month', periodto) order by left(operatorkey,2), date_trunc('month', periodto);
Python scripts: git clone https://git.embargo.energy/entsog.git
EU: Energy prices
- European Commission, EU: Energy price dashboard - historical data, retrieved 23 July 2022