distribution_substations: 94
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94 | bootle | 30/05/2024 | spen | southern | 53.45660294980903 | -2.9858214800409484 | bsp | bootle | spen_southern_bsp_bootle | [{"node_1": ["boot c1", "boot c2"], "voltage_node_1": 132.0, "node_2": ["boot e1", "boot e2"], "voltage_node_2": 33.0, "nom_rating": [60.0, 60.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 11.4, "max_transformer_flow": 45.6, "firm_capacity": 68.6, "accepted_export": 21.05263157894737, "accepted_import": 8.421052631578947, "project_id": ["spen_project_410_subid_0"], "local_gen_headroom": 58.94736842105263, "local_dem_headroom": 14.578947368421046}] | [33.0, 132.0] | NaN | 0.0 | [] | [{"t13": [44.39, -518.41]}] | 44.39 | -518.41 |