distribution_substations: 24
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24 | speke | 30/05/2024 | spen | southern | 53.35305319970272 | -2.848639021709814 | bsp | speke | spen_southern_bsp_speke | [{"node_1": ["spek c1", "spek c3"], "voltage_node_1": 132.0, "node_2": ["spek e1", "spek e2"], "voltage_node_2": 33.0, "nom_rating": [60.0, 60.0], "eme_rating": [], "transformer_count": 2, "min_transformer_flow": 13.8, "max_transformer_flow": 55.3, "firm_capacity": 108.3, "accepted_export": 28.947368421052634, "accepted_import": 21.05263157894737, "project_id": ["spen_project_444_subid_1", "spen_project_716_subid_1", "spen_project_717_subid_1"], "local_gen_headroom": 93.15263157894736, "local_dem_headroom": 31.94736842105263}] | [33.0, 132.0] | NaN | 0.0 | [] | [{"t13": [93.15, 31.95]}] | 93.15 | 31.95 |