distribution_substations: 96
This data as json
| rowid | name | date_published | source | licence | latitude | longitude | type | location | substation_id | transformers | all_voltage | source_id | connected_export | other_substation_ids | comments | detailed_global_headroom | global_gen_headroom | global_dem_headroom |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96 | legacy | 30/05/2024 | spen | southern | 53.02400862110089 | -3.058297368343994 | bsp | legacy | spen_southern_bsp_legacy | [{"node_1": ["lega c7", "lega c6"], "voltage_node_1": 132.0, "node_2": ["lega e1", "lega e2"], "voltage_node_2": 33.0, "nom_rating": [60.0, 45.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 29.9, "max_transformer_flow": 119.7, "firm_capacity": 154.7, "accepted_export": 59.47368421052632, "accepted_import": 10.526315789473685, "project_id": ["spen_project_168_subid_0", "spen_project_810_subid_1", "spen_project_553_subid_1", "spen_project_809_subid_1", "spen_project_155_subid_0"], "local_gen_headroom": 125.12631578947367, "local_dem_headroom": 24.4736842105263}] | [33.0, 132.0] | NaN | 0.0 | [] | [{"t13": [125.13, 24.47]}] | 125.13 | 24.47 |