Difference between revisions of "Energy data"
| Line 80: | Line 80: | ||
(Experimental, physical flow data from 01 Jan 2021 to 05 Aug 2022, where flow value is not null) | (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 | + | Postgres access: <code> psql -h embargo.energy -U embargo entsog </code>; password: 9mTc_9hPjk}&D27/F,VHC8qG |
Some tentative examples: | Some tentative examples: | ||
| Line 86: | Line 86: | ||
Give out consumption (apparently underestimation) | 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); | 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> | ||
Revision as of 16:07, 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
| 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, 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
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);
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