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 |
| Report issue | Report an issue on Github |
| 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)." | |
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 |