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 |