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