distribution_substations: 81
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81 | spital | 30/05/2024 | spen | southern | 53.34122612550317 | -3.007039480926014 | primary | spital | spen_southern_primary_spital | [{"node_1": ["royal liverpool hospital", "spital", "royal liverpool hospital"], "voltage_node_1": 33.0, "node_2": ["royal liverpool hospital t2", "spital", "royal liverpool hospital t1"], "voltage_node_2": 11.0, "nom_rating": [7.5, 7.5, 7.5], "eme_rating": [], "transformer_count": 3, "min_transformer_flow": 3.62, "max_transformer_flow": 14.48, "firm_capacity": 30.0, "accepted_export": 0, "accepted_import": 0, "project_id": [], "local_gen_headroom": 33.62, "local_dem_headroom": 15.52}] | [33.0, 11.0] | NaN | 0.0 | [] | [{"t31": [-2416.27, -2558.72]}] | -2416.27 | -2558.72 |