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