Documentation: meter_events_ts

Time Series data of events processed from meters_ts
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 meters table
manufacturer string
Manufacturer of the device
serial_number string
Serial of the device
start_at datetime
time the event started
end_at datetime
time the event ended
duration_sec integer
time the event was lasting rounded to seconds
energy_start_wh float
energy value at start time in watt-hour
energy_end_wh float
energy value at end time in watt-hour
energy_consumed_wh float
energy value used for the event watt-hour
category string
type of event
created_at datetime
Timestamp when row was inserted
updated_at datetime
Timestamp when row was updated
source_id integer
References Source 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