distribution_substations: 70
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70 | widnes | 30/05/2024 | spen | southern | 53.360618468455534 | -2.739156686981453 | bsp | widnes | spen_southern_bsp_widnes | [{"node_1": ["widn c2", "widn c1"], "voltage_node_1": 132.0, "node_2": ["widn e2", "widn e1"], "voltage_node_2": 33.0, "nom_rating": [60.0, 45.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 20.3, "max_transformer_flow": 81.1, "firm_capacity": 110.6, "accepted_export": 23.10842105263158, "accepted_import": 16.178947368421053, "project_id": ["spen_project_259_subid_2", "spen_project_752_subid_2", "spen_project_102_subid_2", "spen_project_258_subid_2"], "local_gen_headroom": 107.79157894736842, "local_dem_headroom": 13.321052631578947}] | [33.0, 132.0] | NaN | 0.0 | [] | [{"t13": [107.79, 13.32]}] | 107.79 | 13.32 |