Single household power profile related to grid by every 0.2sec

Citation Author(s):
Riga Technical university
Riga Technical university
Submitted by:
Peteris Apse-Apsitis
Last updated:
Wed, 08/17/2022 - 06:59
Data Format:
0 ratings - Please login to submit your rating.


Dataset reflects a single household (home) power profile related to the grid. Households include typical appliances, two air-to-air heat pumps, a 3-phase 18 kW through-flow water heater, 6 kW solar panels and a 2,5 kW charger for the electric car.

For five-month (mid-April-mid August) in 2022, every 0.2 sec took each 3-phase voltage, and current measurement, power and harmonics (up to 15th) were calculated for power profile registration.

Positive value reflects energy flow from the grid to a household, and negative values not used at household energy flow to the grid.

One can observe graphs on the webpage (six hours before chosen time) - U, I, P data. Data graphs, including harmonics and THD, can be observed on (30 minutes before the selected time). Only P data graphs: - 24 hours period before chosen time.

One can zoom in on graphs, toggle lines, and charts can be synchronized.


Get the SQL file powerD2.sql.

The U, I, and P values for each phase are named as ...1, ...2, ... 3, for example, U1, U2, U3, and corresponding columns.

Harmonics values U1fft, U2fft, U3fft etc. are shown as each harmonic value as a percentage of the sum of all harmonic values.

The file is large (3 GB), so it takes time to open and manipulate.