DATAPACKAGE: TIME SERIES =========================================================================== by Open Power System Data: http://www.open-power-system-data.org/ Package Version: 2016-10-27 Load, wind and solar, prices in hourly resolution This data package contains different kinds of timeseries data relevant for power system modelling, namely electricity consumption (load) for 36 European countries as well as wind and solar power generation and capacities and prices for a growing subset of countries. The timeseries become available at different points in time depending on the sources. The data has been downloaded from the sources, resampled and merged in a large CSV file with hourly resolution. Additionally, the data available at a higher resolution (Some renewables in-feed, 15 minutes) is provided in a separate file. All data processing is conducted in python and pandas and has been documented in the Jupyter notebooks linked below. The data package covers the geographical region of 35 European countries. We follow the Data Package standard by the Frictionless Data project, a part of the Open Knowledge Foundation: http://frictionlessdata.io/ Documentation and script =========================================================================== This README only contains the most basic information about the data package. For the full documentation, please see the notebook script that was used to generate the data package. You can find it at: https://nbviewer.jupyter.org/github/Open-Power-System-Data/datapackage_timeseries/blob/2016-10-27/main.ipynb Or on GitHub at: https://github.com/Open-Power-System-Data/datapackage_timeseries/blob/2016-10-27/main.ipynb License and attribution =========================================================================== Attribution: Attribution in Chicago author-date style should be given as follows: "Open Power System Data. 2016. Data Package Time series. Version 2016-10-27. https://data.open-power-system-data.org/time_series/2016-10-27/. (Primary data from various sources, for a complete list see URL)." Version history =========================================================================== * 2016-10-27 Included data from CEPS and PSE * 2016-07-14 Included data from Energinet.DK, Elia and Svenska Kraftnaet Resources =========================================================================== * [Package description page](http://data.open-power-system-data.org/time_series/2016-10-27/) * [ZIP Package](http://data.open-power-system-data.org/time_series/opsd-time_series-2016-10-27.zip) * [Script and documentation](https://github.com/Open-Power-System-Data/datapackage_timeseries/blob/2016-10-27/main.ipynb) * [Original input data](http://data.open-power-system-data.org/time_series/2016-10-27/original_data/) Sources =========================================================================== * CEPS * 50Hertz * BNetzA and Netztransparenz.de * TenneT * own calculation * Energinet.dk * TransnetBW * ENTSO-E Data Portal * Svenska Kraftnaet * Amprion * PSE Field documentation =========================================================================== time_series_60min_singleindex.csv --------------------------------------------------------------------------- * timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%SZ - Description: Start of timeperiod in UTC * ce(s)t-timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%S%z - Description: Start of timeperiod in CE(S)T * comment - Type: string - Description: marker to indicate which columns are missing data in source data and has been interpolated (e.g. solar_DE-transnetbw_generation;) * load_AT_load - Type: number (float) - Description: Consumption in Austria in MW - Source: * load_BA_load - Type: number (float) - Description: Consumption in Bosnia and Herzegovina in MW - Source: * load_BE_load - Type: number (float) - Description: Consumption in Belgium in MW - Source: * load_BG_load - Type: number (float) - Description: Consumption in Bulgaria in MW - Source: * load_CH_load - Type: number (float) - Description: Consumption in Switzerland in MW - Source: * load_CS_load - Type: number (float) - Description: Consumption in Serbia and Montenegro in MW - Source: * load_CY_load - Type: number (float) - Description: Consumption in Cyprus in MW - Source: * load_CZ_load - Type: number (float) - Description: Consumption in Czech Republic in MW - Source: * load_DE_load - Type: number (float) - Description: Consumption in Germany in MW - Source: * load_DK_load - Type: number (float) - Description: Consumption in Denmark in MW - Source: * load_DK-west_load - Type: number (float) - Description: Consumption in DK-west control area in MW - Source: * load_EE_load - Type: number (float) - Description: Consumption in Estonia in MW - Source: * load_ES_load - Type: number (float) - Description: Consumption in Spain in MW - Source: * load_FI_load - Type: number (float) - Description: Consumption in Finland in MW - Source: * load_FR_load - Type: number (float) - Description: Consumption in France in MW - Source: * load_GB_load - Type: number (float) - Description: Consumption in United Kingdom in MW - Source: * load_GR_load - Type: number (float) - Description: Consumption in Greece in MW - Source: * load_HR_load - Type: number (float) - Description: Consumption in Croatia in MW - Source: * load_HU_load - Type: number (float) - Description: Consumption in Hungary in MW - Source: * load_IE_load - Type: number (float) - Description: Consumption in Ireland in MW - Source: * load_IS_load - Type: number (float) - Description: Consumption in Iceland in MW - Source: * load_IT_load - Type: number (float) - Description: Consumption in Italy in MW - Source: * load_LT_load - Type: number (float) - Description: Consumption in Lithuania in MW - Source: * load_LU_load - Type: number (float) - Description: Consumption in Luxembourg in MW - Source: * load_LV_load - Type: number (float) - Description: Consumption in Latvia in MW - Source: * load_ME_load - Type: number (float) - Description: Consumption in Montenegro in MW - Source: * load_MK_load - Type: number (float) - Description: Consumption in Macedonia, Republic of in MW - Source: * load_NI_load - Type: number (float) - Description: Consumption in Northern Ireland in MW - Source: * load_NL_load - Type: number (float) - Description: Consumption in Netherlands in MW - Source: * load_NO_load - Type: number (float) - Description: Consumption in Norway in MW - Source: * load_PL_load - Type: number (float) - Description: Consumption in Poland in MW - Source: * load_PT_load - Type: number (float) - Description: Consumption in Portugal in MW - Source: * load_RO_load - Type: number (float) - Description: Consumption in Romania in MW - Source: * load_RS_load - Type: number (float) - Description: Consumption in Serbia in MW - Source: * load_SE_load - Type: number (float) - Description: Consumption in Sweden in MW - Source: * load_SI_load - Type: number (float) - Description: Consumption in Slovenia in MW - Source: * load_SK_load - Type: number (float) - Description: Consumption in Slovakia in MW - Source: * load_UA-west_load - Type: number (float) - Description: Consumption in UA-west control area in MW - Source: * price_DE_EPEX - Type: number (float) - Description: Day-ahead spot price for Germany - Source: * price_DK-east_Elspot - Type: number (float) - Description: Day-ahead spot price for DK-east control area - Source: * price_DK-west_Elspot - Type: number (float) - Description: Day-ahead spot price for DK-west control area - Source: * price_NO_Elspot - Type: number (float) - Description: Day-ahead spot price for Norway - Source: * price_SE_Elspot - Type: number (float) - Description: Day-ahead spot price for Sweden - Source: * price_SE-3_Elspot - Type: number (float) - Description: Day-ahead spot price for SE-3 control area - Source: * price_SE-4_Elspot - Type: number (float) - Description: Day-ahead spot price for SE-4 control area - Source: * solar_CZ_generation - Type: number (float) - Description: Actual solar generation in Czech Republic in MW - Source: * solar_DE_capacity - Type: number (float) - Description: Electrical capacity of solar in Germany in MW - Source: * solar_DE_generation - Type: number (float) - Description: Actual solar generation in Germany in MW - Source: * solar_DE_profile - Type: number (float) - Description: Share of solar capacity producing in Germany - Source: * solar_DE-50hertz_forecast - Type: number (float) - Description: Forecasted solar generation forecast in DE-50hertz control area in MW - Source: * solar_DE-50hertz_generation - Type: number (float) - Description: Actual solar generation in DE-50hertz control area in MW - Source: * solar_DE-amprion_forecast - Type: number (float) - Description: Forecasted solar generation forecast in DE-amprion control area in MW - Source: * solar_DE-amprion_generation - Type: number (float) - Description: Actual solar generation in DE-amprion control area in MW - Source: * solar_DE-tennet_forecast - Type: number (float) - Description: Forecasted solar generation forecast in DE-tennet control area in MW - Source: * solar_DE-tennet_generation - Type: number (float) - Description: Actual solar generation in DE-tennet control area in MW - Source: * solar_DE-transnetbw_forecast - Type: number (float) - Description: Forecasted solar generation forecast in DE-transnetbw control area in MW - Source: * solar_DE-transnetbw_generation - Type: number (float) - Description: Actual solar generation in DE-transnetbw control area in MW - Source: * solar_DK-east_generation - Type: number (float) - Description: Actual solar generation in DK-east control area in MW - Source: * solar_DK-west_generation - Type: number (float) - Description: Actual solar generation in DK-west control area in MW - Source: * solar_SE_generation - Type: number (float) - Description: Actual solar generation in Sweden in MW - Source: * wind_DE-50hertz_forecast - Type: number (float) - Description: Forecasted wind generation forecast in DE-50hertz control area in MW - Source: * wind_DE-50hertz_generation - Type: number (float) - Description: Actual wind generation in DE-50hertz control area in MW - Source: * wind_DE-amprion_forecast - Type: number (float) - Description: Forecasted wind generation forecast in DE-amprion control area in MW - Source: * wind_DE-amprion_generation - Type: number (float) - Description: Actual wind generation in DE-amprion control area in MW - Source: * wind_DE-tennet_forecast - Type: number (float) - Description: Forecasted wind generation forecast in DE-tennet control area in MW - Source: * wind_DE-tennet_generation - Type: number (float) - Description: Actual wind generation in DE-tennet control area in MW - Source: * wind_DE-transnetbw_forecast - Type: number (float) - Description: Forecasted wind generation forecast in DE-transnetbw control area in MW - Source: * wind_DE-transnetbw_generation - Type: number (float) - Description: Actual wind generation in DE-transnetbw control area in MW - Source: * wind_PL_generation - Type: number (float) - Description: Actual wind generation in Poland in MW - Source: * wind-offshore_DE_capacity - Type: number (float) - Description: Electrical capacity of wind-offshore in Germany in MW - Source: * wind-offshore_DE_generation - Type: number (float) - Description: Actual wind-offshore generation in Germany in MW - Source: * wind-offshore_DE_profile - Type: number (float) - Description: Share of wind-offshore capacity producing in Germany - Source: * wind-offshore_DE-50hertz_forecast - Type: number (float) - Description: Forecasted wind-offshore generation forecast in DE-50hertz control area in MW - Source: * wind-offshore_DE-50hertz_generation - Type: number (float) - Description: Actual wind-offshore generation in DE-50hertz control area in MW - Source: * wind-offshore_DE-tennet_generation - Type: number (float) - Description: Actual wind-offshore generation in DE-tennet control area in MW - Source: * wind-offshore_DK_generation - Type: number (float) - Description: Actual wind-offshore generation in Denmark in MW - Source: * wind-onshore_CZ_generation - Type: number (float) - Description: Actual wind-onshore generation in Czech Republic in MW - Source: * wind-onshore_DE_capacity - Type: number (float) - Description: Electrical capacity of wind-onshore in Germany in MW - Source: * wind-onshore_DE_generation - Type: number (float) - Description: Actual wind-onshore generation in Germany in MW - Source: * wind-onshore_DE_profile - Type: number (float) - Description: Share of wind-onshore capacity producing in Germany - Source: * wind-onshore_DE-50hertz_forecast - Type: number (float) - Description: Forecasted wind-onshore generation forecast in DE-50hertz control area in MW - Source: * wind-onshore_DE-50hertz_generation - Type: number (float) - Description: Actual wind-onshore generation in DE-50hertz control area in MW - Source: * wind-onshore_DE-amprion_generation - Type: number (float) - Description: Actual wind-onshore generation in DE-amprion control area in MW - Source: * wind-onshore_DE-tennet_generation - Type: number (float) - Description: Actual wind-onshore generation in DE-tennet control area in MW - Source: * wind-onshore_DE-transnetbw_generation - Type: number (float) - Description: Actual wind-onshore generation in DE-transnetbw control area in MW - Source: * wind-onshore_DK_generation - Type: number (float) - Description: Actual wind-onshore generation in Denmark in MW - Source: * wind-total_DK-east_generation - Type: number (float) - Description: Actual wind-total generation in DK-east control area in MW - Source: * wind-total_DK-west_generation - Type: number (float) - Description: Actual wind-total generation in DK-west control area in MW - Source: * wind-total_SE_generation - Type: number (float) - Description: Actual wind-total generation in Sweden in MW - Source: time_series_15min_singleindex.csv --------------------------------------------------------------------------- * timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%SZ - Description: Start of timeperiod in UTC * ce(s)t-timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%S%z - Description: Start of timeperiod in CE(S)T * comment - Type: string - Description: marker to indicate which columns are missing data in source data and has been interpolated (e.g. solar_DE-transnetbw_generation;) * solar_CZ_generation - Type: number (float) - Description: Actual solar generation in Czech Republic in MW - Source: * solar_DE_capacity - Type: number (float) - Description: Electrical capacity of solar in Germany in MW - Source: * solar_DE_generation - Type: number (float) - Description: Actual solar generation in Germany in MW - Source: * solar_DE_profile - Type: number (float) - Description: Share of solar capacity producing in Germany - Source: * solar_DE-50hertz_forecast - Type: number (float) - Description: Forecasted solar generation forecast in DE-50hertz control area in MW - Source: * solar_DE-50hertz_generation - Type: number (float) - Description: Actual solar generation in DE-50hertz control area in MW - Source: * solar_DE-amprion_forecast - Type: number (float) - Description: Forecasted solar generation forecast in DE-amprion control area in MW - Source: * solar_DE-amprion_generation - Type: number (float) - Description: Actual solar generation in DE-amprion control area in MW - Source: * solar_DE-tennet_forecast - Type: number (float) - Description: Forecasted solar generation forecast in DE-tennet control area in MW - Source: * solar_DE-tennet_generation - Type: number (float) - Description: Actual solar generation in DE-tennet control area in MW - Source: * solar_DE-transnetbw_forecast - Type: number (float) - Description: Forecasted solar generation forecast in DE-transnetbw control area in MW - Source: * solar_DE-transnetbw_generation - Type: number (float) - Description: Actual solar generation in DE-transnetbw control area in MW - Source: * wind_DE-50hertz_forecast - Type: number (float) - Description: Forecasted wind generation forecast in DE-50hertz control area in MW - Source: * wind_DE-50hertz_generation - Type: number (float) - Description: Actual wind generation in DE-50hertz control area in MW - Source: * wind_DE-amprion_forecast - Type: number (float) - Description: Forecasted wind generation forecast in DE-amprion control area in MW - Source: * wind_DE-amprion_generation - Type: number (float) - Description: Actual wind generation in DE-amprion control area in MW - Source: * wind_DE-tennet_forecast - Type: number (float) - Description: Forecasted wind generation forecast in DE-tennet control area in MW - Source: * wind_DE-tennet_generation - Type: number (float) - Description: Actual wind generation in DE-tennet control area in MW - Source: * wind_DE-transnetbw_forecast - Type: number (float) - Description: Forecasted wind generation forecast in DE-transnetbw control area in MW - Source: * wind_DE-transnetbw_generation - Type: number (float) - Description: Actual wind generation in DE-transnetbw control area in MW - Source: * wind-offshore_DE_capacity - Type: number (float) - Description: Electrical capacity of wind-offshore in Germany in MW - Source: * wind-offshore_DE_generation - Type: number (float) - Description: Actual wind-offshore generation in Germany in MW - Source: * wind-offshore_DE_profile - Type: number (float) - Description: Share of wind-offshore capacity producing in Germany - Source: * wind-offshore_DE-50hertz_forecast - Type: number (float) - Description: Forecasted wind-offshore generation forecast in DE-50hertz control area in MW - Source: * wind-offshore_DE-50hertz_generation - Type: number (float) - Description: Actual wind-offshore generation in DE-50hertz control area in MW - Source: * wind-offshore_DE-tennet_generation - Type: number (float) - Description: Actual wind-offshore generation in DE-tennet control area in MW - Source: * wind-onshore_CZ_generation - Type: number (float) - Description: Actual wind-onshore generation in Czech Republic in MW - Source: * wind-onshore_DE_capacity - Type: number (float) - Description: Electrical capacity of wind-onshore in Germany in MW - Source: * wind-onshore_DE_generation - Type: number (float) - Description: Actual wind-onshore generation in Germany in MW - Source: * wind-onshore_DE_profile - Type: number (float) - Description: Share of wind-onshore capacity producing in Germany - Source: * wind-onshore_DE-50hertz_forecast - Type: number (float) - Description: Forecasted wind-onshore generation forecast in DE-50hertz control area in MW - Source: * wind-onshore_DE-50hertz_generation - Type: number (float) - Description: Actual wind-onshore generation in DE-50hertz control area in MW - Source: * wind-onshore_DE-amprion_generation - Type: number (float) - Description: Actual wind-onshore generation in DE-amprion control area in MW - Source: * wind-onshore_DE-tennet_generation - Type: number (float) - Description: Actual wind-onshore generation in DE-tennet control area in MW - Source: * wind-onshore_DE-transnetbw_generation - Type: number (float) - Description: Actual wind-onshore generation in DE-transnetbw control area in MW - Source: Feedback =========================================================================== Thank you for using data provided by Open Power System Data. If you have any question or feedback, please do not hesitate to contact us. For this data package, contact: Jonathan Muehlenpfordt For general issues, find our team contact details on our website: http://www.open-power-system-data.org