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 Example

grid_name

Name of of the (mini-)grid

 ✓ string ⤫ ⤫ ⤫ installations_ts => site_name

SMU 12 Chinsanka

grid_external_id

ID for the specific (mini-)grid, used to build the grid_uid

 ✓ string ⤫ ⤫ ⤫

X98679862w

metered_at

time the metrics apply to (not time of query)

 ✓ datetime ⤫ ⤫ ⤫ installations_ts => metered_at

2022-01-01 13:00:00.000Z

grid_uid

organization_id + data_origin + grid_external_id; FK from grids table

 ⤫ string ⤫ ⤫ ✓ installations_ts => device_uid

a2ei-X98679862w

primary_source_to_customer_kwh

PV to consumers in kilowatt hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => custom

5.234

primary_source_to_battery_kwh

PV to battery in kilowatt hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => custom

0.0

secondary_source_to_customer_kwh

genset to consumers in kilowatt hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => custom

1.1

secondary_source_to_battery_kwh

genset to battery in kilowatt hour (will probably be 0)

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => custom

0.0

battery_to_customer_kwh

battery to consumers in kilowatt hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => custom

10.234

battery_charge_state_percent

battery charge level in percentage

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => battery_state_of_charge_percent

88.2

interval_seconds

interval for kilowatt hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ integer ⤫ ⤫ ⤫ installations_ts => interval_seconds

3600

households_connected

statistic that is calculated based on separate raw data

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ integer ⤫ ⤫ ⤫ installations_ts => custom

245

created_at

Timestamp when row was inserted

 ⤫ datetime ⤫ ⤫ ✓

2021-05-03 6:23:55

updated_at

Timestamp when row was updated

 ⤫ datetime ⤫ ⤫ ✓

2021-05-03 6:23:55

source_id

References Source of data

 ⤫ integer ⤫ ⤫ ✓

1

import_id

References Import of data

 ⤫ integer ⤫ ⤫ ✓

1

organization_id

References Organization of data

 ⤫ integer ⤫ ⤫ ✓

1

custom

Saves additional imported data out of standard structure

 ⤫ jsonb ⤫ ⤫ ✓

{ "some": "key" }

data_origin

Origin of the data, generic or name of the api

 ⤫ string ⤫ ⤫ ✓

generic