Documentation: meters_ts
Time Series data of individual meters
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 | |||||
metered_at | datetime | ⤫ | ⤫ | ⤫ | ✓ |
time the metrics apply to (not time of query) | |||||
phase | enum: 1, 2, 3 | ⤫ | ⤫ | ⤫ | ⤫ |
1,2,3; default: 1 | |||||
voltage_v | float | ⤫ | ⤫ | ⤫ | ⤫ |
voltage in volts | |||||
power_factor | float | ⤫ | ⤫ | ⤫ | ⤫ |
ratio of working power to the apparent power, value between from 0 and 1 | |||||
power_w | float | ⤫ | ⤫ | ⤫ | ⤫ |
power in watts | |||||
energy_lifetime_wh | float | ⤫ | ⤫ | ⤫ | ⤫ |
cumulative energy reading in watt-hour | |||||
energy_interval_wh | float | ⤫ | ⤫ | ⤫ | ⤫ |
energy consumption at time interval in watt-hour | |||||
frequency_hz | float | ⤫ | ⤫ | ⤫ | ⤫ |
frequency in hertz | |||||
current_a | float | ⤫ | ⤫ | ⤫ | ⤫ |
current in ampere | |||||
interval_seconds | integer | ⤫ | ⤫ | ⤫ | ⤫ |
for remotely monitored systems, interval between measurements | |||||
billing_cycle_start_at | datetime | ⤫ | ⤫ | ⤫ | ⤫ |
timestamp on which the tariff cycle starts | |||||
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 |