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 |