# # Open Power System Data # # Time series Datapackage # # sources.yml : Parameters required for downloading and parsing data from sources # ENTSO-E Transparency FTP: Actual Generation per Production Type: host: 'sftp-transparency.entsoe.eu' port: 22 path: TP_export/AggregatedGenerationPerType/ filename: '{u_start.year}_{u_start.month}_AggregatedGenerationPerType.csv' frequency: monthly start: 2014-12-01 end: recent filetype: csv resolution: - 15min - 30min - 60min web: https://transparency.entsoe.eu/generation/r2/actualGenerationPerProductionType/show cols: DateTime: timestamp ResolutionCode: resolution AreaName: region ProductionType: variable ActualGenerationOutput: generation_actual # not used: 'ActualConsumption' renewables: Solar: solar Wind Onshore: wind_onshore Wind Offshore: wind_offshore stacked: - region - variable ##ProductionType_Name unstacked: attribute append_headers: source: ENTSO-E Transparency web: https://transparency.entsoe.eu/generation/r2/actualGenerationPerProductionType/show unit: MW Actual Total Load: host: 'sftp-transparency.entsoe.eu' port: 22 path: TP_export/ActualTotalLoad/ filename: '{u_start.year}_{u_start.month}_ActualTotalLoad.csv' frequency: monthly start: 2014-12-01 end: recent filetype: csv resolution: - 15min - 30min - 60min web: https://transparency.entsoe.eu/load-domain/r2/totalLoadR2/show cols: DateTime: timestamp ResolutionCode: resolution AreaName: region TotalLoadValue: load stacked: - region unstacked: variable append_headers: attribute: actual_entsoe_transparency source: ENTSO-E Transparency web: https://transparency.entsoe.eu/load-domain/r2/totalLoadR2/show unit: MW Day-ahead Total Load Forecast: host: 'sftp-transparency.entsoe.eu' port: 22 path: TP_export/DayAheadTotalLoadForecast/ filename: '{u_start.year}_{u_start.month}_DayAheadTotalLoadForecast.csv' frequency: monthly start: 2014-12-01 end: recent filetype: csv resolution: - 15min - 30min - 60min web: https://transparency.entsoe.eu/load-domain/r2/totalLoadR2/show cols: DateTime: timestamp ResolutionCode: resolution AreaName: region TotalLoadValue: load stacked: - region unstacked: variable append_headers: attribute: forecast_entsoe_transparency source: ENTSO-E Transparency web: https://transparency.entsoe.eu/load-domain/r2/totalLoadR2/show unit: MW Day-ahead Prices: host: 'sftp-transparency.entsoe.eu' port: 22 path: TP_export/DayAheadPrices/ filename: '{u_start.year}_{u_start.month}_DayAheadPrices.csv' frequency: monthly start: 2014-12-01 end: recent filetype: csv resolution: - 15min - 30min - 60min web: https://transparency.entsoe.eu/transmission-domain/r2/dayAheadPrices/show cols: DateTime: timestamp ResolutionCode: resolution AreaName: region Price: price Currency: unit stacked: - region - unit unstacked: variable append_headers: attribute: day_ahead source: ENTSO-E Transparency web: https://transparency.entsoe.eu/transmission-domain/r2/dayAheadPrices/show OPSD: capacity: url_template: https://data.open-power-system-data.org/renewable_power_plants/2019-04-05/renewable_capacity_timeseries.csv filename: renewable_capacity_timeseries.csv url_params_template: frequency: single file start: 1901-01-01 end: 2019-01-21 filetype: csv resolution: - days web: http://data.open-power-system-data.org/renewable_power_plants colmap: CH: attribute: capacity region: CH source: own calculation based on Swiss Bundesamt für Energie (BFE) unit: MW variable: '{variable}' web: https://data.open-power-system-data.org/renewable_power_plants DE: attribute: capacity region: DE source: own calculation based on BNetzA and netztransparenz.de unit: MW variable: '{variable}' web: https://data.open-power-system-data.org/renewable_power_plants DK: attribute: capacity region: DK source: own calculation based on Energinet.dk and Energistyrelsen unit: MW variable: '{variable}' web: https://data.open-power-system-data.org/renewable_power_plants GB-UKM: attribute: capacity region: GB_UKM source: own calculation based on UK Government Department of Business, Energy & Industrial Strategy (BEIS) unit: MW variable: '{variable}' web: https://data.open-power-system-data.org/renewable_power_plants GB-GBN: attribute: capacity region: GB_GBN source: own calculation based on UK Government Department of Business, Energy & Industrial Strategy (BEIS) unit: MW variable: '{variable}' web: https://data.open-power-system-data.org/renewable_power_plants GB-NIR: attribute: capacity region: GB_NIR source: own calculation based on UK Government Department of Business, Energy & Industrial Strategy (BEIS) unit: MW variable: '{variable}' web: https://data.open-power-system-data.org/renewable_power_plants Offshore: attribute: capacity region: DE source: own calculation based on BNetzA and netztransparenz.de unit: MW variable: wind_offshore web: https://data.open-power-system-data.org/renewable_power_plants Onshore: attribute: capacity region: DE source: own calculation based on BNetzA and netztransparenz.de unit: MW variable: wind_onshore web: https://data.open-power-system-data.org/renewable_power_plants Wind: attribute: capacity region: DE source: own calculation based on BNetzA and netztransparenz.de unit: MW variable: wind web: https://data.open-power-system-data.org/renewable_power_plants Solar: attribute: capacity region: DE source: own calculation based on BNetzA and netztransparenz.de unit: MW variable: solar web: https://data.open-power-system-data.org/renewable_power_plants ENTSO-E Data Portal: load: url_template: https://docstore.entsoe.eu/Documents/Publications/Statistics/Monthly-hourly-load-values_2006-2015.xlsx url_params_template: frequency: single file start: 2006-01-01 end: 2015-12-31 filetype: xls resolution: - 60min web: https://www.entsoe.eu/data/power-stats/ filename: Monthly-hourly-load-values_2006-2015.xlsx colmap: attribute: actual_entsoe_power_statistics region: '{region_from_col}' source: ENTSO-E Data Portal and Power Statistics unit: MW variable: load web: https://www.entsoe.eu/data/power-stats ENTSO-E Power Statistics: # Automatic download not implemented load: frequency: single file start: 2016-01-01 end: recent filetype: xlsx resolution: - 60min web: https://www.entsoe.eu/data/power-stats/ colmap: attribute: actual_entsoe_power_statistics region: '{region_from_col}' source: ENTSO-E Data Portal and Power Statistics unit: MW variable: load web: https://www.entsoe.eu/data/power-stats 50Hertz: wind generation_actual pre-offshore: url_template: http://ws.50hertz.com/web02/api/WindPowerActual/DownloadFile url_params_template: callback: '?' fileName: '{u_start:%Y}.csv' frequency: yearly start: 2005-01-01 end: 2015-12-31 filetype: csv resolution: - 15min web: https://www.50hertz.com/en/Transparency/GridData/Windpower colmap: MW: attribute: generation_actual region: DE_50hertz source: 50Hertz unit: MW variable: wind web: https://www.50hertz.com/en/Transparency/GridData/Windpower wind generation_forecast pre-offshore: url_template: http://ws.50hertz.com/web02/api/WindPowerForecast/DownloadFile url_params_template: callback: '?' fileName: '{u_start:%Y}.csv' frequency: yearly start: 2005-01-01 end: 2015-12-31 filetype: csv resolution: - 15min web: https://www.50hertz.com/en/Transparency/GridData/Windpower colmap: MW: attribute: generation_forecast region: DE_50hertz source: 50Hertz unit: MW variable: wind web: https://www.50hertz.com/en/Transparency/GridData/Windpower wind generation_actual with-offshore: url_template: http://ws.50hertz.com/web02/api/WindPowerActual/DownloadFile url_params_template: callback: '?' fileName: '{u_start:%Y}.csv' frequency: yearly start: 2016-01-01 end: recent filetype: csv resolution: - 15min web: https://www.50hertz.com/en/Transparency/GridData/Windpower colmap: Offshore MW: attribute: generation_actual region: DE_50hertz source: 50Hertz unit: MW variable: wind_offshore web: https://www.50hertz.com/en/Transparency/GridData/Windpower Onshore MW: attribute: generation_actual region: DE_50hertz source: 50Hertz unit: MW variable: wind_onshore web: https://www.50hertz.com/en/Transparency/GridData/Windpower wind: attribute: generation_actual region: DE_50hertz source: 50Hertz unit: MW variable: wind web: https://www.50hertz.com/en/Transparency/GridData/Windpower wind generation_forecast with-offshore: url_template: http://ws.50hertz.com/web02/api/WindPowerForecast/DownloadFile url_params_template: callback: '?' fileName: '{u_start:%Y}.csv' frequency: yearly start: 2016-01-01 end: recent filetype: csv resolution: - 15min web: https://www.50hertz.com/en/Transparency/GridData/Windpower colmap: Offshore MW: attribute: generation_forecast region: DE_50hertz source: 50Hertz unit: MW variable: wind_offshore web: https://www.50hertz.com/en/Transparency/GridData/Windpower Onshore MW: attribute: generation_actual region: DE_50hertz source: 50Hertz unit: MW variable: wind_onshore web: https://www.50hertz.com/en/Transparency/GridData/Windpower solar generation_actual : url_template: http://ws.50hertz.com/web02/api/PhotovoltaicActual/DownloadFile url_params_template: callback: '?' fileName: '{u_start:%Y}.csv' frequency: yearly start: 2012-01-01 end: recent filetype: csv resolution: - 15min web: https://www.50hertz.com/en/Transparency/GridData/Photovoltaics colmap: MW: attribute: generation_actual region: DE_50hertz source: 50Hertz unit: MW variable: solar web: https://www.50hertz.com/en/Transparency/GridData/Photovoltaics solar generation_forecast: url_template: http://ws.50hertz.com/web02/api/PhotovoltaicForecast/DownloadFile url_params_template: callback: '?' fileName: '{u_start:%Y}.csv' frequency: yearly start: 2012-01-01 end: recent filetype: csv resolution: - 15min web: https://www.50hertz.com/en/Transparency/GridData/Photovoltaics colmap: MW: attribute: generation_forecast region: DE_50hertz source: 50Hertz unit: MW variable: solar web: https://www.50hertz.com/en/Transparency/GridData/Photovoltaics Amprion: wind: url_template: https://www.amprion.net/api/grid-data/items/csv/WINDDATEN/{u_start:%Y-%m-%d}/{u_end:%Y-%m-%d} url_params_template: frequency: single file start: 2008-01-04 end: recent filetype: csv resolution: - 15min web: http://www.amprion.net/en/wind-feed-in colmap: 8:00 Uhr Prognose [MW]: attribute: generation_forecast region: DE_amprion source: Amprion unit: MW variable: wind web: http://www.amprion.net/en/wind-feed-in Online Hochrechnung [MW]: attribute: generation_actual region: DE_amprion source: Amprion unit: MW variable: wind web: http://www.amprion.net/en/wind-feed-in wind_onshore: attribute: generation_actual region: DE_amprion source: Amprion unit: MW variable: wind_onshore web: http://www.amprion.net/en/wind-feed-in solar: url_template: https://www.amprion.net/api/grid-data/items/csv/PV_EINSPEISUNG/{u_start:%Y-%m-%d}/{u_end:%Y-%m-%d} url_params_template: frequency: single file start: 2010-07-01 end: recent filetype: csv resolution: - 15min web: http://www.amprion.net/en/photovoltaic-infeed colmap: 8:00 Uhr Prognose [MW]: attribute: generation_forecast region: DE_amprion source: Amprion unit: MW variable: solar web: http://www.amprion.net/en/photovoltaic-infeed Online Hochrechnung [MW]: attribute: generation_actual region: DE_amprion source: Amprion unit: MW variable: solar web: http://www.amprion.net/en/photovoltaic-infeed TenneT: wind: url_template: http://www.tennettso.de/site/de/phpbridge url_params_template: commandpath: Tatsaechliche_und_prognostizierte_Windenergieeinspeisung/monthDataSheetCsv.php contenttype: text/x-csv querystring: monat={u_start:%Y-%m} frequency: monthly start: 2006-01-01 end: recent filetype: csv resolution: - 15min web: https://www.tennet.eu/electricity-market/transparency-pages/transparency-germany/network-figures/actual-and-forecast-wind-energy-feed-in colmap: Anteil Offshore [MW]: attribute: generation_actual region: DE_tennet source: TenneT unit: MW variable: wind_offshore web: https://www.tennet.eu/electricity-market/transparency-pages/transparency-germany/network-figures/actual-and-forecast-wind-energy-feed-in prognostiziert [MW]: attribute: generation_forecast region: DE_tennet source: TenneT unit: MW variable: wind web: https://www.tennet.eu/electricity-market/transparency-pages/transparency-germany/network-figures/actual-and-forecast-wind-energy-feed-in tatsächlich [MW]: attribute: generation_actual region: DE_tennet source: TenneT unit: MW variable: wind web: https://www.tennet.eu/electricity-market/transparency-pages/transparency-germany/network-figures/actual-and-forecast-wind-energy-feed-in wind_onshore: attribute: generation_actual region: DE_tennet source: TenneT unit: MW variable: wind_onshore web: https://www.tennet.eu/electricity-market/transparency-pages/transparency-germany/network-figures/actual-and-forecast-wind-energy-feed-in solar: url_template: http://www.tennettso.de/site/de/phpbridge url_params_template: commandpath: Tatsaechliche_und_prognostizierte_Solarenergieeinspeisung/monthDataSheetCsv.php sub: total contenttype: text/x-csv querystring: monat={u_start:%Y-%m} frequency: monthly start: 2010-01-01 end: recent filetype: csv resolution: - 15min web: https://www.tennet.eu/electricity-market/transparency-pages/transparency-germany/network-figures/actual-and-forecast-solar-energy-feed-in/tennet-control-area-combined colmap: prognostiziert [MW]: attribute: generation_forecast region: DE_tennet source: TenneT unit: MW variable: solar web: https://www.tennet.eu/electricity-market/transparency-pages/transparency-germany/network-figures/actual-and-forecast-solar-energy-feed-in/tennet-control-area-combined tatsächlich [MW]: attribute: generation_actual region: DE_tennet source: TenneT unit: MW variable: solar web: https://www.tennet.eu/electricity-market/transparency-pages/transparency-germany/network-figures/actual-and-forecast-solar-energy-feed-in/tennet-control-area-combined TransnetBW: wind: url_template: https://api.transnetbw.de/wind/csv url_params_template: date: '{u_start:%Y-%m}' frequency: monthly start: 2010-01-01 end: recent filetype: csv resolution: - 15min web: https://www.transnetbw.com/en/transparency/market-data/key-figures colmap: wind_onshore: attribute: generation_actual region: DE_transnetbw source: TransnetBW unit: MW variable: wind_onshore web: https://www.transnetbw.com/en/transparency/market-data/key-figures Ist-Wert (MW): attribute: generation_actual region: DE_transnetbw source: TransnetBW unit: MW variable: wind web: https://www.transnetbw.com/en/transparency/market-data/key-figures Prognose (MW): attribute: generation_forecast region: DE_transnetbw source: TransnetBW unit: MW variable: wind web: https://www.transnetbw.com/en/transparency/market-data/key-figures solar: url_template: https://api.transnetbw.de/photovoltaics/csv url_params_template: date: '{u_start:%Y-%m}' frequency: monthly start: 2011-01-01 end: recent filetype: csv resolution: - 15min web: https://www.transnetbw.com/en/transparency/market-data/key-figures colmap: Ist-Wert (MW): attribute: generation_actual region: DE_transnetbw source: TransnetBW unit: MW variable: solar web: https://www.transnetbw.com/en/transparency/market-data/key-figures Prognose (MW): attribute: generation_forecast region: DE_transnetbw source: TransnetBW unit: MW variable: solar web: https://www.transnetbw.com/en/transparency/market-data/key-figures Svenska Kraftnaet: wind_solar_1: url_template: https://www.svk.se/siteassets/aktorsportalen/elmarknad/statistik/forbrukning-tillforsel-per-timme/arkiverade/n_fot{u_start:%Y}.xls url_params_template: frequency: yearly start: 2002-01-01 end: 2009-12-31 filetype: xls resolution: - 60min web: https://www.svk.se/aktorsportalen/elmarknad/statistik/ filename: n_fot{u_start:%Y}.xls colmap: load: attribute: actual_tso region: SE source: Svenska Kraftnaet unit: MW variable: load web: https://www.svk.se/aktorsportalen/elmarknad/statistik/ solar: attribute: generation_actual region: SE source: Svenska Kraftnaet unit: MW variable: solar web: https://www.svk.se/aktorsportalen/elmarknad/statistik/ wind: attribute: generation_actual region: SE source: Svenska Kraftnaet unit: MW variable: wind web: https://data.open-power-system-data.org/renewable_power_plants wind_solar_2: url_template: https://www.svk.se/siteassets/aktorsportalen/elmarknad/statistik/forbrukning-tillforsel-per-timme/arkiverade/n_fot201001-06.xls url_params_template: frequency: single file start: 2010-01-01 end: 2010-06-30 filetype: xls resolution: - 60min web: https://www.svk.se/aktorsportalen/elmarknad/statistik/ filename: n_fot201001-06.xls wind_solar_3: url_template: https://www.svk.se/siteassets/aktorsportalen/elmarknad/statistik/forbrukning-tillforsel-per-timme/arkiverade/n_fot2010-07-12.xls url_params_template: frequency: single file start: 2010-07-01 end: 2010-12-31 filetype: xls resolution: - 60min web: https://www.svk.se/aktorsportalen/elmarknad/statistik/ filename: n_fot2010-07-12.xls wind_solar_4: url_template: https://www.svk.se/siteassets/aktorsportalen/elmarknad/statistik/forbrukning-tillforsel-per-timme/arkiverade/n-fot2011-01-12.xls url_params_template: frequency: single file start: 2011-01-01 end: 2011-12-31 filetype: xls resolution: - 60min web: https://www.svk.se/aktorsportalen/elmarknad/statistik filename: n-fot2011-01-12.xls wind_solar_5: url_template: https://www.svk.se/siteassets/aktorsportalen/elmarknad/statistik/forbrukning-tillforsel-per-timme/arkiverade/n_fot{u_start:%Y}-01-12.xls url_params_template: frequency: yearly start: 2012-01-01 end: 2014-12-31 filetype: xls resolution: - 60min web: https://www.svk.se/aktorsportalen/elmarknad/statistik filename: n_fot{u_start:%Y}-01-12.xls wind_solar_6: url_template: https://www.svk.se/siteassets/aktorsportalen/elmarknad/statistik/forbrukning-tillforsel-per-timme/arkiverade/forbrukning-och-tillforsel-per-timme-i-normaltid-{u_start:%Y}.xls url_params_template: frequency: yearly start: 2015-01-01 end: 2016-12-31 filetype: xls resolution: - 60min web: https://www.svk.se/aktorsportalen/elmarknad/statistik filename: forbrukning-och-tillforsel-per-timme-i-normaltid-{u_start:%Y}.xls wind_solar_7: url_template: https://www.svk.se/siteassets/aktorsportalen/elmarknad/statistik/forbrukning-tillforsel-per-timme/arkiverade/n_fot{u_start:%Y}-01-12.xls url_params_template: frequency: yearly start: 2017-01-01 end: 2018-12-31 filetype: xls resolution: - 60min web: https://www.svk.se/aktorsportalen/elmarknad/statistik filename: n_fot{u_start:%Y}-01-12.xls wind_solar_8: url_template: https://www.svk.se/siteassets/aktorsportalen/elmarknad/statistik/forbrukning-tillforsel-per-timme/forbrukning-och-tillforsel-per-timme-i-normaltid-2019.xls url_params_template: frequency: yearly start: 2019-01-01 end: 2019-12-31 filetype: xls resolution: - 60min web: https://www.svk.se/aktorsportalen/elmarknad/statistik filename: n_fot{u_start:%Y}-01-12.xls Elia: wind_onshore: url_template: https://publications.elia.be/Publications/Publications/WindForecasting.v4.svc/ExportForecastData url_params_template: beginDate: '{u_start:%Y-%m-%dT%H:%M:%S.000Z}' endDate: '{u_end:%Y-%m-%dT%H:%M:%S.000Z}' isOffshore: 'false' isEliaConnected: '' frequency: monthly #the frequency could in principle be chosen arbitrarily, even complete the complete dataset, but in practise the server often times out if too much data is requested at once start: 2013-01-01 end: recent filetype: xls resolution: - 15min web: http://www.elia.be/en/grid-data/power-generation/wind-power colmap: Day-Ahead forecast [MW]: attribute: generation_forecast region: BE source: Elia unit: MW variable: wind_onshore web: http://www.elia.be/en/grid-data/power-generation/wind-power Measured & upscaled [MW]: attribute: generation_actual region: BE source: Elia unit: MW variable: wind_onshore web: http://www.elia.be/en/grid-data/power-generation/wind-power Monitored Capacity [MW]: attribute: capacity region: BE source: Elia unit: MW variable: wind_onshore web: http://www.elia.be/en/grid-data/power-generation/wind-power wind_offshore: url_template: https://publications.elia.be/Publications/Publications/WindForecasting.v4.svc/ExportForecastData url_params_template: beginDate: '{u_start:%Y-%m-%dT%H:%M:%S.000Z}' endDate: '{u_end:%Y-%m-%dT%H:%M:%S.000Z}' isOffshore: 'true' isEliaConnected: '' frequency: quarterly start: 2013-01-01 filetype: xls resolution: - 15min web: http://www.elia.be/en/grid-data/power-generation/wind-power colmap: Day-Ahead forecast [MW]: attribute: generation_forecast region: BE source: Elia unit: MW variable: wind_offshore web: http://www.elia.be/en/grid-data/power-generation/wind-power Measured & upscaled [MW]: attribute: generation_actual region: BE source: Elia unit: MW variable: wind_offshore web: http://www.elia.be/en/grid-data/power-generation/wind-power Monitored Capacity [MW]: attribute: capacity region: BE source: Elia unit: MW variable: wind_offshore web: http://www.elia.be/en/grid-data/power-generation/wind-power solar: url_template: https://publications.elia.be/Publications/Publications/SolarForecasting.v4.svc/ExportSolarForecastGraph url_params_template: dateFrom: '{u_start:%Y-%m-%d}T23:00:00.000Z' dateTo: '{u_end:%Y-%m-%d}T23:00:00.000Z' sourceId: '1' frequency: monthly start: 2012-11-14 #the data starts from 2012-11-14 end: recent filetype: xls resolution: - 15min web: http://www.elia.be/en/grid-data/power-generation/Solar-power-generation-data/Graph colmap: Corrected Upscaled Measurement [MW]: attribute: generation_actual region: BE source: Elia unit: MW variable: solar web: https://publications.elia.be/Publications/Publications/SolarForecasting.v4.svc/ExportSolarForecastGraph Day-Ahead forecast [MW]: attribute: generation_forecast region: BE source: Elia unit: MW variable: solar web: https://publications.elia.be/Publications/Publications/SolarForecasting.v4.svc/ExportSolarForecastGraph Monitored Capacity [MWp]: attribute: capacity region: BE source: Elia unit: MW variable: solar web: https://publications.elia.be/Publications/Publications/SolarForecasting.v4.svc/ExportSolarForecastGraph Energinet.dk: # Automatic download not implemented prices_wind_solar: frequency: single file start: 2000-01-01 # or even earlier for some data, but not useful as other sources don't go as far back end: recent filetype: xls resolution: - 60min web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx colmap: DE European Power Exchange: attribute: day_ahead region: DE source: Energinet.dk unit: EUR variable: price web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx DK-Øst: attribute: day_ahead region: DK_2 source: Energinet.dk unit: EUR variable: price web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx 'DK-Øst: Bruttoforbrug': attribute: actual_tso region: DK_2 source: Energinet.dk unit: MW variable: load web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx 'DK-Øst: Nettoforbrug': attribute: actual_net_consumption_tso region: DK_2 source: Energinet.dk unit: MW variable: load web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx 'DK-Øst: Solcelle produktion (estimeret)': attribute: generation_actual region: DK_2 source: Energinet.dk unit: MW variable: solar web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx 'DK-Øst: Vindproduktion': attribute: generation_actual region: DK_2 source: Energinet.dk unit: MW variable: wind web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx DK-Vest: attribute: day_ahead region: DK_1 source: Energinet.dk unit: EUR variable: price web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx 'DK-Vest: Bruttoforbrug': attribute: actual_tso region: DK_1 source: Energinet.dk unit: MW variable: load web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx 'DK-Vest: Nettoforbrug': attribute: actual_net_consumption_tso region: DK_1 source: Energinet.dk unit: MW variable: load web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx 'DK-Vest: Solcelle produktion (estimeret)': attribute: generation_actual region: DK_1 source: Energinet.dk unit: MW variable: solar web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx 'DK-Vest: Vindproduktion': attribute: generation_actual region: DK_1 source: Energinet.dk unit: MW variable: wind web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx 'DK: Vindproduktion (offshore)': attribute: generation_actual region: DK source: Energinet.dk unit: MW variable: wind_offshore web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx 'DK: Vindproduktion (onshore)': attribute: generation_actual region: DK source: Energinet.dk unit: MW variable: wind_onshore web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx Norge: attribute: day_ahead region: NO_2 source: Energinet.dk unit: EUR variable: price web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx Sverige (SE): attribute: day_ahead region: SE source: Energinet.dk unit: EUR variable: price web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx Sverige (SE3): attribute: day_ahead region: SE_3 source: Energinet.dk unit: EUR variable: price web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx Sverige (SE4): attribute: day_ahead region: SE_4 source: Energinet.dk unit: EUR variable: price web: http://osp.energinet.dk/_layouts/Markedsdata/framework/integrations/markedsdatatemplate.aspx CEPS: # Automatic download not implemented wind_pv: frequency: single file start: 2012-01-01 end: recent filetype: xls resolution: - 60min web: http://www.ceps.cz/en/all-data#GenerationRES colmap: PVPP [MW]: attribute: generation_actual region: CZ source: CEPS unit: MW variable: solar web: http://www.ceps.cz/en/all-data#GenerationRES WPP [MW]: attribute: generation_actual region: CZ source: CEPS unit: MW variable: wind_onshore web: http://www.ceps.cz/en/all-data#GenerationRES PSE: wind: url_template: https://www.pse.pl/getcsv/-/export/csv/EN_Operation_PPS_G_WF/data/{u_start:%Y%m%d} url_params_template: frequency: daily start: 2012-05-26 end: recent filetype: csv resolution: - 60min web: https://www.pse.pl/web/pse-eng/data/polish-power-system-operation/generation-in-wind-farms colmap: Generation of Wind Farms: attribute: generation_actual region: PL source: PSE unit: MW variable: wind_onshore web: https://www.pse.pl/web/pse-eng/data/polish-power-system-operation/generation-in-wind-farms APG: generation_by_source: url_template: https://www.apg.at/transparency/Download.aspx url_params_template: LANGUAGE: de PID: AGPT Format: csv Resolution: 15M DateFromLocal: '{u_start:%Y%m%d}' DateToLocal: '{u_end:%Y%m%d}' # CacheDir: 20170428131612_4266553c941447f4a8836f88af6cc4ef #is unnecessary CacheFileName: export_agpt_{u_start:%Y-%m-%d}T00_00_00Z_{u_end:%Y-%m-%d}T23_45_00Z_15M_de.csv frequency: quarterly start: 2010-01-01 end: recent filetype: csv resolution: - 15min web: https://www.apg.at/de/markt/Markttransparenz/erzeugung/Erzeugung pro Typ colmap: Solar [MW]: attribute: generation_actual region: AT source: APG unit: MW variable: solar web: https://www.apg.at/de/markt/Markttransparenz/erzeugung/Erzeugung-pro-Typ Wind [MW]: attribute: generation_actual region: AT source: APG unit: MW variable: wind_onshore web: https://www.apg.at/de/markt/Markttransparenz/erzeugung/Erzeugung-pro-Typ RTE: generation_by_source: url_template: https://opendata.reseaux-energies.fr/explore/dataset/eco2mix-national-cons-def/download/ url_params_template: format: csv timezone: UTC use_labels_for_header: "true" frequency: single file start: 2012-01-01 end: recent filetype: csv resolution: - 30min web: https://opendata.reseaux-energies.fr/explore/dataset/eco2mix-national-cons-def colmap: Consommation (MW): attribute: actual_tso region: FR source: RTE unit: MW variable: load web: https://opendata.reseaux-energies.fr/explore/dataset/eco2mix-national-cons-def Eolien (MW): attribute: generation_actual region: FR source: RTE unit: MW variable: wind_onshore web: https://opendata.reseaux-energies.fr/explore/dataset/eco2mix-national-cons-def Prévision J-1 (MW): attribute: forecast_tso region: FR source: RTE unit: MW variable: load web: https://opendata.reseaux-energies.fr/explore/dataset/eco2mix-national-cons-def Solaire (MW): attribute: generation_actual region: FR source: RTE unit: MW variable: solar web: https://opendata.reseaux-energies.fr/explore/dataset/eco2mix-national-cons-def Terna: generation_by_source: url_params_template: frequency: daily # In total, data is available from May 2010 until recently, but there is a large gap in 2011-2012 and since 2016, data # is available from ENTSO-E Transparency, so we use 2012-2016. Furthermore, the 2010-2011 data would require a different read function, # as the files are in tsv format, not xls/xml start: 2012-07-17 end: 2015-12-31 filetype: xls filename: "{u_start}_terna.xls" method: scrape resolution: - 60min web: https://www.terna.it/SistemaElettrico/TransparencyReport/Generation/Forecastandactualgeneration.aspx colmap: attribute: '{attribute}' region: '{region}' source: Terna unit: MW variable: '{variable}' web: https://www.terna.it/SistemaElettrico/TransparencyReport/Generation/Forecastandactualgeneration.aspx National Grid: demand data: files: - url: https://www.nationalgrideso.com/document/54256/download start: 2005-01-01 end: 2010-12-31 - url: https://www.nationalgrideso.com/document/54251/download start: 2011-01-01 end: 2016-12-31 - url: https://www.nationalgrideso.com/document/54241/download start: 2017-01-01 end: 2017-12-31 - url: https://www.nationalgrideso.com/document/109391/download start: 2018-01-01 end: 2018-12-31 start: 2005-01-01 end: 2018-12-31 frequency: file list filetype: csv resolution: - 30min web: https://www.nationalgrideso.com/balancing-data/data-explorer colmap: EMBEDDED_SOLAR_GENERATION: attribute: generation_actual_dso region: GB_GBN source: National Grid unit: MW variable: solar web: https://www.nationalgrideso.com/balancing-data/data-explorer EMBEDDED_WIND_GENERATION: attribute: generation_actual_dso region: GB_GBN source: National Grid unit: MW variable: wind web: https://www.nationalgrideso.com/balancing-data/data-explorer ENGLAND_WALES_DEMAND: attribute: actual_tso region: GB_EAW source: National Grid unit: MW variable: load web: https://www.nationalgrideso.com/balancing-data/data-explorer ND: attribute: actual_tso region: GB_GBN source: National Grid unit: MW variable: load web: https://www.nationalgrideso.com/balancing-data/data-explorer TSD: attribute: actual_gross_generation_tso region: GB_GBN source: National Grid unit: MW variable: load web: https://www.nationalgrideso.com/balancing-data/data-explorer Elexon: generation_by_source: files: - url: https://downloads.elexonportal.co.uk/file/download/7326 start: 2008-01-01 end: 2008-12-31 - url: https://downloads.elexonportal.co.uk/file/download/7327 start: 2009-01-01 end: 2009-12-31 - url: https://downloads.elexonportal.co.uk/file/download/7328 start: 2010-01-01 end: 2010-12-31 - url: https://downloads.elexonportal.co.uk/file/download/7329 start: 2011-01-01 end: 2011-12-31 - url: https://downloads.elexonportal.co.uk/file/download/7330 start: 2012-01-01 end: 2012-12-31 - url: https://downloads.elexonportal.co.uk/file/download/7331 start: 2013-01-01 end: 2013-12-31 - url: https://downloads.elexonportal.co.uk/file/download/7504 start: 2014-01-01 end: 2014-12-31 - url: https://downloads.elexonportal.co.uk/file/download/9385 start: 2015-01-01 end: 2015-12-31 - url: https://downloads.elexonportal.co.uk/file/download/12745 start: 2016-01-01 end: 2016-12-31 - url: https://downloads.elexonportal.co.uk/file/download/17716 start: 2017-01-01 end: 2017-12-31 - url: https://downloads.elexonportal.co.uk/file/download/21844 start: 2018-01-01 end: 2018-12-31 - url: https://downloads.elexonportal.co.uk/file/download/24412 start: 2019-01-01 end: 2019-12-31 start: 2005-01-01 end: 2018-12-31 frequency: file list filetype: csv resolution: - 30min web: https://www.elexonportal.co.uk/fuelhh colmap: PS: attribute: generation_actual_tso region: GB_GBN source: Elexon unit: MW variable: solar web: https://www.elexonportal.co.uk/fuelhh WIND: attribute: generation_actual_tso region: GB_GBN source: Elexon unit: MW variable: wind web: https://www.elexonportal.co.uk/fuelhh # # For the Following sources, the download/read has not yet been implemented # #Fingrid: # wind: # url_template: http://www.fingrid.fi/en/electricity-market/load-and-generation/windpower/Pages/default.aspx/Excel/TimeSeries.xls? # url_params_template: # beginDate: '{u_start:%Y%m%d}' # endDate: '{u_start:%Y%m%d}' # variables: H4sIAAAAAAAEAO29B2AcSZYlJi9tynt_SvVK1-B0oQiAYBMk2JBAEOzBiM3mkuwdaUcjKasqgcplVmVdZhZAzO2dvPfee--999577733ujudTif33_8_XGZkAWz2zkrayZ4hgKrIHz9-fB8_Ih7_ZFYX2aTMmyP769nyvDp6_CJb5EfPzn7_N1999fzsJ788--L49_99vv3m8V3-_PHZ8jKv25_MynV-dJ6VTf74rv_RY_7xrKoXWfu6rYvlxdGPj378x3ce3-1_8firZdG-yd-1R198d353_viu_fvxm6It86PvFstZuqqu8jq9yJd5nbVFtUy3uPWdx3el0ePnxTI_qcqqTu96f3y7XZRHP_7k5MnDHeo8_Pjx63l19eWyvH62btd1_jRrMzOWyDdA3aeP_bM5-n8AhQmq0kUBAAA1 # cultureId: en-US # dataTimePrecision: 5 # frequency: monthly # ??? # start: 2014-11-28 # end: recent # filetype: xls # resolution: # - 60min # web: # #OeMag: # wind_1: # url_template: http://www.oem-ag.at/fileadmin/user_upload/Dokumente/statistik/winderzeugung/winderzeugung_{u_start:%Y}.xls # bundle: YEARLY # start: 2003-01-01 # end: 2011-01-01 # filetype: xls # resolution: # - 15min # wind_2: # url_template: http://www.oem-ag.at/fileadmin/user_upload/Dokumente/statistik/winderzeugung/winderzeugung_{u_start:%Y}.xlsx # bundle: YEARLY # start: 2012-01-01 # end: 2013-12-31 # filetype: xlsx # resolution: # - 15min # wind_3: # url_template: http://www.oem-ag.at/fileadmin/user_upload/Dokumente/statistik/winderzeugung/Winderzeugung_{u_start:%Y}.xlsx # bundle: YEARLY # start: 2013-01-01 # end: 2013-12-31 # filetype: xlsx # resolution: # - 15min # #Energinet.dk: # Automatic download not implemented # prices_2: # url_template: https://stapckanedsfiles01.blob.core.windows.net/edsprod/Elspot_Prices_Data-d2f38eb6e3a74cdab724fec1c050689f.csv # frequency: complete # start: 2016 # 100000 rows download limit # end: recent # filetype: csv # resolution: # - 60min # web: https://www.energidataservice.dk/dataset/elspotprices # wind_solar_2: # url_template: https://stapckanedsfiles01.blob.core.windows.net/edsprod/Electricity_Balance_Data-88d6261333094e56a30f8f8a94ffe509.csv # frequency: complete # start: 2012 # 100000 rows download limit # end: recent # filetype: csv # resolution: # - 60min # web: https://www.energidataservice.dk/dataset/electricitybalance # #TEMPLATE # #source: # variable: # url_template: # url_params_template: # # frequency: # start: # end: recent # filetype: # resolution: # web: