Documentation: shs_ts

Time Series data of individual Solar Home Systems
To import data in this format you can use our API. -> API Documentation
You can also supply us with files in xlsx, csv or json format. -> Example CSV
type p14n blurred autogenerated required
device_uid string
organization_id + manufacturer + serial_number; FK from shs table
manufacturer string
Manufacturer of the device
serial_number string
Serial of the device
metered_at datetime
time the metrics apply to (not time of query)
pv_input_w float
PV to system in watts
grid_input_w float
grid to system in watts
grid_input_v float
grid input voltage in volts
battery_v float
battery voltage in volts
battery_io_w float
battery input / output in watts (>0 = charging)
battery_charge_percent float
battery charge level in percentage
system_output_w float
system output to customer in watts
grid_energy_lifetime_wh float
cumulative energy reading grid to system in watt-hour
grid_energy_interval_wh float
energy consumption at time interval grid to system in watt-hour
pv_energy_lifetime_wh float
cumulative energy reading PV to system in watt-hour
pv_energy_interval_wh float
energy production at time interval PV to system in watt-hour
output_energy_lifetime_wh float
cumulative energy reading system to customer in watt-hour
output_energy_interval_wh float
energy consumption at time interval system to customer in watt-hour
interval_seconds integer
for remotely monitored systems, interval between measurements
paygo_is_paid_off boolean
system is permanently unlocked
paygo_days_left integer
days left until next payment (only used until system is paid off)
created_at datetime
Timestamp when row was inserted
updated_at datetime
Timestamp when row was updated
source_id integer
References Source of data
import_id integer
References Import of data
organization_id integer
References Organization of data
custom jsonb
Saves additional imported data out of standard structure
data_origin string
Origin of the data, generic or name of the api
trust_score float
calculated value how much we trust data