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