Documentation: shs_ts

Time Series data of individual Solar Home Systems

To import data in this format you can use our API. -> API Documentation
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.

You can also supply us with files in xlsx, csv or json format. -> Example CSV

	Required	Type	p14n	Blurred	Autogenerated
manufacturer Manufacturer of the device	✓	string	⤫	⤫	⤫
serial_number Serial of the device	✓	string	⤫	⤫	⤫
metered_at time the metrics apply to (not time of query)	✓	datetime	⤫	⤫	⤫
device_uid organization_id + manufacturer + serial_number; FK from shs table	⤫	string	⤫	⤫	✓
pv_input_w PV to system in watts	⤫	float	⤫	⤫	⤫
grid_input_w grid to system in watts	⤫	float	⤫	⤫	⤫
grid_input_v grid input voltage in volts	⤫	float	⤫	⤫	⤫
battery_v battery voltage in volts	⤫	float	⤫	⤫	⤫
battery_io_w battery input / output in watts (>0 = charging)	⤫	float	⤫	⤫	⤫
battery_charge_percent battery charge level in percentage	⤫	float	⤫	⤫	⤫
system_output_w system output to customer in watts	⤫	float	⤫	⤫	⤫
grid_energy_lifetime_wh cumulative energy reading grid to system in watt-hour	⤫	float	⤫	⤫	⤫
grid_energy_interval_wh energy consumption at time interval grid to system in watt-hour	⤫	float	⤫	⤫	⤫
pv_energy_lifetime_wh cumulative energy reading PV to system in watt-hour	⤫	float	⤫	⤫	⤫
pv_energy_interval_wh energy production at time interval PV to system in watt-hour	⤫	float	⤫	⤫	⤫
output_energy_lifetime_wh cumulative energy reading system to customer in watt-hour	⤫	float	⤫	⤫	⤫
output_energy_interval_wh energy consumption at time interval system to customer in watt-hour	⤫	float	⤫	⤫	⤫
interval_seconds for remotely monitored systems, interval between measurements	⤫	integer	⤫	⤫	⤫
paygo_is_paid_off system is permanently unlocked	⤫	boolean	⤫	⤫	⤫
paygo_days_left days left until next payment (only used until system is paid off)	⤫	integer	⤫	⤫	⤫
created_at Timestamp when row was inserted	⤫	datetime	⤫	⤫	✓
updated_at Timestamp when row was updated	⤫	datetime	⤫	⤫	✓
source_id References Source of data	⤫	integer	⤫	⤫	✓
import_id References Import of data	⤫	integer	⤫	⤫	✓
organization_id References Organization of data	⤫	integer	⤫	⤫	✓
custom Saves additional imported data out of standard structure	⤫	jsonb	⤫	⤫	✓
data_origin Origin of the data, generic or name of the api	⤫	string	⤫	⤫	✓