🔔 Scheduled Maintenance Notification

Please be advised that due to scheduled maintenance, our website will be temporarily unavailable from Saturday, 25 October 2025 at 18:00 CET until Sunday, 26 October 2025 at 14:00 CET. During this time, Prospect will not be accessible. We apologize for any inconvenience this may cause and appreciate your understanding. If you have any questions or need assistance, please contact us at support@prospect.energy. Thank you, The PROSPECT Team
24.10.2025 09:50

Documentation: grids

This table is deprecated and should not be used for imports

Static data about electrical grids - minigrids as well as national 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

external_id

ID for the specific (mini-)grid as tracked by the data provider (source).

 ✓ string ⤫ ⤫ ⤫ installations => device_external_id

X98679862w

name

Name of the (mini-)grid, typically given by operator company. Note that this is not treated as sensitive information, and would be un-encrypted.

 ✓ string ⤫ ⤫ ⤫ installations => site_name

SMU 12 Chinsanka

uid

organization_id + data_origin + external_id; Autogenerated unique identifier of the grid

 ⤫ string ⤫ ⤫ ✓ installations => uid

a2ei-X98679862w

operator_company

Name of the company which operates the (mini-)grid

 ⤫ string ⤫ ⤫ ⤫ installations => custom

Standard Microgrid

location_area_1

(mini-)grid first-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

 ⤫ string ⤫ ⤫ ⤫ installations => location_area_1

Luapola

location_area_2

(mini-)grid second-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

 ⤫ string ⤫ ⤫ ⤫ installations => location_area_2

Samfya

location_area_3

(mini-)grid third-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

 ⤫ string ⤫ ⤫ ⤫ installations => location_area_3

None

location_area_4

(mini-)grid fourth-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

 ⤫ string ⤫ ⤫ ⤫ installations => location_area_4

None

country

two-letter country code according to ISO 3166-1 alpha-2

 ⤫ string ⤫ ⤫ ⤫ installations => custom

TZ

latitude

geo location latitude

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

 ⤫ float ⤫ ⤫ ⤫ installations => latitude

5.432

longitude

geo location longitude

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

 ⤫ float ⤫ ⤫ ⤫ installations => longitude

2.345

power_rating_kw

highest power input allowed to flow through inverter in kilowatt

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

 ⤫ float ⤫ ⤫ ⤫ installations => rated_power_w

2.8

primary_input_installed_kw

sum of installed primary peak power in kilowatt

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

 ⤫ float ⤫ ⤫ ⤫ installations => custom

2.5

secondary_input_installed_kw

sum of installed secondary peak power in kilowatt

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

 ⤫ float ⤫ ⤫ ⤫ installations => custom

3.2

primary_input_source

e.g. solar

 ⤫ string ⤫ ⤫ ⤫ installations => custom

solar

secondary_input_source

e.g. diesel generator

 ⤫ string ⤫ ⤫ ⤫ installations => custom

diesel generator

is_offgrid

indicates whether the grid is a national grid (FALSE) or a mini-grid (TRUE)

 ⤫ boolean ⤫ ⤫ ⤫ installations => custom

true

storage_capacity_kwh

maximum storage capacity in kilowatt hour

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

 ⤫ float ⤫ ⤫ ⤫ installations => battery_capacity_wh

5.8

operator_phone

operator telephone (p14)

 ⤫ string ✓ ⤫ ⤫ installations => custom

0123456789 will be - stored as c340f947f1f7cb83c8f40bb5a7ad24ca78486bdfb2ef587f55ea537de17efc27

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

last_import_id

Id of the last import which updated the record

 ⤫ integer ⤫ ⤫ ✓

337

last_source_id

Id of the last Source which updated the record

 ⤫ integer ⤫ ⤫ ✓

33