Documentation: grids_ts

This table is deprecated and should not be used for imports

Time Series data of individual grids

To import data in this format you can use our API. -> API Documentation
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.

You can also supply us with files in xlsx, csv or json format. -> Example CSV

	Required	Type	p14n	Blurred	Autogenerated	Mapping
grid_name Name of of the (mini-)grid	✓	string	⤫	⤫	⤫	installations_ts => site_name
grid_external_id ID for the specific (mini-)grid, used to build the grid_uid	✓	string	⤫	⤫	⤫
metered_at time the metrics apply to (not time of query)	✓	datetime	⤫	⤫	⤫	installations_ts => metered_at
grid_uid organization_id + data_origin + grid_external_id; FK from grids table	⤫	string	⤫	⤫	✓	installations_ts => device_uid
primary_source_to_customer_kwh PV to consumers in kilowatt hour	⤫	float	⤫	⤫	⤫	installations_ts => custom
primary_source_to_battery_kwh PV to battery in kilowatt hour	⤫	float	⤫	⤫	⤫	installations_ts => custom
secondary_source_to_customer_kwh genset to consumers in kilowatt hour	⤫	float	⤫	⤫	⤫	installations_ts => custom
secondary_source_to_battery_kwh genset to battery in kilowatt hour (will probably be 0)	⤫	float	⤫	⤫	⤫	installations_ts => custom
battery_to_customer_kwh battery to consumers in kilowatt hour	⤫	float	⤫	⤫	⤫	installations_ts => custom
battery_charge_state_percent battery charge level in percentage	⤫	float	⤫	⤫	⤫	installations_ts => battery_state_of_charge_percent
interval_seconds interval for kilowatt hour	⤫	integer	⤫	⤫	⤫	installations_ts => interval_seconds
households_connected statistic that is calculated based on separate raw data	⤫	integer	⤫	⤫	⤫	installations_ts => custom
created_at Timestamp when row was inserted	⤫	datetime	⤫	⤫	✓
updated_at Timestamp when row was updated	⤫	datetime	⤫	⤫	✓
source_id References Source of data	⤫	integer	⤫	⤫	✓
import_id References Import of data	⤫	integer	⤫	⤫	✓
organization_id References Organization of data	⤫	integer	⤫	⤫	✓
custom Saves additional imported data out of standard structure	⤫	jsonb	⤫	⤫	✓
data_origin Origin of the data, generic or name of the api	⤫	string	⤫	⤫	✓