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 | |||||
trust_score | float | ⤫ | ⤫ | ✓ | ⤫ |
calculated value how much we trust data |