distribution_substations: 27
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27 | caldy | 30/05/2024 | spen | southern | 53.357864993900456 | -3.1631556427290692 | primary | caldy | spen_southern_primary_caldy | [{"node_1": ["caldy"], "voltage_node_1": 33.0, "node_2": ["caldy"], "voltage_node_2": 11.0, "nom_rating": [7.5], "eme_rating": [], "transformer_count": 1, "min_transformer_flow": 3.76, "max_transformer_flow": 15.04, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 33.76, "local_dem_headroom": 14.96}] | [33.0, 11.0] | NaN | 0.0 | [] | [{"t31": [20.46, 5.08]}] | 20.46 | 5.08 |