DATAPACKAGE: HOUSEHOLD DATA =========================================================================== by Open Power System Data: http://www.open-power-system-data.org/ Package Version: 2017-09-01 Detailed household load and solar generation in minutely to hourly resolution This data package contains measured time series data for several small businesses and private households relevant for household- or low-voltage-level power system modeling. The data includes solar power generation as well as electricity consumption (load) in a resolution up to single device consumption. The starting point for the time series, as well as data quality, varies between households, with gaps spanning from a few minutes to entire hours. In general, data is adjusted to fit uniform, regular time intervals without changing its validity. Except for small gaps, filled using linear interpolation. The numbers are cumulative power consumption/generation over time. Hence overall energy consumption/generation is retained in case of data gaps. Measurements were initially conducted in 3-minute intervals, later in 1-minute intervals. Data for both measurement resolutions are published separately in large CSV files. Additionally, data in 15 and 60-minute resolution is provided for compatibility with other time series data. Data processing is conducted in Jupyter Notebooks/Python/pandas. The data package covers the geographical region of 1 households in southern Germany. 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/isc-konstanz/household_data/blob/2017-09-01/main.ipynb Or on GitHub at: https://github.com/isc-konstanz/household_data/blob/2017-09-01/main.ipynb License and attribution =========================================================================== Data license: Creative Commons Attribution-International Script license: [MIT License](https://opensource.org/licenses/MIT) Attribution: Attribution in Chicago author-date style should be given as follows: "Open Power System Data. 2017. Data Package Household Data. Version 2017-09-01. https://data.open-power-system-data.org/household_data/2017-09-01/. (Primary data from various sources, for a complete list see URL)." Version history =========================================================================== * 2017-09-01 Improve adjustments function and fix redundant rounding * 2017-08-01 Initial upload Resources =========================================================================== * [Package description page](http://data.open-power-system-data.org/household_data/2017-09-01/) * [ZIP Package](http://data.open-power-system-data.org/household_data/opsd-household_data-2017-09-01.zip) * [Script and documentation](https://github.com/isc-konstanz/household_data/blob/2017-09-01/main.ipynb) * [Original input data](http://data.open-power-system-data.org/household_data/2017-09-01/original_data/) Sources =========================================================================== * [CoSSMic](http://cossmic.eu/) Field documentation =========================================================================== household_data_1min_singleindex.csv --------------------------------------------------------------------------- * utc_timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%SZ - Description: Start of timeperiod in Coordinated Universal Time * cet_cest_timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%S%z - Description: Start of timeperiod in Central European (Summer-) Time * interpolated_values - Type: string - Description: marker to indicate which columns are missing data in source data and has been interpolated (e.g. DE_KN_Residential1_grid_import;) * DE_KN_residential4_dishwasher - Type: number (float) - Description: Dishwasher energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_ev - Type: number (float) - Description: Electric Vehicle charging energy in a residential building, located in the suburban area in kWh * DE_KN_residential4_freezer - Type: number (float) - Description: Freezer energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_grid_export - Type: number (float) - Description: Energy exported to the public grid in a residential building, located in the suburban area in kWh * DE_KN_residential4_grid_import - Type: number (float) - Description: Energy imported from the public grid in a residential building, located in the suburban area in kWh * DE_KN_residential4_heat_pump - Type: number (float) - Description: Heat pump energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_pv - Type: number (float) - Description: Total Photovoltaic energy generation in a residential building, located in the suburban area in kWh * DE_KN_residential4_refrigerator - Type: number (float) - Description: Refrigerator energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_washing_machine - Type: number (float) - Description: Washing machine energy consumption in a residential building, located in the suburban area in kWh household_data_3min_singleindex.csv --------------------------------------------------------------------------- * utc_timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%SZ - Description: Start of timeperiod in Coordinated Universal Time * cet_cest_timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%S%z - Description: Start of timeperiod in Central European (Summer-) Time * interpolated_values - Type: string - Description: marker to indicate which columns are missing data in source data and has been interpolated (e.g. DE_KN_Residential1_grid_import;) * DE_KN_residential4_dishwasher - Type: number (float) - Description: Dishwasher energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_ev - Type: number (float) - Description: Electric Vehicle charging energy in a residential building, located in the suburban area in kWh * DE_KN_residential4_freezer - Type: number (float) - Description: Freezer energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_grid_export - Type: number (float) - Description: Energy exported to the public grid in a residential building, located in the suburban area in kWh * DE_KN_residential4_grid_import - Type: number (float) - Description: Energy imported from the public grid in a residential building, located in the suburban area in kWh * DE_KN_residential4_heat_pump - Type: number (float) - Description: Heat pump energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_pv - Type: number (float) - Description: Total Photovoltaic energy generation in a residential building, located in the suburban area in kWh * DE_KN_residential4_refrigerator - Type: number (float) - Description: Refrigerator energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_washing_machine - Type: number (float) - Description: Washing machine energy consumption in a residential building, located in the suburban area in kWh household_data_15min_singleindex.csv --------------------------------------------------------------------------- * utc_timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%SZ - Description: Start of timeperiod in Coordinated Universal Time * cet_cest_timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%S%z - Description: Start of timeperiod in Central European (Summer-) Time * interpolated_values - Type: string - Description: marker to indicate which columns are missing data in source data and has been interpolated (e.g. DE_KN_Residential1_grid_import;) * DE_KN_residential4_dishwasher - Type: number (float) - Description: Dishwasher energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_ev - Type: number (float) - Description: Electric Vehicle charging energy in a residential building, located in the suburban area in kWh * DE_KN_residential4_freezer - Type: number (float) - Description: Freezer energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_grid_export - Type: number (float) - Description: Energy exported to the public grid in a residential building, located in the suburban area in kWh * DE_KN_residential4_grid_import - Type: number (float) - Description: Energy imported from the public grid in a residential building, located in the suburban area in kWh * DE_KN_residential4_heat_pump - Type: number (float) - Description: Heat pump energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_pv - Type: number (float) - Description: Total Photovoltaic energy generation in a residential building, located in the suburban area in kWh * DE_KN_residential4_refrigerator - Type: number (float) - Description: Refrigerator energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_washing_machine - Type: number (float) - Description: Washing machine energy consumption in a residential building, located in the suburban area in kWh household_data_60min_singleindex.csv --------------------------------------------------------------------------- * utc_timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%SZ - Description: Start of timeperiod in Coordinated Universal Time * cet_cest_timestamp - Type: datetime - Format: fmt:%Y-%m-%dT%H%M%S%z - Description: Start of timeperiod in Central European (Summer-) Time * interpolated_values - Type: string - Description: marker to indicate which columns are missing data in source data and has been interpolated (e.g. DE_KN_Residential1_grid_import;) * DE_KN_residential4_dishwasher - Type: number (float) - Description: Dishwasher energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_ev - Type: number (float) - Description: Electric Vehicle charging energy in a residential building, located in the suburban area in kWh * DE_KN_residential4_freezer - Type: number (float) - Description: Freezer energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_grid_export - Type: number (float) - Description: Energy exported to the public grid in a residential building, located in the suburban area in kWh * DE_KN_residential4_grid_import - Type: number (float) - Description: Energy imported from the public grid in a residential building, located in the suburban area in kWh * DE_KN_residential4_heat_pump - Type: number (float) - Description: Heat pump energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_pv - Type: number (float) - Description: Total Photovoltaic energy generation in a residential building, located in the suburban area in kWh * DE_KN_residential4_refrigerator - Type: number (float) - Description: Refrigerator energy consumption in a residential building, located in the suburban area in kWh * DE_KN_residential4_washing_machine - Type: number (float) - Description: Washing machine energy consumption in a residential building, located in the suburban area in kWh 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: Adrian Minde For general issues, find our team contact details on our website: http://www.open-power-system-data.org