Data Platform

Jump to Data Package:

Household Data

Package version
Description Detailed household load and solar generation in minutely to hourly resolution
Notes 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.
Last changes Initial upload
Geographical scope 1 households in southern Germany
Documentation Documentation and script (view on GitHub)
Download Data package (zip)
opsd-household_data-2017-08-01.zip (9 MB)

Individual data files (csv, xlsx)
household_data.xlsx (18 MB)
household_data_1min_singleindex.csv (28 MB) Alternative file formats Filter
household_data_3min_singleindex.csv (19 MB) Alternative file formats Filter
household_data_15min_singleindex.csv (6 MB) Alternative file formats Filter
household_data_60min_singleindex.csv (2 MB) Alternative file formats Filter

Database (SQLite)
household_data.sqlite (51 MB)
Meta data README.md
datapackage.json
Input data View original input data
Sources CoSSMic
Data license Creative Commons Attribution-International 4.0
Contact Adrian Minde
Subscribe Get notified by email for updates
Attribution in Chicago author-date style should be given as follows: "Open Power System Data. 2017. Data Package Household Data. Version 2017-08-01. https://data.open-power-system-data.org/household_data/2017-08-01/. (Primary data from various sources, for a complete list see URL)."
<- back to overview

Field documentation

household data 1min singleindex.csv

Field Name Type (Format) Description
utc_timestamp datetime (fmt:%Y-%m-%dT%H%M%SZ) Start of timeperiod in Coordinated Universal Time
cet_cest_timestamp datetime (fmt:%Y-%m-%dT%H%M%S%z) Start of timeperiod in Central European (Summer-) Time
interpolated_values string 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 number (float) Dishwasher energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_ev number (float) Electric Vehicle charging energy in a residential building, located in the suburban area in kWh
DE_KN_residential4_freezer number (float) Freezer energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_grid_export number (float) Energy exported to the public grid in a residential building, located in the suburban area in kWh
DE_KN_residential4_grid_import number (float) Energy imported from the public grid in a residential building, located in the suburban area in kWh
DE_KN_residential4_heat_pump number (float) Heat pump energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_pv number (float) Total Photovoltaic energy generation in a residential building, located in the suburban area in kWh
DE_KN_residential4_refrigerator number (float) Refrigerator energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_washing_machine number (float) Washing machine energy consumption in a residential building, located in the suburban area in kWh

household data 3min singleindex.csv

Field Name Type (Format) Description
utc_timestamp datetime (fmt:%Y-%m-%dT%H%M%SZ) Start of timeperiod in Coordinated Universal Time
cet_cest_timestamp datetime (fmt:%Y-%m-%dT%H%M%S%z) Start of timeperiod in Central European (Summer-) Time
interpolated_values string 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 number (float) Dishwasher energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_ev number (float) Electric Vehicle charging energy in a residential building, located in the suburban area in kWh
DE_KN_residential4_freezer number (float) Freezer energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_grid_export number (float) Energy exported to the public grid in a residential building, located in the suburban area in kWh
DE_KN_residential4_grid_import number (float) Energy imported from the public grid in a residential building, located in the suburban area in kWh
DE_KN_residential4_heat_pump number (float) Heat pump energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_pv number (float) Total Photovoltaic energy generation in a residential building, located in the suburban area in kWh
DE_KN_residential4_refrigerator number (float) Refrigerator energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_washing_machine number (float) Washing machine energy consumption in a residential building, located in the suburban area in kWh

household data 15min singleindex.csv

Field Name Type (Format) Description
utc_timestamp datetime (fmt:%Y-%m-%dT%H%M%SZ) Start of timeperiod in Coordinated Universal Time
cet_cest_timestamp datetime (fmt:%Y-%m-%dT%H%M%S%z) Start of timeperiod in Central European (Summer-) Time
interpolated_values string 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 number (float) Dishwasher energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_ev number (float) Electric Vehicle charging energy in a residential building, located in the suburban area in kWh
DE_KN_residential4_freezer number (float) Freezer energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_grid_export number (float) Energy exported to the public grid in a residential building, located in the suburban area in kWh
DE_KN_residential4_grid_import number (float) Energy imported from the public grid in a residential building, located in the suburban area in kWh
DE_KN_residential4_heat_pump number (float) Heat pump energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_pv number (float) Total Photovoltaic energy generation in a residential building, located in the suburban area in kWh
DE_KN_residential4_refrigerator number (float) Refrigerator energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_washing_machine number (float) Washing machine energy consumption in a residential building, located in the suburban area in kWh

household data 60min singleindex.csv

Field Name Type (Format) Description
utc_timestamp datetime (fmt:%Y-%m-%dT%H%M%SZ) Start of timeperiod in Coordinated Universal Time
cet_cest_timestamp datetime (fmt:%Y-%m-%dT%H%M%S%z) Start of timeperiod in Central European (Summer-) Time
interpolated_values string 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 number (float) Dishwasher energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_ev number (float) Electric Vehicle charging energy in a residential building, located in the suburban area in kWh
DE_KN_residential4_freezer number (float) Freezer energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_grid_export number (float) Energy exported to the public grid in a residential building, located in the suburban area in kWh
DE_KN_residential4_grid_import number (float) Energy imported from the public grid in a residential building, located in the suburban area in kWh
DE_KN_residential4_heat_pump number (float) Heat pump energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_pv number (float) Total Photovoltaic energy generation in a residential building, located in the suburban area in kWh
DE_KN_residential4_refrigerator number (float) Refrigerator energy consumption in a residential building, located in the suburban area in kWh
DE_KN_residential4_washing_machine number (float) Washing machine energy consumption in a residential building, located in the suburban area in kWh
<- back to overview