Documentation: grids_ts

Time Series data of individual grids

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
grid_uid	string	⤫	⤫	✓	⤫
organization_id + grid_name; FK from grids table
grid_name	string	⤫	⤫	⤫	✓
Name of of the (mini-)grid, used to build the grid_uid
metered_at	datetime	⤫	⤫	⤫	✓
time the metrics apply to (not time of query)
primary_source_to_customer_kwh	float	⤫	⤫	⤫	⤫
PV to consumers in kilowatt hour
primary_source_to_battery_kwh	float	⤫	⤫	⤫	⤫
PV to battery in kilowatt hour
secondary_source_to_customer_kwh	float	⤫	⤫	⤫	⤫
genset to consumers in kilowatt hour
secondary_source_to_battery_kwh	float	⤫	⤫	⤫	⤫
genset to battery in kilowatt hour (will probably be 0)
battery_to_customer_kwh	float	⤫	⤫	⤫	⤫
battery to consumers in kilowatt hour
battery_charge_state_percent	float	⤫	⤫	⤫	⤫
battery charge level in percentage
interval_seconds	integer	⤫	⤫	⤫	⤫
interval for kilowatt hour
households_connected	integer	⤫	⤫	⤫	⤫
statistic that is calculated based on separate raw data
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